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', '1620')) AND (IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) = '1') HANDLES AXE - REPL. HANDLES,STRIKING TOOLS - REPLACEMENT HANDLES - LAWN AND GARDEN
  1. See Detail

HANDLES AXE


View as Grid List

16 items

Page
per page
Set Descending Direction
  1. SINGLE BIT HICKORY AXE HANDLES
    $19.99 /EA
    64707/100-09 36" BNT SNGL BT AXE HD Learn More
  2. DOUBLE BIT AXE HANDLES
    $25.99 /EA
    64743/140-09 36" DOUBLE BIT AXE HND Learn More
  3. SINGLE BIT CURVED AXE HANDLE
    $28.49 /EA
    64702/100-04 36" SNGL BIT CURVED AX Learn More
  4. AXE HANDLE DOUBLE BIT
    $24.99 /EA
    64740 140-08 AXE HND DBLBIT 36" Learn More
  5. SINGLE BIT HICKORY AXE HANDLES
    $17.49 /EA
    64914/116-08 28" BOYS AXE HANDLE Learn More
  6. BOY SCOUT AXE HANDLE
    $10.99 /EA
    65300/368-19 14" BOY SCOUT AXE HNDL Learn More
  7. AXE HANDLE
    $23.99 /EA
    64774 206-08 AX HND SB WOOD Learn More
  8. SINGLE BIT HICKORY AXE HANDLES
    $33.99 /EA
    64731/119-19 36" STRAIGHT AXE HANDL Learn More
  9. DOUBLE BIT AXE HANDLES
    $20.49 /EA
    64946/145-09 28" CRUISERS DB AXE HD Learn More
View as Grid List

16 items

Page
per page
Set Descending Direction