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: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.