Hi Rusty, the good thing is that you can't really go wrong in the Lake Norman area. As far as resale, you have to ask yourself, "when I go to sell, which groups of people will my house appeal to?". With a small house, you're cutting out most people with families. With too large of a house, you could possibly be cutting out single people or young couples. I would say buy a 2500-3000 square foot house close to everything. In my opinion, Hampton Ridge and Cambridge Grove are two communities that you can get a good value in...250-300K give or take. If you want to go a little higher, Birkdale, Wynfield Forest, Wynfield Creek, Northstone, and The Hamptons are nice. They are all extremely close to everything.
Feel free to contact me if you'd like to speak further