Best neighborhood for STR in Columbia?

[Brian Jasinski]

I am an Investor in the Boston area, dropping off new student at USC next week.  I had a difficult time finding a decent Air B&B, so led me to start looking at the market.  Can anyone recommend a neighborhood (looks like there are numerous areas within Columbia?) for a upper scale rental unit I would use as a short term rental?  Anyone have insight about the demand?  Looks like there are several good attractions in the area, and lastly - anyone know of a property manager in the area?

Thanks in advance for any and all info.....appreciate it!