You are creating the recipe for disaster with this.You engage a tenant to rent with the disclosure that it's going to be in foreclosure and mitigate that with a lower market rent, and the possibility (not probability) of cash for keys from the lender when they foreclose?

Yes, this is the sit you want to stay engaged in.

I should add that one of the tenants took it upon himself to call the painting firm engaged by the condominium corporation and to level these accusations to the owner.

Dominated by 1-2 big players that are not the nicest of people...

Instead of 30+ spreadsheets with 500 previous sales each I of course would prefer a single large sheet.Without engaging a realtor or having access to the MLS, is this possible?  

I was so upset that I let this happen that immediately I engaged in learning all types of new strategy to help me avoid this from happening in the future.  

this is a great site to learn and actually move forward wth so many helpful engaging people.

I've got two calls you'd appreciate.One is with a Major League Baseball player on his $1.7MM house and the other is with his financial advisor who you will hear tell me he understands I'm going to make over $100k on the deal and has no issue with it because I deserve to be paid. 

I honestly don't know what to do or how to engage this issue. 

I'm a poker player myself and love the game.It sounds like you've come to the same realization that many other investors, particularly in California, have come too.