If you are looking to rent a CS server, I'd recommend Clan Servers. They offer CS 1.6, CS: Condition-Zero, and CS: Source servers starting at $1.99 per slot, and even less for private servers. They offer powerful server hardware with the performance and stability you would expect from a top-tier game server. Clan Servers has US locations in New York, Chicago, Dallas, Atlanta, Los Angeles, San Jose, St Louis, Tampa, and Seattle. They have European locations in London, Amsterdam, and Germany. With all those locations, you should be able to find something near you with excellent pings.
More Information:Clan Servers Website (gameservers.com)