Red Label®

Array ( [store_id] => 26 [option_id] => 684 [entity_id] => 16 [attribute_id] => 263 [is_active] => 1 [brand_label] => Red Label® [brand_url_key] => red-label [brand_description] =>

We're stocked up on Red Label® fireworks!

[brand_meta_description] => Shop online for Red Label® fireworks at Red Apple. We offer a 100% no duds guarantee and we ship right to your home! [brand_thumbnail] => [brand_cover] => wysiwyg/brands/red-label-brand.jpg [brand_meta_title] => Buy Red Label® Fireworks Online at Red Apple! [brand_meta_keyword] => Red Label fireworks [brand_is_featured] => 1 [url] => https://www.redapplefireworks.com/brand/red-label [thumbnail] => https://www.redapplefireworks.com/media/codazon_cache/brand/250x/codazon/brand/placeholder_thumbnail.jpg [attribute_code] => mgs_brand )

We're stocked up on Red Label® fireworks!

Default Category
SELECT `e`.*, `cat_index`.`position` AS `cat_index_position`, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(price_index.tier_price IS NOT NULL, LEAST(price_index.min_price, price_index.tier_price), price_index.min_price) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price`, `stock_status_index`.`stock_status` AS `is_salable` FROM `catalog_product_entity` AS `e` INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=26 AND cat_index.visibility IN(2, 4) AND cat_index.category_id='2' INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '1' AND price_index.customer_group_id = 0 LEFT JOIN `cataloginventory_stock_status` AS `stock_status_index` ON e.entity_id = stock_status_index.product_id AND stock_status_index.website_id = 0 AND stock_status_index.stock_id = 1 INNER JOIN `search_tmp_5b53d8318c6322_67561227` AS `search_result` ON e.entity_id = search_result.entity_id ORDER BY IF(stock_status_index.qty > 0, 0, 1), `qty` desc LIMIT 15
Qty 142.0000Cometa 38 Shot XL Aerial (case) | 4/1

Qty 118.0000Red Label 96 Shot Standard Aerial Finale Set (case) | 2/6

Qty 72.0000Red Label 60 Shot XL Aerial Finale Set (case) | 1/2

Qty 59.0000Dream Wave 12 Shot Large Aerials (case) | 6/1

Qty 0.0000Red Label Silver Tails 16 Shot Standard Aerial (each)

Qty 0.0000Night Blossom 16 Shot XL Aerials (unit)

Qty 0.0000Red Label 30 Shot XL Aerial (unit)

Qty 0.0000Cometa 38 Shot XL Aerial (unit)

Qty 0.0000Dark Star 30 Shot XL Aerial (unit)

Qty 0.0000Sin City Standard 34 Shot XL Aerial (unit)

Qty 0.0000Red Label Night Blossom 16 Shot XL Aerials (case) | 2/1

Qty 0.0000Red Label Chrysanthemums 16 Shot Standard Aerial (each)

Qty 0.0000Red Label 30 Shot XL Aerial (unit)

Qty 0.0000Red Label 96 Shot Standard Aerial Finale Set (unit)

Qty 0.0000Red Label Palms 16 Shot Standard Aerial (each)

24 items

Page
Set Ascending Direction
per page

24 items

Page
Set Ascending Direction
per page