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` = 100) 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
    $36.25 /EA
    56-204 FBRGLS ENGINEER HAMMER 4LBS. Learn More
  2. SLEDGE HAMMER
    $58.85 /EA
    41561 SH-16 SLEDGE HMR 16# Learn More
  3. SLEDGE HAMMER
    $41.35 /EA
    41558 SH-10 SLEDGE HMR 10# Learn More
  4. SLEDGE HAMMER
    $42.29 /EA
    41520 SH8FG SLEDGE HMR 8# Learn More
  5. SLEDGE HAMMER
    $29.09 /EA
    41556 SH-6 SLEDGE HAMMER8# Learn More
  6. ENGINEER HAMMER
    $24.29 /EA
    PR40/30576 4# ENGINR HAMMER Learn More
  7. DOUBLE FACE DRILL HAMMER
    $21.69 /EA
    PR3 3# DBL FACE DRILL HAM Learn More
  8. DRILLING HAMMER
    $14.45 /EA
    1196100 2LB DRILLING HAMMER 10.5"HN Learn More
  9. DOUBLE FACE SLEDGE HAMMER WITH 16" HICKORY HANDLE
    $15.79 /EA
    1196900 4LB SLEDGE HAMMER 16" Learn More
View as Grid List

18 items

Page
per page
Set Descending Direction