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='3') and (bedrooms='3')
AND list_price BETWEEN '0' AND '30000000'
ORDER BY list_price Desc
Upper Valley Area NH Homes page 10
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:PRICE REDUCTION/NEW BATHROOM!! Price reduced to sell! Brand new bathroom, and 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 , enjoy a newly remolded first floor bathroom! 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). Right in the heart of the Upper Valley! OPEN HOUSE Saturday July,11th. 10AM-12PM !
Description:Welcome to 60 Church Street, a spacious and well-maintained home located in the heart of Lebanon, New Hampshire. Situated on a quiet street just steps from downtown amenities, this property offers an ideal combination of comfort, convenience, and flexibility for a variety of living arrangements. The home features generously sized bedrooms, providing ample space for residents, guests, or home office setups. Thoughtful storage solutions can be found throughout the property, a rare and highly desirable feature that helps keep living spaces organized and functional. From closets and built-ins to additional storage areas, there is room for everything without sacrificing living space. Gorgeous hardwood floors throughout and a quaint yard with deck. One of the property's standout advantages is its location. Downtown Lebanon's restaurants, shops, parks, and community amenities are all within easy reach, while major commuter routes provide convenient access throughout the Upper Valley region. The home is also located just a short drive from Dartmouth Hitchcock Medical Center. Whether used as a primary residence, a long-term rental property, or a home with room-rental potential, 60 Church Street offers exceptional versatility. The layout provides privacy and comfort, while the home's size and storage capacity make it practical for multiple occupants. Minutes from downtown and great views of Storrs Hill historic Erling Heistad 50-meter ski jump, one of New England's most recognized community ski-jumping venues. Great location, great price!
Description:A well-maintained 3-bedroom, 2-bath saltbox situated on 4.3 acres in scenic Enfield, NH. Minutes from the undeveloped shorelines of Grafton Pond - 319 acres of paddling paradise. The home features a desirable first-floor primary bedroom and bath, and a bright and welcoming interior throughout. On the second level you'll find two large bedrooms and a full bath. In the unfinished walk-out basement you'll find a laundry area and radiant heat in the concrete floor - plenty of natural light and ample room for expansion. Level and open land. Enjoy peaceful country living with plenty of outdoor space, while remaining convenient to the Upper Valley, Dartmouth College, and DHMC. Please note, the bridge is closed at the junction of Route 4 and Potato Rd, use South Rd, or another alternate route. OPEN HOUSE: Saturday August. 8, 10am-1pm.
Description:Summers spent on sandy beaches are a must with how close this home is to North Cove Beach of Eastman Lake. Outdoor features include a nice level lot with mature landscaping and an updated roof, while inside features an updated kitchen and appliances, propane stoves in the living and family rooms, and a large sun-filled room for year-round enjoyment. This 3-bedroom, 2-bath home has a split-level entry with all bedrooms on the main level and a spacious family room on the lower level. Eastman offers exceptional amenities, including lake activities, a championship golf course, tennis, pickleball, groomed cross-country ski trails, miles of walking and hiking trails, an indoor pool, exercise facility and more! Conveniently located just minutes from the Upper Valley and Lake Sunapee regions and only two hours from Boston. Eastman provides a chance to connect with nature through seasonal recreation and connect with people through welcoming community activities.
Description:Fully renovated, low-maintenance, and move-in ready, this contemporary 3-bedroom, 2-bath home offers approximately 2,300 square feet of flexible living space in a convenient in-town Lebanon location. Extensively renovated in 2022, the bright and inviting main living area features a beautiful, updated kitchen, a large walk-in pantry, hardwood and tile flooring, and oversized newer double-pane windows that fill the home with natural light. A spacious bonus room on the lower level provides an ideal setting for a home office, gym, playroom, or additional living space. A newly completed and town-approved accessory dwelling unit (ADU) offers a private entrance, full kitchen, bathroom, and an easy, separate layout. Previously rented for $1,550 per month, the ADU provides meaningful income potential to help offset the mortgage while also offering an excellent option for extended family, guests, or multigenerational living. Major low-maintenance improvements include a standing-seam metal roof, new premium vinyl siding, a new furnace installed in 2025, public water and sewer, updated wiring, and 200-amp electrical service. The property also includes two on-site parking areas and a welcoming wraparound deck. Located within walking distance of downtown Lebanon, with convenient access to restaurants, shopping, schools, public transportation, and Storrs Hill Ski Area, this turnkey property combines modern updates, flexibility, income potential, and exceptional convenience.