The Ultimate Aquarium

The Ultimate Aquarium Situated on the Peninsula between San Francisco and San Jose. Serving the San Francisco Bay Area since 1999
(24)

New Shipment of captive bred fish arrived today! Emperor Angels, Multi Bar Angels, Majestic Angels, Royal Grammas, Yello...
06/29/2023

New Shipment of captive bred fish arrived today! Emperor Angels, Multi Bar Angels, Majestic Angels, Royal Grammas, Yellow Tangs, and Mandarin Gobies!! Very limited supply! Come check ‘em out before they’re gone!!

Be prepared for the next power outage.  Come grab your battery powered air pump while supplies last!  Don’t let your wet...
01/04/2023

Be prepared for the next power outage. Come grab your battery powered air pump while supplies last! Don’t let your wet friends down!

New Shipment of Hanna Checkers!
11/12/2022

New Shipment of Hanna Checkers!

Pre Black Friday Sale!!  Vortech MP10 and MP40 Pumps 25% OFF!!  11/1-7.    While Supplies Last!!
11/02/2022

Pre Black Friday Sale!! Vortech MP10 and MP40 Pumps 25% OFF!! 11/1-7. While Supplies Last!!

We will be open today from 10-3!
07/04/2022

We will be open today from 10-3!

We are looking for a new team member!
06/04/2022

We are looking for a new team member!

We will be open today 4/17 from 10-4.
04/17/2022

We will be open today 4/17 from 10-4.

Just received some Bali Aquarich Captive Bred Yellow Belly Regal Angels, Bali Aquarich Captive Majestic Angels, Biota Ca...
02/23/2022

Just received some Bali Aquarich Captive Bred Yellow Belly Regal Angels, Bali Aquarich Captive Majestic Angels, Biota Captive Bred Mandarin Gobies and Aiptasia Eating Filefish!!! These are limited so get them before they are gone!!

Just received some Bali Aquarich Captive Bred Yellow Belly Regal Angels, Bali Aquarich Captive Majestic Angels, Biota Ca...
02/23/2022

Just received some Bali Aquarich Captive Bred Yellow Belly Regal Angels, Bali Aquarich Captive Majestic Angels, Biota Captive Bred Mandarin Gobies and Aiptasia Eating Filefish!!! These are limited so get them before they are gone!!

All Saltwater Live Stock 25% Off!  Hot Freshwater Fish on Sale!!  Kessil AP9X, Kessil 360X, Ecotech XR30, Simplicty Skim...
11/25/2021

All Saltwater Live Stock 25% Off! Hot Freshwater Fish on Sale!! Kessil AP9X, Kessil 360X, Ecotech XR30, Simplicty Skimmers and DC Pumps All on Sale!! Don’t Miss Out!! Black Friday Only!!

All Sales Final. We will not hold items even if paid for.

Black Friday Sale!!! All Saltwater Live Stock 25% Off!  Hot Freshwater Fish on Sale!! Kessil 360X, Kessil AP9X, Ecotech ...
11/25/2021

Black Friday Sale!!! All Saltwater Live Stock 25% Off! Hot Freshwater Fish on Sale!! Kessil 360X, Kessil AP9X, Ecotech XR30 on Sale Too!! Friday Only!! Don’t miss out!!

Lots of new saltwater fish arrived today: Red and Purple firefish, coral beauty, lemon peel Angel, ruby red scooters, fl...
06/22/2021

Lots of new saltwater fish arrived today: Red and Purple firefish, coral beauty, lemon peel Angel, ruby red scooters, flaming prawn goby, clown trigger, and more!!

We really received some great livestock this week!  Unbelievable captive bred short tail betta fish!  We also received a...
01/07/2021

We really received some great livestock this week! Unbelievable captive bred short tail betta fish! We also received a bunch of captive bred saltwater fish this week too which includes Coral Beauty Angels, Yellow Tangs, Manderin Gobies, and more!!

Exciting week of new live stock!!  On the saltwater side we received purple tangs, red and purple fire fish, tail spot b...
12/08/2020

Exciting week of new live stock!! On the saltwater side we received purple tangs, red and purple fire fish, tail spot blennies, red mini carpet anemones, and much much more! On the freshwater side we received some very rare red tiger severum, beautiful African Peacocks, South American Gars, and much much more!! A new shipment of Indonesian Coral arrives Friday night as well!! Stop on by!!!

We just received 20 Aquaculted Tahitian Clams!! Come by before they are all gone!!
11/16/2020

We just received 20 Aquaculted Tahitian Clams!! Come by before they are all gone!!

We will be closed on Wednesday October 28th to install a new carpet in our dry good area.  If we finish before 6pm that ...
10/17/2020

We will be closed on Wednesday October 28th to install a new carpet in our dry good area. If we finish before 6pm that day we will open for the remainder of the day until 6pm. Please call(650-212-3474) or Facebook message us for updates throughout the day. Thank you!

