Are there any challenges I might face, especially if my long-term tenants aren’t comfortable with the short-term rental activity in the same building?

That way you know they are active in the community!

Passive Activity Losses: Are there ways to offset my W-2 income with rental losses, or do I need to qualify as a real estate professional for that to work?

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

That way you know they are active in real estate!

Thank you Hi Eliane, I am in Baltimore and been an active investor since 2004, doing close to 20 BRRRR a year,and I am an agent, let me know if you have any questions.

@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.

In this post-pandemic landscape, metropolitan areas remain the hubs of economic activity.

@Vina Merrill,I don't have much intel on Knoxville, but I’m active as an investor, turnkey provider, and builder in Chattanooga.

In my opinion it would be cleaner to split partnership based on monetary contribution and then remunerate each active party for their work if the active work is more on one partner than the other.