How do over-improved properties in rough neighborhoods sell for high prices given appraisal constraints?

Anyone can pay whatever they want for a house. The catch is that a financed buyer's appraisal answers to the neighborhood, not the upgrades. When a home is priced well above its comps, say asking $500,000 while similar nearby homes sell around $400,000 (illustrative), a financed buyer's loan still needs an appraisal to support that value. If the appraisal lands where the comps do rather than at the contract price, the deal stalls unless the buyer covers the gap in cash or the price comes down. So these homes tend to go one of two ways: they sell to a cash buyer who does not need an appraisal to line up, or they sit on the market while priced above what comps support. We have seen a heavily over-improved home linger for a long stretch precisely because the asking price ran well ahead of anything the surrounding sales could back. If you are buying one, know that the finishes may be beautiful but the value case rests on the surrounding sales. Budget for a possible appraisal gap and decide in advance how much over appraised value you are willing and able to bring. If you are selling one, price it with clear eyes about what a lender's appraisal will actually support.