Purchasing the right home, choosing the right neighbourhood is a complicated choice, there is no one option that is right for everyone. This is so unique to your family, your work, your time, your financial situation, your priorities and the only right answer is again, talk to a realtor with experience.
As with anything in life, experience is key, knowing the outcome of the choices of many before you, your realtor can help you weigh all of your unique answers and questions to make the right choice for you.