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 25
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:A sportsman's Paradise! Set on 5.5 private acres in a quiet rural setting, this well-built 2008 log home offers the warmth and character so many buyers are looking for. With 3 bedrooms and soaring cathedral ceilings, cherry and red oak hardwood flooring, the home feels open, comfortable, and connected to its natural surroundings. Recent improvements include a new heating system, adding efficiency and peace of mind. A large wraparound deck creates great outdoor living space for relaxing, entertaining, or taking in the peaceful setting. The property abuts conservation land with established trails, giving you direct access to hiking, snowshoeing, and year-round outdoor recreation right from the backyard. The location offers a nice balance of privacy and convenience, with close proximity to Mascoma Lake, Mt Sunapee, Whaleback, DH Medical Center and all Upper Valley amenities. Whether you're looking for a year-round home or a getaway in New Hampshire, this property captures the classic feel of log home living in a beautiful Enfield setting.
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. More photos coming soon. Showings start on 5/30/26.
Description:Tucked away on three private, wooded acres, this charming Cape Cod offers the perfect blend of tranquility and efficient home design. The main level features a nicely proportioned living room, an eat-in kitchen, and a family room with a fireplace, plus a convenient half bath. Upstairs, three bedrooms include a spacious primary suite with a full bath, a study perfect for working from home and an additional three-quarter bath. The finished basement adds even more flexibility with a bonus room ready to become a playroom, home gym, or creative space, along with a three-quarter bath. Recent upgrades include a new roof, exterior paint, heat pump technology for efficient cooling, and updated bathrooms throughout. This is a wonderful place to call home.
Description:Located just a half mile south of the Dartmouth Green, this beautifully updated raised ranch offers the perfect blend of comfort, flexibility, and convenience. Tucked on a level, landscaped lot with lawn space and landscaping, the home provides an easy lifestyle in a truly exceptional location, walkable to downtown, schools, dining, and recreation. The thoughtfully designed main level features three bedrooms--one ensuite with a 3/4 bath and two that share an additional full bath. Sunlight fills the welcoming living room, while the adjoining dining area opens seamlessly onto a deck — ideal for morning coffee or summer BBQs. The updated kitchen offers both style and functionality, creating a warm central gathering space for everyday living. The finished lower level adds remarkable versatility, with a large family room centered around a cozy wood stove, perfect for relaxing evenings or casual entertaining. A full bath, laundry room, dedicated office, and smaller bonus room provide flexible spaces to work, create, or host guests with ease. Direct access to the attached one-car garage adds everyday convenience, especially during New England winters. With recent updates, abundant usable space, and an unbeatable in-town setting, this move-in-ready home offers the rare opportunity to enjoy comfort, character, and walkability in the heart of Hanover. Furnished photos are virtually staged.
Description:This waterfront gem has been thoughtfully enhanced with numerous recent improvements, including a newly winterized sunroom that adds 264 square feet of light-filled living space with sweeping water views. The updated exterior façade, new privacy fencing, and improved stairway leading to the private sandy beach and swimming area further elevate the property’s appeal. Offering ~3,000 sq ft across three levels, this home features 2–3 bedrooms, 3½ baths, and flexible living areas. Enter through the generous mudroom into an open-concept kitchen, dining, and living area designed for both everyday comfort and effortless entertaining. This inviting space flows seamlessly into the newly heated, insulated sunroom perched above the water’s edge, where panoramic lake views can be enjoyed year-round. The lower level offers a full bath and two oversized rooms ideal for bedrooms, office, or family space, both with walkout access to the lakeside deck. The lowest level includes a partially finished area, full bath, workshop, and direct walkout waterfront access. Conveniently located near Dartmouth College, Dartmouth Hitchcock Medical Center, and premier ski resorts—this is the ideal year-round lakefront paradise.