String: SELECT * FROM cds.single WHERE `Listing Status` != 'Sold' AND `Listing ID` != '' AND `City` = 'Concord' UNION SELECT * FROM cds.multifamily WHERE `Listing Status` != 'Sold' AND `Listing ID` != '' AND `City` = 'Concord' UNION SELECT * FROM cds.commercial WHERE `Listing Status` != 'Sold' AND `Listing ID` != '' AND `City` = 'Concord' UNION SELECT * FROM cds.rentals WHERE `Listing Status` != 'Sold' AND `Listing ID` != '' AND `City` = 'Concord' UNION SELECT * FROM cds.lots WHERE `Listing Status` != 'Sold' AND `Listing ID` != '' AND `City` = 'Concord' UNION SELECT * FROM cds.condos WHERE `Listing Status` != 'Sold' AND `Listing ID` != '' AND `City` = 'Concord' ORDER BY `Street Name` ASC LIMIT 0,10
Total: 1430
SortBy: ORDER BY `Street Name`