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 35
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:Embrace the vibrant heart of Hanover with this newly renovated home on Lebanon St, offering the ultimate in downtown living within walking distance to the CoOp and the bus line. Perfectly situated between Dartmouth College and DHMC, this property boasts a walk-out basement providing extra storage. The first floor showcases a contemporary touch with brand new hardwood floors, a renovated kitchen and 3bedrooms, one with a 3/4 bath. Upstairs, the second floor introduces an in-law suite with hardwood floors, new kitchen, 2 bedrooms and a bath with private washer and dryer all with a private exterior entrance. Take advantage of the prime location and the properties surrounding walking trails and Mink Brook. Welcome to Hanover!
Description:Discover your dream home in the picturesque town of Lyme, NH! This stunning newer construction, built in 2014, boasts 4 spacious bedrooms and 2 baths, encompassing 2,400 sq. ft. of quality craftsmanship. Experience the perfect blend of comfort and style in this expanded cape featuring all-steel beams. Step inside to find high ceilings and large windows flooded with natural light, creating an inviting atmosphere throughout. The first floor features a primary bedroom, ideal for convenience and privacy, along with radiant heat for ultimate comfort. The garage is also equipped with radiant heat, ensuring a cozy space year-round. The second floor offers high-output baseboard heating, allowing the boiler to be set at a lower temperature for energy efficiency. Set on .34± flat acres. Seller can accommodate a quick closing, allowing ample time to plant your vegetable or flower garden before the season begins.
Description:This beautifully renovated Hanover home offers a rare opportunity with a great price and modern updates. Nearly fully updated on both levels, the home is filled with natural light and features a comfortable, efficient floor plan. Located just 10 minutes from downtown Hanover, it's tucked away from the road and surrounded by trees. The flat yard is perfect for outdoor activities. A heated, direct-entry two-car garage leads to the lower level, which includes a newly renovated family room and a flexible space that can serve as a rec room, exercise room, or guest bedroom. A stylish 3/4 bath adds extra convenience, along with a small laundry room with a stackable washer and dryer. The second level is where the home truly shines. The main living area features a modern kitchen with a large sit-up island, Quartz countertops, and a seamless flow into the dining and living areas. A cozy pellet stove adds warmth, while a mini-split unit ensures comfort in summer. The inviting color palette and layout are perfect for entertaining. Just off the kitchen, the deck is ideal for summer BBQs. This level also includes three bedrooms, each with its own mini-split for personalized climate control, and a fully renovated full bath. Sellers installed a brand new septic in 2019. Come see what this property has to offer. Showings begin at the open house on Saturday, April 5th and Sunday, April 6th 9am to 12pm.
Description:Escape to your own slice of paradise with this stunning 3-bedroom, 2.5-bath home offering breathtaking, expansive views! Nestled on 21 acres of picturesque land, this property is perfect for nature lovers, hobby farmers, or anyone seeking tranquility while still being close to Dartmouth, schools, shopping, restaurants. Enjoy the perfect blend of modern comfort and outdoor living with an attached garage, a spacious barn, and miles of trails right outside your door.The master suite is a spacious retreat with a private bath and walk in closet while the two additional bedrooms offer ample space for family, guests, or a home office with hi speed internet. The open living and dining areas feature large windows that bring the scenic surroundings indoors, creating a bright and welcoming atmosphere.Enjoy the fireplace warmth as you watch the wildlife through the many windows.Additional features include an attached 2-car garage for secure parking and storage, as well as a barn that's perfect for animals, equipment, or hobbies. The expansive 21 acres includes fields and trails, providing endless opportunities for outdoor recreation, whether it’s hiking, horseback riding, cross country skiing, snowmobiling,or just enjoying the peaceful surroundings.**The 126 acre abutting lot is also available for sale. See MLS#5027346. Some photos are virtually staged.
Description:Bring you chickens, your green thumb and your swim suit and enjoy everything this 3.2+/- acre property has to offer approx. 15 minutes from Dartmouth College and Dartmouth Health! This 3-4 bedroom, 2.5 bedroom home features charming exposed beams, open eat-in kitchen/dining room with a wood fireplace, cozy living room with reading nook and a wood stove for those chilly winter nights, a patio leading to a screened porch, garden space, multiple outbuildings and a swimming and skating pond! This home has something for everyone including a trail network within walking distance and Trescott trail access off of Dogford Rd. for mountain biking about 3 miles away. Do you love to ski? The Dartmouth Skiway is approx. 15 minutes as well! What a spot! Delayed showings start at the Open House on Saturday, Feb 15 from 11:00-1:00. Note - Town has it listed as a 3 bedroom so we assume it's a 3 bedroom septic.