SELECT Id FROM new_searchtable
where (water_body like '%Opechee%') and type='R'
AND list_price BETWEEN '0' AND '150000'
ORDER BY list_price Desc
Lake Opechee NH Homes
603-393-7227 348 Intervale Rd
Gilford NH 03249
Due to the coronavirus pandemic,
COVID-19 guidelines for real estate professionals will be strictly adhered to as they evolve.
Contact us to arrange for options that best accommodate your needs.