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 >='4') and (bedrooms >='4')
AND list_price BETWEEN '0' AND '30000000'
ORDER BY list_price Desc
Dartmouth Area Luxury NH Homes page 25
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:Discover a quietly captivating Contemporary, where natural light pours in and the landscape becomes an ever-present part of the experience. Nearly every room frames a view, inviting you to slow down, settle in, and savor the setting. Thoughtfully designed gathering spaces offer both openness and intimacy. Host dinners in the formal dining room, linger over morning coffee in the breakfast nook, or curl up by the fire as the hillside shifts with the seasons. With generous proportions, the living areas adapt beautifully, whether entertaining, unwinding, or simply living with ease. For those who work from home, a full-size office with built-in bookshelves and expansive windows provides an inspiring place to spend your days. The kitchen is functional, crafted for those who love to cook and connect. A nearby pantry and direct-access mudroom streamline daily routines and arrivals. The east wing features three main-level bedrooms and two full baths, creating both comfort and flexibility. Upstairs, the primary suite feels like a private retreat; wrapped in windows on three sides, filled with soft light, and oriented toward serene northern views. A walk-in closet and full bath with a double vanity complete this sanctuary-like space. A full unfinished basement offers abundant storage, laundry, and direct outdoor access. Outside, rolling lawn, mature landscaping, a solar tracker, and apple trees blend seamlessly with the open field beyond.
Description:Set on 40+/- private acres in desirable Etna, this exceptional 4-bedroom, 3.5-bath home offers breathtaking long-range mountain views, stunning sunsets, and peaceful field vistas. Enjoy the beauty of every season from your own backyard, surrounded by perennial gardens, abundant wildlife, and the sounds of birdsong. As day turns to night, take in spectacular stargazing, where the stars shine brightly above the surrounding mountain and fields. Filled with natural light, nearly every room captures stunning views of the surrounding mountains, fields, and landscape. Inside, you'll find hardwood and tile floors, a spacious laundry room, and a chef’s kitchen featuring beautiful quartz countertops and ample space for gathering and entertaining. Step directly from the kitchen onto the expansive deck, where you can enjoy your morning coffee, watch wildlife, and take in the spectacular scenery. The inviting sunroom provides another peaceful space to relax and appreciate the ever-changing views throughout the year. Cozy up by the woodstove on winter days while enjoying the warmth and charm of this thoughtfully designed home. Additional features include a 2-car garage, abundant attic storage, and a partially finished walkout basement complete with a full bath—ideal for a game room, home gym, guest space, or recreation area. Step outside to the expansive yard where panoramic mountain and field views stretch for miles. With easy access to hiking trails right from your doorstep, outdoor enthusiasts will appreciate the opportunity to explore nature without ever getting in the car. Located just minutes from Hanover, Dartmouth, shopping, dining, and recreation, this property offers a rare combination of privacy, natural beauty, and convenience in one of the Upper Valley's most sought-after locations. Whether enjoying a sunset from the deck or sunroom, relaxing by the woodstove, or exploring the surrounding trails, this remarkable property is a true Upper Valley retreat.
Description:2 HILTON FIELD LANE- Uniquely positioned at the end of Occom Pond with views over the former Hanover Country Club and partial views of the water, Hilton Field Lane presents a rare and extraordinary opportunity to own in the highly coveted Rope Ferry neighborhood of downtown Hanover. The mostly level .7-acre parcel features a lovely mix of landscaping and statuesque mature trees as well as a swimming pool and cabana on the east side of the property. The original 1910 colonial home–officially listed as a 6-bedroom/7-bath–offers stately living and dining areas and gorgeous original details while the entire structure has been well-upgraded and expanded over the years. There is an ADU (accessory dwelling unit) on the lower level as well as rented living space on the east side with a well-established rental history. Reimagine the historic home in your own design or develop a new vision for this incredible lot and location all while enjoying a short walk to Hanover’s shopping and restaurants, Dartmouth campus, and miles of conserved land in Pine Park across the street. Architectural floor plans available.
Description:Welcome to 10 Morgan Road—an expansive brick Colonial perched atop a stunning open meadow with western views across rolling fields to the Green Mountains of Vermont. Spread across 23.5 acres in Hanover's coveted Etna neighborhood, this property is just minutes to downtown Hanover, Dartmouth College, and Dartmouth Hitchcock Medical Center, yet wrapped in privacy virtually impossible to find in the Upper Valley. Built in 1991 and beautifully renovated in 2005, this home offers over 7,000 square feet of above-grade living space across three levels, plus a 3,300-square-foot finished lower level. Its generous size and practical four-level design maximize flexibility, accommodating year-round family living, extensive work-at-home options, inside and outside entertainment, and extended guest visits like no other Hanover property. A dramatic two-story foyer with an elegant double staircase sets the tone. Formal living and dining rooms flow into a spacious kitchen with a sun-filled breakfast area and a family room anchored by a fireplace. The west-facing sunroom is a showstopper—panoramic views, glorious sunsets, and natural light throughout the day. The spacious primary suite features a private office, a double-sided fireplace, a walk-in closet, and a stunning bath. Three additional bedrooms complete the second level. The third floor offers a private guest suite with a sitting room, two additional rooms, a full bath, and cedar closets. The finished lower level—bright and expansive with walkout access—houses a gym, media room, game rooms, craft space, and full bath. An attached three-car garage adds convenience. Outside, open hayfields, mature evergreens, and classic New England stone walls frame a setting of rare beauty. A truly rare opportunity—grand scale, an unrivaled setting, and outstanding proximity to everything the Dartmouth region offers.
Description:Gorgeous house to be built in rural Hanover on a 5.3+/- acre parcel with year round westerly mountain views. With high ceilings and huge imported European triple pane windows and sliding glass doors, the light in this house will be amazing. High end Wolf and SubZero appliances, gourmet kitchen with waterfall soapstone counter and large pantry. First floor master suite with very large marble bathroom and walk in closet. On the lower level, 3 additional bedrooms and bathrooms, each with its own slider to the outdoors. The quality of construction will be absolutely top-notch: this builder is exceptional! Previously built Hanover home will be possible to view.