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', '1511', '1513', '1522')) AND (IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) = '1') LAWN MOWER FUEL SYSTEM PARTS - TRACTOR & MOWER REPL. PARTS - LAWN & GARDEN TRACTORS - LAWN AND GARDEN
  1. See Detail

LAWN MOWER FUEL SYSTEM PARTS


View as Grid List

17 items

Page
per page
Set Descending Direction
  1. BRIGGS & STRATTON FUEL FILTER
    $3.99 /EA
    334286 B&S 1/4 FUEL FILTER Learn More
  2. TYGON STYLKE FUEL LINE
    $4.89 /EA
    334181 .08" FUEL LINE 2' SEC TYGON Learn More
  3. TYGON STYLKE FUEL LINE
    $4.89 /EA
    334180 3/32" FUEL LINE 2' SEC TYGON Learn More
  4. DELUXE FUEL LINE FILTER
    $5.39 /EA
    334284 DELUXE FUEL LN FILTER Learn More
  5. PRIMER BULB
    $3.99 /EA
    339129 PRMR BLB 2C ENG WALBRO188-13 Learn More
  6. PRIMER BULB
    $3.99 /EA
    339128 PRMR BLB 2C ENG WALBRO188-12 Learn More
  7. PRIMER BULB
    $3.99 /EA
    339127 PRIMER BULB 2CYC ENG ZAMA Learn More
  8. PRIMER BULB
    $3.99 /EA
    339131 PRMR BLB B&S 5-6HP Learn More
  9. PRIMER BULB
    $3.99 /EA
    339130 PRMR BLB B&S 3.5-4HP Learn More
View as Grid List

17 items

Page
per page
Set Descending Direction