Don't just go for the obvious, but maybe something less obscure for the area (local sports teams, state flag colors, historic sites nearby, etc.).

Are there any recourses to learn more about my specific area (average prices, average rents, website to find housing listings, historical housing prices, etc.).

Appreciation has been historically good though.

It is in historic and requires special permitting for renovation.

My final comment on subject to is that while historically the instances of the note being accelerated for violation of due on sale are few, the present/future has and is changing in two significant ways.  

Question: Is a short term rental in an area historically riddle with crime but going through a gentrification/revitalization process a good idea?

Historically speaking rates would be likely to come down after that so you can refi later.

I also went to college there so I know a little bit of certain areas, I love the historic home near campus.

He made a suggestion because of rising interest rates and home values being historically high. a snap shot is as follows: I have 100% occupancy.

This does not mean your plan will not work out as historically it will work out great.