In an  Office or Industrial project, competing business can co-exist as neighbors because they are generally providing a service for which the "playing field" is away from the property.

With the STR strategy you potentially go with the 10% down second home occupancy loan that comes with a lower interest rate

In terms of your financing question, the majority of loans we do are in that $1m to $5m range, so that's not an issue at all (fake numbers wasting everyone's time would of course be an issue, but let's stipulate that it's solved).

We plan to take a loan against this house (home equity loan or refinance) for 75% of its value, hopefully.

We have several projects in the pipeline that will require re-development and any help you can provide would be deeply appreciated!

Is there a possibility to get another loan for rehab, fix everything up, and then try to sell and pay back the loan? 

Tools like Zillow, Realtor.com, and local real estate websites can provide valuable insights.Choosing a market involves balancing risk and potential return.

A good credit score will help significantly in the future pursuit of real estate as you try to get the best loans.

Provides good support, doesn't usually bother me unless it comes to expenses large expenses or rent adjustment.The reason I am thinking of getting out of being a real estate investor is due to the stress and constant little expenses that are adding up. 

Im going to househack a 2-4 unit SFR using an FHA loan.