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('2465', '2773', '2813', '2814')) AND (IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) = '1') CHAINSAW GAS - CHAIN SAWS & REPLACEMENT PARTS - POWER SAWS AND POWER SAW BLADES - HAND & POWER TOOLS
  1. See Detail

CHAINSAW GAS


View as Grid List

6 Items

per page
Set Descending Direction
  1. 45.7 CC 2.8 HP CHAINSAW
    $97.99 /EA
    HUSQ965084001 445 18" F/ASSEMBLED Learn More
  2. 38CC CHAIN SAW
    $169.99 /EA
    967196401 PP3816AV 16" ASSEMBLED Learn More
  3. 18'' 40 CC CHAIN SAW PP260
    $185.99 /EA
    967185102 PP4218AVX ASSEMBLED Learn More
  4. 2050 PIONEER CHAINSAW 33 CC 14''
    $150.99 /EA
    967061601/2026 PL3314 33CC 14' C/SA Learn More
  5. 16'' 34 CC WOODSMAN CHAINSAW 2150
    $153.99 /EA
    967084701/301 PL3816 38CC 16" C/SAW Learn More
  6. REMINGTON GAS CHAIN SAW
    $180.99 /EA
    41AY427S983 REM 4216 GAS CHAINSAW Learn More
View as Grid List

6 Items

per page
Set Descending Direction