Yellow/Blue/Red/Black/Green, HDPE Fluted Bollard Covers

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 (8449, 8460, 8804, 9220, 8450, 8455, 8456, 8457, 8458, 8452, 8459, 8469, 8470, 8471, 8447, 8467, 8621, 8624, 8799, 8448, 8451, 8468, 8472, 8620)) ORDER BY FIELD(e.entity_id,8449,8460,8804,9220,8450,8455,8456,8457,8458,8452,8459,8469,8470,8471,8447,8467,8621,8624,8799,8448,8451,8468,8472,8620)

Items 1-24 of 26

Page
Set Descending Direction
View as Grid List

Items 1-24 of 26

Page
Set Descending Direction
View as Grid List

Yellow/Blue/Red/Black/Green, HDPE Fluted Bollard Covers

Fluted bollards from Eagle feature a high-density polyethylene construction and a resilient fluted designed that offers more flexibility upon impact than other bollard sleeves. Fluted bollard covers can be placed over old bollards to instantly make them look like new. Bollard covers eliminate the need for regular maintenance and can be trimmed on site for an exact fit. The bright, safety colors of these bollard covers will help prevent collisions in warehouses and parking lots.

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