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')) AND (IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) = '1') HOSE,HOSE ACCESSORIES/TUBING - LAWN AND GARDEN
  1. See Detail

HOSE,HOSE ACCESSORIES/TUBING


View as Grid List

530 items

Page
per page
Set Descending Direction
  1. IMPULSE SPRINKLER Call for Price
    PS2 IMPULSE SPRINKLER Learn More
  2. PRO TWIST NOZZLE Call for Price
    50500GP PRO TWIST NOZZLE Learn More
  3. REAR TRIGGER NOZZLE Call for Price
    440GP REAR TRIGGER NOZZLE Learn More
  4. POWER JET WAND Call for Price
    300GPJ POWER JET WAND Learn More
  5. PRO LARGE SPRINKLER Call for Price
    199LMSGP PRO LRG SPRINKLER Learn More
  6. 1 INCH HOSE WASHER WITH SCREEN Call for Price
    80070 5/8HOSE WSHR W/SCREEN Learn More
  7. GARDEN HOSE ELBOW Call for Price
    U2276LFA 1/4X3/4GRDN HOSE TRD Learn More
  8. HOSE CAP Call for Price
    PP850-68 3/4" HOSE CAP W/WASHER Learn More
  9. HOSE Y CONNECTOR Call for Price
    PP850-1 HOSE Y CONNECTOR Learn More
View as Grid List

530 items

Page
per page
Set Descending Direction