I hope you'll do a post that takes us through the whole process, what it involved, the problems encountered. if doing it today, what wouldyou have done differently (other than not doing it at all) Are you selling it, renting it or ? 

So I encountered a vacant/abandoned property that has been in that state for 3-5 years, and was condemned by the city due to it's poor status (hoarder house etc.).

Sure, try working something out, but man sure sounds like all the "takers" I've encountered in my life. 

I also had a bit of sticker shock with Loopnet.  

I have multiple running, but one that has worked more than I expected it too is making a sticker magnet and placing on the side of my car.

I love your comparison against hotels, and that they do certain things for a reason, and that those things are what produce long-lasting success in their business model.As a host, I've tried implementing "hotel quality" at all of our vacation homes but have encountered friction from those STR investors who don't understand the difference between being cheap and being frugal, much less see the value in great design, or the 'little things' that make a big difference.

I have encountered people acting as intermediaries with little knowledge, training, or experience or understanding of the field they’re involved in.  

Search the BP for ADU appraisals to encounter numerous examples.

And so far I have not encountered one in a "cheap" Tesla but I am aware of the efforts for such.

She is separating from her husband, so it seems tax returns are no help because they filed jointly last year so income is combined on there.I am curious as to how others have handled this if they have encountered this situation.