You are missing the impact of debt here (mortgages)
In your same example:
I have $10k, and buy that $100k house with a $90k mortgage. For simplicity let's forget mortgage repayments
After 10 years I sell for $163000, leaving me $73k for my next down payment
I can now "afford" a $700000 house assuming banks are willing to lend 90% LTV