I would use A8Parts, I've always had great service from them, and wouldn't have a problem using a used good sensor.
There is this new Bosch sensor,
https://www.ebay.co.uk/itm/302150530146?
Hopefully it's original and not a Chinese copy. Who knows!?!
Measuring Block 1 in ABS will display each wheel speed, not so useful in this case. Measuring Block 7 is Installation position, either
invalid / ok / not ok. It would be interesting to see if yours displays
invalid or
not ok. Not ok would indicate a working sensor but inserted wrong with too much gap, bad bearing, axle tolerance (incorrect tyre size on that corner etc..). My guess now would be an
invalid reading due to the puddle and the sensor may have water ingress.
All the best with CV, job, A8