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'%Deer Yard 3' and subdivision like'%Deer Yard 3'
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:This stunning Yankee Barn home is a masterpiece of design and craftsmanship, featuring architecturally inspired improvements throughout. The spacious, open-concept kitchen is the heart of the home, offering stainless steel appliances, granite countertops, a large island with gas cooking, and seamless flow into the dining and sitting areas—perfect for entertaining or everyday living. The dramatic two-story stone fireplace creates a breathtaking focal point and fills the home with warmth and character. The sun-filled primary suite is generously sized and offers direct access to the expansive western-facing deck, where you'll enjoy spectacular sunsets and peaceful outdoor living. Every bathroom has been thoughtfully customized with beautiful cabinetry and tile work, while the lower-level bath includes a built-in sauna for the ultimate retreat. Step outside to discover an extraordinary garden sanctuary featuring multi-tiered hardscaping, a fire pit, ambient lighting, and beautifully landscaped spaces designed for relaxation and entertaining. Situated on a double lot, the property provides exceptional privacy and a tranquil setting. Additional features include high-efficiency heating, on-demand hot water, air conditioning, heated towel bars, and numerous quality upgrades throughout. Located in the Eastman community, this home offers access to year-round recreation and amenities for every lifestyle, including a 345-acre lake with 6 beaches, championship golf, tennis and pickleball courts, a fitness center, heated indoor pool, cross-country skiing, hiking and biking trails, and countless opportunities to enjoy the outdoors. Whether you're seeking an active lifestyle or a peaceful retreat, this exceptional property offers the best of both worlds.