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 dream home nestled on 2.56 picturesque acres. This beautifully maintained property offers the perfect combination of modern amenities and serene surroundings. Step inside to discover a sunny, open floor plan designed for both relaxation and entertaining. The kitchen features granite countertops, ample cabinet space, and a seamless flow into the dining and living areas. Enjoy morning coffee or unwind in the sunroom, bathed in natural light, while taking in the peaceful views of your private yard. The home boasts a formal living room with gas fireplace and a cozy family room with a gas woodstove, providing flexible spaces for gatherings or quiet evenings at home. The fenced yard is perfect for pets, gardening, or outdoor play. Conveniently located, this home offers easy access to all Upper Valley amenities, including shopping, dining, schools, and recreational opportunities. With its prime location and thoughtful design, this home truly has it all. Don't miss the chance to make this beautiful property your own!
Description:Possibly one of the most spectacular locations on Mascoma Lake you'll ever find. The "Lovett Cottage" has not been offered for sale since 1971 and boast direct Southwesterly exposure with 125 feet of private lake frontage. The original cottage built circa 1940 then remodeled and expanded in 2005 with a second floor addition which included a new kitchen, dining room, living room and bedroom/balcony. The house along with an extensive deck and dock system is grandfathered into is current location making it extremely unique and a rare find that will most certainly never be found again. The deck and dock system feel almost like they are vaulted out over the lake. The privacy here is amazing, imagine sitting by the shore on some quiet summer evening, with your feet in the water, sipping on a cool drink, listening to the waves gently slapping the rocky shore line. Nothing else to do but watch the sun slowly setting behind Shaker Mountain while your children or grandchildren are at play. The crackle of the firepit as tales from the past are being spun, and then your the grandchild runs over and whacks you in the face with a sun fish. Look what we caught Grampa! This is not a house, it's a lifetime of memories that we are selling, make them yours, call for a private showing today, you'll be glad you did.
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.
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.