Many big-tech companies have established themselves here or are expanding into the Columbus market.

As Kate mentioned above there is definitely some marketing efforts needed but once established its about keeping up good reviews and that's all about the guest experience.

Do you intend to rent the property out via short-term or long-term rentals?

If you're not planning to live in the property long-term, I'd suggest prioritizing the property's standalone investment potential during evaluation, regardless of its role in a house-hack scenario.

o Bridge (rehab) or long term (30-year fixed)?

You may be able to get away with 10% down if you have multiple fix and flips/holds completed in the last 36 months and the LTARV allows for it. 

One person is extrapolating out the depths of the inner city to the entire market as far as long term viability for investment, when the other person is actually considering A/B neighborhood buy and hold. 

For example, I often see Buyers purchase property thinking there is a $1,000 deposit but then the tenant claims it was $2,000 because they paid the last month's rent.

does lending one have a long term loan product ?? 

With every deed recorded and date last used title my GUESS is this: Dad intended for Mom to stay until she died but did not intend for Mom to get a loan on the house.