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` = 122) WHERE (`e`.`entity_id` IN('2465', '2470', '2483', '2484')) AND (IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) = '1') SLEDGE ENGINEERS DRILLING HAMMERS SHORT HANDLE - HAMMERS-HEAVE SHORT HANDLE - HAMMERS AND MALLETS - HAND & POWER TOOLS
  1. See Detail

SLEDGE ENGINEERS DRILLING HAMMERS SHORT HANDLE


View as Grid List

18 items

Page
per page
Set Descending Direction
  1. FIBERGLASS ENGINEER HAMMER
    $34.49 /EA
    56-204 FBRGLS ENGINEER HAMMER 4LBS. Learn More
  2. 4-LB ENGINEER HAMMER, 16 INCH HANDLE
    $19.49 /EA
    1197000 4LB ENG FG HAMMER 16" Learn More
  3. DOUBLE FACE SLEDGE HAMMER WITH 16" HICKORY HANDLE
    $15.49 /EA
    1196300 3LB SLEDGE HAMMER 16" Learn More
  4. SLEDGE HAMMER
    $27.99 /EA
    41556 SH-6 SLEDGE HAMMER8# Learn More
  5. 11528 48oz. ENGINEER'S HAMMER
    $24.49 /EA
    11528 48oz. ENGINEER'S HAMMER Learn More
  6. ENGINEER HAMMER
    $22.49 /EA
    PR30 3# DOUBLE FACE HAMMER Learn More
  7. DOUBLE FACE DRILL HAMMER
    $23.49 /EA
    PR3 3# DBL FACE DRILL HAM Learn More
  8. SLEDGE HAMMER
    $55.99 /EA
    41561 SH-16 SLEDGE HMR 16# Learn More
  9. DOUBLE FACE DRILL HAMMER
    $26.99 /EA
    PR4 4# DBLE FACE DRILL HA Learn More
View as Grid List

18 items

Page
per page
Set Descending Direction