Kim (980) 621.9854
Results
Back
String: SELECT * FROM cds.single WHERE `Listing Status` != 'Sold' AND `Listing ID` != '' AND `City` = 'Mount Pleasant' UNION SELECT * FROM cds.multifamily WHERE `Listing Status` != 'Sold' AND `Listing ID` != '' AND `City` = 'Mount Pleasant' UNION SELECT * FROM cds.commercial WHERE `Listing Status` != 'Sold' AND `Listing ID` != '' AND `City` = 'Mount Pleasant' UNION SELECT * FROM cds.rentals WHERE `Listing Status` != 'Sold' AND `Listing ID` != '' AND `City` = 'Mount Pleasant' UNION SELECT * FROM cds.lots WHERE `Listing Status` != 'Sold' AND `Listing ID` != '' AND `City` = 'Mount Pleasant' UNION SELECT * FROM cds.condos WHERE `Listing Status` != 'Sold' AND `Listing ID` != '' AND `City` = 'Mount Pleasant' ORDER BY `Street Name` ASC LIMIT 0,10
Total: 67
SortBy: ORDER BY `Street Name`
View Saved Searches
Save Search Results
Thank you for trusting us with your referrals of family and friends. We will give them the service and care they expect and deserve.
- Search for Homes in Charlotte NC
- Homes for sale in Kannapolis North Carolina
- Properties in Midland North Carolina
- Homes for sale in Concord North Carolina
- Search for Houses in Mount Pleasant
- Foreclosures
- Short Sales
- Distressed Properties