Long term play, this is likely your best bet.

😀But I have to get to it since the right choice here doesn't seem to be that obvious. 

Well if its from a bank you do not have any choice.

I'd suggest narrowing your choices down based on your long-term goals and what excites you most (sounds like hands on flipping).

Properties are pieces of a market.You're not doing anything wrong with your property analysis, you are doing wrong in your choice of markets.

It’s completely normal to feel a bit of analysis paralysis, especially when you’re in a position to make a move.The choice between a short-term rental (like Airbnb), long-term rentals, or a duplex comes down to your personal preferences and lifestyle.

There are many reasons why a cash out refinance is the better choice but there are a couple of reasons a Heloc can be used.

I would bet the most of us self manage.

Same time, I can let her stay til the family find new home but afraid if she keep complain after lease is terminated.As I have another project, I am ok if they live quietly but what will be the choice if the lease is over and tenant still live there?

I would say your best bet is to see if you can purchase a home with an assumable mortgage.