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', '3131', '3172', '3179')) AND (IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) = '1') HAMMER HOLDER HANGER - CRAFTSMAN POUCHES, HOLSTERS & APRONS - CRAFTMAN AIDS - HAND & POWER TOOLS
  1. See Detail

HAMMER HOLDER HANGER


View as Grid List

9 Items

per page
Set Descending Direction
  1. SWINGING HAMMER HOLDER
    $6.59 /EA
    739 HAMMER HOLDER Learn More
  2. SWINGING HAMMER HOLDER
    $8.69 /EA
    1340-4 SWINGING HAMMER HOLDER Learn More
  3. HEAVY DUTY HAMMER HOLDER
    $11.99 /EA
    DG5139 HD HAMMER HOLDER Learn More
  4. HAMMER HOLDER
    $13.99 /EA
    1320-1 HAMMER HOLDER & KNIFE SHEATH Learn More
  5. HAMMER SNAPPER¨HAMMER HOLDER
    $6.99 /EA
    839 SNAPPER HAMMER HOLDER Learn More
  6. DOUBLE LAYER HAMMER HOLDER
    $8.29 /EA
    1330-1 DELUXE HAMMER HOLDER Learn More
  7. HAMMER HOLDER WITH BELT SLOT
    $16.99 /EA
    1360-1 HAMMER HOLDER W/BELT SLOT Learn More
  8. STEEL LOOPHAMMER HOLDER
    $4.49 /EA
    439 HAMMER HOLDER Learn More
  9. HAMMER HOLDER WITH LARGE KNIFE POCKET
    $15.49 /EA
    1350-1 HAMMER HOLDER & KNIFE POCKET Learn More
View as Grid List

9 Items

per page
Set Descending Direction