Andrew’s arrival in Sandringham met with frosty reception from locals