Collapsible Barricades

Lightweight and Durable Collapsible Road Barricadesr

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 (9209)) ORDER BY FIELD(e.entity_id,9209)

1 Item

Set Descending Direction
View as Grid List

1 Item

Set Descending Direction
View as Grid List

Lightweight and Durable Collapsible Road Barricadesr

Eagle’s collapsible road barriers are a lightweight and durable option suitable for use as an emergency, construction, or temporary road blockade. These easy-to-use collapsible barricades help to direct traffic and pedestrians away from hazards.

Read More

Foldable Traffic Barrier Features

The collapsible barricades feature ergonomic handling, making it simple to set up and tear down at special events or in safety zones. The portable road barricades feature a revolutionary ball and detent design that snaps the unit in place with a twist of the handle. The barricades can be easily stored in a vehicle trunk, bed, or utility compartment. Collapsible road barriers are commonly used as a traffic barricade, construction barricade, street barricade, general-purpose safety barricade, caution barricade, school crossing sign, and pedestrian crossing sign.

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