Remote workforces and e-commerce trends have significantly impacted retail and office asset classes; however, the multifamily asset class has seen relatively little disruption.

The 1031 works just fine with each of these types.As far as sector goes both DSTs and NNNs will be available in all the types of investments you mentioned, medical, multifamily, retail, supply chain logistics, self storage etc. 

If your business needs space, why not look into industrial?

In a fast moving industry where agents have multiple clients going to look at FSBO homes is almost always a time waster.You need a company or an agent that specifically caters to investors.

This site is filled with do it yourself landlords who crap on the industry but there are plenty of really great companies, you just need to find them. 

I financed these buildings with a bank loan, and they hold both retail and apartments. 

The Auto industry due to thechip shortage is backlogged for the next two years trying to ramp upproduction.

I have built and sold affordable, retail and  I have built my own B2R.  

Also should it be a commercial mixed use (retail below multifamily above) or just multifamily?

It's listed as retail and office outparcels.