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 25
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
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 brand-new home in Hanover! This beautifully designed new construction features a spacious open floor plan, ideal for both entertaining and enjoying peaceful nights at home. With convenient first-floor laundry hookups and a maintenance-free lifestyle, this home offers all the modern amenities you need. Hardwood floors, masterfully designed bathrooms with custom tile showers, a spectacular kitchen with Quartz countertops, fully appliances kitchens, and tile back splash. Primary Suite is stunning and offers lots.of privacy from the rest of the home. Located just minutes from Dartmouth College, Dartmouth-Hitchcock Medical Center, and several ski resorts, it provides unmatched convenience and accessibility. Whether you're working on campus or exploring the vibrant Hanover area, this location can't be beat. Don't miss the chance to make this your new home—ready for immediate occupancy! Schedule a showing today and start imagining your life in this dream home. Home is complete and move-in ready! The seller is a licensed New Hampshire real estate broker. 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: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.