Surprisingly, no one has discussed the transaction costs of real estate, which takes a large bite out of any potential gains. You don't necessarily come out ahead when you sell, even in a growing market, once commissions and attorney fees are paid.
I tend to move often and only buy real estate if I'm willing to hold it forever. So I buy what I think is a good long term investment and live where I want to live.