A practical spreadsheet could use one row per home: precise area, first seen, original and current price, condition, reductions, withdrawn date, relisting and final known outcome. Leave the outcome as unknown when it is unknown; that is better than treating every removal as sold.