Home   >  Aquariums / Bowls  >   Aquarium Kits and Breeders  

Tetra Glofish Aquarium Kit - 1.5 gallon

View 1 or more review(s)    Submit a Review


Features blue led s that enhance the glofish colors. Includes a seamless 1.5 gallon aquarium, black aquarium background, light with 9 blue led s, clear cover. . . Also includes black base with drawer, tetra 3i internal filter, air pump, air line tubing an

Model No: 29236 - In Stock

Discounts Available!

GLOFISH

---

Tetra Glofish Aquarium Kit - 1.5 gallon

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='48305' AND product_attribute_sku.product_id='48305' 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)