http://psd.tutsplus.com/tutorials/photo-effects-tutorials/cityscape-concept-art/

In this tutorial, I will teach you how to easily create a successful piece of cityscape concept art. We’ll be using a very basic 3D scene as a foundation for the piece, then taking it into Photoshop for some creative photo manipulation of reference photos, basic painting and adjustments. Let’s create this urban scene!