=> for-rent
 => Squam%20Lake
 => NH
 => Duplex
SELECT Id FROM new_nnerenrentals
where (town like 'Squam Lake%' or water_body like 'Squam Lake%') and state='NH' and PropertyType ='Duplex'
AND list_price BETWEEN '0' AND '30000000'
ORDER BY list_price ASC
NH Lakes Real Estate 603-393-7227 Squam Lake NH Duplex
603-393-7227 348 Intervale Rd
Gilford NH 03249
Sorry No Results were found
refresh page or
click back button to search again.