I am in the process of building in the coolest fish tank. It's 240 gallons, 8' long, 2' x 2'. Both of the ends are poking out different walls (i only have one finished). The main body is in my living room. That side is not complete but will have cabinets all around. I got it custom made from http://www.walltanks.com and there is a helpful forum at http://www.bizarreaquariums.com. Check out my pics, any suggestions, I will post more as I finish more of it!
I just want to add some more pictures I took of plumbing etc. I have hot and cold going to a float but I also ran a cold pipe in that I use to start my siphon which goes to a drain under the tank.