Boxes & Strips

Shop By
SELECT `e`.*, `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`, IFNULL(review_summary.reviews_count, 0) AS `reviews_count`, IFNULL(review_summary.rating_summary, 0) AS `rating_summary`, `stock_status_index`.`is_salable` FROM `catalog_product_entity` AS `e` INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.customer_group_id = 0 AND price_index.website_id = '1' LEFT JOIN `mst_sorting_index` AS `mst_sorting_index_1` ON mst_sorting_index_1.product_id = e.entity_id AND mst_sorting_index_1.store_id = 1 LEFT JOIN `mst_sorting_index` AS `mst_sorting_index_0` ON mst_sorting_index_0.product_id = e.entity_id AND mst_sorting_index_0.store_id = 0 LEFT JOIN `review_entity_summary` AS `review_summary` ON e.entity_id = review_summary.entity_pk_value AND review_summary.store_id = 1 AND review_summary.entity_type = (SELECT `review_entity`.`entity_id` FROM `review_entity` WHERE (entity_code = 'product')) INNER JOIN `catalog_product_entity` AS `product` ON product.entity_id = e.entity_id LEFT JOIN `inventory_stock_2` AS `stock_status_index` ON product.sku = stock_status_index.sku WHERE (e.entity_id IN (685, 688, 694, 704, 706, 708, 711, 1454, 1459, 1463, 1465, 1477, 1484, 1485, 1486, 10005, 10008, 10015, 197035, 197036, 152400, 162570, 162655, 162658, 162659, 177809, 17552, 20332, 85748, 91462)) ORDER BY IFNULL(mst_sorting_index_1.factor_2_score, IFNULL(mst_sorting_index_0.factor_2_score, 0)) * 50 desc, FIELD(e.entity_id,685,688,694,704,706,708,711,1454,1459,1463,1465,1477,1484,1485,1486,10005,10008,10015,197035,197036,152400,162570,162655,162658,162659,177809,17552,20332,85748,91462)
View as Grid List

Items 1-30 of 36

