The recent Redfin article on what city is the most competitive is fairly accurate, given the data used to calculate the figures. It does appear however, that the data quoted did not account for off market sales, which, if taken in to consideration, could potentially change the figures.