Hi Jon.
Welcome to the money pit called Astronomy.
Don't be completely disheartened by your location.
Chris Go is one of the worlds finest Planetary Astrophotographers and he does a lot of it from his open top balcony in his High-Rise apartment in the WAAYYY over-light-polluted city of Cebu City, Philippines!
SEE HERE
He does also travel for many images, but he is living proof that fantastic images can be achieved from a balcony in massive light pollution.
I know others too, Chris A in Ontario Canada and Gabriel in Romania are 2 more that do almost ALL their imaging or visual from light polluted apartment balconies.
Get to darker spots as often as you can, but by all means know that you can also do it from home
Here is Chris Go:
http://www.christone.net/astro/aboutme.htm
and also, here is the very 1st Astronomy Forum in the world (still very active) with the majority of it's members based in light polluted Singapore:
http://www.singastro.org/forum2/
Look through their image galleries of images taken from the city of Singapore. Amazing!
and finally, the personal website belonging to Remus Chua (a member in here and Founder and owner of Singastro, the worlds 1st Astro forum) showing what can be achieved in Light pollution:
http://celestialportraits.com/cp_index.php