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` = 93) WHERE (`e`.`entity_id` IN('2465', '3131', '3132', '3133')) AND (IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) = '1') HAMMER TACKERS AND STAPLER - STAPLERS, STAPLE GUNS & STAPLES - CRAFTMAN AIDS - HAND & POWER TOOLS
  1. See Detail

HAMMER TACKERS AND STAPLER


View as Grid List

12 items

Page
per page
Set Descending Direction
  1. HEAVY DUTY HAMMER TACKER
    $37.69 /EA
    HT-50 HAMMER TACKER HEAVY DUTY Learn More
  2. PRO HAMMER TACKER
    $47.09 /EA
    HT55 PRO HAMMER TACKER Learn More
  3. SLIMLINE HEAVY DUTY HAMMER STAPLER
    $0.09 /EA
    HT55BL SLIMLINE HVYDTY HAMMER STPLR Learn More
  4. HAMMER/STAPLER
    $39.99 /EA
    H30-8D6 HAMMER/STAPLER W/HOLSTER Learn More
  5. MAX IMPACT HAMMER TACKER
    $32.19 /EA
    5800 MAX IMPACT HAMMER TACKER Learn More
  6. SHARPSHOOTER HEAVY DUTY HAMMER TACKER
    $31.49 /EA
    PHT150C HAMMER TACKER Learn More
  7. HAMMER TACKER
    $0.09 /EA
    HTX50 HAMMER TACKER Learn More
  8. HAMMER TACKER
    $30.69 /EA
    GRR11 GR A-11 HAMMER TACKER Learn More
  9. POWERSLAM POWERCROWN HAMMER TACKER
    $64.69 /EA
    PC2K POWERSLAM HAMMR TACKER Learn More
View as Grid List

12 items

Page
per page
Set Descending Direction