Pentru o livrare cat mai rapida va recomandam sa alegeti produse cu stoc in Magazin fizic si in Depozit Online. Produsele cu Stoc furnizor au termen de livrare mai mare si pot intarzia comanda dvs.
articole de pescuit Gama variata de produse

La Claumar Pescar poti alege simplu si rapid dintr-o gama variata de articole de pescuit.

transport gratuit Transport Gratuit

Comenzile peste 400 lei pot beneficia de transport gratuit.

Vezi mai multe detalii

plata in rate Plata cu cardul

Plata cu cardul in rate fara dobanda.

Vezi mai multe detalii

suport Suport 10-18

Suportul telefonic este 10-18. Orice intrebare ai avea, stim ca nu poate astepta. Apeleaza serviciul Suport 10-18! Un consultant asteapta sa iti preia apelul in intervalul orar 10-18 de luni pana vineri.

Vezi mai multe detalii

returnare Returnare simplu in 14 zile

Retur simplu in 14 zile.

Vezi mai multe detalii

Filtreaza

Bilute Cauciuc Claumar Shocker Beads Kaki 6mm 20buc

Bilute Cauciuc Claumar Shocker Beads Kaki 6mm 20buc

clm237187
Livrare imediată!

5,90Lei

Bilute Cauciuc Pentru Montura Leadcore Helicopter Claumar Shocker Beads Kaki 6mm 12buc

Bilute Cauciuc Pentru Montura Leadcore Helicopter Claumar Shocker Beads Kaki 6mm 12buc

clm237071
Livrare imediată!

7,90Lei

Bilute Cauciuc Fox Tapered Bore Beads Camo, 4mm, 30buc/pac

Bilute Cauciuc Fox Tapered Bore Beads Camo, 4mm, 30buc/pac

cac769
Livrare imediată!

17,96Lei

Bilute Cauciuc Fox Tapered Bore Beads Camo, 6mm, 30buc/pac

Bilute Cauciuc Fox Tapered Bore Beads Camo, 6mm, 30buc/pac

cac770
Livrare imediată!

17,96Lei

Margele Energoteam Cauciuc 5mm 20buc Kt00

Margele Energoteam Cauciuc 5mm 20buc Kt00

79456084
Livrare imediată!

8,90Lei

Margele Energoteam Cauciuc 6mm 20buc Kt00

Margele Energoteam Cauciuc 6mm 20buc Kt00

79456085
Livrare imediată!

8,90Lei

Margele Energoteam Cauciuc 7mm 20buc Kt00

Margele Energoteam Cauciuc 7mm 20buc Kt00

79456086
Livrare imediată!

8,90Lei

Opritor Korda Cauciuc Protectie Nod D 4mm.25buc.pl
Exclusiv online!

Opritor Korda Cauciuc Protectie Nod D 4mm.25buc.pl

k4rbb
Livrare 7-14 zile

18,49Lei

Bile Pvc Nevis Power Cat Black Soft Beads, 10mm

Bile Pvc Nevis Power Cat Black Soft Beads, 10mm

6431-001
Livrare imediată!

5,70Lei

Bile Cauciuc Nevis Pvc Fluo 10mm 20buc/plic
Exclusiv online!

Bile Cauciuc Nevis Pvc Fluo 10mm 20buc/plic

6431-002
Livrare 48-72 ore

7,00Lei

Bile Antisoc Kryston Cauciuc 5mm Weed
Exclusiv online!

Bile Antisoc Kryston Cauciuc 5mm Weed

krac34
Livrare 48-72 ore

23,90Lei

Bile Antisoc Kryston Cauciuc 5mm Black
Exclusiv online!

Bile Antisoc Kryston Cauciuc 5mm Black

krac35
Livrare 48-72 ore

23,90Lei

Margele Fish Pro Amortizor 4mm 10buc/plic

Margele Fish Pro Amortizor 4mm 10buc/plic

chpma-4
Livrare imediată!

7,90Lei

Margele Fish Pro Amortizor 6mm 10buc/plic

