SELECT Id FROM new_searchtable
where (town like 'Lyme' or town like 'Enfield' or town like 'Plainfield' or town like 'Cornish') 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 NH Homes page 0
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:Are you dreaming of being part of a tight knit community, living in a downtown location, steps away from local farmers' markets, parades, and a charming park with a river running through it? 53 Main Street is the perfect opportunity for you. Originally Plainfield’s post office, this unique property has served many purposes over the decades—including the beloved River Run Restaurant—and has now been transformed into a warm, inviting single-family home. Whether you are looking for a cozy residence or a place to start a small business, this property offers: - Commercial Zoning: Great exposure for selling your wares or running a home business. - Charming Features: An open floor plan with gleaming hardwood floors, custom built-ins, stained glass windows, and cathedral ceilings. - Versatile Space: A bright living area, a stunning loft with skylights, and a large first-level bonus room suitable for a bedroom or office. - Comfortable Living: A private upstairs room with access to a large 3/4 bath featuring a basin sink and walk-in shower. -Systemic upgrades: New fully insulated concrete foundation and a whole house water filter leaving your town water tasting like it just flowed from the mountainside Don't let this unique piece of history pass you by!
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:614 Gray Road is a modern, contemporary home built by the renowned Yestermorrow Design/Build School of Waitsfield, Vermont. This one-of-a-kind structure was custom-built for its setting, harmonizing with the natural landscape. Enter through a spacious, functional mudroom into an open-concept, sun-drenched living area featuring radiant-heated bamboo floors. The interior boasts soaring two-story walls with extensive windows that invite the outdoors in, creating a bright and airy atmosphere. The kitchen is a chef's delight, equipped with a new propane stove, range hood, and dishwasher, complemented by extra-deep countertops, ample drawer storage, and two-tone custom hardwood cabinetry. A dining area abuts french doors overlooking the outside and a soapstone woodstove keeps everyone warm and cozy through the winter months. A newly enclosed den offers versatility as a guest space, private office, or media room. Upstairs, a spacious loft is the perfect spot to sit and look out to the beautiful pastures and mountains that are your backyard. A private bedroom and a full bath featuring new tile flooring and a tub/shower round out the second level. The exterior is equally impressive, situated on 13.5 acres of land. The property includes open, south-facing, sloping pastures, ideal for agricultural pursuits. Soil test results available. A rock wall perimeter encloses the grounds, which are populated by over 40 Chestnut trees, raspberry canes, blueberry bushes, apple trees, and a turn-key chicken coop. There are established garden areas and a perennial herb garden, as well. With a septic system designed for 4 bedrooms, there is significant potential for future expansion. This is a rare opportunity to own a meticulously designed, energy-efficient home in a serene setting. Schedule your showing today!
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.