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 wf_owned = 'Owned' and wf_owned = 'Owned'
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:EVERY ROOM WITH A VIEW! This exceptional waterfront home with seasonal lake views, has so much to offer! Open concept kitchen, dining and great room with hardwood floors and soaring ceilings. The primary bedroom suite with private bath and walk in closet opens to one of two modern decks with views over the spacious backyard with wildlife abounding and water views. Two more bedrooms in the lower level walkout with large windows making them both light and bright. The media room opens for easy access to backyard games and water's edge. All new modern appliances throughout. Whole house generator. Forced hot water heat and new mini splits for AC. Come enjoy all that Eastman has to offer. Golf, X-country ski, 6 beaches around the lake, tennis, pickleball, fitness room and 25 yard indoor pool! Whether part time or full time Eastman is an experience and this home makes it exceptional!
Description:Own a piece of early New England history with waterfront — a rare combination that almost never comes available. This iconic 1812 stone home sits on a level 0.98-acre lot and includes 130 feet of owned Connecticut River frontage just across the quiet country road, offering easy access for kayaking, fishing, paddle boarding, or simply enjoying the ever-changing water views. Inside, the home blends historic character with comfortable living. The first floor offers a warm and inviting living room with wood stove, country kitchen with dining nook, formal dining room, first-floor bedroom, half bath, sun porch, workshop space, and generous storage. Upstairs you'll find a large primary bedroom, office, and full bath, while the third level provides an additional bedroom and flexible bonus space perfect for guests, studio, or work-from-home use. Original details remain throughout — maple floors on the main level, wide pine floors above, and deep farmhouse window trim — creating the charm only a true period home can offer. Outside, the property is equally special, with mature landscaping, established garden areas, patio space, and a workshop/shed. The river frontage across the road expands the lifestyle, giving you your own personal access to the Connecticut River without sacrificing privacy at the house site. Conveniently located just minutes to I-91 and an easy bike ride to Post Pond and Cedar Circle Farm, this property offers a unique blend of history, recreation, and rural tranquility — a setting increasingly difficult to find in the Upper Valley. Just a 20 minute drive to downtown Hanover & Dartmouth College. High School Choice.
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.
Description:Crystal Lake Front! Don’t let the modest roadfront facade deceive you. This charming 3,000+ sq ft lakefront cottage expands into three inviting levels overlooking beautiful Crystal Lake. Enter through the spacious mudroom into an open-concept kitchen, dining, and living area designed for easy gathering and everyday comfort. The space flows seamlessly into a heated, insulated sunroom perched above the water’s edge, where panoramic lake views can be enjoyed year-round. Also capturing the stunning scenery on this level is the generous primary suite with a private ensuite bath, allowing for comfortable one-level living while hosting family and guests on the levels below. Down a level you’ll find an oversized ensuite bedroom, large family room with fireplace and al fresco porch—perfect for relaxed evenings by the lake. The lowest level offers a large partially finished space with another bath and workshop, ideal for recreation, hobbies, or guest overflow, with direct walkout access to the waterfront.Three exceptional levels designed to capture the beauty of the lake and make the most of lakeside living. Conveniently located just a short drive to Dartmouth College, Dartmouth Hitchcock Medical Center, and several area ski resorts.
Description:DRUM ROLL PLEASE!! A pleasure and a privilege to introduce this GEM - AIA Vermont Design Award 2004 winner. The design and cleverly sited Contemporary waterfront home embodies flair, creative use of space, ingenuity, workmanship, charm and a WOW factor from the minute you enter the door. Light filled, open floor plan on the main level with great large windows, living room with two-way fireplace, with black marble lintel, extends the indoor to outdoor living space on an amazing screened porch complete with views to the Lake and the Knox River at Shaker Boulevard!! AND THEN The Cottage House!! This is another GEM, totally renovated with a well thought out floor plan consisting of one bedroom, kitchen, living/dining area, 1.5 bathrooms, full basement and an amazing wraparound porch with VIEWS, up the Lake and all around!! To describe the setting: Private, level, beach area, docks and an estuary to watch the birds and ecosystem of life survive. This is a must see!!
Description:Set on the crest of Hanover’s prestigious Occom Ridge, The Carleton House is a landmark residence with deep roots in Dartmouth College’s history. Originally built circa 1897, this shingle-style estate combines timeless New England architecture with a coveted in-town location—just a short walk to Pine Park, Dartmouth’s campus, and downtown Hanover. Sited on 1.2 beautifully elevated acres with 273 feet of frontage and sweeping western views over the Connecticut River, the property is accessed via a private driveway, offering both privacy and proximity. The main house features seven bedrooms and is rich in period detail—graciously scaled, light-filled rooms, original hardwood floors, raised paneling, wainscoting, crown moldings, and other hallmarks of its era. Thoughtful updates over time have preserved its historic character while enhancing everyday comfort. The first floor includes an open kitchen/family room, formal living and dining rooms, a spacious front entry hall, rear mudroom, and a half bath. Upstairs, four bedrooms—including a generous primary suite—and a laundry room occupy the second level, with three additional bedrooms and a study on the third. Connected via enclosed breezeway and exterior walkway is a distinct four-bedroom accessory dwelling—a rare feature in this neighborhood. With its own kitchen, two bathrooms, and an open living/dining area, this second home offers versatile living for extended family, guests, or rental income. Elegant, enduring, and intrinsically tied to the fabric of Hanover, The Carleton House is a singular opportunity to own one of the town’s most admired historic homes.