The biggest I have seen at a LFS was for sale. It was 256 gallons all-glass aquarium.
The biggest tank ever was a coral/sw tank at the Columbus Zoo & Aquarium. It was at least 200 feet long, 40 feet high, and 60 feet wide. Massive, it even has bleachers along it to watch it for hours. It had a giant sea turtle in it, thousands of fish. Some like a square yard in area.
They also had an open air Manatee tank with many florida native fishes.
The biggest tank ever was a coral/sw tank at the Columbus Zoo & Aquarium. It was at least 200 feet long, 40 feet high, and 60 feet wide. Massive, it even has bleachers along it to watch it for hours. It had a giant sea turtle in it, thousands of fish. Some like a square yard in area.
They also had an open air Manatee tank with many florida native fishes.