For completed examples, I would record only a few fields: tightly defined location, property type, apparent condition, first public ask, later asks, days advertised, final price and whether the listing vanished before completion could be confirmed. Keep withdrawn homes in a separate column. That...