SELECT `e`.*, IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) AS `is_active` FROM `catalog_category_entity` AS `e` INNER JOIN `catalog_category_entity_int` AS `at_is_active_default` ON (`at_is_active_default`.`entity_id` = `e`.`entity_id`) AND (`at_is_active_default`.`attribute_id` = '46') AND `at_is_active_default`.`store_id` = 0 LEFT JOIN `catalog_category_entity_int` AS `at_is_active` ON (`at_is_active`.`entity_id` = `e`.`entity_id`) AND (`at_is_active`.`attribute_id` = '46') AND (`at_is_active`.`store_id` = 95) WHERE (`e`.`entity_id` IN('2465', '2926', '2938', '2939')) AND (IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) = '1') TORCH KITS (WITH TANK) - BLOW TORCHES, FIREPOTS&FURNACES - SOLDERING/BURNING SUPPLIES/EQUIP - HAND & POWER TOOLS
  1. See Detail

TORCH KITS (WITH TANK)


View as Grid List

10 items

Page
per page
Set Descending Direction
  1. PENCIL BURNER TIP TORCH KIT
    $13.99 /EA
    MT200-3 2PC TORCH KIT PENCIL Learn More
  2. TRIGGER START 4000 CAST ALUMINUM PROPANE TORCH
    $43.99 /EA
    TS4000T TRIGGER PRO TORCH Learn More
  3. SELF LIGHTING TORCH KIT
    $41.99 /EA
    MT535CK SELFLIGHT TORCH KIT Learn More
  4. PLUMBERS TORCH KIT
    $35.99 /EA
    2880048 PK1001KC TORCH KIT Learn More
  5. TRIGGER START TORCH KIT
    $58.99 /EA
    2880092/TS4000 START KIT W/ Learn More
  6. 7-PIECE SOLID BRASS PROPANE TORCH KIT
    $33.95 /EA
    331660 UL125SM 7PC TORCH KIT Learn More
  7. CUTTING, WELDING AND BRAZING TORCH KIT
    $77.99 /EA
    2880538 OX2550KCSM GAS WELD T/KIT Learn More
  8. MAGTORCH PROPACK
    $65.99 /EA
    MT579 PRO PROPACK Learn More
  9. SELF LIGHTING SWIVEL REGULATED STAINLESS STEEL TIP MAPP TORCH KIT
    $44.99 /EA
    MT551CK TORCH SELFLIGHTING STNLS KT Learn More
View as Grid List

10 items

Page
per page
Set Descending Direction