This question made me laugh.
I live in the suburban Boston area. In my town, which is one of the more affordable within commuting distance and with a good school system, 500K gets you a 50 year old home, about 2000 square feet, 2 baths, 3 beds, that will probably require a lot of upkeep and renovations. We are actually in a gentrifying phase where a lot of these old homes are being bought, torn down and then 400 sqft McMansions built in their place selling for $800K.
Now, I was fortunate enough to buy a home 15 years ago when homes were more affordable here, and I have seen my house value double in that time. The towns that surround me are generally even more expensive. I personally would not pay 500K for a home and didn't, but if I were buying today, I would probably have to spend $400-450K to buy my home.
The idea is to finish paying off the mortgage, sell the home when my kids are out of the house, buy a much cheaper home north or west, and pocket the rest.