Housing in major cities like New York and LA remain unaffordable, while markets like Phoenix and Atlanta shift toward buyers.