SELECT Id FROM new_searchtable
where
(town = 'Cornish' and state='NH'
or town = 'Eastman' and state='NH'
or town = 'Enfield' and state='NH'
or town = 'Hanover' and state='NH'
or town = 'Lebanon' and state='NH'
or town = 'Lyme' and state='NH'
or town = 'Plainfield' and state='NH'
)
and type ='C'
and subdivision like'%former Keene Medical supply' and subdivision like'%former Keene Medical supply'
AND list_price BETWEEN '0' AND '30000000'
ORDER BY list_price Desc
Upper Valley Area NH Commercial Listing page 0
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:Corporate headquarters or prime income investment property. 3 buildings with Offices, display and retail showroom, service and repair area, receiving and storage. Additional land with extensive road frontage. Easy potential subdivision of house lots. Potential to subdivide or condo the commercial buildings. On 7 acres, frontage at road grade. Main building - 2 levels. Ground level 3700 sf. office and product display. Good street visibility. 3700 SF lower walk out. Mostly finished. Used for Storage and repair. Post and beam 4800 2 story barn with drive through. Good road visibility. Corner lot location. Repair/storage building 2160 sf. Multiple uses under flexible grandfather use rights. 734 feet on Rt. 120. 300 feet on Storrs Hill Rd. Ample paved parking area. Natural area backs up to Great Brook. No wetlands observed, No flood plain per town map. 2 miles south of center of town. R3 zone. All building in excellent condition and updated. Projected cap 8% or 12.75% after extra land spin off.