Home prices in Columbia run 42% below the national median: $245,000 versus $420,000. Relative to the $58,000 median household income here, the price-to-income ratio comes out to 4.2x.
Factor in $225/month for property tax in Columbia, based on the area's 1.1% effective rate applied to the median home price. That's $2,695 annually.
Missouri levies a state income tax on top of the $1,604/month this mortgage runs. Model your real after-tax take-home before deciding how much payment you can carry.
Columbia's cost of living index is 88, below the 100 national baseline. That's on top of the housing numbers above, not instead of them.
Columbia's median home price runs 4% lower than nearby Kansas City: $255,000 there versus $245,000 here.