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 (bedrooms='3' and baths >='2') and (bedrooms='3' and baths >='2')
AND list_price BETWEEN '0' AND '30000000'
ORDER BY list_price Desc
Dartmouth Area Luxury NH Homes page 20
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:DRUM ROLL PLEASE!! A pleasure and a privilege to introduce this GEM - AIA Vermont Design Award 2004 winner. The design and cleverly sited Contemporary waterfront home embodies flair, creative use of space, ingenuity, workmanship, charm and a WOW factor from the minute you enter the door. Light filled, open floor plan on the main level with great large windows, living room with two-way fireplace, with black marble lintel, extends the indoor to outdoor living space on an amazing screened porch complete with views to the Lake and the Knox River at Shaker Boulevard!! AND THEN The Cottage House!! This is another GEM, totally renovated with a well thought out floor plan consisting of one bedroom, kitchen, living/dining area, 1.5 bathrooms, full basement and an amazing wraparound porch with VIEWS, up the Lake and all around!! To describe the setting: Private, level, beach area, docks and an estuary to watch the birds and ecosystem of life survive. This is a must see!!
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.