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.