Home buyers in some cities could be feeling more confident than others, as affordability varies widely from state to state.