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 70
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:Charming 4-bedroom, 3-bath farmhouse nestled on over 4 acres of open pasture and field. This inviting home blends classic character with modern updates, featuring beautiful hardwood floors, an updated kitchen with plenty of space for cooking and gathering, and comfortable living areas filled with natural light. The additional finished space over the garage offers flexibility for a guest suite, office, or recreation room. Enjoy peaceful local mountain views from the screened in porch or spend evenings by the outdoor firepit, perfect for entertaining or relaxing under the stars. With easy access to town, schools, and all amenities, this property combines the serenity of country living with everyday convenience and plenty of blueberries with over 40 bushes to pick from. Ideal for those seeking room to roam, a place for animals or gardens, and a home designed for comfort and connection. Just minutes from I89, Lebanon green and DHMC plus part of this 4 acres has direct access to the rail trail for walking and biking. Open House Saturday March 28th from 11:30-1:00pm
Description:In Town Corner Lot, sits this 4 bedroom, 2 bath Cape style home with sidewalks to Dartmouth and Main Street. The first floor has open floor plan with large living room, dinning area, 2 bedrooms and full bath. The second floor has an additional 2 bedrooms and nicely updated 3/4 bathroom and possible office space. A solid home in a great location would make a great investment or a primary residence.
Description:Nestled in the heart of the charming village of Etna sits this quintessential four bedroom farmhouse that offers a rare blend of historic character, natural beauty and country living. Set on three picturesque acres of pasture, fields and a bordering brook, the property provides a peaceful setting with room to roam, garden or enjoy outdoor recreation. Inside, the home is rich with timeless farmhouse charm, featuring warm hardwood floors, exposed beams, and inviting living spaces that reflect its heritage while offering everyday comfort. The four bedroom layout provides ample space for family, guests, or a home office. Outside, a classic detached barn adds both character and functionality, complete with stalls and plenty of space for hobbies or storage. Meandering paths and trails wind through and around property, inviting exploration and offering opportunities for walking, riding, and enjoying the surrounding landscape. Whether you're seeking a country retreat, a small farm, or a historic New England home with enduring appeal, this Etna farmhouse offers a unique opportunity with close proximity to the Etna Library and Hayes Nature Preserve.
Description:A property for all seasons with waterfront, views, color, comfort and privacy. From the moment you walk into this totally renovated, architecturally designed waterfront home, you will be taken! The floor plan takes advantage of light, efficiency, space and views; includes kitchen, with island crafted of hardwood maple salvaged from a bowling alley in Maine and beautifully refurbished, high-end appliances, dining area, living room and the bedroom where you awaken looking at the River. In addition, there is a laundry area and three-quarter bathroom and a sleeping loft as well as a small area of basement. Not only River frontage but a cove, too, a dock and docking ramps and a Level 2 EV Charger. The owners have been the ultimate stewards of this property; they have had engineers assess the banks and have added structural components not only to better stabilize the banks but to also assure the integrity of the structure of the house. A gem and only minutes to “in town” Hanover!! *‘Renovations were completed in 2022, with design by Daniel Johnson of Watershed Studio Architecture."
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