It kind of freaks me out but I want one.
I don’t even really like to eat fish…

metaljamie:

Local River is a rather amazing idea for keeping plants and fish in your home by designer Mathieu Lahanneur.

Local River proposes a home storage unit for live freshwater fish combined with a mini vegetable patch. The plants extract nutrients from the nitrate-rich dejecta of the fish. In doing so they act as a natural filter that purifies the water and maintains a vital balance for the eco-system in which the fish live. 
Local River responds to everyday needs for fresh food that is 100% traceable. It bets on a return to favour of farm-raised freshwater fish  (trout, eel, perch, carp, etc…), given the dwindling supplies of many saltwater species due to over-fishing. 
Local River aims to replace the decorative ‘TV aquarium’ by an equally decorative but also functional ‘refrigerator-aquarium’. In this scenario, fish and greens cohabit for a short time in a home storage unit before being eaten by their keepers, the end-players in an exchange cycle within a controlled ecosystem [source].

You’ll want to click on through to this guy’s website to learn about all his other magical designs.