This post shows that you dont need to have dark skies in order to take decent astro photos. The location this was taken, the 2nd magnitude star, Polaris was difficult to see. Areas to the South were even worse, and most of these objects were taken fairly low to the south.
The most southern object was the helix. These were taken in white light, with a Astronomik Clip in CLS filter.
Sure, its pretty dim, but with a few extra exposures, it can be had a little brighter.
The next object I tried was the Horsehead. It too was quite do-able from within city lights.
The Orion Nebula is a bright object and is an easy target from anywhere.
The blue dust surrounding the stars of the Pleiades, although quite faint is still within the city dweller's grasp.