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

PIPE & TUBING CUTTERS & CUTTING


View as Grid List

83 items

Page
per page
Set Descending Direction
  1. TUBING CUTTERS
    $23.49 /EA
    534991 PLASTIC TUBE CUTTER Learn More
  2. PVC PIPE CUTTER
    $21.49 /EA
    151-051 PVC PIPE CUTTER Learn More
  3. THREAD CUTTING OIL
    $16.49 /EA
    016265 QT DK CUTTING OIL Learn More
  4. THREAD CUTTING OIL
    $37.99 /EA
    016325 GAL DARK CUTTING OIL Learn More
  5. WOLVERINE TOOLSREPLACEMENT TUBE CUTTER WHEEL
    $4.99 /EA
    PST025 CUTTER WHEEL Learn More
  6. PVC CABLE SAW
    $10.49 /EA
    093070 PVC CABLE SAW Learn More
  7. CUTTING OIL
    $4.69 /EA
    64113 TBE CUT OIL 1/3FL OZ Learn More
  8. PEX CRIMP REMOVAL TOOL
    $27.99 /EA
    23055 PEX CRIMP REMOVAL TOOL Learn More
  9. PEX CLAMP TOOL
    $42.99 /EA
    24611 PEX CLAMP TOOL FULL SIZE Learn More
View as Grid List

83 items

Page
per page
Set Descending Direction