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 35
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:Completed in 2023, this custom-built home is set on 9.41 acres in the Olde Farms subdivision and captures sweeping panoramic views. Enjoy vistas of nearby peaks, including Grantham and Croydon Mountains, as well as Mount Kearsarge, Mount Sunapee, and Mount Cardigan. The elevated setting offers a peaceful location with a private approach from the road. Designed with energy efficiency in mind, the all-electric home is powered by a solar tracking system for much of the year and utilizes high-efficiency heat pumps for both heating and air conditioning. The open-concept floor plan features soaring 22+ foot ceilings in the central living area, expansive windows, and mountain views from nearly every room. A floor-to-ceiling fireplace anchors the living space, which flows seamlessly into a spacious dining area, sunroom nook, and designer kitchen with an oversized island. Adjacent to the kitchen is a flexible guest room with vaulted ceilings and custom barn doors. The upper-level loft, complete with a full bath and large closet, offers additional space suitable for a bedroom, office, or studio. The main-level primary suite is positioned to take advantage of the surrounding views and includes a walk-through closet with custom built-ins and an ensuite bath featuring a tiled walk-in shower and dual vanity. The heated lower level includes an oversized garage with space for up to three vehicles, equipment, and additional storage. This thoughtfully designed property combines contemporary construction, energy-efficient systems, and exceptional mountain views in a convenient Grantham location.
Description:Experience year-round recreation and lakefront living at this stunning log home on the shores of Crystal Lake. Built in 2014 and set on a level .74-acre lot with 401 feet of private waterfront, this exceptional property offers the perfect blend of rustic elegance, comfort lake living with unforgettable outdoor enjoyment. The spacious main level features a desirable first-floor primary suite with a private bath, creating an ideal retreat after a day on the water. Upstairs, you’ll find an additional bedroom, a dedicated exercise room with deck access and lake views, a stylish full bath, providing comfortable accommodations for family and guests. A detached, heated barn with a half bath offers outstanding flexibility for a studio, hobbies, storage, workshop space, or recreational equipment. Whether you’re boating, swimming, snowmobiling, or simply relaxing by the water, this remarkable Crystal Lake property delivers the ultimate four-season lifestyle.
Description:NEW PRICE! - Rarely available in one of Hanover’s most coveted in-town locations, this charming Gambrel Colonial offers the perfect blend of classic 1920s character, thoughtful updates, and unbeatable convenience. Tucked on a quiet street of only four homes on the edge of downtown Hanover, 1 Ripley Road is just moments from Main Street, Dartmouth College, local shops, restaurants, cafés, and all that Hanover has to offer within walking distance. Filled with wonderful natural light due to its excellent southern exposure, the home features three bedrooms, one and a half baths, hardwood flooring throughout, and a warm, inviting layout. The cozy living room includes a wood fireplace, while the dining room off the kitchen showcases a classic 1920s built-in adding timeless charm. The sunroom/family room offers a bright and comfortable additional living space, while the walk-out basement provides laundry, generous storage, a workout area, and office space, adding valuable flexibility to the home. Recent improvements include refinished first-floor flooring in 2020, all-new sunroom windows and fully refurbished first-floor windows with a second pane of glass and new seals in 2021. In 2022, the kitchen and first-floor bathroom were beautifully redone, and all appliances were replaced, offering the ease of modern updates while preserving the home’s original character. A truly special Hanover offering, this property combines charm with modern updates, light, privacy, and a prime walk-to-town location in a way that is increasingly hard to find.
Description:Privately sited on beautifully landscaped grounds in the coveted Mulherrin Farm neighborhood, this impeccably maintained three-bedroom Colonial blends timeless New England architecture with thoughtfully designed living spaces and exceptional indoor-outdoor appeal. Surrounded by mature landscaping and offering a peaceful sense of privacy, this exceptional home is just minutes from Hanover, Dartmouth College, DHMC, and is within the Hanover School District for K-12. The beautifully appointed kitchen flows seamlessly into a stunning vaulted living area featuring exposed beams, a cozy gas fireplace, and oversized windows that fill the space with abundant natural light while framing picturesque views of the surrounding landscape. Rich architectural details and an open, inviting floor plan create an atmosphere that is both elegant and welcoming. The spacious primary suite serves as a private retreat, complete with a generous walk-in closet and a well-appointed ensuite bath. Above the oversized two-car garage, an impressive 27' x 16' heated bonus room with electricity provides exceptional flexibility as a home office, media room, fitness studio, playroom, guest suite, or creative workspace. A partially finished basement offers additional living space ideal for a recreation room, home gym, hobby area, or abundant storage. Step outside to the inviting screened porch, the perfect place to enjoy your morning coffee, entertain guests, or unwind while overlooking the beautifully landscaped grounds. Whether hosting gatherings or savoring a quiet evening surrounded by nature, the outdoor spaces are every bit as inviting as the home's interior. Combining quality craftsmanship, architectural character, and an exceptional location in one of the Upper Valley's most desirable neighborhoods, this is a rare opportunity to enjoy a lifestyle of comfort, privacy, and convenience. OPEN HOUSE Sunday 8/30 from 10 AM- 12:00. See you there!
Description:This substantial expanded Cape on 107 ancres offers an exceptional blend of multi-generational living, extensive workspace, and expansive acreage. The main residence features five bedrooms and four and a half bathrooms, anchored by a beautiful Crown Point Cabinetry kitchen equipped with abundant cabinet and counter space, a woodstove, and direct access to a porch designed for summer dining. A large, elegant living room centers around a classic Rumford fireplace. Recent updates include a new oil-fired boiler with ten heating zones alongside a whole-house generator. A two-car garage provides convenient attached parking. Complementing the main house is a detached guest house featuring a character-rich post and beam upper frame with a sleeping loft and a full bathroom. For projects and storage, the property includes a 24x60 storage building and a premier 24x44 workshop outfitted with radiant floor heat, an 80-gallon compressor, and a 2,000-pound traveling hoist. Set on 107.5 acres, the grounds feature an in-ground saltwater swimming pool, an established pond, a seasonal brook, and an extensive network of trails and wood roads. Beautiful landscaping frames the home, complete with mature plantings of blueberries, rhubarb, and Christmas trees, creating a private and versatile rural retreat.