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 '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:Location, location, location! Enjoy the serenity of rural life without sacrificing accessibility—just five minutes away, the 12A plaza provides easy access to shopping, dining, and essential services. 1.9+/- scenic acres on the Blood Brook, this charming 3-bedroom, 2.5-bath home invites you to unwind with the soothing sounds of nature right in your backyard. Inside, you’ll find a comfortable and functional layout with ample living space. Close proximity to Kimball Union Academy, True's Ledges Natural Area, Mac's Maple, Riverview Farm, Dartmouth, and everything else life in the Upper Valley has to offer!
Description:Spacious property with endless possibilities in a prime location near the Lebanon Green and convenient access to Interstate 89. Just 10 minutes to Dartmouth College, this versatile property has served as both a veterinarian office and residence for the past two owners, offering outstanding potential for a home business, investment property, or multi-family conversion. The main home features three bedrooms and two baths with beautiful hardwood floors, sun-filled living spaces, and charming character throughout. A separate one-bedroom, one-bath apartment provides excellent rental income potential or space for extended family and guests. Outside, the beautifully landscaped yard is filled with mature perennial gardens creating a welcoming and peaceful setting. Whether you are looking to continue a professional use, create multiple apartments, or simply enjoy a spacious home with income opportunities, this property offers flexibility and location in one attractive package.
Description:One of a kind custom built home with passive solar design. Open concept includes 2-3 bedrooms, kitchen, dining area, living room, office/rec room, finished space in lower level, 1 & 3/4 baths, workshop area. Detached outbuilding and shed included. Great .8+/- acre lot for gardening and play. New heating system, some new windows and mini splits for AC. 2-bedroom septic system.
Description:PRICE IMPROVEMENT!! Motivated sellers! Welcome Home to 21 Foliage View Road! Nestled in a highly desirable, peaceful Lebanon neighborhood, this single-family home offers the perfect blend of tranquil Upper Valley living, fantastic structural updates, and unmatched everyday convenience. Featuring 3 spacious bedrooms, 2 bathrooms, and 1,482 square feet of bright living space, this property is ready for its next chapter. Peace of mind comes built-in with major recent capital improvements, including a brand-new roof and brand-new windows throughout, ensuring excellent energy efficiency and structural integrity for years to come. Inside, the home offers a fantastic opportunity to truly make the space your own: the first-floor bathroom has been prepped and cleared out, serving as a clean, blank canvas ready for your custom finishes and personal design vision. Outdoor enthusiasts will fall in love with the location. Step outside to enjoy incredible proximity to the area's premier local trail networks, offering miles of scenic hiking, biking, and walking paths right at your doorstep. Best of all, you do not have to sacrifice convenience for privacy. This home boasts an exceptional location just minutes from Dartmouth-Hitchcock Medical Center (DHMC), Dartmouth College, and the bustling downtown areas of both Lebanon and Hanover. Enjoy quick access to local shopping, dining, top-rated schools, and major commuter routes (I-89 and I-91). Bring your design ideas and seize the opportunity to customize a peaceful retreat right in the heart of the Upper Valley! OPEN HOUSE Saturday July,11th. 10AM-12PM !
Description:Near Crystal Lake in Enfield on a quiet country road with the feel of rural while being so close to everything. You will be amazed as you walk in off the covered porch into the mudroom area to the open concept kitchen/dining/living room with cathedral ceilings and sliders to the deck overlooking the 2 acres with open field, pear, apple and plum trees, blackberries, blueberries, garden with mature asparagus patch, laced by trees on the sides. New kitchen with granite counters, farmhouse style stainless steel sink, an abundance of cabinets, pantry cabinet, and new appliances. 2 bedrooms & new full bathroom on the first floor. New radiant heating system, wiring, engineered hardwood flooring, foam insulated, and freshly painted interior. Brick hearth with woodstove included. Custom moldings, staircases to the loft for your office or bedroom. Full walkout basement with a 3/4 bath, office, laundry, rec room with partial finish and patio doors to the rear yard. 8x16 storage shed plus a chicken coop with power and water. Within a 1/2 mile to Crystal Lake dam for fishing, nearby Colette Trail for hiking, Grafton Pond and Spectacle Pond with public access. Convenient travel to I-89, Dartmouth College, Dartmouth Medical, VA, the Upper Valley & New London area.