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...
There is also a boundary problem. “Bangkok” can group locations that buyers do not treat as substitutes. If the cheaper and more expensive ends of the sample sit in different neighbourhoods, neither the +4.0% nor the 74 days is a clean citywide signal.
Thirty days alone would not make me call a listing stale, especially without new-listing volume for comparison. The bigger missing detail is geography: are these genuinely comparable streets or units grouped under broad neighbourhood names? I’d also separate condition and seller motivation...