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', '2971', '2972')) AND (IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) = '1') TUBE FLARERS & BENDERS - PIPE BENDING & CUTTING HDW - HAND & POWER TOOLS
  1. See Detail

TUBE FLARERS & BENDERS


View as Grid List

9 Items

per page
Set Descending Direction
  1. WOLVERINE TOOLS6-IN-1 SWAGING TOOL
    $10.99 /BG
    PST053 6 IN 1 SWAGING TOOL Learn More
  2. STANDARD FLARING TOOL
    $26.49 /EA
    151 STANDARD FLARING TOOL Learn More
  3. FLARING TOOL SET
    $17.99 /EA
    PP24008/840-8 FLARING TOOL SET Learn More
  4. WOLVERINE TOOLSHEAVY DUTY FLARING TOOL
    $30.99 /EA
    PS2666/PST050 FLARING TOOL Learn More
  5. WOLVERINE TOOLSTUBE BENDING SPRING SET
    $11.99 /BG
    PST073 TUBE BENDING SET Learn More
  6. Tube Bending Spring
    $3.69 /EA
    PST075 3/8 TUBE BNDG SPRING Learn More
  7. COMPOUND TUBING BENDER
    $39.49 /EA
    153 COMPOUND TUBING BENDER Learn More
  8. WOLVERINE TOOLS DEBURRING TOOL
    $8.99 /EA
    PST090 DEBURRING TOOL Learn More
  9. Tube Bending Spring
    $4.89 /EA
    PST076 5/8TUBE BNDNG SPRING Learn More
View as Grid List

9 Items

per page
Set Descending Direction