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 >='4') and (bedrooms >='4')
AND list_price BETWEEN '0' AND '30000000'
ORDER BY list_price Desc
Upper Valley Area NH Homes page 20
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:Tucked away on 6.3 acres, this classic 1998 Colonial offers a rare blend of seclusion and modern comfort. Built and lovingly maintained by the original owner, the home has a spacious open floor plan, and abundant natural light through oversized windows. The heart of the home is the bright eat-in kitchen, opening to the back deck—perfect for morning coffee while watching local wildlife. Upstairs, the second floor features a generous primary suite, three additional bedrooms, and a versatile den/office. Downstairs, the large, unfinished walkout basement is a blank canvas. Whether you envision a home gym, a media room, or an expansive workshop, the possibilities are endless. Complete with an attached two-car garage, this is the perfect place to call home.
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.
Description:A rare opportunity in the heart of Hanover! Known as the former “David’s House,” this historic property was originally built in 1880 and has been renovated and updated throughout the years. Offering over 3,000 square feet of living space, 9 bedrooms, and 5 bathrooms, this property provides tremendous flexibility and potential. The third floor features a separate one-bedroom apartment, offering additional possibilities for rental income, guests, extended family, or private living space. The property is served by town water and sewer and features a built-in sprinkler system, fire escapes, walkout partially finished lower level, and a warm and inviting covered front porch. A large parking area with road frontage on both Prospect Street and West Street adds to the property's versatility and accessibility. While the home may require renovations to return it to a traditional single-family residence, the possibilities are substantial. With its prime in-town location, historic character, generous square footage, third-floor apartment, town utilities, and unique access from two streets, this is a compelling investment opportunity in Hanover. Bring your vision and unlock the potential of this truly special property!
Description:For the first time in nearly 250 years, this remarkable 1780 colonial is being offered for sale. Thoughtfully cared for by the same family for generations, this exceptional 52-acre estate offers a rare opportunity to own a piece of New Hampshire history in the heart of Lyme. As you pull into the driveway, you're welcomed by rolling fields, mature hardwoods, and the peaceful setting that makes this property truly special. Inside, you'll find hand-hewn beams, wide pine floors, abundant natural light, four bedrooms, two bathrooms, a full basement, and timeless craftsmanship that reflects the history and character of this remarkable home. A drilled well, newer septic system, and an automatic-feed pellet furnace with oil baseboard backup provide modern convenience while complementing the home's historic character. Step outside to discover a four-stall horse barn complete with a tack room, fenced riding area, a network of mowed trails, a four-bay pole barn, multiple outbuildings, an oversized garage equipped with a professional-grade lift capable of servicing one ton trucks, and a fenced backyard. Beyond the buildings, the 52 acres offer a beautiful blend of open fields and mature hardwood forest, all enrolled in Current Use, creating plenty of room for horses, recreation, farming, or simply enjoying the surrounding landscape. Despite its private country setting, you're just 10 minutes from Lyme Elementary and Middle School, 15 minutes from Hanover, Dartmouth College, and I-91, and only 20 minutes from Dartmouth Health.
Description:Discover a quietly captivating Contemporary, where natural light pours in and the landscape becomes an ever-present part of the experience. Nearly every room frames a view, inviting you to slow down, settle in, and savor the setting. Thoughtfully designed gathering spaces offer both openness and intimacy. Host dinners in the formal dining room, linger over morning coffee in the breakfast nook, or curl up by the fire as the hillside shifts with the seasons. With generous proportions, the living areas adapt beautifully, whether entertaining, unwinding, or simply living with ease. For those who work from home, a full-size office with built-in bookshelves and expansive windows provides an inspiring place to spend your days. The kitchen is functional, crafted for those who love to cook and connect. A nearby pantry and direct-access mudroom streamline daily routines and arrivals. The east wing features three main-level bedrooms and two full baths, creating both comfort and flexibility. Upstairs, the primary suite feels like a private retreat; wrapped in windows on three sides, filled with soft light, and oriented toward serene northern views. A walk-in closet and full bath with a double vanity complete this sanctuary-like space. A full unfinished basement offers abundant storage, laundry, and direct outdoor access. Outside, rolling lawn, mature landscaping, a solar tracker, and apple trees blend seamlessly with the open field beyond.