SELECT Id FROM new_searchtable
where town = 'Enfield' and state='NH' and type ='T'
and(InteriorFeat like '%Fireplace%') and(InteriorFeat like '%Fireplace%')
AND list_price BETWEEN '0' AND '30000000'
ORDER BY list_price Desc
Enfield NH Condos page 0
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:Great opportunity in Enfield! Enjoy Mascoma Lake access and other amenities with this 2 bedroom, 2 bathroom condo in the Upper Valley Region. Great floor plan with fully applianced kitchen, living/dining room with propane heater, slider out to patio, bedroom and 3/4 bath on the first floor. The second level is an open loft area with spacious full bath, washer and dryer and attic storage space. Just a short walk or drive to the shared beach on Mascoma Lake for swimming and kayaking or enjoy the amenities and head to the salt water pool and tennis courts or the nearby woods trail. Easy commute to Lebanon/Hanover for local dining, shopping, theater, Dartmouth Health and so much more. Quick close possible.