Filters
Filters
Price
Producer

Show Filters
SELECT t.id, t.pic, t.pnomer, ROUND(t.price*a.coef, 2) as price, t.name_en, t.short_en, t.used, t.unpacked, t.price as price_new, t.price_org, t.status_id, DATE_FORMAT(t.nav_date, '%d-%m-%Y'), t.nav_order, t.nav_date, t.delivery_days, DATE_FORMAT(t.delivery_date, '%d-%m-%Y'), t.disc_qty FROM products t JOIN atts a ON (a.id = ?) ,products_groups u WHERE t.status = '1' AND t.cz_en = '0' AND (t.id IN (SELECT b.product_id FROM productsgroups_active a, products_groups b WHERE a.id = b.group_id)) AND t.id = u.product_id AND t.discounted = '0' AND u.group_id IN (SELECT v.id FROM productsgroups_v2 v WHERE v.b_id = '270' OR v.s_id = '270' OR v.t_id = '270' OR v.r_id = '270' OR v.f_id = '270' OR v.e_id = '270') /*GROUP BY t.id*/ ORDER BY t.id DESC
Turnbuckles M8, DIN 1480, eye-eye, galvanized 19421 Turnbuckles M8, DIN 1480, eye-eye, galvanized
❌ The item is not available. There is no option to order.
Delivery No confirmed delivery date
1.40 EUR
incl. VAT
Buy
Turnbuckle VANT-5/PL (Load up to 50 kg) VANT-5/PL Turnbuckle VANT-5/PL (Load up to 50 kg)
❌ The item is not available. There is no option to order.
Delivery No confirmed delivery date
1.02 EUR
incl. VAT
Buy
Steel cable cross sleeve ZL-3 ZL-3 Steel cable cross sleeve ZL-3
❌ The item is not available. There is no option to order.
Delivery No confirmed delivery date
0.31 EUR
incl. VAT
Buy
TURNBUCKLE VANT-10/PL (Load up to 220 kg) VANT-10/PL TURNBUCKLE VANT-10/PL (Load up to 220 kg)
✅ In Stock < 10 Бр.
Delivery Planned Delivery Date by Courier to you 30-04-2025
5.14 EUR
incl. VAT
Buy
Mast Bracket - Clamping ring for attaching FLUE SR-3050 SR-3050 Mast Bracket - Clamping ring for attaching FLUE SR-3050
❌ The item is not available. There is no option to order.
Delivery No confirmed delivery date
7.38 EUR
incl. VAT
Buy