Ballantyne: Ballantyne Elementary, Community House Middle, Ardrey Kell High
Country Club site:
Ballantyne Country Club - Located in Charlotte, North Carolina
In the past, memberships were tied to the house, but I believe that has changed in the past few years.
Providence: Polo Elementary, JM Robinson Middle, Ardrey Kell High
Country Club site:
Providence Country Club - Home
You do not need to live in community to join country club, also, do not need to join country club if you live in the community.
Palisades: Winget Park Elementary, Southwest Middle, Olympic High
Country Club site:
Home - The Palisades Country Club
TPC Piper Glen: McAlpine Elementary, South Charlotte Middle, South Mecklenburg High
Country Club site:
TPC at Piper Glen > TPC Piper Glen
Tega Cay, Regent, Springfield: Last I heard there were freezes on some schools, so when you have narrowed it down I would check individually.
For NC school information check:
NC School Report Cards
For SC school information:
School Report Cards - South Carolina Department of Education (http://ed.sc.gov/topics/researchandstats/schoolreportcard/ - broken link)
Let me know if you need more detailed info -- best of luck in your relocation!