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` = 122) WHERE (`e`.`entity_id` IN('1460', '1865', '1909')) AND (IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) = '1') GATES (NOT PORCH-BABY) - FENCING AND GATES - LAWN AND GARDEN
  1. See Detail

GATES (NOT PORCH-BABY)


View as Grid List

26 items

Page
per page
Set Descending Direction
  1. ECONOMY GATES
    $148.99 /EA
    6ER16 RED 6BAR ECON GATE 16' Learn More
  2. 6-RAIL 1 5/8'' GALVANIZED 12' HIGH-TUBE GATE
    $149.99 /EA
    6GG16/40113168 16'GLV TUBE GATE Learn More
  3. CANE BOLT
    $9.59 /EA
    152058 V836 1/2X12 CANE BLT Learn More
  4. GATE WHEEL
    $22.99 /EA
    GW-1 GATE WHEEL Learn More
  5. SURE-LATCH2-WAY LIVESTOCK GATE LATCH
    $27.99 /EA
    GL22P HD GATE LATCH 2 WAY Learn More
  6. 6GG6 TUBE GATE 6' 6 BAR GALVANIZED 1-3/4'' OD 18 GAUGE
    $112.99 /EA
    6GG6 TUBE GATE 6' 6 BAR GALVANIZED Learn More
  7. 2RG10 RED TUBE GATE 6 BAR 10 FT 2'' 14 GA
    $217.99 /EA
    2RG10 RED TUBE GATE 6 BAR 10 FT 2" Learn More
  8. WG4 WIRE FILLED GATE GALVANIZED 4' x 50''
    $105.99 /EA
    WG4 WIRE FILLED GATE GALVANIZED Learn More
  9. WG6 WIRE FILLED GATE GALVANIZED 6' x 50''
    $118.99 /EA
    WG6 WIRE FILLED GATE GALVANIZED Learn More
View as Grid List

26 items

Page
per page
Set Descending Direction