I am exploring both short and long term investment as an out of states investor and trying to understand between Cleveland and Columbus OH.I have been learning these two markets are appreciating and have a good cashflow.As I am new to these two markets, I would like to learn which markets are providing a reasonable cashflow while up potential of appreciation for next few years.between these two markets, which ones are suggested?

Short answer: noI haven't looked at your other posts, and I don't know anything about you, but this does not seem like a good idea

Last year I pushed the button and bought a house in San Diego which I've been using as a short-term rental and it's been doing pretty well.

It is always best to have a lead person on the lease.

BUT this also leads to very high default rates.

We will visit there once~twice a year and meanwhile we want to rent it out as short term rental. ( we are thinking of Florida and that market seems slow these days ) we are in CA. 

At the minimum, the lead data gives you great insight into the MTR demand for your market.

(for traveling nurses/visiting physicians), Yale students/visiting families (for short-term), adjunct professors, researchers, grad students etc. 

I’m planning on getting a short term Investment property in Houston texas but I have some concerns due to the fact I live out of state.

If you believe that they will be short $800 per month I would not approve the applicant.