Northstone Country Club is a private club and offers an extensive list of of annual term memberships to choose from. Northstone has a great site as it takes you through the course, hole by hole.
Northstone also has some of the most unique membership packages going, so if you are looking for a club in the Huntersville area, Northstone may be a good one to do a little more research on.