CrimeIndexer.com has a map of total crime volume and a map of crime density adjusted for population.

The dilemma i face now is that I can’t decide if it makes more sense to embrace the c class identity this property gives the impression of, or put a lot more into the renovation, get better quality tenants and convert it to the B class property that the building (and the area) should/could be.

It's tough to say with certainty and it a lot of success in the MTR market hinges upon operating ability, property layout, understanding your clientele and ability to adjust to the market.This article does flag some cities that are good for MTRs: https://www.stessa.com/blog/hot-spots-medium-term-rentals/

Similar to the 15$ Big Mac, even inflation adjusted from 5$ should be around $8.50 so the gouging is greedy and it is real on all accounts.

Our housing prices are insanely high to begin with.We take adjustable rate mortgages at levels you would never see in the US.

Adjusting to a new city is hard enough without changing your standard of living.

Think of it this way - you have two communities with 1 bed 1 bath 900 sf units.One has a HOA fee of $350 and another identical is $650 - which units will have higher valuations? 

I have to show the comps chosen by the appraiser were not as good as other comps or the adjustments made by the appraiser were absurd. 

It's about adjusting expectations and maybe giving up on some of the "rules" for good deals.

Naturally, we asked the cost segregation company to adjust their report.