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 10
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:You will never want to leave your front porch swing overlooking sweeping 180 degree Lake Sunapee vistas from north to south. Revel in mosaic full sky sunsets from your porch or waterfront terrace. Jump in the lake from your private waterfront or the beloved Blodgetts public pier right next door. This charming 4 bedroom home features a spacious great room, cozy kitchen with dining area, first floor bedrm & laundry, 3 bedrms and bath up. Storage shed in back. Blodgetts Landing is a quiet lakeside village located on the coveted eastern shore of 10 mile long Lake Sunapee with some of the best views in the region! Showings start at OPEN HOUSE - Saturday 4/20 -1pm to 3pm