In Hi-end architectural visualizations there are two schools of rendering. In one of them, the major aim is to receive as best possible render directly from 3d software, but second is based on post production.
This tutorial presents how you can add effects such as abberation or depth of field to make image look more like photo.
I use V-Ray renderer, but you can use some other rendering engine, and the effect would be similar.