My wife and I relocated here to the south of town and absolute love it. Charlotte is a great area and its still one of the fastest growing areas in the country with 50,000 new people a year calling this place home.
Sorry to be vague in my answer however this the very first step to discovering a buyer's needs to assist them in finding the right house in the right location at the right price.
One thing is for sure it is a buyers market and gthe area needs teachers! Charlotte-Mecklenburg Schools is the big guy on the block-- but there is Union/Iredell and Cabarrus close by. All have websites withhelp wanted info. Good Luck!
Then I would suggest working with a good buyer's agent. I can refer you to several good people that I know could help you.
As real estate agents, we are not allowed to direct people to one community or another. It's called "steering" and we can lose our licenses for doing it.
The best thing to do is get in touch with a local agent who will be able to give you information regarding schools and crime stats so that you can decide for yourself which area looks to be the one you would like to move to.
If you don't know where to look for a local US agent and no one from Trulia responds, my company is a member of LRE-Leading Real Estate Companies of the World. We have connections everywhere and can recommend a good local office for you. Contact me through my website where you can also find crime and school stats on your own.
I am in the Raleigh area and do not know much about Charlotte. Since you are out of the country, please get a good agent to help you with this move!
I can give you several referalls to fantastic agents in the Charlotte area. They have all been in the business for years and would be perfect to help you get to know the city before you buy.