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 (createtime >='2025-04-20 11:03:10') and (createtime >='2025-04-20 11:03:10')
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:Welcome to 36 Dartmouth Avenue, a spacious and beautifully maintained home just minutes from DHMC, top schools, and local trails. Located in a desirable Lebanon neighborhood, this property blends comfort, convenience, and expansion potential. The light-filled open-concept layout features hardwood floors, a cozy pellet stove, and a large living area ideal for relaxing or entertaining. The kitchen offers cherry cabinetry, a center island with seating, and stainless steel appliances. The adjacent dining space flows seamlessly into the living room for an easy, connected feel. Upstairs, the primary suite includes a private bath with dual sinks and ample closet space. Additional bedrooms are roomy and bright, perfect for guests, family, or home office setups. the main office with a pleasant glass door adds work-from-home flexibility or the fourth bedroom. The lower level is already framed and wired, offering the exciting potential for even more finished living space, whether a media room, gym, or space to spread out. Outside, enjoy a fenced-in backyard with a large deck, and ample space to gather. The oversized two-car garage adds storage and style with a barn-inspired facade. With its convenient location and room to grow, this home offers the best of Upper Valley living.
Description:Convenient location, optional 1-floor living, and extensive, thoughtful updates come together in this fully move-in ready home. The main floor includes a large and inviting kitchen with newer stainless steel appliances including a double oven and Wolf range, Crown Point cabinetry, and marble countertops, a separate dining room, living room with fireplace, 2 bedrooms that share a full bath, plus a primary bedroom with updated 3/4 en-suite bath. The lower walkout level features another bedroom, full bath, large playroom or den with Hearthstone wood stove, office space, laundry and workshop, plus plenty of extra storage space. Outside you'll find a newly resurfaced Trex deck from which there are lovely seasonal mountain views, a fenced yard with raised garden beds and mature plantings, and a paved circular drive. Recent updates are numerous and a full list is available on request but energy efficiency was a priority. A fully-owned 10-megawatt solar panel system, an electric heat pump hot water heater, a Level-2 CCS EV charger and Anderson 400 Low-E windows are some highlights. Located almost equidistant to Dartmouth College, DHMC, West Lebanon, and the Miracle, commuting and shopping are a breeze. SHOWINGS BEGIN AT OPEN HOUSE SATURDAY, APRIL 26 10:30-1:30.
Description:Come to Etna and make your new home on Dogford Road. This contemporary home has it all. From a large open kitchen/living/dining room combination family and guests can disperse to any number of getaways in this multi level home. Enjoy the abundant wildlife, songbirds, hooting owls, and a crows nest where you can escape amongst the trees. Two bedrooms, a full bathroom and workout area complete the lower walk out area. The main floor has a vaulted ceiling along with a generous full length deck. Enjoy great natural light from all levels of this home. The house sits up high so you really feel the privacy afforded by the trees, particularly at the rear. The primary bedroom is oversized and and has it's own ensuite bathroom. The other bedroom on this level is served by a three quarter bath and then via a spiral stairwell you can escape the madding crowd and vanish up to the aforementioned crows nest with it's little balcony. Read, craft, nap-whatever-this is a really cool space. The 4.2 acres is mixed with some wetlands at the back, some very nice terracing near the house and also blueberry bushes are a plenty. This is a really lovely property and could be your next home. Come and check out 420 Dogford Road you won't be disappointed. Delayed showings begin with an Open House on Saturday April 26th, 2025 between 11:00 AM - 1:00 PM.
Description:After more than 50 years of being cherished and lovingly cared for by the same family, this 3-bedroom, 4-bath charmer awaits its next chapter. Set on .71 private acres with 210 feet of waterfront, the home invites you to slow down and savor every moment — whether soaking in the sunken spa in the detached sunroom, floating in the peaceful waters, watching sunsets from the mahogany deck, or strolling down the tree-lined street. A 42-foot aluminum dock with new thru-flow decking extends into the lake’s deep waters, providing the perfect platform for boating, fishing, or simply enjoying the serene surroundings. The home’s cedar shake siding brings charm to the property, while the whole-house standby generator offers practicality. The quiet location ensures a peaceful retreat. Floor-to-ceiling windows bring the lake into the heart of the home, and thoughtful updates offer comfort and ease. Although it is a seasonal home, this treasured property is ready to welcome year-round memories with some modifications. Here, the days are longer, the air is sweeter, and the lake feels like it belongs only to you.