SELECT Id FROM new_searchtable
where town = 'Enfield' and state='NH' and type ='T'
and (bedrooms='2') and (bedrooms='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:Lakeview Condominiums ~ you will feel like you are on vacation with these amenities: tennis courts, pickle ball, pool, walking trails, and access to Mascoma Lake shared sandy beach. Having two bedrooms, two baths, open-concept kitchen, dining, living sliders to your patio with a great view of the lake. A propane stove making it toasty on cold nights. Lakeview is pet friendly and an easy commute to the Upper Valley.
Description:OPEN HOUSE SATURDAY, MARCH 30TH 10AM TO 12PM - Nestled within the serene surroundings of Lakeview Condo Association, this adorable abode has been meticulously remodeled, where every corner exudes high-end quality, sophistication, and functionality. Just steps from Mascoma Lake, settle into this sunny and bright new home and enjoy a completely updated kitchen that epitomizes modern finish, with customized step-in pantry, all new appliances and countertops. The open layout seamlessly integrates dining and living areas, accentuated by a vaulted ceiling, and then connecting to a private and fenced-in patio, with large storage shed, a perfect space for outdoor grilling or morning coffee. The primary bedroom with all new ensuite completes the first level floorplan. Ascend to the lofted second bedroom, a versatile space ideal for work or leisure, complemented by thoughtfully organized storage and a second remodeled and updated full bath with laundry. Other upgrades include new electrical, plumbing, heat pump and mini-splits, so comfort is assured year-round. Lakeview offers an array of amenities including a shared private beach, canoe and kayak storage, tennis courts, Pickleball, heated inground pool, and a vast trail system within the Petryk Woodland Preserve, all just steps from your door. Close to Hanover, DHMC, Dartmouth College and downtown Lebanon, this residence strikes the perfect balance between a rural retreat and convenient access to urban amenities.