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 10
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
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: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:Located on scenic Blueberry Hill Drive with the beautiful Killington Mountain range as its backdrop, this spectacular white brick home offers lovely views from nearly every room in the home. Offering over 2,360 square feet of above-grade living space plus more than 1,500 finished square feet below grade, this spacious four-bedroom, three-bath residence provides exceptional room for both everyday living and entertaining. The dramatic living room features large windows, a striking brick fireplace, and direct access to a large Trex deck where the view takes center stage. Adjacent to the dining room, a charming glass sitting room creates the perfect place to relax and enjoy the ever-changing mountain scenery. The thoughtfully designed kitchen overlooks beautiful gardens and a stone patio and features cherry cabinetry, Corian countertops, and a comfortable eat-in counter area. Downstairs, the expansive Great Room offers a second impressive stone fireplace, bar, and wet bar, creating an ideal space for gatherings. A bright and inviting office or studio provides flexibility for remote work, hobbies, or creative pursuits. All four generously sized bedrooms are conveniently located on the same level. The primary suite enjoys its own private bath, while three additional bedrooms share a full bathroom. Practical amenities include a two-car garage and an oversized tiled mudroom with entrances from both the driveway and garage. A laundry area and additional bathroom complete this functional space. Set on 2.47 private acres, with opportunity to purchase an additional 2.16 acre parcel located directly below this home on Blueberry Hill Drive. Ideally situated 3.5 miles from the Lebanon Green, five miles from Dartmouth Hitchcock Medical Center and less than six miles from Dartmouth College this home has a wonderful location! Agent has personal interest in this property. Home is vacant and has been digitally staged in photos.
Description:Step into timeless elegance with this extraordinary 1929 Classical Revival home, where historic craftsmanship and gracious living come together beautifully. Period details include ornate plaster moldings, stained and beveled glass windows, quarter-sawn oak floors, rich mahogany doors, extra-high ceilings, a sweeping front staircase, and a classic fireplace that creates a warm, dramatic sense of arrival. Offering nearly 5,000 square feet, the home features five bedrooms and six baths, including four ensuite bedrooms for comfort and privacy. Two expansive porches, including a screened porch, overlook spectacular perennial gardens filled with layered plantings, seasonal blooms, and mature landscaping that provide color and fragrance from spring through fall. Pollinator-friendly varieties attract birds and butterflies, while established borders and intimate garden spaces create a serene, park-like setting ideal for morning coffee, sunset gatherings, and evening stargazing. A charming portico and garage add convenience while preserving architectural character. Ideally located in Historic Shaker Village minutes from Dartmouth College and Dartmouth Health, the property offers rare flexibility. Formerly a successful bed and breakfast and now a single-family residence, it is well suited for elegant private living or renewed hospitality use. Enjoy year-round recreation with nearby lake activities, rail trails, and mountain biking, plus easy access to multiple ski areas including Whaleback, Sunapee, Dartmouth Skiway, and Ragged Mountain, with Killington, Stowe, and Loon about an hour away. Completing this remarkable offering is a peaceful, private meditation chapel — a truly unique retreat space that sets this home apart.