@Victor Yang To use the rental losses to offset any active income (W2), you'd have meet Real Estate Professional status (which would be difficult to do with a W2 job because you'd have to work more on real estate than any other job to qualify) OR have an AGI of $150K or less.

I’m actively seeking to purchase either a multi-family or duplex unit in the Columbus area  for a medium rehab project. 

Sounds like this could possibly be a Schedule C activity so keep self employment tax in mind.

So, if you have 10 units and you are going to pay $1,500 a month and you are working on an active income job, too, this is an easy switch due to the labor mentally and physically (even if it is just phone calls) to get these rentals running as a well-oiled machine.  

I have been investing in real estate for the past 15 years but more actively for the past 10 years.

I am actively expanding my STR consulting business!

This would be an easy decision however I do not think you can come close even with you being active in the process.  

Sounds like things have changed a lot since 2016, and it's helpful to hear from someone who’s actively operating in the area.I completely get that this is a different market dynamic.

I’m looking to raise $160,000 to cover the purchase, renovation, and activation of this new Airbnb property.

I don't like seeing a bunch of blue haired nerds running around crying about how evil their landlord's are for forcing them to pay their rent on time, but I don't want being a blue haired nerd to become a criminal offense.