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 (createtime >='2026-07-04 23:12:11') and (createtime >='2026-07-04 23:12:11')
AND list_price BETWEEN '0' AND '30000000'
ORDER BY list_price Desc
Upper Valley Area NH Homes page 0
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:Welcome to Spectacle Pond, a beautiful hidden gem consisting of over fifty acres, perfect for swimming, kayaking or paddle boarding to beat the summer heat. This amazing pond is surrounded by hundreds of acres of conservation land to add to your privacy. If peace and quiet is what you are looking for then this adorable waterfront cottage is perfect for you. Relax on the deck and feel the cool breezes coming off of the water, or enjoy the loons swimming close to shore with their new hatchlings. As a bonus, this cottage comes fully furnished. Recent improvements include the driveway in 2020, a new septic system in 2021 , the house was painted in 2022, as well as a new 40 gallon hot water heater and UV filtration system. Satisfactory septic inspection report is available on request and linked with the listing.
Description:Recently renovated 3-bedroom, 2-bath home ideally located just steps from Lebanon Green, downtown restaurants, shopping, and the Rail Trail. This move-in-ready home features a deck, ample off-street parking, and a desirable corner lot. The attached bonus space, formerly a garage, has been seamlessly incorporated into the home's exterior. This partially finished area offers exceptional flexibility—continue using it for storage or a workshop, or easily transform it into an in-law suite, home office, studio, or additional living space. If you're looking for a home that combines an unbeatable in-town location with modern updates and room to grow, this property offers the flexibility to fit a variety of lifestyles and future needs.
Description:Presenting 4 Bear Dr, a 2006 former Builder's home with many recent upgrades done by the current owners. This handsome Cape/Contemporary features a Cherry/Granite kitchen which was nicely updated in 2021 by these owners with new stainless appliances, new Heat Pump/AC system, whole house generator and fenced yard just to name a few items. This home is designed with 2 bedrooms on the 2nd floor including Primary Suite, an office/guest room on the 1st floor, and 2 bedrooms plus rec. room and family room/office and full bath in the Lower Level. There is a full or 3/4 bath on every level for convenience, plus laundry on the 1st floor and a great layout for home office needs, multi generations or older independent children. Eastman is located conveniently close to Darmouth-Hitchcock Medical Center, Hanover/Dartmouth College and/or New London/Colby Sawyer College, but provides a serene quality lifestyle with an abundance of outdoor recreation activities. If you are looking for all that Eastman has to offer including a private lake with 6 beaches and trails, a clubhouse with fitness center and indoor pool, a fantastic 18 hole golf course, pickleball/tennis courts and more, this may be the one. Come take a look at the open house or schedule a private showing. BE SURE TO CLICK ON THE VIRTUAL TOUR URL TO WALK THROUGH THE FLOORPLAN WITH EMBEDDED PHOTOS. Showings start on Friday 7/10 from 12-5 by appointment, with an OPEN HOUSE SATURDAY 7/11 FROM 10-12. Don't miss a chance to see if this is the home for you!
Description:Gorgeous New Hampshire Lakefront! Wake up to breathtaking unobstructed views of Mascoma Lake in this beautifully situated Shaker Village home. Located across from the peaceful Shaker Museum walking grounds, this end-lot offers privacy while still being part of the sought-after Chosen Vale community. Outdoor enthusiasts will love the easy access to boating, swimming, ice fishing, skating, sledding, snowshoeing, hiking trails in the Lower Shaker Wildlife Management Area, and nearby skiing at Whaleback Mountain. This home boasts direct access to a dock slip and is just a short walk to two shared beaches. Additional features include heat pumps, Powerwall backup battery system, electric vehicle charger, and recently installed on-demand boiler. Conveniently located just 15–20 minutes from Dartmouth Hitchcock Medical Center, Dartmouth College, and White River Junction, this property offers the perfect balance of lakeside tranquility and accessibility. Open house Fri 7/10 3-5pm and Sat 7/11 10am-12pm