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 5
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:Large Lebanon house located in the business district. Commercial zoning. 3-4 bedrooms, 2 baths with a full walk out basement and 1 car garage. Spacious rooms, first floor laundry and the enclosed side porch is a nice feature. The yard has lilacs and a few trees that make it feel a bit more private, while still in the middle of town. Walk the rail trail that is located across the street. Convenient to most everything.
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 property has solid bones, just waiting for the right buyer to bring it back to life. Built in 1967, this 1,848 sq. ft. ranch sits on a quiet 0.35-acre lot in West Lebanon—an ideal canvas for a fix-and-flip or long-term investment. With the right cosmetic updates, this home could really shine and offer incredible value beyond the asking price. It’s easy to show, and though it needs some serious aesthetic work, the location and layout of 13 Pasture Lane promise great upside. Whether you’re looking to renovate for resale or transform it into a beautifully restored home, the potential here is undeniable. A possible 4th bedroom, additional living room, and a complete 3rd bath in the lower level, which is already heated, could add up to 1,200 sq. ft. to the total living space after transformation. This home is being sold AS-IS. Sellers are motivated and open to discussions.
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:Welcome to this meticulously maintained home in the heart of Lebanon, where modern comfort meets prime location. This thoughtfully updated 3-bedroom, 2-bath residence offers single floor living. The heart of the home showcases a kitchen adorned with granite countertops and sleek stainless steel appliances. A generously sized laundry room adds convenience to daily life, while a finished lower level presents a versatile space ideal for a home gym, private office, or entertainment area with built in bar. Recent upgrades demonstrate the owners' commitment to both sustainability and modern living. The home features 2 year old solar panels with an output of 8.8 kwd, a newly installed wood deck (2023), and an electric car charger (2023). Additional improvements include 10 new windows (2021), a 9 year young architectural shingled roof, an efficient Buderus boiler (2018), and a newer water heater (2022). Step outside to discover your private oasis - a fully fenced backyard featuring a beautiful paver patio with a built-in firepit, perfect for outdoor entertaining. The location couldn't be better, offering easy access to the Northern Rail Trail and walkable distance to downtown amenities including Colburn Park, local restaurants, seasonal Farmers Markets, the Lebanon Opera House, and Lebanon Memorial Pool. This turnkey home combines the charm of in-town living with modern amenities and energy-efficient updates, creating the perfect blend of comfort, convenience, and sustainability.
Description:A fantastic location, just 15 or 20 minutes to the Upper Valley or New London area on paved roads. Traditional layout with updates of new kitchen, baths, windows, spray foam insulation, plus many original features add to the charm with refinished wide pine floors, moldings, 4 panel solid wood doors, and built ins. Kitchen/Dining with new flooring, former summer kitchen is now a 3 season hobby room with woodstove, 2 baths on the first floor, one bath has a washer/dryer that are included. Depending on how you want to use the rooms you could have a formal dining room for family gatherings over the holidays, there is a primary bedroom & bath, music/office room on the first floor, and two bedrooms on the second floor. 3.3 surveyed acres+/- with Knox River frontage to cool off next to, beautiful backyard with rolling lawns, apple trees, and a foot bridge to the unspoiled woodlands. Attached ell with storage above as well as loft above the barn. Enjoy all the area has to offer with Farmer's Market on Saturday, Concerts, area lakes/ponds with public access. Dartmouth College, VA hospital, & Dartmouth Medical Center are within convenient travel time.
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:Welcome Home to this Charming Cape Style Home Located in the Desirable Anderson Hill Neighborhood, on a Quiet Cul-De Sac! This Home Features 3 Bedrooms and 2 Baths. Main LeveL Offers an Open Concept, Kitchen, Dining Room, Which Flows into the Family Room with a Beautiful Hearth and Wood Stove to take the Chill Off. First Floor Also Offers a Den/Office, Possible 4th Bedroom. Laundry Room and Gorgeous Hardwood Flooring Throughout. Second Floor Provides 3 Bedrooms and Full Bath. Basement Features a Walkout, Exercise Area and Finished Office Space, Bodenus Boiler, Hot Water Heater, Well Pump, Water Filtration/Softener and Radon Air Mitigation System. Another Awesome Bonus is the Screened in Porch, Overlooking a Private Backyard, just Waiting for New Buyers to Entertain Family and Friends! Wait! There is a Attached 2 Car Garage and Shed for Extra Storage. Highly Sought This Highly Sought-After Neighborhood is a Commuters Delight, Offering Easy Access to Schools, Ball Fields Police Station, Post Office, Supermarkets & Major Highways! For the History Buffs, Enfield Shaker Museum is Right Down the Rd. Only 7 Miles to Lebanon and 10 Miles to Dartmouth Hitchcock Medical Center. Enjoy a Dip in the Scenic Mascoma Lake with a Walkable Promenade.
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:Spectacular yard that gently slopes down to the Brook. With 273' along the brook, this is a special property. Ample space for large gatherings, camp fires or garden space. This light and bright 3 bedroom ranch has been updated over the years, with a modern kitchen and hardwood flooring. Relax by the woodstove in the family room or sit back and enjoy a book in the sunroom. Plenty of rooms for everyone to enjoy. There is a full unfinished basement, a wonderful back deck with a 2024 hot tub. Did I mention the oversized garage? 28 x 60' for parking, workshop area or just extra storage for all the fun toys you may acquire. In 2007 the septic was updated. 2.7 acres of land to enjoy. Located conveniently to shopping and just 15 Minutes to DHMC.