The following homes in Charlotte, Concord and surrounding area Presented by Kim Gandy
Click HERE to search all area listings
String: SELECT * FROM cds.single WHERE `Listing Agent ID` = '45422' AND `Listing Status` != 'Sold' UNION SELECT * FROM cds.multifamily WHERE `Listing Agent ID` = '45422' AND `Listing Status` != 'Sold' UNION SELECT * FROM cds.commercial WHERE `Listing Agent ID` = '45422' AND `Listing Status` != 'Sold' UNION SELECT * FROM cds.rentals WHERE `Listing Agent ID` = '45422' AND `Listing Status` != 'Sold' UNION SELECT * FROM cds.lots WHERE `Listing Agent ID` = '45422' AND `Listing Status` != 'Sold' UNION SELECT * FROM cds.condos WHERE `Listing Agent ID` = '45422' AND `Listing Status` != 'Sold' UNION SELECT * FROM sites_gandygeorge.featured ORDER BY PropertyType DESC, `Listing Price` ASC
Total: 50
SortBy: ORDER BY PropertyType DESC, `Listing Price`
