The U.S. housing market slumped badly last year amid surging mortgage and a dearth of affordable properties, new data shows.