Definitely a question for a plumbing contractor. Note you cannot get a mortgage on a property that doesn't have functioning plumbing. If the property was abandoned I would suggest to you that a short sale sounds very suspicious to me. This should be a foreclosure and my best advice to you is that if it is indeed a short sale requiring lender approval, I'd forget about it and move on. If it's a foreclosure I would not have these concerns.