Watch the movie Pacific Heights with Michael Keaton.

What’s the revenue stream and payback?

I have two condos now, and looking to invest about 250k in a new property. ideally, i like the steady stream of renting vs short term rentals. 

All investors should consider private money lending as an additional income stream if due diligence is done correctly and the project is a good fit.

Hey James, with a price range like that Columbus and Cleveland OH will be a standout choice, in these cities, your financial resources will go a long way enabling you to assemble a diverse multifamily portfolio and initiate a steady stream of income. 

On another note about the area, very positive news about Sony Studios project/mixed-use development.https://www.reviewjournal.com/business/1-8b-sony-movie-studi...

So if I setup an LLC, setup a self directed 401k, transfer money from traditional IRA into the 401k, use that to take out a 401k loan of $50k, how does that work with crossing streams and tax conflicts? 

While most of the steady jobs are north of the city, as previous comments said, there are a few big HQs near the airport (Porsche, Delta, etc.) and several movie studios nearby.

I want to generate a consistent stream of cash flow and make it as passive as possible to do so.

If you're seeking a reliable income stream, consider checking out Cleveland.