We have a tour ticket sales store with items that are in a category and 10 of these categories are in a main category. It looks like this:
Category WashingtonDC has sub-categories Land, Water, Museum, Packages. Under Land we have a "Barefoot Glass-Walking" tour. We don't sell many of these

I'm looking for a way to have the SEO friendly URL say http://mystore.com/WashingtonDC/Barefoo ... lking.aspx (Land is not necessary here). Any ideas out there of a good way to do this? I know how to use the custom url to make it mystore.com/Barefoot-Glass-Walking but how do I programmatically get the category (city) in as a "folder" in the URL?
Thanks!