I actually have a video I did about a year ago depicting what I believe the 24th Century version of Charleston, South Carolina would look like. The special effects are crude, but hopefully you will get the idea of what I wanted it to look like. Here is the link:
http://www.youtube.com/watch?v=Ca7JrK8XniQ