SELECT Id FROM new_searchtable
where (town like 'Lyme' and state='NH'
or town like 'Enfield' and state='NH'
or town like 'Lebanon' and state='NH'
or town like 'Hanover' and state='NH'
or town like 'Plainfield'and state='NH'
or town like 'Cornish'and state='NH'
or town like 'Grantham'and state='NH'
or town like 'Eastman'and state='NH'
or town like 'Dorchester'and state='NH' )
and list_price > '700000' and (type = 'R' or type ='O')
and subdivision like'%Burpee Hill II' and subdivision like'%Burpee Hill II'
AND list_price BETWEEN '0' AND '30000000'
ORDER BY list_price Desc
Dartmouth Area Luxury NH Homes page 0
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:Nestled along the serene shores of Eastman Lake in the sought-after four-season Eastman Community, this fully renovated three-bedroom waterfront home offers a perfect blend of modern comfort, natural beauty, and a touch of Adirondack style. Step inside to discover a stunning new kitchen featuring gleaming stainless-steel appliances, including a 3-foot gas cooktop—ideal for the home chef—along with a wall oven, microwave, and wet bar. Custom built-in cherry cabinetry enhances both the kitchen and living room, while a full-height stone fireplace with a custom cherry mantel creates a warm and inviting focal point. Each level offers an updated bath, including a beautifully appointed primary bath that stands out as a private retreat. A second kitchen adds exceptional flexibility, making it easy to entertain guests while enjoying the hot tub or dining outdoors. Beyond the walls, the thoughtfully designed, tiered landscape features stone steps, walkways, and curated plantings, all leading to a peaceful path to the lake. In just a short walk, you can be relaxing on one of Eastman’s inviting beaches. Living in Eastman means embracing a true four-season lifestyle. Residents enjoy access to a championship golf course, indoor pool, fitness center, tennis and pickleball courts, as well as cross-country skiing, snow shoeing, hiking, and biking trails. The centerpiece is the 345-acre lake with six beaches, offering endless opportunities for recreation and relaxation. Unwind at the water’s edge or take in expansive lake views from your private deck—this is lakeside living at its finest. Seller is a licensed real estate agent.