We are open today(Labor Day) from 10-5!
09/07/2020

We are open today(Labor Day) from 10-5!

Some of the newest products we just got in stock!!  The new Kessil AP9X Panel as well as the new Radion G5 Blue’s are in...
08/15/2020

Some of the newest products we just got in stock!! The new Kessil AP9X Panel as well as the new Radion G5 Blue’s are in stock!! Due back in Tuesday will be a limited number of the Ecotech S2 and M2 Vectra Pumps!!

Happy 4th!! We are open today 10-4!!
07/04/2020

Happy 4th!! We are open today 10-4!!

06/03/2020

Due to the protest of the murder of George Floyd tomorrow(Wednesday June 3rd) that is expected to proceed through San Mateo, we have decided to close at 4pm. Stay safe everyone!!

Come and “Bounce” on by and check out what we have in stock!!  Plenty of freshwater fish, plants, live coral and saltwat...
04/26/2020

Come and “Bounce” on by and check out what we have in stock!! Plenty of freshwater fish, plants, live coral and saltwater fish. We also have koi and other pond fish back in stock!!! Open daily from 10-5. We are also offering curbside pick up to those that don’t want to enter the store. Please note that we do require a mask or face covering to enter the store during this time. We hope to see you soon!!

Before all of these streaming options we all used to stare at our aquariums! Once you’redone watching your favorite show...
03/27/2020

Before all of these streaming options we all used to stare at our aquariums! Once you’re
done watching your favorite show, take a break and enjoy your tank for a change. We’re open everyday if you feel like tinkering with it like the old days. New plants and decorations, corals and fish are available! Come pick some out and take them home.

Curbside Assistance Now Available!   We are offering curbside assistance for our customers who do not want to get out of...
03/22/2020

Curbside Assistance Now Available! We are offering curbside assistance for our customers who do not want to get out of the car and enter the store. Call us at 650-212-3474 and tell us what you need. We will bring it out to your car! Everyday 10-5!!

We are still operating and here for any of your aquarium or pond needs.  Give us a call or drop by any day between 10-5....
03/21/2020

We are still operating and here for any of your aquarium or pond needs. Give us a call or drop by any day between 10-5. Entrance is temporarily in the rear of the building.

As we continue with the “Shelter in Place Order,” we will continue to operate during this time in a limited capacity. We...
03/18/2020

As we continue with the “Shelter in Place Order,” we will continue to operate during this time in a limited capacity. We will be open everyday from 10am to 5pm until further notice. We would like to thank everyone for their loyal patronage and wish you and families good health!!

We have found out that we are actually exempt from the “Bay Area Shelter” and are allowed to continue to operate, howeve...
03/17/2020

We have found out that we are actually exempt from the “Bay Area Shelter” and are allowed to continue to operate, however we will be taking it day by day for the time being. We will be limiting our operating hours and be open from 10am to 5pm on Tuesday March 17th. Please check back to our page or call the store (650-212-3474)as we move forward.

Hot new stock is in! 🔥 Salt lovers, we have harlequin shrimp, porcelain crabs, true red coco worms, a cream angel, Flagf...
02/23/2020

Hot new stock is in! 🔥 Salt lovers, we have harlequin shrimp, porcelain crabs, true red coco worms, a cream angel, Flagfin angel, freckled hawkfish, bimaculatus anthias, shrimp gobies, barnacle blennies and more ✨

Freshwater fellas, we have apistogramma cacatuoides, apistogramma cacatuoides "gold flash", apistogramma agassizii "golden fire red", panther crabs, koi angels, a queen arabesque pleco, and red sailfin Venezuelan cory cats ✨

We are open during construction! Entrance is in the back of the store behind the Ah Sam parking lot, through an open cha...
01/29/2020

We are open during construction! Entrance is in the back of the store behind the Ah Sam parking lot, through an open chain-linked gate. Signs will help navigate you 🐠✨

The clowns are in town! 🤡 Check out our lightning maroons, snowflake ocellaris, frostbite, black stubby clowns, and XL m...
01/24/2020

The clowns are in town! 🤡 Check out our lightning maroons, snowflake ocellaris, frostbite, black stubby clowns, and XL maroon, plus square back anthias and more ✨

Address

2625 S El Camino Real
San Mateo, CA
94403

Opening Hours

Monday 10am - 6pm
Tuesday 10am - 6pm
Wednesday 10am - 6pm
Thursday 10am - 6pm
Friday 10am - 6pm
Saturday 10am - 6pm
Sunday 10am - 5pm

Telephone

(650) 212-3474

Alerts

Be the first to know and let us send you an email when The Ultimate Aquarium posts news and promotions. Your email address will not be used for any other purpose, and you can unsubscribe at any time.

Videos

Share


Other San Mateo pet stores & pet services

Show All