SELECT Id FROM new_searchtable
where state='NH' and (town = 'Gilford') and type ='L'
and water_body like 'Winnipesaukee%'
AND list_price BETWEEN '0' AND '30000000'
ORDER BY list_price Desc
Copyright © 2022 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 August 7th, 2022
Designed by BSC DATA