I know the Charlotte area use to change quite a bit. Of course that was years ago when I lived there. Below is the link to the Mecklenburg county education site. So you can browse for yourself. There are quite a few good agents on here from the Charlotte area so they will be able to give you a more in depth look at what is going on. I guess the one other thing they will need to know is the size of the home you want and your price range. I remember growing up in Charlotte (too long ago to mention) but, we lived on Queens Road and I still remember Myers Park Elem. fondly. So if changes I am sure that is still a good area but all resales and in town.
Hope this helps,
Coldwell Banker Triad