Very good points on market time. Indeed the cancelled, expired and withdrawns should be taken into consideration for a sold listing if they are all part of that same “selling period”. I take a similar approach when analyzing true numbers. I also like to use a ratio of active/pending status as an indicator. For instance if someone is selling a 3/2 1800 square foot home then I will find his comps on 3/2 from 1600-2000 sq ft, and perform that ratio for his mapcode and his zip code. I have similar ratios that use for solds to unsolds (cancelled, expired, withdrawns) to really get a more solid picture of things.
I do believe that the market time for a contingent property is still reported correctly though. Don’t you keep your listing in active status until the sales contingency is removed?
Anyways that is just being nitpicky on my part. Good post.