SELECT Id FROM new_searchtable
where town = 'Lebanon' and state='NH' and (type = 'R' or type ='O')
and subdivision like'%Hillcrest Acres' and subdivision like'%Hillcrest Acres'
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:Location, location! This one level ranch features three bedrooms, 2.5 baths with formal dining area, living room on the main level. Walkout lower level with finished family room, 1/2 bath, laundry, storage and bonus room. You will love the pretty views off the back deck overlooking a spacious landscaped yard. New septic system and attached 2-car garage. This desirable Lebanon neighborhood is within walking distance to the Lebanon Middle School, Northern Rail Trail and City pool. Just a ten minute drive to Dartmouth Hospital and minutes to I-89 and the Lebanon Green.