Margele Fish Pro Amortizor 6mm 10buc/plic

chpma-6
Livrare imediată!

7,00Lei

Bilute Anti Soc Orange Heli Stoper Pentru Leadcore 16buc
Exclusiv online!

Bilute Anti Soc Orange Heli Stoper Pentru Leadcore 16buc

40541ac2010
Livrare 48-72 ore

9,62Lei

Helicopter Beads Prowess Kaki 5buc/pac
Exclusiv online!

Helicopter Beads Prowess Kaki 5buc/pac

40533prcak1101-kaki
Livrare 48-72 ore

12,51Lei

Bilute Antisoc Korum Camo Quick Change Bead L, 8buc/plic
Exclusiv online!

Bilute Antisoc Korum Camo Quick Change Bead L, 8buc/plic

k0310219
Livrare 7-14 zile

15,76Lei

Bile Cauciuc Select Baits Soft Rubber Beads, 5mm, 10buc
Exclusiv online!

Bile Cauciuc Select Baits Soft Rubber Beads, 5mm, 10buc

sel-061323
Livrare 24-48 ore

7,90Lei

Korum Camo Quick Change Bead - Anti Tangle, 8buc/plic

Korum Camo Quick Change Bead - Anti Tangle, 8buc/plic

k0310220
Livrare imediată!

15,76Lei

Bilute Antisoc Korum Camo Quick Change Bead S, 8buc/plic

Bilute Antisoc Korum Camo Quick Change Bead S, 8buc/plic

k0310218
Livrare imediată!

15,76Lei

Afişare 1 - 20 din 106 (6 pagini)

Descoperă gama noastră de biluțe antisoc pentru monturi pescuit, esențiale pentru protecția nodurilor și amortizarea șocurilor.
Alege biluțe din cauciuc sau silicon, ideale pentru prevenirea încurcăturilor și stabilizarea monturilor.
Disponibile în variante pentru pescuit la crap, feeder și răpitori, asigură monturi sigure și eficiente.
Biluțele antisoc pentru plumb culisant și leadcore oferă protecție suplimentară și o prezentare optimă.
Pentru un pescuit fără probleme, recomandăm biluțe rezistente pentru monturi submersibile și pescuit de distanță.
Modelele pentru method feeder și monturi competiționale sunt testate pentru performanță maximă.
Biluțele anti-încurcare îmbunătățesc precizia și stabilitatea echipamentului de pescuit.
Indispensabile pentru pescuitul recreativ și competițional, aceste accesorii optimizează fiecare partidă.
Biluțele de protecție pentru noduri asigură monturi durabile și sigure în orice condiții.
Alege cele mai bune biluțe antisoc pentru pescuit și maximizează succesul fiecărei ieșiri pe apă!

