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 list_price BETWEEN '150000' AND '250000'
ORDER BY list_price Desc
Upper Valley NH Homes page 0
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:Welcome home to this inviting property in the beautiful village of Meriden. Close to KUA and short drive to Lebanon or Claremont for shopping, entertainment, or hospitals. This 924 square feet mobile home has 2 bedrooms, 2 bathrooms, and a dedicated office space, perfect for working from home, hobbies, or guest accommodations, as well as an open concept living room and kitchen. Enjoy year-round comfort with central air conditioning throughout the home. Situated on a desirable corner lot, the property offers added privacy and outdoor space. A peaceful bubbling brook enhances the setting, creating a relaxing backdrop to everyday life. The yard also includes a convenient storage shed, providing extra room for tools, equipment, and seasonal items. Combining comfort, functionality, and natural charm, this property is a wonderful place to call home.
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.