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 '0' AND '30000000'
ORDER BY list_price Desc
Dartmouth Area Luxury NH Homes page 30
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:This beautifully renovated 3-bedroom, 3-bath split-level home offers the perfect blend of modern updates and an unbeatable Hanover location. Thoughtfully redesigned from top to bottom, the property features all-new siding, roof, windows, central air conditioning, and stylishly updated kitchen and baths. Bright, comfortable living spaces and a versatile floor plan make everyday living and entertaining effortless. Set in a sought-after neighborhood within easy walking distance to the highly acclaimed Hanover elementary and middle schools, this turnkey home combines quality, convenience, and timeless appeal.
Description:Set in a highly sought-after location with easy access to town and nearby trails, this beautifully maintained cape blends comfort, functionality, and convenience. An attached 2-car garage and direct entry add to the home’s everyday ease. Inside, the thoughtfully designed layout begins with a spacious mudroom featuring a walk-in closet and half bath—perfect for staying organized year-round. The open-concept kitchen, dining, and living area creates a natural gathering space, ideal for both daily living and entertaining, with a slider leading out to a private back patio. A dedicated home office offers the flexibility today’s buyers are looking for. Upstairs, you’ll find two generously sized bedrooms and a full bath, along with an oversized primary suite. This inviting retreat features a walk-in closet and an en-suite bath complete with a soaking tub. Convenient second-floor laundry enhances the home’s practical design. The finished lower level provides additional living space with a large family room and full window—perfect for guests, a media room, or a cozy place to unwind. A utility room offers excellent storage or the potential for a small workshop. All of this is just minutes from Dartmouth College and within 10 minutes of Dartmouth-Hitchcock Medical Center. With a level, low-maintenance yard and well manicured perennial gardens, and a location that balances accessibility with outdoor recreation, this home delivers the best of Upper Valley living.
Description:Set on a picturesque 7-acre parcel complete with a beautiful pond perfect for summer swimming and winter skating, this spacious four-bedroom contemporary offers the ideal balance of privacy and convenience just 10 minutes from downtown Hanover and Dartmouth Health. A substantial addition completed in 1990 transformed the home with a stunning open-concept family room featuring soaring ceilings, abundant natural light, an inviting gathering space designed for everyday living and entertaining alike. Above, the spacious primary suite provides a wonderful retreat with a soaking tub and private balcony overlooking the rolling pastures of Dartmouth's, Morton Horse Farm. Additional highlights include a large 4 season porch, a private back deck, a large finished basement offering exceptional flexibility for recreation, hobbies, fitness, and plenty of storage and separate two-bay garage. Call for a showing appt. or come to the Open House on Thursday (5/21) from 1-3.
Description:Terrific 5-bedroom, 3.5-bath Colonial nestled at the end of a quiet cul-de-sac in the highly sought-after Poverty Lane section of Lebanon. Surrounded by gardens you truly have to see to believe, the property offers a rare blend of beauty in a great location. Inside, a family room with fireplace leads into a great gourmet kitchen. Additionally, the living spaces features a formal dining room and living room. The spacious and private primary suite has a walk-in closet and an updated bathroom. Upstairs, you’ll find four additional bedrooms, two full bathrooms, and a dedicated office, offering flexible space for work or study. This house has spaces designed for both wellness and fun with a workout room in the walkout lower level and and an indoor saltwater pool, and hot tub. A unique opportunity to own a peaceful, elegant home in one of Lebanon’s most desirable neighborhoods. Showings by Open Houses - Friday 5/1 3-4:30, Satuday 5/2 11-1 and Sunday, 5/3 2-3:30.
Description:A fresh, modern offering is about to debut in Etna. This newly built contemporary offers a composed, modern feel, combining clean lines with durable finishes. The main level is designed for connection while maintaining definition, with kitchen and dining areas that flow naturally yet feel purposeful. Vaulted ceilings and large windows bring in abundant natural light, and the finishes are current and understated, keeping the focus on space and light. Four bedrooms are thoughtfully distributed across two floors, offering flexibility for guests, work-from-home needs, or long-term living. The primary suite is comfortable and private, and the first-floor laundry adds everyday convenience. A lofted living room adds architectural interest and a sense of openness, creating a light-filled upper level that overlooks the main living space. This area connects seamlessly to an additional second-floor bedroom, providing a flexible option for guests, a studio, or a quiet retreat. The setting is peaceful, with level land that invites a range of uses while remaining easy to maintain. Outdoor space extends the living experience, offering room to garden, gather, or simply enjoy the surroundings. A detached two-car garage and generous parking area complement the home without overwhelming the site. Inside, storage is well considered, with ample closets and practical spaces that support organized, everyday living. Located just minutes from Hanover and Dartmouth, and within the Dresden School District, the property offers a compelling balance of accessibility and a more relaxed pace. Clean, modern, and thoughtfully designed, this home is well executed and ready for immediate enjoyment.