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:Canaan NH, NH Route 118. Bring your tools, house needs work. Selling 'as is' 3 Bedrooms 1 bath home on .37 AC lot, Good size back yard, just few minutes to Cardigan Mountain, Canaan Street Lake, race track, nearby ponds, trails and outdoors recreational sites in Canaan. 25 minutes to Lebanon and Plymouth.