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` = 90) WHERE (`e`.`entity_id` IN('1460', '1788', '1842', '1852')) AND (IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) = '1') SPRAY HEAD PULL UP TOOL NOZZLES - SPRINKLERS & SOAKERS - HOSE,HOSE ACCESSORIES/TUBING - LAWN AND GARDEN
  1. See Detail

SPRAY HEAD PULL UP TOOL NOZZLES


View as Grid List

17 items

Page
per page
Set Descending Direction
  1. SPRAY HEAD PULL UP TOOL Call for Price
    PTC1 SPRAY HEAD PULLUP TOOL Learn More
  2. MATCHED PRECIPITATION RATE SPRAY NOZZLES Call for Price
    15QC1 12'-15' SPRAY QTR CIRCLE Learn More
  3. SHRUB NOZZLE Call for Price
    A17F SHRUB NOZZL FULL CIRCLE Learn More
  4. DUAL SPRAY NOZZLE Call for Price
    12DSF 9'-#2 DUAL SPRAY NZZL FULL Learn More
  5. MATCHED PRECIPITATION RATE SPRAY NOZZLES Call for Price
    15FC1 12'-15' SPRAY FULL CIRCLE Learn More
  6. SHRUB NOZZLE Call for Price
    A17Q SHRUB NOZZL QTR CIRCLE Learn More
  7. NOZZLE END STRIP Call for Price
    15ESTC1 4'X30' NZZLE END STRIP PTRN Learn More
  8. DUAL SPRAY NOZZLE Call for Price
    12DSH 9'-#2' DUAL SPRAY NZZLE HALF Learn More
  9. ADJUSTABLE SPRAY NOZZLE Call for Price
    15AP 12'-15' SPRAY NOZZL ADJ Learn More
View as Grid List

17 items

Page
per page
Set Descending Direction