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 '250000' AND '500000'
ORDER BY list_price Desc
Upper Valley Area NH Homes page 15
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
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:Your opportunity to live where you work! This 2-bedroom home features a two-car garage and sits on 8 acres, complete with a fully functional indoor kennel (built in 2003) and additional outdoor kennel space. Plenty of open area for running and exercise. Take advantage of nearby scenic Smith Pond trail for a true recreational delight!. Located just off of exit 15 off I-89, close to skiing and the Upper Valley!
Description:Post Pond Possibilities!! One of a few number of lots that have pond access. Don't miss the opportunity to be a Post Pond resident. 11 Acres and a Camp/Cottage with rustic character overlooks the pond in a wooded setting. Most of the land already in current use and building envelope is ready for your personal touches. Septic installed new in 2007 with power and a drilled well onsite. Outbuildings for boat storage and more. Come and imagine life on the pond minutes from Hanover, Dartmouth College, and DHMC. All the amenities of the Upper Valley minutes away from your quiet access to nature and wooded serenity.
Description:Ideally located in downtown Lebanon and moments from the Lebanon Green (Colburn Park), local schools, restaurants, grocery stores, shopping, and the Northern Rail Trail, this updated home offers convenient first floor living in a desirable setting. With Dartmouth Hitchcock Medical Center just a short drive away and Dartmouth College easily accessible, this home provides the perfect blend of convenience and tranquility while abutting conservation land. The main level features two bedrooms, two updated bathrooms—one with a walk-in shower and a kitchen with recently updated appliances, providing a comfortable and practical layout. The partially finished basement adds flexible living space, perfect for a home office or entertainment area. The home also includes an attached garage, a welcoming covered front porch, and a yard that's just the right size, offering enough outdoor space for gardening, relaxing, or entertaining without extensive maintenance. Recent utility upgrades add to the home's appeal, providing added comfort and peace of mind for the next owner. With its convenient location, versatile layout, and updates, this home is ready to be enjoyed by its next owners.