http://www.flickr.com/photos/53782220@N00/187597543/
Sea Pyramids.

this is a composite landscape image by an unnamed photographer who's username on flickr is mattijn
it is a landscape image created from many different ones that were textured to create a much more realistic look. this work was done in photoshop.

it has a very distinct textured look with very real colours that draw you into thinking it is an actual scene.
i think this image is amazing and very well done. i would love to try something like this.