Hoodbar JCB 427-437 2020-
Sold out
Estimated shipping time:
10-30 business days
Several model options available!
WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '))
)
ORDER BY
FIELD(pm2.meta_value, 'products', 'categories') AS...' at line 13]
SELECT p.ID
FROM wp_posts AS p
LEFT JOIN wp_postmeta AS pm1 ON p.ID = pm1.post_id AND pm1.meta_key = '_pricing_discount_status'
LEFT JOIN wp_postmeta AS pm2 ON p.ID = pm2.post_id AND pm2.meta_key = '_dynamic_pricing_discounts_display'
LEFT JOIN wp_postmeta AS pm3 ON p.ID = pm3.post_id AND pm3.meta_key = '_product_pricing_discount_ids'
LEFT JOIN wp_term_relationships AS tr ON p.ID = tr.object_id
LEFT JOIN wp_term_taxonomy AS tt ON tr.term_taxonomy_id = tt.term_taxonomy_id AND tt.taxonomy = 'product_cat'
WHERE p.post_type = 'em_pricing_discount'
AND p.post_status = 'publish'
AND pm1.meta_value = 'yes'
AND (
(pm2.meta_value = 'products' AND pm3.meta_value LIKE '%198255%')
OR (pm2.meta_value = 'categories' AND tt.term_id IN ())
)
ORDER BY
FIELD(pm2.meta_value, 'products', 'categories') ASC,
p.menu_order ASC,
p.post_date DESC
LIMIT 1
Description
Hoodbar JCB 427-437 2020-
RST-Steel hoodbars are premium-quality Key Flag products manufactured in Finland from stainless steel.
This hoodbar is a stylish accessory that allows you to mount additional lights easily and securely. The light bar can also be equipped with marker lights, further improving visibility both in traffic and on job sites.
Why Choose RST-Steel?
- Reliability: Years of experience and expertise guarantee the high quality and durability of our products.
- Customer Satisfaction: Thousands of satisfied customers around the world trust RST-Steel products.
Technical Specifications:
- Color: Polished stainless steel or powder-coated in standard RAL colors
- Tube diameter: 60 mm
Package Includes:
- Hoodbar JCB 427-437
- Required mounting brackets
- Installation instructions
Vehicle compatibility
Hoodbar JCB 427-437 2020- fits the following brands/models:
Fits all vehicles and models.




