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 15
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:Nestled in the heart of the charming village of Etna sits this quintessential four bedroom farmhouse that offers a rare blend of historic character, natural beauty and country living. Set on three picturesque acres of pasture, fields and a bordering brook, the property provides a peaceful setting with room to roam, garden or enjoy outdoor recreation. Inside, the home is rich with timeless farmhouse charm, featuring warm hardwood floors, exposed beams, and inviting living spaces that reflect its heritage while offering everyday comfort. The four bedroom layout provides ample space for family, guests, or a home office. Outside, a classic detached barn adds both character and functionality, complete with stalls and plenty of space for hobbies or storage. Meandering paths and trails wind through and around property, inviting exploration and offering opportunities for walking, riding, and enjoying the surrounding landscape. Whether you're seeking a country retreat, a small farm, or a historic New England home with enduring appeal, this Etna farmhouse offers a unique opportunity with close proximity to the Etna Library and Hayes Nature Preserve.
Description:Tucked into a picturesque tree-lined neighborhood with buried power lines, a central grassy common area, and a charming community mailbox gathering spot, this beautifully maintained home offers the perfect blend of comfort and convenience just five minutes from downtown Hanover. A welcoming covered front porch leads into a gracious foyer, while a second entrance from the attached two-car garage provides easy access directly into the kitchen. The main level is thoughtfully designed for both everyday living and entertaining, featuring a bright kitchen with a casual dining area, a separate formal dining room that could also serve as a home office or den, and a spacious living room anchored by a cozy gas fireplace. The living room opens directly onto the large back deck with built-in bench seating, where you can enjoy peaceful views of the level grassy backyard and the wooded backdrop beyond. A convenient half bath completes the main level. Upstairs, the home offers four bedrooms, including a serene primary suite with its own 3/4 bath and walk-in closet. Three additional bedrooms share a well-appointed full bath, providing comfortable accommodations for family and guests alike. The walk-out lower level is partially finished, offering flexible space for a recreation room, media area, gym, or hobby space, while also housing the laundry area and additional storage. Ideally situated just minutes from Dartmouth College, DHMC, and all the shops, restaurants, and cultural amenities of downtown Hanover, this home combines a serene neighborhood setting with exceptional proximity to everything the Upper Valley has to offer. Only 5 minutes to downtown Hanover, this is a rare opportunity to enjoy peaceful residential living without sacrificing convenience.
Description:Cottage Hill Farm is a rare opportunity to experience the beauty, character, and enduring spirit of a historic New England farmhouse thoughtfully renovated for today’s lifestyle. Set on 3.8 picturesque acres, this exceptional property blends timeless architectural character with the comforts and flexibility of a modern country home. Dating to approximately 1792, the property was a working farm for nearly two centuries, continuing its agricultural tradition into the 1980s. Today, its seasoned historic barns stand as a remarkable reminder of the property’s past while offering exciting possibilities for hobbies, animals, workshops, storage, or simply enjoying the romance of a classic Vermont-New Hampshire farm setting. Expansive lawns, mature trees & gardens, open countryside, and beautiful westerly views create a peaceful backdrop, with spectacular sunsets adding a magical close to each day. Inside, the renovated five bedroom farmhouse offers a dreamy, spacious cottage-inspired floor plan designed for comfortable everyday living and effortless entertaining. Generous living spaces, warm natural light, inviting gathering areas, and the character one hopes to find in a historic home create an atmosphere that feels both authentic and wonderfully livable. Long covered porches extend the living experience outdoors, providing the perfect perch for morning coffee, afternoon relaxation, or watching the sun disappear past the gardens and fruitful peach tree. Adding exceptional versatility, a private one or two bedroom ADU or in-law suite provides flexible space for guests, extended family, a home office or studio, or potential rental income. Whether envisioned as a hobby farm, a peaceful country retreat, a multigenerational property, or simply a beautiful place to call home, Cottage Hill Farm offers room to live, create, gather, and dream. Please join us for an Open House on Saturday, August 29th from 10 AM - 1 PM.
Description:Price adjustment! This BRAND NEW home is a fresh, modern offering in Etna. This 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.
Description:Looking for a property that truly has it all? Look no further than 376 Orford Road, in the coveted town of Lyme, NH. With 4,500 square feet of wonderfully comfortable and functional living space, the first floor offers a primary en suite bedroom, 2 additional bedrooms and bathrooms, a large living room, spacious eat-in kitchen, mudroom and laundry. The lower level includes a media room, recreation room, exercise room and office. Attached to the main residence, and with its own entrance as well, is a two story auxiliary dwelling unit equipped with a full eat-in kitchen, living room, laundry, 3/4 bathroom and private deck - ideal for in-laws, a nanny or rental opportunity. The back of the home connects to the level, landscaped, and fenced-in backyard area with a deck, in-ground pool, and pool house - ideal for relaxing or entertaining. The oversized 3 car garage has an upper level that could easily be finished off for additional living space, or is ideal "as is" for a home office or business storage. The abutting conserved land offers lovely pastoral views and westerly sunsets. Rounding out the property is another large outbuilding and separate shed for all your storage needs. Lyme is home to one of the most highly rated K - 8th grade schools in the state and is a short drive to Hanover, Dartmouth College and Dartmouth Health. Don't miss this incredible opportunity for a property that has everything you want, and more.
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.