SELECT Id FROM new_searchtable
where town = 'Enfield' and state='NH' and type ='T'
and (bedrooms='3' and baths >='2') and (bedrooms='3' and baths >='2')
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:SPACIOUS 10' X 6' DECK Off Living Room VIEWS MASCOMA LAKE! Exposed Beams! Propane Fireplace On Hearth! 2nd Level Loft Bedroom With Walk In Closet, Sky Light & View Of Mascoma Lake. 1st Level Bedroom W/Full Bath. 3rd Bedroom. 2nd Bath is a 3/4 Bath. Washer/Dryer Hook-Ups. Open Concept Kitchen/Dining/Living Room W/Cathedral Ceiling, Propane Fireplace On Hearth & Slider to Deck! Cupboard & Closet. Lakeview Amenities Include: In Ground Pool; Tennis Court; 2 Pickle Ball Courts; Private Sandy Beach on Mascoma Lake W/Dock & Kayak Loader, Charcoal Grills, Picnic Tables & Chairs; Direct Access to 167 Acre Petryk Woodland Preserve and the Shaker Mountain Which Offers Extensive Hiking Trails, Smith & Cole Ponds and Waterfalls! Attractive Propane Price of $1.41761 Per Gallon. Lakeview Is Sited Close to Upper Valley Employment, Shopping & Additional Recreation. Pre-Approval Letter or Proof of Funds REQUIRED to be Attached to Purchase & Sales Agreement. Don't Miss This One!