Do I only reveal that I have $40k, when in reality, I have a total of $55k but that's for downpayment, closing, renovations, immediate fixes, emergency fund, etc? 

If you look at the report, this deal has such a low CoC return due to a high amount of expenses. 

The simple answer is highly accurate..A recent CBRE report on the accuracy of AirDNA date found it to be 97.5% accurate in reporting active supply of vacation rentals.

Present the inspection report to Seller and ask them to address the issues.

Let everyone know that you will report them for failing to report.

I'm sure this is taking quite the emotional toll on you, in addition to taking away precious time from your day where you aren't able to source additional deals.I would also go after the lawyer and report this conduct to the board of ethics. 

Then, on the day of closing, the buyer revealed a major issue: there was a second loan on the property, an additional $60,000 over our contract price.

They were actively trying to open credit card accounts in his name I seen on his credit report.

Some conflicting reports but it seems the nation average of home sold per agent is been 8-12 depending on the data, for this scenario we will go with 10.

Removal and examination after ceiling drywall removal revealed the water tracked along a joist and saturated the ceiling from a focal point along the joist.