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 10
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:Motivated Seller! Great in-town location!! A charming 3-bedroom home with fresh interior paint throughout. Features a new mudroom entry off the oversized, heated 2-car garage and covered front porch with composite decking for low maintenance. New paved driveway and plenty of parking spaces for guests. .46 acre lot with private back yard for gardening and play space. Ample storage space in the unfinished basement. You will love the close proximity to the Lebanon Green, Hanover, CCBA, I-89 and Northern Rail Trail for recreation.
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!