SELECT Id FROM new_searchtable
where town = 'Canaan' and state='NH' and (type = 'R' or type ='O')
AND list_price BETWEEN '150000' AND '250000'
ORDER BY list_price Desc
Canaan NH Homes page 0
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:Great Location near Canaan Village and just a mile to the lake with a public beach. Kitchen, dining, living room, bedroom and full bath with laundry on the first floor. Second floor bedroom. Kitchen appliances included. Basement with older 3/4 bathroom that needs repair. FHW heating system. 2 car detached garage. Great back yard for get-togethers. Town water. In need of TLC which is reflected in the asking price. Will not meet requirements for an FHA or VA loan due to the condition of the paint. Short walk to the Northern Rail Trail, park, modern library, award-winning elementary school, senior center, Advance Transit Bus system, eateries, and Farmer's Market in the summer.