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 25
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:Discreetly tucked away to ensure privacy and leisure, this Mascoma Lake estate has it all. A rare opportunity on Mascoma Lake, this property has a grandfathered boathouse to store all your toys. Leading you out of the boathouse is your own personal dock. When you aren’t on your boat exploring the lake, sit on the oversized deck and soak in the views. An ideal location for hosting all of your get-togethers. The 180 degree views from every room allows pure natural light to permeate through this home. With the ability to connect to the town sewer system, this 3 bedroom home has the opportunity to be a 5+ bedroom home. Should you seek an in-law suite/studio, there is a bonus suite on the upper level that is plumbed for a kitchen. The basement contains finished space with a partial kitchen, allowing convenience for your hosting needs. This is luxury living.