Thinking about a move-up home or a second home? Here are some things to consider before you decide which is best for you.