String: SELECT * FROM cds.single WHERE `Listing Agent ID` = 'CMLS10347' AND `Listing Status` != 'Sold' UNION SELECT * FROM cds.multifamily WHERE `Listing Agent ID` = 'CMLS10347' AND `Listing Status` != 'Sold' UNION SELECT * FROM cds.commercial WHERE `Listing Agent ID` = 'CMLS10347' AND `Listing Status` != 'Sold' UNION SELECT * FROM cds.rentals WHERE `Listing Agent ID` = 'CMLS10347' AND `Listing Status` != 'Sold' UNION SELECT * FROM cds.lots WHERE `Listing Agent ID` = 'CMLS10347' AND `Listing Status` != 'Sold' UNION SELECT * FROM cds.condos WHERE `Listing Agent ID` = 'CMLS10347' AND `Listing Status` != 'Sold' ORDER BY PropertyType DESC, `Listing Price` ASC
Total: 0
SortBy: ORDER BY PropertyType DESC, `Listing Price`
