I've been asked how I get that look I have in some of my screenshots. Some of that is partially due to this mod here.
Quote from the author:
DESCRIPTION: I give you Sexy Whiterun 3.0, a near-complete retexturing of the city of Whiterun.
While I consider this mod "lore friendly" it is NOT for everyone. Those who like the weathered look of vanilla Skyrim should steer clear. Those who like a more fantastical world, ala Oblivion, The Witcher, and Fable, with more vibrant colors, however, should give this one a try!
Get it here: http://skyrim.nexusmods.com/downloads/file.php?id=7059
Also, check out his other 'Sexy' cities at the links on his page.
Sexy Solitude v1
Sexy Villages and Towns
If you like the mods, be sure to endorse him.