SELECT Id FROM new_searchtable
where state='NH' and (town = 'Gilford') and type ='M'
and water_body like 'Winnipesaukee%'
AND list_price BETWEEN '0' AND '30000000'
ORDER BY list_price Desc
Currently there are no listings for Gilford NH Multi Family Homes
Sorry No Results were found
Gilford NH Multi Family Homes $0 to $30000000
change property type or
click back button to search again.
or Change Town