I did the relocation from Farifield County area of Connecticut to Charlotte eight years ago. I have four children and at the time had three in school....So like you picking the right area with good schools was very important to me.
In terms of areas Charlotte is a different city than anything in Connecticut. I have found that it is more community oriented and depending on your wants and needs there are pockets of Charlotte that fit certain lifestyles better than others.
In terms of Schools. When my wife and I decided to relocate to Charlotte we chose Matthews area. I have helped clients relocating from New York and Connecticut and they have relocated to various parts of Charlotte based on their lifestyle and wants in it....
If you are strictly looking at schools a good website to visit is http://www.ncreportcard.org.
I found in all my research this to be the best website for evaluation of schools. It is run by the state and is strictly and a data information site that shows you how the school performs against other schools in the district, county and state.
Being a Realtor we are not allowed to steer you toward or away from one from one area or another....But this site should give you a good idea of school rankings. On a personal note I have been very pleased with the education my children have received down here form the Charlotte Mecklenburg School system. When I moved here I had one going into first grade, another entering third grade and a third entering fifth grade....Now with my oldest a senior in High School I have been through the whole system and have been very pleased with the educational opportunities afforded them.
Coldwell Banker United