Andrew Mountbatten-Windsor is looking forward to a quiet life at Sandringham’s Marsh Farm, but it turns out his new estate comes with a watery warning.

The property sits on a flood plain, just a stone’s...