One vacancy in a lower tier market, could take 1+ years to fill, compared to a prime retail location that has a tenant waiting list just hoping a vacancy appears at a center.

Since you plan to sell the property and use a 1031 exchange, resurfacing the floor to improve its appearance before the sale makes sense.

Every system you try will have flaws, or you may salivate over a feature that appears in other software.Some familiar names are mentioned frequently: Stessa, Apartments.com, RentRedi, TenantCloud, Innago, RentManager, Avail, Rentec Direct, Doorloop, etc.I recommend conducting thorough research on each app online to understand their offerings, pricing, etc.

However, the particular property that this tax sale I was referring to is located in Allegheny county where the procedure appeared to be the latter judicial sale.   

Usually the loopy terms are exaggerated compared to the deal they actually transacted on because they have to make their "system" appear even more marketable. 

Another reason may be that you appear unprofessional and interested parties are looking for a sweet deal like a landlord that doesn't screen or is negotiable on all their terms.

Appears the property in question can be used as residential or commercial and there are advantages to such a designation.

There still is a tendency for DSCR Loans in particularly to get lumped in (throughout securitization) with other "Non-QM" loans, mostly owner-occupied when they really shouldn't be in my view, further a lot of the "tech" and software, systems buildout (including loan doc generators) are based on consumer resi which creates a lot of headaches.Anything rehab/construction related though (which is what the original post appears to be more about) is a different animals though - experiences are likely to vary markedly by market, lender, bank etc quite a bit

It appears to be pretty unrealistic.

You will have to spend considerable time and energy getting familiar with a new market whereas if you stick with the original one you appear to have enough capital to get started right away on a new building.