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 30
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:2 WOODS END ROAD- Well maintained 3-bed & 4-bath contemporary sited on 3 landscaped acres conveniently located just 10 minutes from downtown Hanover. A spacious and updated kitchen flows effortlessly into an open concept living & dining area with fireplace and wood stove and an expansive outdoor deck and gazebo, all of which bathes in natural light to make it a perfect setup for entertaining family and friends. On the front side of the house is another sizable living or family area, office space that is a ground floor bedroom option, and 3/4 bath. The second floor features a warm and sunlit primary suite, two additional bedrooms, and a full bath. A finished lower level complete with full bath and two versatile recreation / bonus rooms offers plenty of overflow space. Renovated mudroom on main level is dog kennel option. With easy access to area schools, recreation, restaurants, shopping, and more, this turnkey Hanover home is a must-see. Most of furnished photos are virtually staged.
Description:This circa 1900s Craftsman gem is sited on 23.75 acres with full appreciation of the innate beauty of the Connecticut River Valley and the mountains beyond. Artfully designed perennial gardens, stepping stone pathways, and an outdoor stone patio complement the natural scenery and panoramic landscape. Walk up an inviting stone pathway to enter into a woodworked gallery of rooms with French doors, beautiful artistic stone fireplace, window seats and exquisite period lighting fixtures. The first floor consists of a large family room and gourmet kitchen with a half bath, ample closet space and an expansive family room that boasts a sweeping view of the mountain ranges as far as the eye can see. On the second floor you get the feeling that you are constantly enjoying the delights of the forest surrounding you. A large master en-suite with a walk in closet and large tiled bath greets you at the top of the staircase as well as a second spacious bedroom with full tiled bath and sizable laundry room. Finally, the third floor opens to a multi use room and large bedroom split by French doors complete with a half bath. A new wrap around deck completes the home's offerings with the pinnacle of endless sunsets and the seasons changing colors. Located at the end of the paved circular drive is the three-car heated garage which includes potential for an ADU above. The property is located 11 miles to Hanover, New Hampshire, 11 miles to the Lebanon Municipal Airport.
Description:Sited on a southeast-facing ridge in the hills of Plainfield, this extraordinary estate seamlessly blends elegance, solitude, and natural beauty. The private 103 acres of pristine woodlands with multiple ponds, meandering hiking and riding trails, and views of local hills and distant mountains, offers the ultimate retreat while being just minutes from Dartmouth College, DHMC, I-89, and I-91. Its location provides both tranquility and convenient access to the best of the Upper Valley, Boston, and beyond. The residence is a unique fusion of Tuscan-inspired design, Italian elegance, and traditional New England craftsmanship. Recently renovated with meticulous attention to detail, the home features a sun-drenched, flexible floor plan with five spacious bedrooms, multiple additional spaces to use as you see fit, and a guest wing. The redesigned eat-in kitchen and breakfast nook showcase modern updates, while radiant heat, wood, and pellet stoves ensure cozy warmth. Notable features such as the observation tower provide unique spaces to relax, take in the spectacular views, and stargaze. The property is designed for both leisure and function and includes a 2-bay attached garage, 1-bay under, 3-bay detached barn, and more. There's ample space for your hobbies and all the gear. Whether exploring the trails, enjoying the ponds, or hosting in the expansive living spaces, this retreat delivers a lifestyle of unmatched serenity, privacy, luxury, and sophistication.
Description:Gorgeous Lakefront! Sail, canoe, kayak or boat from your dock in the summer and skate, ski, or snowshoe in the winter. This property has it all! Lake views, mountain views, enchanting sunsets, bald eagle sightings and the haunting call of the loons. From the moment you enter this newly renovated contemporary home, you will be greeted with views and sunshine. The easy open flow and abundant windows framing the exquisite views are sure to impress you, while the quality craftsmanship can be observed in every room from the two center stone fireplaces to the custom Dana Robes built cherry shelving. Recent renovations include a high end designer chef's kitchen with Induction Wolf Range, double ovens and built-in microwave, Sub Zero Refrigerator, Bosch Dishwasher, elegant wine cooler and gorgeous counters opening to the sun filled dining area. Not only do you have a light bright open floor plan with a wrap around deck overlooking the water but there are also 4 bedroom and home office options complimented by 4 recently renovated custom bathrooms including the primary suite bath with sumptuous sauna. The Village abuts acres of conserved land for you to explore and the local rail trail is nearby for hiking and biking pleasure. This little piece of paradise also includes an attached two car garage, beautiful stonewalls and is located only minutes from Dartmouth Health, Dartmouth College and Mt. Cardigan. (virtual staging used)
Description:Mastlands, named for the towering Eastern white pines once used as ship masts, is a historic Cornish Art Colony estate nestled among trees, farmland, and exquisite gardens. Once the summer home of Dr. Arthur Nichols and his family, it carries a rich legacy, with his daughter, Rose Nichols - a prominent landscape architect - designing the walled garden off the piazza, inspired by her uncle Augustus Saint-Gaudens and architect Charles Platt. The estate's 24 acres feature revived gardens, seasonal blooms, restored fountains, and peaceful retreats like Pine Tree Alley and a firepit. The property offers great outdoor opportunities, with access to a nearby Class 4 road connecting to the scenic River Road, ideal for walks, and additional paths around the cornfields for leisurely strolls. The grand living spaces featuring high ceilings and intricate moldings, including a ballroom wing with elements salvaged from a European chateau, combine historic charm with modern comforts and is crafted for sharing with loved ones. A versatile one-bedroom apartment offers independent living or rental potential, making Mastlands a perfect home for those who cherish history and seek to continue its stewardship. Showings begin 9/3.