SELECT Id FROM new_searchtable
where (water_body like 'Newfound%' and water_body_type ='Lake') and (type = 'R' or type ='O')
and subdivision like'%Ledgeview Shores' and subdivision like'%Ledgeview Shores'
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:Views, views, views! Spectacular views Overlooking pristine Newfound Lake! This beautifully crafted log home offers a rare combination of privacy, character and scenic lake living. Built in 2002 and set on 5 wooded acres at the top of the hill on a cul-de-sac, this home provides a peaceful retreat with spacious interior living on 3 levels. There are 5 bedrooms (3 bedroom septic), 3 bathrooms designed for comfort & flexibility. The 1st floor is an open floor plan w/vaulted ceiling living room w/stone gas fireplace, dining area & eat-in-kitchen w/granite countertops & peninsula breakfast bar. The wall of windows w/2 sliders leads out to a private 34'x14' maintenance-free deck w/6 person hot tub and gorgeous views! Spacious Primary suite w/wood vaulted ceilings, large walk-in closet & its own private deck overlooking a wooded setting, plus an attached on-suite 3/4 tiled floor bath. The sun drenched loft w/gleaming wood floors overlooks the first floor and offers sweeping lake views! Full finished walk-out basement w/spacious family rm, game area w/ping pong table, wood stove, mini fridge & door to yard makes for great entertainment space! There are 2 additional bedrooms and a full bath. Utility room houses weil-mclain oil furnace, HW heater, well tank and washer/dryer. The large day dock is 0.4 miles away and is shared w/4 other homes and enhances the lake experience w/jet skiing, kayaking, swimming, hanging out and relaxing in the water. The elevated setting captures sweeping views of Newfound Lake and the natural beauty beyond. Ideal for year-round living or a private getaway, this exceptional home delivers the best of New Hampshire lake life in a highly desirable location. Less than a mile from Sugarloaf mountain for great hiking trails and Wellington State Beach and Park for public boat access. There may be an opportunity at Newfound Boat Club in Bristol to buy or lease a boat slip. Skiers delight-close to Gunstock. NO SHORT-TERM RENTAL less than 185 days allowed.