Vita-Chamber from Bioshock (little bit of a spinoff). Texturing has always been my weakness, so I took some professional advice and confronted it (and boy did I learn a lot).
Programs: Blender (modeling, compositing, texturing, rendering), Photoshop (creating/reassembling/editing textures and signing my name).
Time: Unknown, large number of hours somewhere in the double digits over the last 6 days (or something like that).
Vita-Chamber design idea belong to 2k games as do the radiator, trashcan, little post thing, light fixture, wall column and the fist in the "Welcome to Rapture" poster (but were nonetheless modeled by me)
Almost every texture is from CG Textures.com
The others include:
Textured Circles by craftsquid.com
Corner Grunge Photoshop Brushes by inspiiired
Rapture font: Andes by an unspecified artist: [link]