SELECT Id FROM new_searchtable
where (water_body like 'Newfound%' and water_body_type ='Lake') and (type = 'R' or type ='O')
and subdivision like'%Holiday Hill' and subdivision like'%Holiday Hill'
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:Get excited because opportunities like this don’t come along often! Meticulously crafted for easy living, whether you’re looking for a full-time residence or the perfect weekend retreat. Situated on over 2 private acres, this home features the most amazing wraparound deck to relax and take in the peaceful surroundings. Inside, you’ll find beautiful hickory wood floors, rough-edged granite countertops, a loft filled with endless potential for fun, and an abundance of natural light throughout. Located in the Holiday Hills development, owners enjoy access to one of the most beautiful private beaches on Newfound Lake. Store your kayaks, lawn chairs, and beach toys right by the water, with boat slips also available as part of this private neighborhood beach (there currently is a waitlist). Newfound Lake is known as one of the cleanest lakes in the world, and the location offers so much more — nearby trail systems, Ragged Mountain just 15 minutes away, Wellington State Park, and endless year-round recreation. This is truly a place to make memories! FIRST SHOWINGS start at Open House, Friday, May 29th 5:30 - 7:30pm