Housing market sees major price cuts in expensive cities like San Jose and Los Angeles, while affordable markets maintain steady demand and stability, a new report found.