SELECT Id FROM new_searchtable where (water_body like 'Newfound%' and water_body_type ='Lake') and (type = 'R' or type ='O') and subdivision like'%Bristol Shores' and subdivision like'%Bristol Shores' AND list_price BETWEEN '0' AND '30000000' ORDER BY list_price Desc Currently there are no listings for Newfound Lake NH Homes

Sorry No Results were found
change property type or
click back button to search again.
or Change Town

Newfound Lake NH Homes $0 to $30000000