SELECT Id FROM new_searchtable
where town = 'Manchester' and state='NH' and type ='T'
and subdivision like'%249 & 251 Dunbar Street' and subdivision like'%249 & 251 Dunbar Street'
AND list_price BETWEEN '0' AND '30000000'
ORDER BY list_price Desc
Manchester NH Condos page 0
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:2 Bedroom, 1, 1/2 bath, finished walkout basement, Across the street from the Merrimack River, and walking trails short distance away, Ready to move in, New Carpets, laminate floor, freshly painted throughout. 5 minutes from downtown and rivers Edge urgent care 5 minutes away. listing agent has financial interest No Condo Fees split water / sewer bill and master insurance