The 40-year-old left his holiday villa to go to the shops, but never returned