Specifically, the viability of flipping and/or implementing the brrrr strategy.I have boots on the ground but not sure about the market conditions.Thanks in advance.   

Way too many red flags and hoops to jump through...you someone on the NPO to approve of your renovations, you need a contractor who is familiar with the historical district requirements, and you need a friend out here to push it through the NPO (if it gets approved).Not to mention the stringent requirements of renovating a house in the historical district, you even need particular building materials to work with.Even if you live here, I've seen a project turn bad very quickly in Fairmount when a contractor made an addition too large.For an out of state investor, this could very quickly turn into a nightmare.

What can anybody tell me about implementing the house hacking strategy with short term rentals?

We are nice about it, and gave them a notice before we implemented the change - but we tell them that we have too many units to pick up the rent in person.  

To me, that’s excessive. 1 month should be plenty, and if you are having issues where it’s not, then you need to increase your rental standards and make them more stringent. 

The right tenant for you will gladly give you a tour, and the wrong one would push back. implement the practices in those books and you'll be just fine. :)

And implement cover your back and your investment FIRST.

Not enough people to implement at the moment, they can't get section 8 inspections done quick enough.

Reaching out to brokers and presenting my requirements and qualifications sounds like a great way to establish myself in the market.Finding a US partner with local expertise seems like a smart move, I see the value in partnering with someone who knows the neighborhoods, property values, and potential investment opportunities.Overall, I appreciate the guidance and will start working on implementing these strategies right away.

Prioritize positive cash flow.When vetting a deal if you're looking for appreciation see where you can implement forced appreciation, where you, the investor have some control rather than being at the mercy of market appreciation.Forced appreciation could be done in the form of operational (changing out property management to enforce rent increases, getting rid of delinquent tenants, reducing property expenses, etc.) or interior/exterior value-add work (unit renovation, amenity/facility upgrades, paint, roof, etc.)