I have done quite a few renderings in the similar style.

It's 3D Studio Max to render and then multiple layers of photoshop.
People and trees were added later. I'm pretty sure you can get to this rendering using V-Ray for SketchUp but your key is Photoshop