SELECT Id FROM new_searchtable
where
(town = 'Cornish' and state='NH'
or town = 'Eastman' and state='NH'
or town = 'Enfield' and state='NH'
or town = 'Hanover' and state='NH'
or town = 'Lebanon' and state='NH'
or town = 'Lyme' and state='NH'
or town = 'Plainfield' and state='NH'
)
and (type = 'R' or type ='O')
and (bedrooms='3') and (bedrooms='3')
AND list_price BETWEEN '0' AND '30000000'
ORDER BY list_price Desc
Upper Valley Area NH Homes page 15
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:Charming, inviting, and wonderfully connected to all that Lyme has to offer, this village home pairs classic New England character with beautiful western views and an exceptional Upper Valley location. Set on spacious grounds overlooking protected conservation land, the property enjoys an open sky and memorable sunsets that will remain part of the view for years to come. Inside, the home offers 3 bedrooms, warm and comfortable living spaces, and the character that makes an older home feel special. A screened porch becomes an extension of the living space for three seasons, perfect for morning coffee, summer dinners, or relaxing at the end of the day. Mature sugar maples, a generous yard, and a barn offering storage for bikes, skis, tools, and more add to the property’s appeal. Recent investments in a substantial solar array, heat pumps for heating and cooling, and a heat pump hot water heater bring modern efficiency to this classic home. It was just recently repainted inside and out making it move-in ready. Located at the edge of Lyme village, everyday conveniences are just a short stroll away, while outdoor recreation is equally accessible. Walk to Grant Brook for a summer swim, hike Lyme Pinnacle from the backyard, launch a kayak on the Connecticut River, or head to nearby Dartmouth Skiway and the Greens for winter adventures. All this within easy reach of Hanover and Dartmouth, and with access to the highly regarded Lyme/Hanover school system. Just 25 min to DHMC, 15 min to Dartmouth college, 2h 15min to Boston. A special opportunity to enjoy village convenience, country charm, beautiful views, and the quintessential Upper Valley lifestyle.
Description:Enjoy the comfort and convenience of this newer 2023 built home, ideally located on a paved dead end street in the Village. From the moment you step inside, this home has the wow factor, with a bright, open layout and thoughtful finishes throughout. The impressive kitchen is the centerpiece of the main level, featuring granite countertops, a large breakfast island, under-cabinet lighting, and stainless steel appliances. The kitchen flows seamlessly into the living areas, creating a welcoming space for everyday living and entertaining. Doors lead directly to the wraparound deck, extending the living space outdoors. The fenced in lawn provides a great space for pets, play, or simply relaxing at home. The home features modern bathrooms on first and second level, including a spacious primary suite with its own full bath and walk-in closet. An impressive extra-wide, 4-foot staircase leads to the second floor, where conveniently located laundry adds to the home’s thoughtful and functional design. The partially finished basement provides additional usable space with plenty of potential, while the one-car garage adds even more convenience. Located just steps from the rail trail and abutting to the Mascoma River, with an easy commute to Dartmouth Hitchcock Medical Center and the Upper Valley, this impressive home combines newer construction, a great layout, outdoor living, and a location that is hard to beat.
Description:OPEN HOUSE - SATURDAY 8/29 from 10-12. Welcome to your private country sanctuary. Situated on 3.2 peaceful, scenic acres in a highly desirable area, this beautifully maintained 3-bedroom, 2-bathroom residence offers over 1,700 square feet of comfortable, move-in-ready living space. Inside, you will find a bright and spacious layout designed for modern comfort, featuring generous living areas filled with natural light, a Rinnai on-demand system for ample hot water, and picturesque views of the surrounding grounds from every room. The kitchen shines with sleek granite countertops, custom cabinets with slide-out drawers, and ample pantry-style storage, highlighted by an replica Elmira 1865 dual-fuel cooking stove (available as a negotiable inclusion).Outside, the property is a true hobby farmer’s or equestrian’s dream, anchored by an exceptional 3-stall Amish-built barn complete with water and electricity, along with an adjacent fenced-in paddock ready for horses or livestock. The meticulously landscaped parcel features a prominent stone retaining wall, vibrant established perennial garden beds that bloom year after year, and mature sugar maples ready for seasonal tapping. Despite the serene and secluded setting, you are never far from everyday necessities and year-round adventure: enjoy quick access to shopping, local public services, and a favorite nearby swimming hole, with premier skiing just 10 miles away and regional hospital services and dining destinations within an easy 20-minute drive. Whether you are looking for an active homestead, equestrian property, or a quiet retreat close to modern conveniences, this turnkey country home offers an exceptional lifestyle opportunity.
Description:Privacy, convenience, and beautifully updated living spaces come together in this inviting Lebanon home. Set on approximately 0.7 acres in an established neighborhood, the property enjoys a wonderfully private setting while remaining just minutes from downtown Lebanon, shopping, dining, recreation, Dartmouth Hitchcock Medical Center, and the many amenities of the Upper Valley. Inside, the updated kitchen and baths bring a fresh, polished feel to the home, complemented by a comfortable and functional floor plan designed for everyday living. Three bedrooms provide flexibility for family, guests, or a dedicated home office, while the finished lower level expands the possibilities with additional space for a family room, fitness area, hobbies, work-from-home needs, or guest overflow. An enclosed porch creates another inviting place to relax and enjoy the surroundings, while the attached two-car garage adds convenience through every New England season. Outside, the generous lot provides breathing room, privacy, and space to enjoy the outdoors without the upkeep of a much larger property. With thoughtful updates, flexible living space, a private setting, and excellent proximity to downtown Lebanon and the Upper Valley’s major employment and recreation centers, this home offers an appealing balance of comfort, convenience, and location.
Description:Welcome to 793 Shaker Hill Road - an inviting 3-bed, 2-bath home situated on 2.25 acres in the heart of Enfield. Offering a wonderful blend of modern comfort, character, and convenience. The spacious great room is a standout feature, complete with a grand fireplace that creates a welcoming gathering space. The tasteful kitchen features granite countertops, solid wood cabinetry, and plenty of room for preparing and enjoying meals. Outside, the back deck and fully-fenced yard provides space to relax, play, garden, or simply enjoy the peaceful New Hampshire surroundings. Located near Crystal Lake, Shakoma Beach, the Shaker Inn & Museum, and the Enfield Dog Park. A comfortable home, a beautiful setting, and a desirable Enfield location - this property is ready to welcome you home. A quick commute to Dartmouth, DHMC, and the Greater Upper Valley of NH and VT. Open House: Saturday Aug. 15, 10am-1pm