With retirement on the horizon, Andrew is already considering how to make the most of his new villa