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 15
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:PRICE IMPROVEMENT! This 3 bedroom/2 bathroom home is ready for its next owners! Located in one of Lebanon's most desirable locations, the King's Grant neighborhood, it's close to shopping, dining, and schools, and backs up to Carter Country Club. The first floor features a mudroom or bonus room, office, and utility/laundry room and also connects to the garage. Upstairs, you'll find a large living room with high ceilings, a kitchen featuring brand new stainless steel appliances, and a dining area leading to a large, private deck. A primary bedroom with en-suite 3/4 bath and 2 other bedrooms which share a full bath complete the space. Hanover, Dartmouth Hitchcock Medical Center, and West Lebanon shopping are all within a 15 minute drive. You'll love living in the heart of the Upper Valley!
Description:Nestled along the shores of Mascoma Lake and surrounded by the historic Shaker Museum you’ll find the community of North Village. A unique cluster of lovely homes, stylized with a hint of day’s gone by yet very modern on the interior. That’s exactly what you’ll find at 51 Chosen Vale Lane, built in 2002 and lovingly cared for this home has many features not found in the others. The large primary suite consists of vaulted ceilings, a separate dressing/sitting room with fireplace and spacious bath. The additional second floor suite again boasts a private bath, and a loft for those adventurous ones in the family. The main level is perfect for entertaining with an open concept living room, kitchen and dining room with built-ins and hardwood floors throughout. Red Birch & Mahogany cabinets, granite countertops and plenty of room for the best of cooks. The living room center piece is a fireplace mantel hand crafted by Dana Robes. A first-floor bedroom with a full bath rounds off the main level. A fully covered 3 season porch allows for lovely views of the lake, all within a short walk to the private Association beach. The lower level has a wonderful family room complete with bar, workshop, storage and laundry. The systems include two Air conditioning units one for each floor, a Buderus heating system, and a whole house sprinkler system. The Association maintains the roads, landscaping and beaches. Easy commute to Dartmouth College and the Dartmouth Medical Center.
Description:If you are looking for a home that has a country feel, with a scenic country road access, yet offers Windsor VT, Claremont and the Upper Valley of NH, all within a 25 minute drive or less, this location will speak to you. This is a custom built home, that has hillside views (can be improved with some clearing), a brook at the north end of the property, a detached 2 car garage (2016), standby generator, privacy and gardens. Inside you have large spaces, vaulted ceilings, wood beams, a kitchen with a view and granite counters. The stone fireplace goes two stories high. In some houses that would be the focal point, this home offers several. The sunroom, it is sunny and bright, take in the view and stay warm with the gas fireplace. Step out onto the deck and take in the fresh air. The primary suite is large, has direct access to the deck and a bath that is just a dream. There is space for a in-home gym and office. The second floor has an open loft, two large bedrooms and full bath. Radiant heat on the main floor keeps you warm all winter and the newer metal roof gives you peace of mind. Other features: hardwood floors, paved driveway, pellet stove, water filtration, dumbwaiter and more! Delayed showings, showings start at the open house on Saturday 09/07 11am-1pm
Description:Welcome to your new home in Hanover! This stunning new construction boasts a spacious open floor plan, perfect for entertaining guests or enjoying quiet nights at home. With first floor laundry hookups and maintenance-free living, this home has all the modern conveniences you could ask for. Located just minutes away from Dartmouth College, Dartmouth Hospital, and multiple ski resorts, this property offers convenience and accessibility like no other. Whether you work on campus or want to explore all that Hanover has to offer, this location is unbeatable. Don't miss out on the opportunity to make this house your own - it's ready for a November move-in! Schedule a showing today and start envisioning yourself in your dream home in Hanover. Property will be complete and ready for move-in 11/30. Seller is a licensed New Hampshire real estate broker
Description:Discover your dream home in this serene 3 bedroom, 3 bathroom property set on 5 picturesque acres. A tree-lined lot provides privacy, giving you tranquility while the nearby neighbors offer a sense of community. Step inside to find beautiful hardwood floors that extend through much of the home. The spacious kitchen features stone counters, cherry cabinets, and stainless steel appliances. It connects seamlessly to the dining area, both of which are warmed by a cozy pellet stove, ideal for those chilly evenings and for reducing heating expenses! The main floor boasts a generous primary bedroom with ample closet space and a pretty 3/4 bath featuring dual sinks. Two additional bedrooms and versatile bonus rooms provide flexible living options, whether you need a home office, playroom, or guest space. Enjoy the convenient mudroom with lots of storage options, before heading out to the detached 2-car garage. Two additional sheds offer plenty of space for all your outdoor gear. Located in the sought-after Dresden School District, this home is a rare find--don't miss the opportunity to enjoy peaceful country living with modern comforts.
Description:Enjoy ultimate privacy and tranquility in this three bedroom, two and a half bath residence set on 3.8 acres in one of Lebanon's most desirable neighborhoods. Living room with gas fireplace for those cozy wintry evenings. Formal dining room plus kitchen with cherry cabinets and breakfast area with bay window to enjoy your natural surrounds. Primary en suite bedroom convenience on main level. Generously sized two bedrooms plus office on the second level. Plenty of storage and room for hobbies in the oversized garage and full basement. Large deck for your outside activities. Gardeners will certainly appreciate the greenhouse and organically cultivated raised beds plus relish in the generous harvests from the raspberry and blueberry patch. Easy drive to shopping, DHMC and area activities. Come take a look.
Description:Fantastic Mascoma Lake property with 93' of water frontage and breathtaking views of the surrounding mountains. The open layout connects a spacious kitchen, dining area, and family room with an adjacent screened-in seasonal porch to take in your dock, boat, and the expanse of the lake beyond. The interiors have recently been substantially renovated and upgraded, with a floor plan flow that accentuates the water view. There are three bedrooms upstairs, one of which is a primary suite overlooking the lake, while an office on the first floor could easily be converted into an additional bedroom. Stay warm in the winter with the pellet stove and radiant heat throughout. With so much fun on the lake leaving will be challenging, but when you do I-89 is nearby, making the rest of the Upper Valley readily accessible.
Description:Located on a rise overlooking the pastoral gateway that extends east to the village of Lyme and west towards the Connecticut River is this iconic brick cape, built and continuously owned by the famous Grant family since 1799. Now for the first time in 200+ years, this very special historic homestead is being offered for sale on 24.03+/- acres. The house requires restoration but with its high ceilings, comfortable floor plan, updated double-hung windows, full basement, new roof, and furnace, it has great bones to work with. The back wing also has potential and character worth updating, but the attached post and beam barn, with lovely old beams and barn boards, needs to be taken down, salvaged and or replaced. Outside, the land is mostly comprised of fields. Directly west of the house is a large level area with fertile soils where the Grant’s used to have a prolific vegetable garden. Further below, on the 20-acre portion that is conserved with the Upper Valley Land Trust, another field slopes down to the brook, then west. Most of the acreage is suitable for livestock. The Grant Brook Trail crosses the property and leads from the village of Lyme to the Connecticut River. Across the street is an extensive network of groomed XC ski trails. Last but not least, several abutting parcels and others within view of the house are conserved thus ensuring that the beauty of this undeveloped area will remain in perpetuity.
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.