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` = 100) WHERE (`e`.`entity_id` IN('1460', '1915', '1935', '1936')) AND (IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) = '1') LANDSCAPE FABRIC WEED BARRIER AND PINS MULCH LOCK - SAND & DIRT SCREENS - FLOWER BED ACCESSORIES - LAWN AND GARDEN
  1. See Detail

LANDSCAPE FABRIC WEED BARRIER AND PINS MULCH LOCK


View as Grid List

18 items

Page
per page
Set Descending Direction
  1. GARDEN MULCH
    $4.89 /EA
    NH350 3X50 MULCH FILM Learn More
  2. CAMOUFLAGE FABRIC
    $23.05 /EA
    3050 3X50 CAMO FABRIC Learn More
  3. 302235 LANDMASTER WEED FABRIC 3 FT x 100 FT 5 YEAR
    $13.35 /RL
    302235 LANDMASTER WEED FABRIC 3 FT Learn More
  4. 302234 LANDMASTER WEED FABRIC 3 FT x 50 FT 5 YEAR
    $7.09 /RL
    302234 LANDMASTER WEED FABRIC 3 FT Learn More
  5. WEED ENDER PREMIUM LANDSCAPE FABRIC
    $12.85 /EA
    304 3'X50' PREM LANDSCAPE FABRIC Learn More
  6. SOD STAPLES
    $58.29 /BX
    85726 SOD STAPLES 6"11GA(1000) Learn More
  7. MULCH LOCK CONCENTRATE
    $24.25 /EA
    HG-16001 MULCH LOCK CONC 64 Learn More
  8. MUCHLOCK
    $36.95 /EA
    HG-16000 MULCH LOCK RTU 1.5 Learn More
  9. WEED ENDER COMMERCIAL LANDSCAPE FABRIC
    $15.75 /EA
    404 3'X50' COMM. LANDSCAPE FABRIC Learn More
View as Grid List

18 items

Page
per page
Set Descending Direction