SELECT Id FROM new_searchtable
where town = 'Newbury' and state='NH' and (type = 'R' or type ='O')
and subdivision like'%Sunapee Overlook' and subdivision like'%Sunapee Overlook'
AND list_price BETWEEN '0' AND '30000000'
ORDER BY list_price Desc
Newbury NH Homes page 0
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:Instantly appealing and offering a charm that complements the environment this saltbox style home offers a serene and functional interior that's sure to please the most fastidious buyer. The generously proportioned sun filled rooms provide a natural ebb and flow between the spaces. The first floor features a mudroom with laundry and storage, full bath, a spacious eat in kitchen with quartz countertops, a den, living room with a propane stove and a magnificent window wrapped sunroom with vaulted ceiling that serves as a magnet for family and friends. There are two large bedrooms with an updated connecting bath and a small reading nook on the second floor. The finished basement lends itself to many possibilities, and there is still plenty of basement for storage or a workshop. This home blends nicely into it's 3.4-acre hillside setting with seasonal vieews of the mountain and is close to skiing, boating, hiking and the Upper Valley and Concord. It’s move in perfect!.