How to use Secure Pages in Acquia's Cloud Environments

So I am curious if someone is using Acquia's Cloud hosting, with the 3 environments (Dev, Stage, Prod) and use Secure Pages.

I am having some difficulty when I am trying to update my Dev and Staged environments. When I go to log into the site in those environments, I get redirected to the live site's admin panel, and I can't get back. It's a real pain to do, but I can turn off Secure Pages in the database but it that tends to cause more harm then good.

So with setups were there are multiple environments, different URL's for each, how are people handling this? Is it something that you need to just setup in your local /etc/hosts file? Not sure what to do but I haven't been using the environment setups because of Secure Pages and the URL redirect that takes place.