If it is for rent, try to get the best return ratio, and a livable house that if it is damaged, you don't feel pain.
If it is reserved for future retirement, you need to pick a good location, but you may not need to have a good school district because at your retirement time, you don't need to have a good school. Usually people liquidate their good school district house and move to elsewhere low price neighborhood for retirement.
To mix different goals usually doesn't bring a great result.
And to reserve for some future purpose also may miss target very easily.
When I was young, I bought a lot of things to reserve for the future, for example, I spent a lot of extra money to buy a video player that can support satelite signals and I planed to use it in the future when it got popular. But before that, technology, personal situation and everything have changed. I endded to pay extra money for nothing.
Gu-shi