If you are looking to rent a CS server, I'd recommend Apoplexy Industries. They offer CS 1.6, CS: Condition-Zero, and CS: Source servers with packages to get your started. They offer powerful server hardware with the performance and stability you would expect from a top-tier game server. They also provide servers with FPS from 500 to 10,000!! There customer support is unparalleled in the game server industry.

Aigaming has US locations in New York, Chicago, Dallas, Atlanta, and San Jose. With all those locations, you should be able to find something near you with excellent pings.

More Information: AIgaming Website