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

FLOWER BED ACCESSORIES


View as Grid List

76 items

Page
per page
Set Descending Direction
  1. WEED FABRIC Call for Price
    9104 5YR WEED FABRIC Learn More
  2. GARDEN PEGS Call for Price
    805 GARDEN PEGS 10 PK Learn More
  3. FABRIC PINS Call for Price
    703 FABRIC PINS 75 COUNT Learn More
  4. FABRIC PINS Call for Price
    701 FABRIC PINS 10 PER BAG Learn More
  5. GARDEN MULCH Call for Price
    NH350 3X50 MULCH FILM Learn More
  6. BLOEM SATURN PLANTER Call for Price
    SP1028 SATURN 10" GRE-FRESH Learn More
  7. SINGLE HOOK POT HANGER Call for Price
    SS48 FLEUR-DE-LIS S/HOOK Learn More
  8. WALL MOUNT FLOWER HANGER Call for Price
    SB14 WALL MOUNT FL HANGER Learn More
  9. LARGE DOUBLE SHEPHERDS STAFF Call for Price
    SS35 LARGE D/SHEPERD STAFF Learn More
View as Grid List

76 items

Page
per page
Set Descending Direction