Queries: 15, Total time: 8.169 ms [By time] [By id] [By file]
1 (0.112)
SELECT data
FROM `oc_session`
WHERE session_id = '8728f1272d4052463f364eead5'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.073)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.102)
SELECT *
FROM oc_url_alias
WHERE keyword = 'bilute-antisoc'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.392)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '324' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46
5 (2.411)
CREATE TEMPORARY TABLE oc_bf_tmp_product (PRIMARY KEY (`product_id`)) ENGINE=InnoDB SELECT p.product_id, p.sort_order, p.quantity, p.manufacturer_id, "1" AS match_filters, (IF(MIN(ps.price) IS NOT NULL, MIN(ps.price), p.price) * (1 + IFNULL(percent_tax, 0)/100) + IFNULL(fixed_tax, 0)) AS actual_price
FROM `oc_product` AS p
INNER JOIN `oc_product_to_store` AS p2s ON (p2s.product_id = p.product_id)
INNER JOIN `oc_bf_filter` AS f ON (p.product_id = f.product_id)
INNER JOIN `oc_product_to_category` AS p2c ON (p.product_id = p2c.product_id)
LEFT JOIN `oc_product_special` AS ps ON (ps.product_id = p.product_id AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()) AND (ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND ps.customer_group_id = '1')
LEFT JOIN ( SELECT SUM(fixed_rate) AS fixed_tax, SUM(percent_rate) AS percent_tax, tax_class_id
FROM `oc_bf_tax_rate` GROUP BY tax_class_id) AS tx ON (p.tax_class_id = tx.tax_class_id)
WHERE p2s.store_id = '0' AND p2c.category_id = '324' AND p.status_filtru > 0 AND p.price > 0 GROUP BY p.product_id
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:857
6 (0.110)
SELECT COUNT(1) AS total
FROM ( SELECT p.*
FROM `oc_bf_tmp_product` AS p
WHERE match_filters = 1) AS t
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1593
7 (0.679)
SELECT p.*, pp.sort_order, pp.viewed, IF ((pp.quantity) > 0, 1, 0) AS array_quantity
FROM `oc_bf_tmp_product` AS p
INNER JOIN `oc_product_description` AS pd ON (pd.product_id = p.product_id)
INNER JOIN `oc_product` AS pp ON (pp.product_id = p.product_id)
WHERE match_filters = 1 AND pd.language_id = '2'
ORDER BY array_quantity DESC, pp.sort_order ASC, pp.viewed DESC, pd.name DESC LIMIT 0, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
8 (2.275)
SELECT a.attribute_group_id AS group_id, av.attribute_id AS attr_id, av.attribute_value_id AS val_id, ad.name AS attr_name, av.sort_order AS val_sort, av.value
FROM `oc_bf_product_attribute_value` AS af
INNER JOIN `oc_bf_tmp_product` AS p ON (af.product_id = p.product_id)
INNER JOIN `oc_bf_attribute_value` AS av ON (af.attribute_value_id = av.attribute_value_id)
INNER JOIN `oc_attribute` AS a ON (a.attribute_id = av.attribute_id)
INNER JOIN `oc_attribute_description` AS ad ON (ad.attribute_id = a.attribute_id)
WHERE ad.language_id = '2' AND av.language_id = '2' AND match_filters = 1 GROUP BY av.attribute_value_id
ORDER BY a.sort_order, ad.name, av.sort_order, CAST(av.value AS UNSIGNED), av.value
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:1286
9 (0.377)
SELECT DISTINCT m.manufacturer_id AS id, CONCAT(UCASE(LEFT(m.name, 1)), LCASE(SUBSTRING(m.name, 2))) AS name
FROM `oc_manufacturer` AS m
INNER JOIN `oc_bf_tmp_product` AS p ON (m.manufacturer_id = p.manufacturer_id)
WHERE match_filters = 1
ORDER BY m.sort_order, m.name
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:1393
10 (0.089)
SELECT stock_status_id AS id, name
FROM `oc_stock_status`
WHERE language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:1415
11 (0.104)
SELECT MIN(actual_price) AS min, MAX(actual_price) AS max
FROM `oc_bf_tmp_product` AS p
WHERE match_filters = 1
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:1180
12 (0.907)
SELECT COUNT(1) AS val, filter_group, filter_id
FROM `oc_bf_tmp_product` AS p
INNER JOIN `oc_bf_filter` AS f ON (p.product_id = f.product_id)
WHERE match_filters = 1 AND f.language_id = '2' GROUP BY filter_group, filter_id
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:1094
13 (0.225)
SELECT *
FROM `oc_pb_bundles`
WHERE `products` != '' AND `status`= '1' AND type = '1' AND `date_available` <= NOW() AND `customer_type` = 0 AND `categories_show` LIKE '%"324"%' LIMIT 0, 1000
/var/www/clients/client1/web1/web/catalog/model/module/productbundles.php:106
14 (0.190)
SELECT *
FROM `oc_pb_bundles`
WHERE `products` != '' AND `status`= '1' AND type = '0' AND `date_available` <= NOW() AND `customer_type` = 0 AND `categories_show` LIKE '%"324"%' LIMIT 0, 1000
/var/www/clients/client1/web1/web/catalog/model/module/product_recomandate.php:106
15 (0.123)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '0' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:37