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', '1865', '1909', '1912')) AND (IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) = '1') FARM GATE CANE BOLTS LATCHES AND WHEELS - GATES (NOT PORCH-BABY) - FENCING AND GATES - LAWN AND GARDEN
  1. See Detail

FARM GATE CANE BOLTS LATCHES AND WHEELS


View as Grid List

7 Items

per page
Set Descending Direction
  1. CANE BOLT
    $17.95 /EA
    348516 V810 .5X12" CANE BOLT ST ST Learn More
  2. CANE BOLT
    $8.99 /EA
    165902 836 CANE BOLT BLK Learn More
  3. CANE BOLT
    $12.45 /EA
    177196 V835 CANE BOLT 11/2 Learn More
  4. CANE BOLT ZINC PLATED
    $17.05 /EA
    35936 BOLT CANE 18"X5/8"ZP Learn More
  5. CANE BOLT
    $7.49 /EA
    152058 V836 1/2X12 CANE BLT Learn More
  6. GATE WHEEL
    $24.25 /EA
    GW-1 GATE WHEEL Learn More
  7. SURE-LATCH2-WAY LIVESTOCK GATE LATCH
    $29.35 /EA
    GL22P HD GATE LATCH 2 WAY Learn More
View as Grid List

7 Items

per page
Set Descending Direction