Home   >  Aquariums / Bowls  >   Fish and Goldfish Bowls  

Tetra Waterfall Globe Aquarium 1.8 gal.

View 1 or more review(s)    Submit a Review


Crystal clear glass aquarium with unique waterfall feature. Tetra pump driven filter with cartridge. Bright white led lights. Stylish black base with light arm. Single power cord operates both the light and the filter.

Model No: 29008 - In Stock

Discounts Available!

GLOFISH

---

Tetra Waterfall Globe Aquarium 1.8 gal.

Enter the quantity below and click "add to cart":

Database error: Invalid SQL: SELECT product_thumb_image,Bradprice,product_height,product_attribute.attribute_name,product_attribute.attribute_value,product_lwh_uom,product_attribute.product_id,product_attribute_sku.attribute_name,madeinusa,shippingsurcharge,bcispecial,product_weight,product_full_image,product.product_id,product_name,product_in_stock,loneinstock,loneprice,Color,Size,Ingredients,Infos from product,product_price,product_attribute_sku,product_attribute WHERE product_attribute.product_id=product.product_id AND product_attribute.attribute_name=product_attribute_sku.attribute_name AND product_parent_id='44886' AND product_attribute_sku.product_id='44886' AND product.product_id=product_price.product_id ORDER BY FIELD(lcase(substr(attribute_value,1,3)),'min','xxs','xsm','x-s','sma','med','int','lar','lrg','xla','xl ','xxl','xxx'), product_attribute.attribute_value asc
MySQL Error: 1030 (Got error 28 from storage engine)