If you have lived in it for 2 yrs I would suggest renting it for 2 - 3 years and then selling it to avoid capital gains taxes. 

Any recommendations or suggestions on how to navigate this?

Quote from @Nicole Heasley Beitenman: When I was starting, I found a resource in FF that suggested pricing $300-500 above LTR rates.

Can anyone suggest Property Managers in the Columbia, SC market?

I would suggest that you make sure your Attorney records the deed as well.

@Dominic Holt , I am happy to review your scenario and suggest changes that could improve your property.

I suggest using a service like Mayistay.

Cities don't play fair when they decide to go after you.One thing I would also suggest you do is look on AirBnB for the specific building you want to buy in. 

Since this is happening at the end of their lease, is it a probably that I’m notifying them less than 30 days that I won’t be renewing the lease and that I’m suggesting them to find somewhere else to live?

If you are looking to be an investor then I would suggest you don't be an agent that is a poor mans game and it will make it way more difficult to find deals.