Agreed on separating developments, though energy performance can still be tested rather than dismissed. I’d build two small tables: active and withdrawn listings in one, completed sales in the other. For each flat, record the exact neighbourhood, type, original and current ask, first reduction...