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='1') and (bedrooms='1')
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:Do you like tiny homes? Are you a minimalist? This may be the home for you. 2 bedroom, 1 bath home home on corner lot in Hannahs Village. Home is offered with furnature. Owner has made the following updates new flooring, new roof, new appliances and new water heater.
Description:THE CABIN IN THE WOODS! THIS IS AN ADORABLE COTTAGE SETTING IN THE MOST PEACEFUL LOCATION WITH 440 FEET ON MILL BROOK. THE HOME OVERLOOKS THE BROOK WHICH GIVES IT THE MOST SOOTHING SOUNDS AND THE FEEL OF TOTAL SERENITY. THE HOME HAS ONLY BEEN USED AS A VACATION HOME FOR THE SUMMER MONTHS AND HAS BEEN VERY WELL CARED FOR. I AM CALLING IT A ONE BEDROOM HOME BUT IT DOES HAVE A SEMI FINISHED ATTIC WHICH IS ACCESSED BY A PULL DOWN LADDER. THIS ROOM HAS BEEN USED AS THE GUEST QUARTERS. THERE IS EVEN A HANDY WORKSHOP TO ENJOY. SO, IF YOU ARE LOOKING FOR A LITTLE GET-AWAY PLACE....THIS COULD BE IT. THIS SPECIAL HOME IS REALLY A LITTLE PIECE OF HEAVEN! SELLERS WILL SELL IT FURNISHED OR COMPLETLEY EMPTY.
Description:Welcome to Spectacle Pond, a beautiful hidden gem consisting of over fifty acres, perfect for swimming, kayaking or paddle boarding to beat the summer heat. This amazing pond is surrounded by hundreds of acres of conservation land to add to your privacy. If peace and quiet is what you are looking for then this adorable waterfront cottage is perfect for you. Relax on the deck and feel the cool breezes coming off of the water, or enjoy the loons swimming close to shore with their new hatchlings. As a bonus, this cottage comes fully furnished. Recent improvements include the driveway in 2020, a new septic system in 2021 , the house was painted in 2022, as well as a new 40 gallon hot water heater and UV filtration system. Satisfactory septic inspection report is available on request and linked with the listing.
Description:Post Pond Possibilities!! One of a few number of lots that have pond access. Don't miss the opportunity to be a Post Pond resident. 11 Acres and a Camp/Cottage with rustic character overlooks the pond in a wooded setting. Most of the land already in current use and building envelope is ready for your personal touches. Septic installed new in 2007 with power and a drilled well onsite. Outbuildings for boat storage and more. Come and imagine life on the pond minutes from Hanover, Dartmouth College, and DHMC. All the amenities of the Upper Valley minutes away from your quiet access to nature and wooded serenity.
Description:For generations, camps like this have been where summer traditions begin. Tucked along the shores of Goose Pond in Hanover, this charming seasonal waterfront camp invites you to unplug, slow down, and enjoy the simple pleasures of life on the pond. Spend your mornings with a cup of coffee by the water, your afternoons swimming, boating, or fishing, and your evenings gathered around the fire sharing stories from the day. A private dock makes it easy to get out on the water, while the comfortable camp provides the perfect place to relax after a day outdoors. Thoughtful updates over the years include a private septic system installed in 2010, kitchen and bathroom renovations completed in 2012, updated 100-amp electrical service, and structural improvements completed in 2019. After decades of being enjoyed by one family, this special property is ready to welcome its next owners. Whether you're looking for a quiet weekend retreat, a seasonal getaway, or a property with short-term rental potential, this Goose Pond camp is ready for its next chapter.
Description:A property for all seasons with waterfront, views, color, comfort and privacy. From the moment you walk into this totally renovated, architecturally designed waterfront home, you will be taken! The floor plan takes advantage of light, efficiency, space and views; includes kitchen, with island crafted of hardwood maple salvaged from a bowling alley in Maine and beautifully refurbished, high-end appliances, dining area, living room and the bedroom where you awaken looking at the River. In addition, there is a laundry area and three-quarter bathroom and a sleeping loft as well as a small area of basement. Not only River frontage but a cove, too, a dock and docking ramps and a Level 2 EV Charger. The owners have been the ultimate stewards of this property; they have had engineers assess the banks and have added structural components not only to better stabilize the banks but to also assure the integrity of the structure of the house. A gem and only minutes to “in town” Hanover!! *‘Renovations were completed in 2022, with design by Daniel Johnson of Watershed Studio Architecture."