A balance transfer card alone most likely won't affect your ability to get a mortgage, but credit card debt could.