SELECT Id FROM new_searchtable
where town = 'Hanover' 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
Hanover NH Homes page 0
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:Do you need a place to escape the city at the weekend, or a full time residence just a few minutes from the Dartmouth Green, but nestled in a delightful country setting? This is the place. A new kitchen frames one corner of this light filled log cabin. The gas stove renders the main living area super cozy and welcoming. The nice big deck at the rear gives the opportunity for summer entertaining or to just watch the local fauna pass you by. Situated on over four acres of woods, a stream and very close to the AT, this is a special little place where it feels like time stands still. Come and check it out!