How are you defining a completed sale? Is it a confirmed transfer, an agent saying a deal was agreed, or simply a listing disappearing? Those are not interchangeable.
Condition also needs its own column. Two mixed-use buildings at similar asking prices may require very different spending before...