Distressed assets: repeatedly unsold lots
distressed_assetsProperties that keep going to auction and NEVER SELL — the distress screen.
The clearest distress signal in the warehouse: a vendor who wants out and a
market that has said no more than once, both on the public record. Ranked by
how many separate auctions the lot has failed at, then by how long it has
been on the circuit.
READ `guide_to_avm` BEFORE CALLING ANY ROW AN OPPORTUNITY. It is the latest
guide divided by our AVM, and it is the difference between the two reasons a
lot fails:
* above 1.0 — guided ABOVE our estimate. It keeps failing because it is
priced wrong. That is a repricing conversation, not a discount.
* 0.5-1.0 — guided below estimate and repeatedly unsold. The cohort worth
a call.
* below ~0.5 — check the lease before anything else. A flat guided at a
fraction of a freehold estimate is usually short lease, ground rent or a
garage, not a bargain.
`max_guide_to_avm` filters on that ratio; 0.8 keeps only lots guided at
least 20% below estimate. Lots with no guide or no AVM are EXCLUDED when it
is set, because an unknown ratio is not a low one.
Rows are grouped by ADDRESS, not UPRN. Flat-level UPRN matching in this
table collapses separate flats onto one id — five flats in one Nottingham
block share a single UPRN — so a per-UPRN count over-reports. `uprn` is
returned for onward lookups but is not what rows are counted by, and for a
subdivided building it may name a neighbouring unit.
Geography is postcode district or area, not area_id — the auction table
carries postcodes and the UPRN join is too weak to filter on.
UK only. Free.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| limit | No | ||
| years | No | ||
| offset | No | ||
| min_auctions | No | ||
| is_commercial | No | ||
| postcode_area | No | ||
| max_guide_to_avm | No | ||
| postcode_district | No |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||