SELECT Id FROM new_searchtable
where town = 'Newbury' and state='NH' and (type = 'R' or type ='O')
and (bedrooms='1') and (bedrooms='1')
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:Over the river and through the woods - on the back side of Mt Sunapee exists the most beautiful stone cottage on a pond in the middle of 150 +/- acres. Apres ski, you are greeted by a warm fire and perhaps the smell of cookies in the oven. Skating on the pond, or in summer, swimming, hiking, relaxing on the screened porch is just part of the amenities you will enjoy There is a cozy loft for sleeping or snuggling up with a book, or playing with toys, a darling updated kitchen, and a nice addition for another bedroom or family/dining room. The screened porch is perfect for relaxing with a good book. On the water's edge, a small cabin with fireplace and bath ( needs updating) Enjoy peace and quiet and escape from the crowds, but drive 10 mins to shopping, Lake Sunapee. 20 mins to I89 and 90 mins to Boston. 4 hours to NYC. This one will not last! Open House 4/13 10-12; 4/14 11-1