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 '500000' AND '1000000'
ORDER BY list_price Desc
Dartmouth Area Luxury NH Homes page 15
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:Nestled along the waterfront of Anderson Pond within the sought-after Eastman Community, this fully renovated home offers an exceptional blend of modern comfort and four-season recreation. Thoughtfully updated throughout, the home features all new windows and doors, spray foam insulation for outstanding efficiency, a heated bonus room over the garage, a standing seam metal roof and a beautifully redesigned kitchen with new appliances and striking Dekton countertops. The focal point beyond the water view is the stone fireplace. As for the community, enjoy the unmatched lifestyle of Eastman’s 3,700-acre residential community surrounding a 345-acre lake, featuring six beaches, championship golf, tennis and pickleball courts, a fitness center, indoor pool, and miles of walking and hiking trails. Whether spending summer days on the water, golfing a scenic round, or enjoying year-round recreation, this property offers waterfront living paired with resort-style amenities in one of New Hampshire’s premier four-season communities.
Description:Fabulous location in highly desirable Hanover, NH! This charming Cape offers the perfect blend of character, comfort, and convenience, just minutes to downtown Main Street, the Co-op, Hanover Elementary, Middle, and High School, Dartmouth College, and with easy access to Dartmouth-Hitchcock Medical Center. Featuring 4 bedrooms, a flexible bonus room, and 3 bathrooms, highlighted by a generous primary suite with dual closets and a private 3/4 bath, this warm and inviting home is filled with classic charm. Cozy up by the wood-burning fireplace with an insert or enjoy relaxing summer evenings on the screened porch overlooking a beautiful yard, perfect for playing or entertaining. Beautiful wood floors flow throughout the main living areas, adding warmth and timeless appeal. The first floor offers a functional layout with an eat-in kitchen, pantry, and mudroom area, along with a comfortable family room and a dining space with a wood-burning stove. A bonus room provides flexibility for a home office or spare bedroom, along with a full bathroom on the main level. Upstairs, you’ll find four bedrooms, including a primary suite with its own private 3/4 bath, along with an additional 3/4 bath. Additional features include a partially finished basement, ideal for a quiet workspace, workout area, or extra storage; and easy access to everything Hanover has to offer. Located in a top-rated school district, with school bus pickup steps away, this home offers both convenience and community. A truly sweet Cape in an unbeatable location; walkable, welcoming, and ready to call home. Don’t miss out! Showings begin at the open houses on Saturday, May 9th from 11:30 AM–1:00 PM and Sunday from 11:30 AM–1:00 PM. Experience the perfect blend of timeless charm and modern comfort, your Hanover home awaits.
Description:This 3 bedroom 2.5 bath home with attached 2 car garage is situated very privately on a beautifully landscaped 3.86 acres in the desirable community of Eastman! The interior is light and bright with many windows throughout. The very spacious primary suite has custom built-ins and an attached laundry room. With a generous den/office, working from home is a fabulous option and the two decks and a sunroom make for lovely areas to enjoy the outdoors and wildlife during your breaks. Two more bedrooms and a full bath up with tons of storage overlooking the living room below, and an additional sitting room in the loft for reading and watching the birds out the windows. Passive Solar and energy efficient! The additional 3 car garage with workshop and massive storage overhead is awaiting your antique cars. This one is calling your name!
Description:The sun streams in to this delightfully bright home set on a gorgeous 3.45 ac site in Lebanon. Spacious great room with beautiful outlook. 2648 sq ft home is currently set up as 1 bedroom, 2.5 bath, with large first floor master suite. Upstairs has a large family/game room and a full bath. Seller will give credit of builder's estimate to add two more bedrooms to the second floor. (House has a 4 bedroom septic system). Full basement provides great space for workshop or more finished space. 2 car garage. Open house Sunday, May 31 from 1--3pm.
Description:Spacious, move-in-ready, contemporary home with 3 bedrooms plus a bonus room, 4.5 baths and over 3,000 SF. Ideally situated on 2+ acres with privacy and views of the meadow and pond. Property abuts Grantham Recreational Park and conservation land. You’ll absolutely love the state-of-the-art kitchen featuring granite countertops, a large island, walk-in pantry, professional-grade gas range, custom tile backsplash, and two dishwashers. The open layout flows into a dining area and continues to an expansive living room with vaulted ceilings and a beautiful fireplace as the focal point. The first-floor primary suite offers a generous walk-in closet and two separate baths for convenience. Two more bedrooms, each with its own bath, and a bonus room are on the lower level. You'll also find a family room filled with natural light in the walkout lower level. Additional highlights include a home office, whole-house generator, direct entry from the 2-car garage, a screened porch, and large wraparound deck. Located just minutes from I-89, this property provides easy access to the Upper Valley and Dartmouth-Lake Sunapee Region. The area offers year-round opportunities for outdoor recreation including kayaking, fishing, skiing, ice skating, and more. All this in a lovely country setting.
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.