A friend of mine emailed me, because they saw an episode of ugly houses where they re-did the room using a wall mounted aquarium. They want to buy one, and have asked me if there were any catches or surprises with this and they sent me a link:
http://www.wallaquariums.com/
I poked around their site, and it actually looked somewhat credible (considering the product), but I was wondering if anyone had first hand experience with it?
So far I've told them that it will only hold very few tiny fish, as I think it's only 3' wide (extrapolating the dimensions and volume) and has a very small surface area (3'x48'

. I have some concerns about access (reaching the bottom, cleaning the algae, servicing the filter, what kind of filter etc), so that I would investigate it a bit more for them.
I think it's a very bad idea, but I'm trying to keep an open mind while collecting the information for them.