It is a liquid whose temperature is lowered below the freezing point but lacks a nucleation site for freezing to occur. Truthfully, I didn't even think about water pipes.
The danger of a supercooled liquid is that it freezes as soon as you touch it. So it is very difficult to handle - pump, pass through pipes / valves etc.