A $5,000 monthly mortgage payment is very realistic for homeowners in high-cost states like California, Massachusetts, and New Jersey. See the level of income needed to afford it.