Attached Link: http://www.renderosity.com/gallery.ez?ByArtist=Y&Artist=geoegress

first - learn lighting- then Hi-res photo realistic textures( sorry, most painted ones don't give ya the effect you want) there are many in the market place.