CMBS loans that went to foreclosure, REO or deed in lieu, and how they ended
search_cmbs_resolutionsEvery conduit CMBS loan whose servicer reported a foreclosure, REO or deed in lieu workout (SEC ABS-EE), with how it ended: resolved or still pending, the SEC liquidation code decoded (disposition/liquidation, discounted payoff, payoff, repurchase), the liquidation date, the balance before resolution, the last reported realized loss and loss severity, the special servicer, and the trust filing that reported the resolution. Plus a summary by resolution and the total loss reported. The answer to 'which CMBS loans went to foreclosure and how were they resolved'. A zero realized loss is stored as absent, so 'not reported' is never 'no loss'. For live loans and their current status use search_cmbs_loans. ACCESS: without a paid DFX plan on the vertical, a list returns its first 5 rows in full and a count of the rest by type (locked.count, locked.by_type), never the rows; a record names its subject and the first 3 related names per section; contact values (email, phone, profile URLs) and decision-maker names are never returned, only their types and counts. Every answer says what it withheld in entitlement and locked. Full access: DFX Intelligence, 7 days free at https://dfxintel.com/data-factory/plans.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| limit | No | ||
| since | No | ISO date; resolved (or entered distress, when pending) on or after. | |
| state | No | Two-letter state of the property. | |
| cursor | No | next_cursor from a previous page of this tool, unchanged. | |
| status | No | resolved: a liquidation code after the distress entry; pending: still in workout. | |
| resolution | No | Resolution text contains, e.g. 'liquidation', 'discounted payoff', 'payoff'. | |
| min_loss_usd | No | Only loans with a reported realized loss of at least this. | |
| property_type | No |