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', '1702', '1720', '1727')) AND (IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) = '1') INSECTICIDES CONCENTRATE PESTICIDES - INSECTICIDES/REPELLENTS/FUNGICIDE - FERTILIZERS, SOIL CONDITIONERS - LAWN AND GARDEN
  1. See Detail

INSECTICIDES CONCENTRATE PESTICIDES


View as Grid List

37 items

Page
per page
Set Descending Direction
  1. MALATHION 50
    $12.99 /EA
    992 MALATHION PT Learn More
  2. SPECTRACIDE MALATHION INSECT SPRAY CONCENTRATE
    $12.99 /EA
    HG-60900 SPECTRACIDE MALATHION INS Learn More
  3. PYRETHRIN GARDEN SPRAY CONCENTRATE
    $21.49 /EA
    858 PYRETHRIN GARDEN SPR CONC PT Learn More
  4. THURICIDE (BT) CONCENTRATE
    $15.99 /EA
    803 THURICIDE(BT) CONC PT Learn More
  5. WORRY FREE INSECT CONCENTRATE
    $21.85 /EA
    100508954 WF INSECT CONC QT Learn More
  6. NEEM OIL
    $19.99 /EA
    024 NEEM OIL PINT Learn More
  7. FRUIT TREE CONCENTRATE
    $21.99 /EA
    203 FRUIT TREE CONC. QT Learn More
  8. FRUIT TREE SPRAY
    $57.99 /EA
    205 FRUIT TREE SPRAY GAL. Learn More
  9. TRIAZICIDE ONCE & DONE
    $14.99 /EA
    HG-96400/HG-95829 TRIAZI ONCE&DON Learn More
View as Grid List

37 items

Page
per page
Set Descending Direction