I need a remote control or electric switch underground beer caddy that is mains operated

I think you need to tell more details. I am assuming that you don't have a compressed air source so I will exclude the pneumatic solution. You can use any rotational to linear motion mechanism like crank shaft mechanism. for doing this you will need to design a mechanism to your specific case (you can get one from here and change the dimensions to fit into your application), additionally, you may need a power source to actuate your mechanism like a small motor and you can control it using a push button, a relay, and a limit switch or a proximity for position control. Provide me with more details. So, I can provide you with more specific answer.