Rising supply and slowing demand in the housing market are finally causing prices to cool off, and the weakness is accelerating