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 list_price BETWEEN '1000000' AND '99999999'
ORDER BY list_price Desc
Upper Valley Area NH Homes page 0
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
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 beautifully renovated 3-bedroom, 3-bath split-level home offers the perfect blend of modern updates and an unbeatable Hanover location. Thoughtfully redesigned from top to bottom, the property features all-new siding, roof, windows, central air conditioning, and stylishly updated kitchen and baths. Bright, comfortable living spaces and a versatile floor plan make everyday living and entertaining effortless. Set in a sought-after neighborhood within easy walking distance to the highly acclaimed Hanover elementary and middle schools, this turnkey home combines quality, convenience, and timeless appeal.
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 bedrooms plus a bonus room, 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.
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:Super Sunsets on Crystal Lake! This private 2006 lakefront home offers 112' of pristine waterfront with 3 bedrooms, 2 baths, cathedral ceilings, and an open-concept living area filled with natural light and stunning lake views. The finished walkout basement provides extra space for family and guests, while the full-length screened porch, lakeside deck, grassy yard, and established docks make outdoor living easy. A drilled well, storage shed, and shared ownership of 21+ wooded acres with trails across the road complete this exceptional property. Location, location, location!