I come back to see such helpful pointers.
Of course, with completely disregard for safety, I went for a total plumbing cowboy. Then I realised he didn't seem to understand that having 'no hot water' did not mean the same as having 'no cold water', or having 'no water at all', or whatever else...