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('1460', '1613', '1615', '1616')) AND (IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) = '1') HANDLES MAUL SLEDGE - REPL. HANDLES,STRIKING TOOLS - REPLACEMENT HANDLES - LAWN AND GARDEN
  1. See Detail

HANDLES MAUL SLEDGE


View as Grid List

9 Items

per page
Set Descending Direction
  1. 36'' AXE EYE
    $20.49 /EA
    64777/206-19 36" AXE EYE Learn More
  2. SLEDGE & OVAL EYE WOOD CHOPPER MAUL HANDLE
    $22.49 /EA
    64409/001-04 36" SLEDGE HAMMER HDLE Learn More
  3. SLEDGE & OVAL EYE WOODCHOPPER MAUL HANDLES
    $28.99 /EA
    64430/001-99 FBRGLS SLG OVAL EYE Learn More
  4. SLEDGE OR MAUL HANDLE
    $20.99 /EA
    64441/009-19 36" SLEDGE OR MAUL HND Learn More
  5. WOODCHOPPER MAUL HANDLES
    $31.99 /EA
    64768/205-19 36"#5 EYE MAUL HNDLE D Learn More
  6. HANDLE FOR HEAVY SLEDGE HAMMER
    $19.99 /EA
    64652/010-19 20# 36" SLEDGE HANDLE Learn More
  7. SLEDGE & OVAL EYE WOODCHOPPER MAUL HANDLES
    $17.99 /EA
    64552/003-19 30" SLEDGE MNNR HANDLE Learn More
  8. SLEDGE & OVAL EYE WOODCHOPPER MAUL HANDLES
    $19.49 /EA
    64417/001-09 36" SLEDGE HANDLE Learn More
  9. POST MAUL HANDLE
    $31.99 /EA
    65141/229-19 36" POST MAUL HNDL Learn More
View as Grid List

9 Items

per page
Set Descending Direction