For the past 9 months, I have been obsessively researching aquaponics and tinkering with various demonstration systems. After several notable failures, including sluggishly slow plant growth, the death of many goldfish, and an epic pond tsunami, I am happy to say that I finally have a system up and running in my bedroom. The plumbing works great, the fish are happy, and I just seeded some greens for the winter! You can check out some more photos of my setup here.
(Also, for those of you who have never even heard of aquaponics, here is a diagram that should give you a good overview.)