=> for-rent
 => Newfound%20Lale
 => NH
 => Single%20Family
SELECT Id FROM new_nnerenrentals
where (town like 'Newfound Lale%' or water_body like 'Newfound Lale%') and state='NH' and PropertyType ='Single Family'
AND list_price BETWEEN '0' AND '30000000'
ORDER BY list_price ASC
Newfound Lale NH Rental Properties page 0
603-393-7227 348 Intervale Rd
Gilford NH 03249
Viewing Single Family Change Town change to Newfound Lale NH Rentals by Type