I recognize this isn't exactly like kind but wondering if this has been done or if there is a multistep process involving several transactions over a period of time where you can shift from multifamily to single family or vice versa?

Recognizing that home appreciation is crazy high right now, rates will likely go up in the future due to inflation, I expect the apprecation to slow down in the next year or so (just my hunch). 

Look for events put on by the names you recognize from online searches or podcasts and find out what you can about the events. 

I have recently found another good paying job but I need to be with that job for awhile for the bank to recognize longevity.

Note they know their limits and I recognize jobs that warrant licensed work.  

Hard money lender called L3Funding. There website is  https://l3funding.com/

I inherited the tenant living in the ADU and part their rent included all of the utilities plus Internet because the ADU does not have its own address and the cable company does not recognize the main house and ADU as a separate address. 

The TAR(Texas *** of Realtors) forms are the most recognized and are thorough. 

Generally speaking there are 2 main types of loans for investors: “Conventional” and “Portfolio”Conventional - I'll define these as loans that come from Fannie Mae and Freddie Mac (if you recognize those names).

That differs from the leverage in RE that is not backed by any value other than the RE.3) recognizing that most investment RE is at high LTV, the RE appreciation that you depict provides a return that is compounded for the LTV.4) I am not impressed by multi millionaire.