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(InteriorFeat like '%Fireplace%') and(InteriorFeat like '%Fireplace%')
AND list_price BETWEEN '0' AND '30000000'
ORDER BY list_price Desc
Upper Valley Area NH Homes page 0
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:Step inside through the marble checkered entry tile and take in the vaulted ceilings, creating an airy, open ambiance. The main living spaces feature gleaming cherry hardwood floors, warm wood paneling, interesting architectural design and enough space to gather and host. For the culinary enthusiast, the kitchen has a beautiful wide high-end Sub-Zero refrigerator, Wolf propane range, and ample counter space. There is a laundry room/mudroom off the kitchen and an ensuite bedroom off the living room perfectly suited for single level living. Upstairs, you'll find two more generous bedrooms with a jack-and-jill bathroom, a walk in cedar closet, and shelves for all your books, decor, and craft supplies. Above the attached two car garage you'll find a bonus area, perfect for finishing into a home office, gym, or extra living space. The garage already has a propane Rinnai heater. There is a private drilled well with reverse osmosis system for crisp water, and the house has a whole house Kohler generator that jumps right into action if needed. There is a wonderful deck with additional screened in porch that is quiet and ready for you to bring a book and enjoy the nature surrounding the property. With all the right bones in place, this property is ready to be transformed into your perfect oasis. Don't miss the chance to make this home yours in the sought-after Eastman community with tennis, skiing, trails and more.
Description:This home has it! It has that feeling of home and comfort with beautiful curb appeal. Offering 3 bedrooms, 2 full baths, an updated kitchen in 2017, beautiful wood floors and an open and airy living room, highlighted by a beautiful bay window. The finished basement includes a versatile room for entertainment, plus an office, utility room and direct access to the one car garage with auto open for added convenience. Outside, you’ll find a great space to relax and enjoy. There’s a nice garden area and a well maintained above-ground pool to cool off in during the summer months or relax on the inviting screen porch or deck. Excellent location, close to recreation fields, shops, restaurants, and I-89. This well-maintained home has everything you need!
Description:Built in 1961 this Cape style Brick home sits on almost 2 acres with possible views west. In the family for over 63 years this 2 bedroom, 1 bath has the original custom cabinets made with lumber from the Hayes farm in Etna. The home is surrounded with flower gardens, peach tree, raspberries, apple tree and space for vegetable gardens. New Submersible water pump in 2023, hot water heater in 2020, town sewer and newer oil tank are just a few of the mechanical updates, along with a double fireplace. The sloping lot would allow clearing to provide more light for westerly sunsets. Close to Dartmouth and DHMC, great location with unlimited potential.
Description:Escape to your own slice of paradise with this cozy 3-bedroom, 2-bath log cabin nestled on 34 pristine acres. Featuring an open floor plan, the living space is bathed in natural light, highlighting the beautiful pine and hardwood floors throughout. Step outside to enjoy a new expansive deck. The front porch provides the perfect spot to enjoy your morning coffee as you unwind while soaking in breathtaking mountain views and the serene ambiance of your very own pond. The property boasts ample garden space, perfect for cultivating your green thumb, and is an ideal setting for a potential barn and horses, making it a dream for equestrian enthusiasts. A detached 2-car garage provides extra storage or workshop space. Located just a short drive from Dartmouth College and Dartmouth Hitchcock Medical Center, this retreat offers the perfect blend of tranquility and convenience. Don’t miss your chance to own this unique property—schedule your showing today! Open House November 3, 2024 11-2.
Description:This 3 bedroom ranch sits on 6.2 remote acres out in the rural stretches of the Hanover School District. With a large shop space and expansive gardening space, this is a wonderful location to enjoy. This property is a part of the Rennie Road Value Assurance Program provided by Dartmouth College. For more information, please ask the agent or your buyer's agent!
Description:Envision the exclusive pleasure of owning 1.5 acres of property complete with your very own swimming pond, located in the desirable town of Hanover. This contemporary, a mere 6 minutes from Hanover, Main Street and 15 minutes from I-89, offers both privacy and convenience. Historically owned by a family, the home has been cleverly configured to included two separate rental units with their own kitchens, providing potential income opportunities or accomodations for guests. The primary living space, used by the owners, features modern updates and expansive windows that frame captivating views of the serene pond. For those inclined towards customization, the rental units can be seamlessly integrated into the main living area to create a spacious single-family home. Alternatively, maintaining the current layout offers continued benefits as a rental property. With Mink Brook gracefully meandering through the landscape, this property is not only a peaceful retreat but also a promising investment. There is all new wiring, new carpet, new energy efficient boiler, new chimney liner, new baseboards, new toilets and has had a septic inspection. This property has unique features and a prime location, making it an exceptional opportunity for both personal enjoyment and financial growth.
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: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:Discover a rare gem in the heart of Lebanon—this expansive single level 4-bedroom, 4-bathroom home is nestled on 43 picturesque acres. Enjoy stunning westerly views, ample living space, and the perfect blend of privacy and convenience. This unique property offers the tranquility of country living with all the benefits of being close to town. With several acres of open pasture land and a barn/stable the property would be well suited for horses or other grazing animals. The 10 KW solar array reduces current power demands with room for future expansion. A fantastic opportunity to create your ultimate dream home. Imagine snowshoeing, and cross-country skiing on your own land in the winter while enjoying the pollinator flowers and organic vegetable gardens by the half basketball court. The downstairs includes a library, bar, and a large space to create what you want. In addition, the property benefits from easy access to downtown Lebanon, Dartmouth College, Dartmouth-Hitchcock, I89 and I91, Lebanon Airport, and Dartmouth Coach goes to New York or Boston. Don’t miss out on this exceptional opportunity located at the end of a dead-end road! Home is being sold as is.