SELECT Id FROM new_searchtable
where town = 'Canaan' and state='NH' and (type = 'R' or type ='O')
AND list_price BETWEEN '0' AND '150000'
ORDER BY list_price Desc
Canaan NH Homes page 0
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:Located in a quiet country park, this 2 bedroom, 1 bath home is very comfortable and affordable. The sun-filled kitchen has plenty of cabinet space and opens up to the living area. The yard allows for room for play and relaxing, and has garden space and a lilac bush. Ample storage in the shed. 30 min commute to Lebanon, NH and Plymouth NH.