SELECT Id FROM new_searchtable
where town = 'Enfield' and state='NH' and type ='L'
AND list_price BETWEEN '500000' AND '1000000'
ORDER BY list_price Desc
Enfield NH Land / Acres page 0
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:Prime development opportunity in Enfield's TIF district — 2.5 acres with 340 feet of frontage and a curb cut on Route 4, plus an existing Class IV road along the east boundary that could serve as a secondary driveway or access point. US Route 4 carries an average of 7,472 vehicles per day (2025 AADT), split roughly evenly between eastbound (3,699) and westbound (3,774) traffic — solid visibility for a commercial user. Town water and sewer available at the street. Zoned Community Business, supporting a range of commercial and mixed-use development. A conceptual design for a mixed-use building is available for review.