SELECT Id FROM new_searchtable
where town = 'Lebanon' and state='NH' and type ='T'
and subdivision like'%Terrace View' and subdivision like'%Terrace View'
AND list_price BETWEEN '0' AND '30000000'
ORDER BY list_price Desc
Lebanon NH Condos page 0
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:Well cared for 2 bedroom, 1 bath condo at Terrace View. This home has an updated electric panel, interior paint, cork floors, Lyptus cabinets with maple interiors, soft close drawers, Ice Stone Co. concrete and glass countertops for improvements. End unit, next to the rail trail. One car garage under and basement storage.