SELECT Id FROM new_searchtable
where town = 'Enfield' and state='NH' and (type = 'R' or type ='O')
and (bedrooms >='4') and (bedrooms >='4')
AND list_price BETWEEN '0' AND '30000000'
ORDER BY list_price Desc
Enfield NH Homes page 0
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:Gorgeous Lakefront! Sail, canoe, kayak or boat from your dock in the summer and skate, ski, or snowshoe in the winter. This property has it all! Lake views, mountain views, enchanting sunsets, bald eagle sightings and the haunting call of the loons. From the moment you enter this newly renovated contemporary home, you will be greeted with views and sunshine. The easy open flow and abundant windows framing the exquisite views are sure to impress you, while the quality craftsmanship can be observed in every room from the two center stone fireplaces to the custom Dana Robes built cherry shelving. Recent renovations include a high end designer chef's kitchen with Induction Wolf Range, double ovens and built-in microwave, Sub Zero Refrigerator, Bosch Dishwasher, elegant wine cooler and gorgeous counters opening to the sun filled dining area. Not only do you have a light bright open floor plan with a wrap around deck overlooking the water but there are also 4 bedroom and home office options complimented by 4 recently renovated custom bathrooms including the primary suite bath with sumptuous sauna. The Village abuts acres of conserved land for you to explore and the local rail trail is nearby for hiking and biking pleasure. This little piece of paradise also includes an attached two car garage, beautiful stonewalls and is located only minutes from Dartmouth Health, Dartmouth College and Mt. Cardigan. (virtual staging used)
Description:The Lake House on Mascoma - Situated on one of the best parcels Mascoma Lake has to offer, this stunning 4 bedroom, 2 bathroom home offers the ultimate lake living experience. It has been fully renovated, with updated heating and air conditioning systems, electrical, plumbing, roof, windows, stunning stone hearth with a propane fireplace and more, yet it retains the comfortable, easy-going feel of a classic lake house. Beautiful landscaping frames over 110’ of lake frontage, a private sandy beach, boat launch, large lawn, and views for miles - this property is a dream for lake-living enthusiasts. 20 minutes from Dartmouth College, Dartmouth Health, Colby-Sawyer College, Kimball Union Academy and Cardigan Mountain School. Less than 2 hours to Boston.