Many of the estate properties are located on lakes or rivers providing unique recreational activities.

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

Not sure how active he is on BP, but you might be able to get some insight from someone who was in a similar position. 

Many have an unfavorable outlook on the 5+ unit market for the next 2 years or so, while there are a few who are still hungry and actively funding deals in the space.  

Basically, flip partnerships suck unless you spend a long time being clear about the roles and payouts, etc.

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?

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?

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.