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 list_price BETWEEN '1000000' AND '99999999'
ORDER BY list_price Desc
Upper Valley Area NH Commercial Listing page 5
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:almost 9 Acres at the Lebanon/Hanover Gateway. This is the best and only site in Lebanon with such exposure. Subject site has extensive frontage on Rt. 120 and I-89 with full visibility. A rare level, dry and prepared site. Potential uses include: hotel, office, R& D, Mfg, some residential. Anticipated General Commercial zone (GC1) has been delayed until around Spring 2027. GC would allow most uses by right including mixed commercial/residential. Price has been reduced by 1.5M for a sale prior to rezoning.