SELECT Id FROM new_searchtable
where town = 'Newbury' and state='NH' and (type = 'R' or type ='O')
AND list_price BETWEEN '0' AND '30000000'
ORDER BY list_price Desc
Newbury NH Homes page 20
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:Designed by the acclaimed Bonin Architects, this extraordinary Lake Sunapee contemporary captures sweeping panoramic views spanning miles of sparkling water, framed by Mt. Sunapee to the south, Sunapee Harbor to the west, and Georges Mills to the north. Nestled in the charming lakeside community of Blodgett’s Landing, this custom-built 2011 residence blends the sophistication of a premier New York loft with four levels of refined lakeside living. The main level features an open-concept design with seamless living, dining, and gourmet kitchen spaces, all flowing effortlessly to an expansive covered porch — truly the finest vantage point to take in the lake’s breathtaking scenery. Upstairs, the luxurious primary suite offers a private balcony, spa-inspired bath, and commanding water views. Two additional bedrooms share a beautifully appointed bath on this level, while the top floor hosts a secluded guest suite with its own private bath. The walk-out lower level is designed for entertaining, complete with a home theater, billiards area, and a ľ bath that provides flexible accommodations for additional guests. Outside, enjoy a flagstone patio, lakeside dining deck, and a deep-water dock ready for boating adventures. Few properties offer a setting as magical as this — where unforgettable sunsets paint the sky while tour boats and classic mahogany runabouts glide across the horizon. A rare opportunity to experience luxury waterfront living at its finest on Lake Sunapee.
Description:Enjoy a brand new 2026 built energy efficient home in this spectacular Lake Sunapee setting offering 131' prime shoreline, a lush lawn at the waterfront & a 2016 built 2 bay boathouse with over-water recreation space. The 5 bedroom design features open concept living/kitchen/dining with a first floor bedroom, 4 large bedrooms up and options to finish areas over the garage and in the walk-out lowest level. Currently an existing seasonal structure can be used and enjoyed while you finalize all building plans with Snow Construction (or other builder of your choice). Options available to purchase the current seasonal cottage only if you are seeking a seasonal option - or wish to build new at a later date. This Lake Sunapee home is located near the base of Mt. Sunapee Ski Resort. Enjoy hiking trails through a 100 acre adjacent preserve right across the street. Ride your bike to the sandy State Beach for a picnic. Mt. Sunapee offers an adventure park , zip lines & many cultural events in summer & 344 acres of ski trails to explore in winter.