There are some great courses down in South Charlotte such as Myers Park Country Club, Carmel Country Club, Quail Hollow Country Club (home of the Wells Fargo, former Wachovia Cup Championship), Piper Glen Country Club and many other lesser known ones, but not bad courses.
If you're looking to live near the lake, The Peninsula is a great course and home to LPGA tournaments. The Point, a little bit further north in Mooresville, NC has just been purchased by real estate mogul, Donald Trump, who will convert the course to Trump National Country Club and will invest tons of money to revamp the course.
Please contact me, I want to help you with your move, and you have no obligation!!