The appraised value is just a signal how much collateral a bank can rely on for the loan, which is why most loans with good interest rates have a maximum loan to value ratio. Banks don't want to own houses, they want to own a piece of the borrower's future productivity, manifested as interest payments.
The limited housing/transit supply (due to zoning restrictions) coupled with concentrated job growth are what drives up housing costs.