A picture lies more than a thousand words, so instead of lengthy introductions I’ll just give you the pictures. All of them of the same model/building.
The completed main shot:
Go here for a larger image: http://personal.inet.fi/koti/jate/images/UKI/sco_per_1_larger.jpg
An unrealistic theme shot at night:
And a few WIPs:
The night shot was rendered in blender, the others with Yafray. Postpro in photoshop.
EDIT: as requested, here’s an in-blender screenshot.