SELECT Id FROM new_searchtable
where state='NH' and (town = 'Gilford') and (type = 'R' or type ='O')
and water_body like 'Winnipesaukee%'
AND list_price BETWEEN '0' AND '30000000'
ORDER BY list_price Desc
Copyright © 2021 New England Real Estate Network, Inc. All rights reserved. This information is deemed reliable, but not guaranteed. The data relating to real estate displayed on this Site comes in part from the IDX Program of NEREN. The information being provided is for consumers´ personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Data last updated January 22nd, 2021
Designed by BSC DATA