An appraisal that comes up short can completely derail a real estate transaction. Here’s how you can avoid it.