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

HOSE HANGERS


View as Grid List

11 items

Page
per page
Set Descending Direction
  1. Poly Hose Hanger Call for Price
    2382561 HOSE HANGER POLY Learn More
  2. NEVER LEAK WALL MOUNT HOSE REEL Call for Price
    2415600 225' NV LEAK WALL MOUNT Learn More
  3. STEEL HOSE HANGER Call for Price
    8115 STEEL HOSE HANGER Learn More
  4. Poly Hose Hanger Call for Price
    2384010 HOSE HANGER POLY TAN Learn More
  5. HOSE HANGER STANDING Call for Price
    HC-2 HOSE HANGER STANDING Learn More
  6. DELUXE HOSE HANGER Call for Price
    2384110 150 DLX HOSE HANGER Learn More
  7. HOSE HANGER WALL MOUNT Call for Price
    HCWM-1 HOSE HANGER WALL MOUNT Learn More
  8. Saddle Hose Hanger Call for Price
    2383520 HOSE HANGER BLK SADDLE Learn More
  9. HOSE HANGER Call for Price
    HS100 IN GROUND HOSE HANGER Learn More
View as Grid List

11 items

Page
per page
Set Descending Direction