Good Locations hold value and appreciate. Bad locations offset all the good features of a home, and will ultimately cause the home to lose value. It is one where people want to live. One that is close to work, shopping, and recreation, for example . A good location has access to major highways, but does not get highway noise.
Good locations have continuity of land use.
A good location will have good schools. Evaluate them by visiting specific schools, not just by looking at average district test scores. San Antonio has some remarkably good schools. Texas has no county zoning, and many subdivisions outside the city limits have no controls on land use. Look for evidence that the CCRs are being enforced when you look for a home.