A stunning waterside property...