Prices in massively inefficient markets do not follow the supply + demand equilibrium. Beer is not an inefficient market. You're doing the absurd comparison.
housing isn’t an inefficient market. It’s surprisingly liquid for how large the purchases are
It's more correct to say supply and demand still drive the overall average, but in a high-friction market of unique items, every single case is still a unique case. It's not like moving wheat bushels or RAM chips. When they sell oil, they mix up all the oil from different producers in the same reservoir, in the same tanks. Electricity travels in the same wires. Housing is nothing like that.