SELECT Id FROM new_searchtable
where town = 'Lebanon' and state='NH' and type ='C'
AND list_price BETWEEN '500000' AND '1000000'
ORDER BY list_price Desc
Lebanon NH Commercial Listing page 0
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:57 Main Street - Old West Lebanon! Historic & Charming! This Former Library Building Has Been Meticulously Restored & Renovated! 1st Floor Offers Space For Professional Office That Can Include The Basement Or Usage Can Be Separate. Kitchenette & Bathroom. Ample Ceiling Height. 2nd Floor Offers A Luxurious & Spacious 1-Bedroom Apartment With Chief's Kitchen & Custom Cabinetry. Configured So The Apartment Can Be Rented Separately From The Professional Office Space! Excellent Location!