SELECT Id FROM new_searchtable
where town = 'Enfield' and state='NH' and (type = 'R' or type ='O')
and (createtime >='2025-04-20 5:52:03') and (createtime >='2025-04-20 5:52:03')
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:A rare find! This Crystal Lake year round home sits on the lakeside with 120+ feet of shorefront. Enjoy the sunrises and gorgeous views. What more could you want with this adorable home? There's a full lake facing finished porch to relax on. All the conveniences with an updated kitchen, open living area, full bath and more. Wake up and look directly at the lake. It's not everyday you get a 2 car garage too on waterfront property. So much fun awaits and just in time for the summer. Join us at the Open House Saturday, April 26th 10 am to Noon
Description:After more than 50 years of being cherished and lovingly cared for by the same family, this 3-bedroom, 4-bath charmer awaits its next chapter. Set on .71 private acres with 210 feet of waterfront, the home invites you to slow down and savor every moment — whether soaking in the sunken spa in the detached sunroom, floating in the peaceful waters, watching sunsets from the mahogany deck, or strolling down the tree-lined street. A 42-foot aluminum dock with new thru-flow decking extends into the lake’s deep waters, providing the perfect platform for boating, fishing, or simply enjoying the serene surroundings. The home’s cedar shake siding brings charm to the property, while the whole-house standby generator offers practicality. The quiet location ensures a peaceful retreat. Floor-to-ceiling windows bring the lake into the heart of the home, and thoughtful updates offer comfort and ease. Although it is a seasonal home, this treasured property is ready to welcome year-round memories with some modifications. Here, the days are longer, the air is sweeter, and the lake feels like it belongs only to you.