As housing prices continue to rise, new data highlights how hard it can be to afford a home in some parts of the U.S.