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: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:The sun streams in to this delightfully bright home set on a gorgeous 3.45 ac site in Lebanon. Spacious great room with beautiful outlook. 2648 sq ft home is currently set up as 1 bedroom, 2.5 bath, with large first floor master suite. Upstairs has a large family/game room and a full bath. Seller will give credit of builder's estimate to add two more bedrooms to the second floor. (House has a 4 bedroom septic system). Full basement provides great space for workshop or more finished space. 2 car garage. Open house Sunday, May 31 from 1--3pm.
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."