SELECT Id FROM new_searchtable
where (water_body = 'Crystal' and town ='Enfield') and (type = 'R' or type ='O')
AND list_price BETWEEN '0' AND '30000000'
ORDER BY list_price Desc
Crystal 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