All the areas you mentioned have much more crime than any neighborhood I'd want to live in.

Not to mention, you've now become reliant on a 3rd party for income streams, and yes, they do occasionally run short of funding and, yes, they have no compunction with telling you to pound sand until they get new funding. 

Not to mention, they also snipped all of the wiring in the basement of the home running all over the house, so there is also major electrical repairs needed. 

Depending on your scale you can even go with the cheapest subscription and work around not having the class feature that @Basit Siddiqi mentioned.

Yes same here which is why I mentioned it.

One applicant mentioned their desired move-in date in 9 months in the future but that move-in date is way too far from our earliest move-in date (2 months from now). 

I found this deal through a conversation with other condo owners, who mentioned that the seller was motivated to sell.

@Benjamin Stacey you didn't mention your family size, but if just the two of you, what would happen with your numbers if you finished the basement and lived down there, while renting the upstairs?

Assuming that's what you're looking for, the above mentioned google turned up this website: https://www.charlestoncounty.org/property-info.phpIf you click on the GIS parcel viewer option, there's a search bar where you can punch in a street address.

Thanks for the mention, @Jonathan Greene!