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

STAKES, PROPS, & TRELLIS


View as Grid List

18 items

Page
per page
Set Descending Direction
  1. WOOD STAKES
    $0.89 /EA
    250348 WOOD STAKE 1X2X18 Learn More
  2. HEAVY DUTY SUPPORT
    $7.39 /EA
    704009 42"HD SUPPORT Learn More
  3. TOMATO CAGES
    $4.49 /EA
    708073/TC54 54-4-4 TOMATO CAGE Learn More
  4. WOOD STAKES
    $2.39 /EA
    250706 2X2X36 WOOD STAKE Learn More
  5. WOOD STAKES
    $1.69 /EA
    250362 WOOD STAKE 1X2X48 25/PK Learn More
  6. WOOD STAKES
    $1.39 /EA
    250355 WOOD STAKE 1X2X36 25/PK Learn More
  7. Round Concrete Stake
    $10.49 /EA
    STKR36 36"RND CONCRT STAKE Learn More
  8. Round Concrete Stake
    $8.79 /EA
    STKR30 30"RND CONCRT STAKE Learn More
  9. Round Concrete Stake
    $5.79 /EA
    STKR18 18"X3/4 RND CON STK Learn More
View as Grid List

18 items

Page
per page
Set Descending Direction