Glad you took the page and link the way I meant it, not how I typed it. I was giving the location in case I hosed the direct link. The site City Data will be you best bet, the local forum I believe is Charlotte at
http://www.city-data.com/forum/charlotte/ Their detailed page on Union county is
http://www.city-data.com/county/Union_County-NC.html
I also forgot to mention some of the best parts about living here , you will be 2.5-3 hours ride to the mountains or to the beach. Charlotte & Monroe is right in between both. So making a day trip is easy.
If you have a bike great roads for scenic rides and some for challenging turns.
Hiking? Mountains-to-Sea Trail and the Appalachian Trail will cover any long distance and enough parks and waterfalls to keep them fresh and new for years of exploring. I highly suggest Roan Mtn and Carver's Gap(This side is free and has the grassy balds that aren't above the treeline for growth, just trust me it is a great hike with a great photo chance where a rock out cropping is in the middle of Rhododendron, so you look like you are standing a sea of flowers) Big Bloom is towards mid July to late July(local rangers will give detailed info for when that season) for the Rhododendron being in bloom. Plus you have the Balds which are a unique feature.
https://en.wikipedia.org/wiki/Roan_Mountain_%28Roan_Highlands%29 Park splits NC and Tennessee. then There is Mount. Mitchell, highest point east of the Mississippi. There so many guides/webpages you get overloaded for options close to you and within day tripping or camping overnight. The Blue Ridge Parkway is a great drive but is very well packed when the leaves start turning.
Rock climbing is great, even ice climbing in the winter. Weather will also be hit or miss on snow & ice in the mountains. Many planned trips to ice climb in January & February had me in a thin T-shirt rock climbing, yet I have seen ice in late may at the base of water fall. Seriously the weather is screwy here, in few days you can go from cold to warm and back to cold again. Ski and/or Snowboard you're covered but we get a more compact type than powder for snow.
Great white water and a great man made white water park.
Like Amusement parks and roller coasters ? See Carowinds .
If you fish and/or hunt NC and SC will have you covered.
Scuba dive? Graveyard of the Atlantic, 3 German U-boats
Into Aviation, a hidden gem is Carolinas Aviation Museum with a very large dedicated subject matter library. Although you should check if going on the weekends for what air shows some of the aircrafts may be at for display.
Racing? NASCAR is king. Seriously if living in Union county or in North Mecklenburg areas expect to see drivers and their crews.
The downside is the area is not big on preserving history, so expect newer rather than older. But hey those historical marker signs are cool trade off... Although you'll find, Multiple Native American tribes history . With Revolutionary war and Civil war history. Various Pockets exist in certain areas and the Appalachian Mountains are mixed. Not to mention places like Mt. Airy /Mayberry(Andy Griffin fame).
If you want land and open space stay out of these dense population centers , Charlotte(spills over the county lines and state line for suburbs), Ashville, Raliegh-Durahm-Chapel Hill(aka Research Triangle for their big medical specialists and research departments, a big perk if you need a top of the country specialist), Wilmington. There are few others, you can see them from maps.
Mass Transit is very limited.