SELECT Id FROM new_searchtable
where town = 'Orange' and state='NH' and (type = 'R' or type ='O')
and (bedrooms='2') and (bedrooms='2')
AND list_price BETWEEN '0' AND '30000000'
ORDER BY list_price Desc
Orange NH Homes page 0
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:OVER 40 ACRES! Very Motivated Seller. Property being sold AS-IS. Colonial style structure, 2 car garage with open concept living space above. Located close to Cardigan Mountain State Park. A renovation loan or cash needed as walls and finishing are not complete. Do not walk the property without an appointment.