Bollard Rubber Base Attachment and Replacement Chain Kit

SELECT `e`.*, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(price_index.tier_price IS NOT NULL, LEAST(price_index.min_price, price_index.tier_price), price_index.min_price) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price`, IFNULL(review_summary.reviews_count, 0) AS `reviews_count`, IFNULL(review_summary.rating_summary, 0) AS `rating_summary`, `stock_status_index`.`stock_status` AS `is_salable` FROM `catalog_product_entity` AS `e` INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '1' AND price_index.customer_group_id = 0 LEFT JOIN `review_entity_summary` AS `review_summary` ON e.entity_id = review_summary.entity_pk_value AND review_summary.store_id = 1 AND review_summary.entity_type = (SELECT `review_entity`.`entity_id` FROM `review_entity` WHERE (entity_code = 'product')) LEFT JOIN `cataloginventory_stock_status` AS `stock_status_index` ON e.entity_id = stock_status_index.product_id AND stock_status_index.website_id = 0 AND stock_status_index.stock_id = 1 WHERE (e.entity_id IN (8793, 8794, 8795, 8790, 8792)) ORDER BY FIELD(e.entity_id,8793,8794,8795,8790,8792)

5 Items

Set Descending Direction
View as Grid List

5 Items

Set Descending Direction
View as Grid List

Bollard Rubber Base Attachment and Replacement Chain Kit

Bollard post covers and sleeves are available with several optional accessories that expand their utility. Rubber bases can be attached to bollard covers to allow them to function as free-standing bollards in parking lots and warehouses. Free-standing HDPE bollards are easy to transport and are ideal visual indicators or temporary barriers. The chain attachment for decorative bollard covers can replace barrier chains that have been lost or damaged.

Terms and Conditions Privacy Policy Terms of Use © 2021 Eagle Manufacturing All Rights Reserved