Finding the right home at the right price and being able to afford a mortgage isn't necessarily all it takes to sign on the dotted line: Location is another factor that could torpedo the deal.