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'%Eastman Community Association' and subdivision like'%Eastman Community Association'
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:Enjoy Eastman living at its finest in this beautifully maintained 4-bedroom, 3-bath home set on 1.39 acres with access to the lake. Designed for both everyday comfort and four-season enjoyment, this residence blends thoughtful updates with the quintessential lifestyle that makes Eastman so special. The main level is anchored by a stunning Danish soapstone fireplace that elegantly separates the living and dining rooms, creating a sophisticated yet cozy atmosphere. Featuring three bedrooms on the main level—including a primary suite with en suite bath for the ease of first floor living—the floor plan is further enhanced by a versatile loft space, currently used as a gym but ideal for a home office. The heart of the home extends to a screened-in porch off the kitchen, providing the perfect sanctuary to relax with morning coffee or unwind on summer evenings. The walk-out lower level features the fourth bedroom and bath along with an expansive family room that creates a seamless connection to the outdoors, ideal for entertaining. After a day exploring the trails or the lake, you can retreat to your private Swedish sauna for a true spa-like experience at home. With updates completed within the past ten years, a durable standing-seam roof, and a two-car garage, this property offers complete peace of mind. This is a rare opportunity to embrace a peaceful setting with all of Eastman’s sought-after amenities, whether as a full-time residence or a premier four-season retreat. Showings begin on Thursday and Please join me for an OPEN HOUSE on Thursday, May 7th from 3-6pm