SELECT Id FROM new_searchtable
where town = 'Lebanon' and state='NH' and (type = 'R' or type ='O')
and subdivision like'%192 Mascoma Street, LLC' and subdivision like'%192 Mascoma Street, LLC'
AND list_price BETWEEN '0' AND '30000000'
ORDER BY list_price Desc
Lebanon NH Homes page 0
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:Classic Cape With Spacious Garage & Paved Driveway. Front Screened Porch, Rear Screened Porch/Entrance Room. Kitchen Leads To Dining/Living Room W/Ceiling Fans & Entrance To Front Screened Porch. 1st Floor Den/Office Can Be A Bedroom. Full Bath W/Washer & Dryer. 3 Bedrooms & 1/2 Bath on 2nd Floor. This In Town Home Allows Walking To Conveniences, Employment & Recreation.