Page
per page
Set Ascending Direction
  1. Chimera Lantern With Skirt (20")
    USD $241.00
    Out of stock
    SKU: CHI-00061
    Model: 1880
    Condition: New-In-Box
  2. Strobe Speed Light for Elinchrom (All Models)
    Chimera Strobe Speed Light for Elinchrom (All Models)
    USD $66.00
    Out of stock
    SKU: CHI-00089
    Model: 2170
    Condition: New-In-Box
  3. SKU: CHI-00115
    Model: 2345AL
    Condition: New-In-Box
  4. Lightbank Pole – Stainless Steel – (13" / 330mm)
    SKU: CHI-00150
    Model: 4000
    Condition: New-In-Box
  5. Lightbank Pole – Stainless Steel (24.5" / 622mm)
    SKU: CHI-00157
    Model: 4025
    Condition: New-In-Box
  6. Lightbank Pole – Stainless Steel (36" / 914mm)
    SKU: CHI-00161
    Model: 4035
    Condition: New-In-Box
  7. Chimera Window Series 1 (Cuculoris Breakup) (22 x 22)
    USD $37.00
    Out of stock
    SKU: CHI-00173
    Model: 5360
    Condition: New-In-Box
  8. Super Pro Plus Strip Softbox (Silver) (Small)
    Chimera Super Pro Plus Strip Softbox (Silver) (Small)
    USD $206.00
    Out of stock
    SKU: CHI-00009
    Model: 1055
    Condition: New-In-Box
  9. Chimera Pro II Lightbank (Small)
    USD $136.00
    Out of stock
    SKU: CHI-00041
    Model: 1520
    Condition: New-In-Box
  10. Chimera Mini Lightbank (Silver)
    USD $79.00
    Out of stock
    SKU: CHI-00053
    Model: 1710
    Condition: New-In-Box
  11. Lantern With Skirt (30")
    Chimera Lantern With Skirt (30")
    USD $329.00
    Out of stock
    SKU: CHI-00063
    Model: 1885
    Condition: New-In-Box
  12. SKU: CHI-00123
    Model: 2520AL
    Condition: New-In-Box
  13. Lightbank Pole – Stainless Steel (25" / 635mm)
    SKU: CHI-00155
    Model: 4020
    Condition: New-In-Box
  14. Pole – Stainless Steel (36.5″ / 927mm)
    Chimera Pole – Stainless Steel (36.5″ / 927mm)
    USD $15.00
    SKU: CHI-00165
    Model: 4050
    Condition: New-In-Box
  15. Chimera Video Pro Plus One Softbox (Small)
    USD $366.00
    Out of stock
    SKU: CHI-00167
    Model: 8125
    Condition: New-In-Box
  16. Chimera Super Pro Plus - White (Medium 36" x 48")
    USD $338.00
    Out of stock
    SKU: CHI-00022
    Model: 1135
    Condition: New-In-Box
  17. Super Pro Plus Strip Softbox - White (Medium 14" x 56")
    SKU: CHI-00028
    Model: 1165
    Condition: New-In-Box
  18. Chimera White Lightning Ultra Speed Ring
    USD $87.00
    Out of stock
    SKU: CHI-00124
    Model: 2520QR
    Condition: New-In-Box
  19. Super Pro X Plus Stripbank (9" x 36") (White Interior)
    SKU: CHI-01150
    Model: 1150
    Condition: New-In-Box
  20. Octaplus Speed Ring (Broncolor Pulso, Unilite, Siros, Mobiled, Litos)
    SKU: CHI-02090
    Model: 2090OP
    Condition: New-In-Box
  21. 6 3/8" x 0.12" Replacement Pole for 1x1 LED Lite Panel
    SKU: CHI-04016
    Model: 4016
    Condition: New-In-Box
  22. Octaplus Speed Ring (Profoto/HMI)
    Chimera Octaplus Speed Ring (Profoto/HMI)
    USD $168.92
    Out of stock
    SKU: CHI-00106
    Model: 2330OP
    Condition: New-In-Box
  23. Super Pro X (White, Medium)
    Chimera Super Pro X (White, Medium)
    USD $338.00
    Out of stock
    SKU: CHI-00021
    Model: 1130
    Condition: New-In-Box
  24. Video Pro Ring for Zylight
    Chimera Video Pro Ring for Zylight
    USD $189.00
    Out of stock
    SKU: CHI-09213
    Model: 9213
    Condition: New-In-Box
  25. Video Pro XS LH Lightbanks for Zylight F8
    Chimera Video Pro XS LH Lightbanks for Zylight F8
    USD $255.00
    Out of stock
    SKU: CHI-8115LHZ
    Model: 8115LHZ
    Condition: New-In-Box
  26. Aluminum Pole (16.5" / 419mm)
    Chimera Aluminum Pole (16.5" / 419mm)
    USD $12.00
    Out of stock
    SKU: CHI-04065
    Model: 4065
    Condition: New-In-Box
  27. Chimera Lighttools Fabric Grid (Large) (50°)
    USD $430.00
    Out of stock
    SKU: CHI-03545
    Model: 3545
    Condition: New-In-Box
  28. SKU: CHI-00008
    Model: 1045
    Condition: New-In-Box
  29. Super Pro Plus Shallow Light Bank (Extra Small)
    Chimera Super Pro Plus Shallow Light Bank (Extra Small)
    USD $149.00
    Out of stock
    SKU: CHI-00029J
    Model: 1215
    Condition: New-In-Box
  30. Super Pro X Plus Lightbank (White, 16" x 22")
    Chimera Super Pro X Plus Lightbank (White, 16" x 22")
    USD $149.00
    Out of stock
    SKU: CHI-01110
    Model: 1110
    Condition: New-In-Box
View as Grid List

Items 1-30 of 36

Page
per page
Set Ascending Direction