Array ( [0] => [1] => for-rent [2] => Newfound%20Lake [3] => NH [4] => Duplex [5] => )
SELECT Id FROM new_nnerenrentals where (town like 'Newfound Lake%' or water_body like 'Newfound 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 Newfound Lake NH Duplex

Sorry No Results were found
refresh page or click back button to search again.

click back button to search again