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', '1865', '1866', '1871')) AND (IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) = '1') FENCE BARBED WIRE - YARD & FARM FENCE & FENCE POSTS - FENCING AND GATES - LAWN AND GARDEN
  1. See Detail

FENCE BARBED WIRE


View as Grid List

7 Items

per page
Set Descending Direction
  1. GAUCHO CLASS III GALVANIZED BARBED WIRE Call for Price
    118293 GCH020 151/2GA BARB WIRE 4PT Learn More
  2. BARBED ELECTRIC FENCE WIRE Call for Price
    206165 18G 4PT BRB WRE 1,320'5" Learn More
  3. ZA HIGH STRENGTH BARBED WIRE Call for Price
    261131 GCHO30 BARB WIRE 15.5GA 4PT Learn More
  4. BARBED WIRE IN 80 ROD LENGTHS Call for Price
    145734 14GA 2/4/5 BARB WIRE Learn More
  5. BARB WIRE Call for Price
    118400 BARB WIRE 12.5GA CL1 1,320' Learn More
  6. HIGH TINSEL BARB WIRE Call for Price
    80941512 15-1/2GA HT BARB WIRE 4PT Learn More
  7. BARBLESS WIRE Call for Price
    7227 12-1/2GA BARBLESS WIRE Learn More
View as Grid List

7 Items

per page
Set Descending Direction