SELECT Id FROM new_searchtable
where (water_body like 'Newfound%' and water_body_type ='Lake') and (type = 'R' or type ='O')
and subdivision like'%Camelot Acres' and subdivision like'%Camelot Acres'
AND list_price BETWEEN '0' AND '30000000'
ORDER BY list_price Desc
Newfound Lake NH Homes page 0
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:Open House Saturday 5/18/2024 10Am - 12:00 Noon, Well maintained cottage style 4 season home. Perfect for your vacation retreat, offering 2 bedrooms on main level, along with a sleeping loft, 1/2 bath, kitchen, sunroom with direct access to large deck for seasonal entertaining. The lower level is partially finished with a bonus room along with a 3/4 bath. Additional area in lower level offers possible options to expand living space. Property is just a short walk to the beautiful association beach on Newfound Lake with a low annual fee of $300.00 Come enjoy the lakes and mountains!