Agreed on separating the stages. I’d make a simple table for each neighbourhood: active, under offer if visible, completed and withdrawn; then add condition, recurring charges, original price, latest price and dates. Don’t merge relisted properties without checking whether they are the same...