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:Privately sited on beautifully landscaped grounds in the coveted Mulherrin Farm neighborhood, this impeccably maintained three-bedroom Colonial blends timeless New England architecture with thoughtfully designed living spaces and exceptional indoor-outdoor appeal. Surrounded by mature landscaping and offering a peaceful sense of privacy, this exceptional home is just minutes from Hanover, Dartmouth College, DHMC, and is within the Hanover School District for K-12. The beautifully appointed kitchen flows seamlessly into a stunning vaulted living area featuring exposed beams, a cozy gas fireplace, and oversized windows that fill the space with abundant natural light while framing picturesque views of the surrounding landscape. Rich architectural details and an open, inviting floor plan create an atmosphere that is both elegant and welcoming. The spacious primary suite serves as a private retreat, complete with a generous walk-in closet and a well-appointed ensuite bath. Above the oversized two-car garage, an impressive 27' x 16' heated bonus room with electricity provides exceptional flexibility as a home office, media room, fitness studio, playroom, guest suite, or creative workspace. A partially finished basement offers additional living space ideal for a recreation room, home gym, hobby area, or abundant storage. Step outside to the inviting screened porch, the perfect place to enjoy your morning coffee, entertain guests, or unwind while overlooking the beautifully landscaped grounds. Whether hosting gatherings or savoring a quiet evening surrounded by nature, the outdoor spaces are every bit as inviting as the home's interior. Combining quality craftsmanship, architectural character, and an exceptional location in one of the Upper Valley's most desirable neighborhoods, this is a rare opportunity to enjoy a lifestyle of comfort, privacy, and convenience. OPEN HOUSE Sunday 8/30 from 10 AM- 12:00. See you there!
Description:This charming 3-season home on beautiful 1158-acre Mascoma Lake has been lovingly cared for by the same family for over 50 years, and now it’s ready for its next chapter. Nestled on 0.71 private acres with 210 feet of pristine waterfront, this 3-bedroom, 4-bath retreat invites you to slow down and savor lakeside living. Whether you're floating in the peaceful waters, relaxing in the sunken spa within the detached sunroom, enjoying a sunset from the mahogany deck, or strolling down the quiet, tree-lined road, every moment here feels like a getaway. Listen to the sound of the loons and watch the eagles soar. Nature's beauty is right at your doorstep. A 42-foot aluminum dock with new thru-flow decking stretches into the deep water, ideal for boating, fishing, or simply soaking in the beauty of the surroundings. Cedar shake siding adds timeless appeal, while the whole-house standby generator offers convenience and peace of mind. Inside, floor-to-ceiling windows bring the lakefront views right into the living space, and thoughtful updates throughout provide comfort and function. Though currently used as a 3-season home, it holds the potential to be enjoyed year-round with a few modifications. Here, the days feel longer, the air is a little sweeter, and the lake feels like it’s all your own.
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 Quartz countertops, 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.
Description:Perfectly positioned along the Connecticut River in Hanover, 32 River Road offers a rare blend of refined living and extraordinary natural beauty. This thoughtfully updated three-bedroom, three-bath residence captures sweeping river views and an effortless indoor-outdoor lifestyle in one of the Upper Valley’s most desirable settings.Renovated in 2021, the kitchen, family room, and baths feature clean, timeless finishes, while hardwood floors and radiant heat throughout the lower level and garage provide year-round comfort. Cathedral ceilings introduce natural light and volume, while loft spaces accessed by custom ladders add charm, flexibility, and a perfect hideaway for younger guests. Clapboard siding and a standing seam metal roof complete the home’s understated New England aesthetic. The home’s 700+ square-foot wraparound deck serves as the centerpiece of the property, offering panoramic river views and exceptional space for entertaining, dining, or quiet retreat. Whether enjoying morning coffee beside the water, evenings in the hot tub, or sunset gatherings with friends, every moment is framed by the rhythm and beauty of the Connecticut River. A private dock provides access to rowing, paddling, boating, and exploration. Included in the offering are a Vespoli racing shell, canoe, kayak, and motorized raft, along with amenities including dedicated gear storage, an outdoor summer shower, and a heated two-car garage. In the early morning hours, Dartmouth crew shells glide quietly along the river, adding to the timeless character of life on the Connecticut. Adding to the property’s appeal is an additional 10-acre parcel across the street, where carved walking trails and several potential building sites offer future possibilities. The river becomes part of daily life in every season, creating a rare sense of privacy and connection to nature just moments from downtown Hanover and Dartmouth College. Offered with tasteful furnishings-this is a turn key opportunity.
Description:BRECK HILL ROAD- With incredible south facing mountain views, Breck Hill’s spectacular location and setting are the ideal backdrop for this stylish and updated contemporary home. Featuring a spacious open concept design with exceptional flow, the interior spaces are well-appointed to welcome abundant natural light and showcase the breathtaking long-range vistas. A sizable eat-in kitchen, living, and dining space open to a breezy screened porch overlooking the grounds, while a cozy library/den sits adjacent to these spaces on the north side of the home. The grand primary bedroom suite has arguably the best views on the property and is perfectly positioned to take in the mature landscaping and gardens that adorn the property. Two additional bedrooms, each with its own bath, round out the main living area. There is a generous unfinished space on the second floor if expansion is desired, while the basement offers ample room for storage. The substantial land component of 22+ conserved acres is comprised of a lovely mix of open meadows and magical forest trails tailor made for dog walks, cross-country skiing, and more. Complete 2009 renovation including new mechanicals, interior finishes- new floors, walls, ceilings and doors, exterior finishes- new insulation, windows, doors & siding. Minutes away from the Village of Lyme and a short hop to Hanover, Dartmouth College, and the best of the Upper Valley region, this turnkey luxury home offers privacy without compromising convenience.