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', '2470', '2471', '2475')) AND (IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) = '1') HAMMERS RIP FRAMING 21 OZ 22OZ 24OZ 28OZ AND LARGER - NAIL HAMMERS - HAMMERS AND MALLETS - HAND & POWER TOOLS
  1. See Detail

HAMMERS RIP FRAMING 21 OZ 22OZ 24OZ 28OZ AND LARGER


View as Grid List

16 items

Page
per page
Set Descending Direction
  1. PLUMB¨ ANTI-VIBE HAMMER
    $31.59 /EA
    SS22RN 22OZ HAMMER ANTI-VIBE Learn More
  2. FRAMING HAMMER
    $41.89 /EA
    E3-22SR SMTHFC FRAMING 22OZ HAMMER Learn More
  3. SMOOTH FACE HAMMER
    $39.89 /EA
    E322S 22OZ 16" SMTFACE HAMMER Learn More
  4. CLAW HOMEOWNER HAMMER
    $18.49 /EA
    72278 STRT HMR W/HICK 24OZ Learn More
  5. SOLID STEEL RIP CLAW CHECKERED FACE HAMMER
    $31.59 /EA
    SS22RCFN PLUMB 22OZ STEEL HAMMER CK Learn More
  6. FRAMING HAMMERS
    $42.59 /EA
    E3-24S SMOOTH FACE HAMMER 24 OZ Learn More
  7. FRAMING HAMMERS
    $44.39 /EA
    E3-24SM MILLED FACE HAMMER 24 OZ Learn More
  8. FRAMING HAMMERS
    $40.99 /EA
    E3-28SM ESTWING 28OZ HAMME N-V GRIP Learn More
  9. FRAMING HAMMERS
    $40.69 /EA
    E3-22SM ESTWING 22OZ 16" N-V GRIP Learn More
View as Grid List

16 items

Page
per page
Set Descending Direction