SELECT Id FROM new_searchtable
where ( town like 'Enfield' or town like 'Canaan') and type ='T'
and (createtime >='2025-03-24 14:21:27') and (createtime >='2025-03-24 14:21:27')
AND list_price BETWEEN '0' AND '30000000'
ORDER BY list_price Desc
Canaan Enfield NH Condos page 0
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:Discover this stunning home in a lakefront community, perfect for year-around or vacation living. Enjoy sunny, open-concept spaces with cathedral ceilings & all new Marvin windows. Relax on porches overlooking a serene garden, stream & waterfall, or dine on the charming dining porch. The sunny kitchen features granite countertops & center island. Stay comfortable year-round with a mini-split cooling system. Move-in ready with a new roof, four skylights, & an optional in-home gym. Mascoma Lake, hiking trails, & a dog park are just steps away, offering endless outdoor adventures. A perfect home for embracing lake life living. Showings begin on 04/05/25. Open house: 04/05 & 04/06 11:00 - 1:00. Please leave shoes on porch. Owner is a licensed NH Real Estate Broker.