Hitching Post/Classic, Black ArmorKraft™ Decorative Bollard Post 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 (8810, 8811)) ORDER BY FIELD(e.entity_id,8810,8811)

2 Items

Set Descending Direction
View as Grid List

2 Items

Set Descending Direction
View as Grid List

Hitching Post/Classic, Black ArmorKraft™ Decorative Bollard Post Covers

Decorative bollard covers can be placed over old bollards to instantly add an elegant aesthetic. The all-weather, high-density polyethylene construction of these bollards makes them resistant to cracking, denting, or fading. Decorative bollard covers are designed to withstand extreme temperatures and feature UV inhibitors that provide fade resistance. These bollard covers can be easily installed by placing the cover over an existing bollard. They can also be deployed as freestanding bollards when combined with the optional rubber base.

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