This matte was made for the Pluginz.com competition... andit won it too!
It's made entirely with Photoshop CS2 and a Wacom tablet. The process consisted mainly in chosing a nice color pallette, hand-painting the ancient buildings and the other elements over the existing picture and creating a proper atmosphere for the scene through the lighting. Photo integration helped to achieve realism.