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 '250000' AND '500000'
ORDER BY list_price Desc
Upper Valley NH Homes page 0
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:End of the road, on the cul de sac, this home is beautifully landscaped with open lawn, a firepit, gardens and so much more. Walk into the full finished lower level with a bedroom and bath, family room and laundry room. The upper level is an open living/kitchen area, two more bedrooms and a full bath. Nice and light and bright. The deck wraps around is wonderful with steps to the hot tub! Come and check out this beautiful home on Saturday September 21st at the open house 10am to Noon. Delayed showings until open house.
Description:IN THE VILLAGE OF CORNISH FLAT! THIS IS A SPACIOUS FARMHOUSE WITH A COMBINATION OF THE OLD CHARACTER AND THE CONVENIENCE OF THE NEW! WAIT UNTIL YOU SEE THIS INCREDIBLE BRAND NEW DREAM KITCHEN. IT WAS DESIGNED FOR A CHEF WITH ITS QUARTZ COUNTER TOPS, WALK-IN PANTRY, PORCELAIN FLOOR WITH RADIANT HEAT AND LOTS OF MODERN CONVENIENCES. THE RADIANT HEAT IS ALSO IN THE PANTRY AND MUDROOM FLOORS AS WELL AS THE NEW HALF BATH ON THE FIRST FLOOR. THE ATTACHED BARN HAS BEEN NEWLY CONVERTED TO A 2 CAR GARAGE WITH FULL STAIRS TO THE ABOVE STORAGE AREA. THE 7 ROOM FLOOR PLAN CAN BE FLEXIBLE DEPENDING ON YOUR NEEDS. THE LARGE LEVEL LOT HAS A LARGE GARDEN AREA WITH RICH GROWING SOIL AND EVEN INCLUDES THE CHICKEN COOP. THE METAL STANDING SEAM ROOF IS ALSO A BONUS TO APPRECIATE. THESE SELLERS HAVE GIVEN THIS SPECIAL HOME A NEW FACE-LIFT, BUT HAVE LEFT SOME ROOM FOR THE NEW OWNERS TO DO THE FINISHING TOUCHES. THIS IS A SPECIAL HOME IN THE VERY SPECIAL CORNISH COMMUNITY AND FOR THE HIGH SCHOOLERS, YOU EVEN HAVE A CHOICE OF HIGH SCHOOLS. COME QUICK....OR IT WILL BE GONE.
Description:Take advantage of a rare opportunity to own a fully operational and profitable mechanical shop situated in the heart of Plainfield. This well-established business has built a solid reputation for quality service and customer satisfaction, making it an ideal investment for both seasoned mechanics and aspiring entrepreneurs. Previously there was a residence on site, so the potential is there to live and work in one location! The sale will include the equipment you need to perform most repairs including three Rotary lifts, Corghi tire machine, new waste oil furnace. This is a very well cared for shop with bathroom, waiting room and office. This is a rare opportunity to own your own profitable business and be in control of your own future!
Description:Step inside through the marble checkered entry tile and take in the vaulted ceilings, creating an airy, open ambiance. The main living spaces feature gleaming cherry hardwood floors, warm wood paneling, interesting architectural design and enough space to gather and host. For the culinary enthusiast, the kitchen has a beautiful wide high-end Sub-Zero refrigerator, Wolf propane range, and ample counter space. There is a laundry room/mudroom off the kitchen and an ensuite bedroom off the living room perfectly suited for single level living. Upstairs, you'll find two more generous bedrooms with a jack-and-jill bathroom, a walk in cedar closet, and shelves for all your books, decor, and craft supplies. Above the attached two car garage you'll find a bonus area, perfect for finishing into a home office, gym, or extra living space. The garage already has a propane Rinnai heater. There is a private drilled well with reverse osmosis system for crisp water, and the house has a whole house Kohler generator that jumps right into action if needed. There is a wonderful deck with additional screened in porch that is quiet and ready for you to bring a book and enjoy the nature surrounding the property. With all the right bones in place, this property is ready to be transformed into your perfect oasis. Don't miss the chance to make this home yours in the sought-after Eastman community with tennis, skiing, trails and more.
Description:Nestle in on your own peaceful country retreat located in Enfield on 6.7 acres. Centrally located between the Dartmouth region and Ragged Mt. while only a few miles to Crescent Lake, Grafton Pond and Mascoma Lake or just walking distance to Colette hiking Trail. This property has lots of open space for the nature lover to explore their gardening skills, trail blazing and night sky watching which includes some natural wetlands. House was built in 1990 with comfort in mind, simply relax on the covered front porch with a convenient entry to the kitchen also great for grilling. Kitchen has both breakfast bar seating and a dining area. Choose your social space in the sunny living room with cathedral ceilings in the summer or settle into another family room with a woodstove option for the long winter months. Bedrooms are on the upper level with balcony overlooking the great room. Master bedroom is well appointed with its own private balcony for more outdoor enjoyment. Standing seam roof is an upgrade. Interior needs to be freshened up and painted. Outbuildings include a barn with loft and several new storage sheds for extra toys and tools.