As far as 1031, Indianapolis has a lot of development with businesses moving there  so that could be a consideration, not sure how far you are from Indy. 

Long term wholesaling as we now define it may not be a viable method of business.  

I own a triplex and was wondering if I could use one unit as a short term rental to offset my W2 income as a trader business.

DSCR Loans are mortgage loans secured by residential real estate turnkey properties strictly used for a business purpose and underwritten primarily based on the property.

Mortgage holder or private mortgage?  

If you really think about it, those Realtors that are super busy, aren't always available either lol, and they defer to their assistant A LOT.

I'd say this deal overall doesn't seem like the best deal given the numbers you gave as well.My business partner and I do investment deals all the time in Phoenix, we should grab coffee sometime and talk through a strategy based on your goals.

I really like the  appreciation vs. cash flow article here, but also not sure where to look for things like where businesses are moving to and types of jobs in the area written in the same way as that article.

I am opening a business in Mexico city (Hair salon) for my wife so get some short term income, Also I am heavily invested in the US stock market but at this time it is not going no where until we have some rate cuts. 

This is going to be a very tough scenario, I suggest you stop putting money into this deal until you get things sorted on the financing side.I would also be very careful with and sketical about any offers for 100% financing... it will not happen, they are lying 99.99999999999999% of the time.The only realistic way would be for you to find a private investor to come up with the down payment for the mortgage but a down payment will be needed.90% LTC is theoretically possible through a flip loan but in order to reach that level you would need to have a lot of completed projects under your belt over 2 years.20% is possible but with 25% you would have a lot more options.That is part of the issue with this transaction...The other issue is with HOW MANY loans you are seeking...This is not 1 loan because this is not 1 deal...You need 3 loans because you are doing 3 separate transactions at the same time with the same seller.Blanket loans do exist but they are not widely available.Each folio number is a separate deal...