Check out the concept art for Gears of War, amongst other things.

http://www.johnwallin.net 

that guy is so good, a lot of the paintings look like they're in-game. Thanks for the inspiration Kinn; though that guy has no right to be that talented. 

that at least some of these are not CG. 

or maybe he renders something and then paints over it. 

Jago, CG = computer graphics, using photoshop/painter/etc = CG, so yes obviously those are CG as far as I'm concerned (I kind of doubt he did them with traditional means).
But if you mean 3D renders, yeah, he probably renders some stuff before doing a paint over (but I know it's possible to do that kind of stuff without it really). 

but I know it's possible to do that kind of stuff without it really).

My best friend gave me a Blade Runner city scene print before going back to college, my first thought, 'we would assumed this to be CGI instead of hand painted matte if we did not know its origins.' 

http://forums.sijun.com/viewtopic.php?t=39434&start=30

He's really good, young, self thaught and a nice guy! (I worked with him for a while about three years ago) 

including architecture
http://www.patentroom.com/ 

Map it
http://www.patentroom.com/architecture/images/yawningpig.gif 

http://textures.shedeki.net/she_textures(2).htm 

Thanks for the link. To my surprise, most of those textures are tilable so they can actually be used in a game. 

http://episteme.arstechnica.com/groupee/forums/a/tpc/f/34709834/m/943001045731/r/325001045731#325001045731

Some AWESOME pics from Huangshan, China. 

http://www.roadstothefuture.com/I664_VA_MMMBT_Aerial.html 

the huge bridge between sweden and denmark is like that too, there's an artificial island where it goes underground/water. One can see it from the airplane is one flies to/via copenhagen (SAS hub so it's likely if you travel in the north).

There are also small dam/bridge combinations in the north (seen them in sweden) where there is first a dam that overflows evenly from the whole width and then the water runs over a road that is a couple meters lower - it's only a few cm deep when the flow is normal so you can drive on the road over the river. But it feels strange since on the other side is a thin wall holding huge amounts of water, and if there was a flow increase, it would flow over the dam and your car would be washed away. Shame I didn't have a camera with me. 

http://ueba.com.br/forums/index.php?showtopic=18987
I guess it's India? 

My own translation of the important bits:

Kanyakumari: Located in the southernmost part of India, Kanyakumari is the point where three seas join: the bay of Bengal, the Arabian Sea, and the Indian Ocean. The legend behind the temple is as romantic as the place itself. Dedicated to the virgin goddess Kanyakumari (Parvati) who is proud to protect the country. The temple is built on the top where she was created and she waits for her consort to come and ask her hand in marriage.

After the tsunami???

I wish there were more shots close up. It looks like there might be some cool details. 

http://www.conceptart.org/forums/showthread.php?t=43791

constantly updated (even if uv been there, it`s worth another look)
many images 

Wow, awesome! Thank you for this link :) 

http://www.opacity.us/gallery87.htm
(boingbong) 

Wow, cool photos !! It would be great to make a partially submerged map using these photos...
I'm just dreaming about a ship cimeterry full of monsters.. ;P 

I'm just dreaming about a ship cimeterry full of monsters..

If you ever make such a level, I have the perfect name for it. Do you know what the Barbary Pirates called their deep sea hell? 

No... Let me know please .. 

Dom Daniel -- The first time I encountered the word was in a short story by Gene Wolfe several years ago. I looked it up with whatever search engines were available at the time, but I found little information (Gaimon also made reference to it in Sandman).
So I looked up Wolfe's e-mail address and asked about it, and got a nice little etymonic discription in return. I wished I still had that e-mail, it was quite interesting. 

Please if you still have this email, send it to lambert_jph - at - yahoo - dot - fr

I'm always interested by these "mythological" stories... it gives me some good inspirations for mapping ;) 

<3 boats