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 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:Welcome to this beautifully updated 4-bedroom, 3-bath home tucked into one of Lebanon’s most convenient and scenic neighborhoods. Located adjacent to the stunning trails and open spaces of the 864 acre Farnum Hill Reserve, this property offers the perfect balance of nature, comfort, and accessibility. Step inside to discover a thoughtfully updated interior with bright, welcoming living spaces designed for everyday living and entertaining. The home features a modernized kitchen, spacious bedrooms, and three well-appointed bathrooms, providing flexibility for owners, guests, or home office needs. Recent upgrades include a brand-new heating and air conditioning system, ensuring year-round comfort and energy efficiency. The Tesla power wall with 2 batteries provides back up support during storms or power outages. Outside, the professionally landscaped yard creates a peaceful setting for relaxing, gardening, or enjoying the surrounding natural beauty. The slate patio provides a private area that is surrounded by perennial gardens. Move-in ready and beautifully maintained, 41 Foliage View Road is a rare opportunity to enjoy updated living in an exceptional location. Seller is a licensed NH Real Estate Broker.
Description:This West Lebanon gem combines classic comfort with a versatile, modern layout. At the heart of the home, a bright eat-in kitchen with a large island flows naturally into a spacious living room anchored by a cozy fireplace. The second floor offers four bedrooms, including a primary suite with a private bath. For added flexibility, a separate suite above the two-car garage features a kitchenette and built-ins—perfect for guests, a home office, or recreation. Outside, enjoy the quiet neighborhood from the deck or the level, tree-lined backyard. Ideally located, you’re just a quick bike ride from Hanover’s Main Street with easy Advance Transit access to the rest of the Upper Valley. Showings to begin at the Open House on Sunday, March 29th from 1pm to 3pm.
Description:Charming 4-bedroom, 3-bath farmhouse nestled on over 4 acres of open pasture and field. This inviting home blends classic character with modern updates, featuring beautiful hardwood floors, an updated kitchen with plenty of space for cooking and gathering, and comfortable living areas filled with natural light. The additional finished space over the garage offers flexibility for a guest suite, office, or recreation room. Enjoy peaceful local mountain views from the screened in porch or spend evenings by the outdoor firepit, perfect for entertaining or relaxing under the stars. With easy access to town, schools, and all amenities, this property combines the serenity of country living with everyday convenience and plenty of blueberries with over 40 bushes to pick from. Ideal for those seeking room to roam, a place for animals or gardens, and a home designed for comfort and connection. Just minutes from I89, Lebanon green and DHMC plus part of this 4 acres has direct access to the rail trail for walking and biking. Open House Saturday March 28th from 11:30-1:00pm
Description:Set on 11.5 private acres in scenic Plainfield, New Hampshire, this beautifully designed 2021 home offers the perfect balance of comfort, privacy, and modern living. The main living area is warm and welcoming, centered around a striking stone hearth with a propane fireplace. The bright kitchen opens seamlessly to the living and dining areas, creating an easy flow for everyday living and entertaining. An oversized 2-car garage offers direct entry into the home, while a dedicated laundry room and half bath are conveniently tucked just off the kitchen. A spacious wraparound deck expands the living space outdoors, providing a peaceful setting for summer dining, relaxing, and enjoying the surrounding landscape and water views. The primary suite features a beautifully appointed en suite bath and walk-in closet. The finished lower level offers a large sauna, flexible space for a gym, office, media room, or additional living area. A whole-house generator adds year-round peace of mind. Surrounded by nature yet conveniently located with easy access to Hanover, Lebanon, Shopping, Dartmouth College, and Dartmouth Hitchcock Medical Center, this property offers a wonderful blend of privacy, convenience, and Upper Valley living.
Description:Waterfront property in Eastman with seasonal lake views! This beautiful home has been totally updated, including an all new kitchen with granite counter tops, stainless steel appliances, lots of cabinets for storage and a custom breakfast bar at the height for standard chairs. This opens to a separate dining area with a bay window for plenty of natural light. Continue through the open floor plan to a light and bright living room with a gorgeous wood-burning fireplace as the focal point. Retreat to the first-floor primary bedroom suite with an updated bathroom, which includes a separate tub and shower, plus a powder room with its own sink and vanity, and a spacious walk-in closet. Speaking of spacious, the finished lower level walkout has a large family room, flex space/den, 3 more bedrooms, and 2 more updated bathrooms. Completely handicap accessible with an elevator to seamlessly change levels! Other amenities include a generous office with built-ins, first-floor laundry room with built-in storage and counter for folding, convenient first-floor half-bath, radiant heat floors in baths, and direct entry from the 2-car attached garage. Take advantage of the peaceful wooded setting from the screened porch, deck, covered front porch and hot tub. All this in the desirable 4-season community of Eastman in the heart of the Dartmouth - Lake Sunapee Region with easy access to I-89. Enjoy lake activities, golf, XC ski trails, tennis, pickleball, an indoor pool, fitness center and more.