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', '1646', '1653', '1654')) AND (IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) = '1') SPRAYER REPAIR PARTS HOSES CONTROLS AND NOZZLES - HAND SPRAYERS/DUSTERS/INSECTICIDES - LAWN ROLLERS, SPREADERS,GARDEN S - LAWN AND GARDEN
  1. See Detail

SPRAYER REPAIR PARTS HOSES CONTROLS AND NOZZLES


View as Grid List

34 items

Page
per page
Set Descending Direction
  1. SHUT OFF
    $12.99 /EA
    6-2000 SHUT-OFF Learn More
  2. SPRAYER SHUT OFF VALVE
    $17.99 /EA
    4800170P SHUT-OFF VALVE Learn More
  3. NOZZLE POLY ADJUSTABLE CONE
    $6.99 /EA
    6-6003 POLY NOZZLE ASSEMBLY Learn More
  4. POLY SHUT-OFF ASSEMBLY
    $14.99 /EA
    6-4626 SHUT-OFF ASSEMBLY Learn More
  5. NOZZLE BODY CAP BLANK
    $3.99 /PK
    8028P4PK PLY SPRAY TIP Learn More
  6. NOZZLE BODY CAP
    $3.79 /PK
    8027WP4PK NOZZLE BODY CAP Learn More
  7. QUICK DISCONNECT CROSS FITTING MANIFOLD
    $5.39 /EA
    600211 QD CROSS FITTINGS- Learn More
  8. 25 FT REPLACEMENT HOSE
    $43.49 /EA
    RHK25FT 25FT RPLCMNT HOSE Learn More
  9. GARDEN HOSE VALVE Y WITH SHUT OFF VALVE
    $12.99 /EA
    G3434YV GARDEN HOSE "Y"VLV/ Learn More
View as Grid List

34 items

Page
per page
Set Descending Direction