SELECT Id FROM new_searchtable
where ( town like 'Enfield' or town like 'Canaan') and type ='C'
AND list_price BETWEEN '250000' AND '500000'
ORDER BY list_price Desc
Canaan Enfield NH Commercial Listing page 0
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:US Route 4 - Mirror Lake Automotive, New to the market. Fully operational business with 1.79 acres of land and the building. Three bay garage with a spacious office and an additional smaller space that would work nice as a rental/office. The garage is 40x54 and the office is 16x18. Plenty of parking with the paved driveway. Beautiful stone walls and well maintained, this property is ready for its new owner. Appointments are necessary.