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

Baston De Nadire Avid Extremity Throwing Stick, 22mm, 80cm
Exclusiv online!

Baston De Nadire Avid Extremity Throwing Stick, 22mm, 80cm

a0640098
Livrare 7-14 zile

247,45Lei

Cobra Strategy Ptr Boilies 20mm

Cobra Strategy Ptr Boilies 20mm

006537-00002-00000
Livrare imediată!

51,00Lei

Cobra Eazi Stick D=25mm Korda
Exclusiv online!

Cobra Eazi Stick D=25mm Korda

ts25
Livrare 7-14 zile

102,58Lei

Cobra Momit Jaxon 20mm
Exclusiv online!

Cobra Momit Jaxon 20mm

ac-pc046a
Livrare 48-72 ore

80,00Lei

Cobra Prologic D=20mm

Cobra Prologic D=20mm

svs49884
Livrare imediată!

53,00Lei

Cobra Prologic D=24mm

Cobra Prologic D=24mm

svs49885
Livrare imediată!

62,00Lei

Cobra De Nadit Carp Zoom 20mm

Cobra De Nadit Carp Zoom 20mm

cz8038
Livrare imediată!

57,00Lei

Cobra Momit Jaxon 25mm

Cobra Momit Jaxon 25mm

ac-pc046b
Livrare imediată!

80,00Lei

Cobra De Nadit Carp Zoom 24mm

Cobra De Nadit Carp Zoom 24mm

cz8045
Livrare imediată!

60,00Lei

Cobra Momit 25mm Jaxon
Exclusiv online!

Cobra Momit 25mm Jaxon

ac-pc045a
Livrare 48-72 ore

119,00Lei

Cobra Carp Academy Boilie 25mm

Cobra Carp Academy Boilie 25mm

7332-025
Livrare imediată!

57,00Lei

Cobra Boilies Carp Academy Carbon 22mm

Cobra Boilies Carp Academy Carbon 22mm

7334-022
Livrare imediată!

205,00Lei

Bason Ngt De Nadire 20mm 92cm

Bason Ngt De Nadire 20mm 92cm

ngt-fo-stick -20mm
Livrare imediată!

35,00Lei

Cobra Carp Zoom De Nadit 28mm
Exclusiv online!

Cobra Carp Zoom De Nadit 28mm

cz1302
Livrare 48-72 ore

64,00Lei

Cobra Carp Zoom De Nadit 25mm
Exclusiv online!

Cobra Carp Zoom De Nadit 25mm

cz1296
Livrare 48-72 ore

64,00Lei

Baston De Nadire Mivardi 22mm

Baston De Nadire Mivardi 22mm

ngt-fo-stick-carbon
Livrare imediată!

249,00Lei

Cobra Plastic Fox Rangemaster 26mm

Cobra Plastic Fox Rangemaster 26mm

cac673
Livrare imediată!

98,96Lei

Korda Easy Stick 20mm -17%

Korda Easy Stick 20mm

ts20
Livrare imediată!

84,50Lei(-17%) 70,00Lei

Baston Nadire Plastic Fox Rangemaster

Baston Nadire Plastic Fox Rangemaster

cac672
Livrare imediată!

98,96Lei

Cobra Baston De Nadire Din Carbon Mirel Steflea Plus Husa 113 Cm / 20mm
Exclusiv online!

Cobra Baston De Nadire Din Carbon Mirel Steflea Plus Husa 113 Cm / 20mm

2942441424015
Livrare 48-72 ore

450,00Lei

Afişare 21 - 40 din 73 (4 pagini)

Descoperă gama noastră de cobre din carbon și PVC pentru nadire cu boilies 20-24 mm, ideale pentru pescuitul la crap.
Alege cobre carbon ultraușoare și cobre PVC rezistente, perfecte pentru nadire rapidă și precisă.
Disponibile în variante pentru pescuit de distanță și pescuit de competiție, optimizează fiecare partidă.
Cobrele ergonomice și anti-alunecare asigură confort și precizie în lansare.
Pentru o nadire eficientă, recomandăm cobre pentru boilies tari și solizi, de 20mm și 24mm.
Modelele pentru lacuri și râuri sunt concepute pentru o dispersie uniformă a nadei.
Cobrele din carbon performante permit lansări precise pe distanțe mari.
Indispensabile pentru pescarii profesioniști și amatori, îmbunătățesc strategia de nadire.
Cobrele flexibile din PVC sunt ideale pentru utilizare îndelungată fără oboseală.
Alege cele mai bune cobre pentru nadire cu boilies și atrage crapii mari cu precizie maximă!

Queries: 16, Total time: 5.538 ms [By time] [By id] [By file]
1 (0.078)
SELECT data
FROM `oc_session`
WHERE session_id = '08b35f66cc8eadd114e447841d'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.109)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.127)
SELECT *
FROM oc_url_alias
WHERE keyword = 'cobre-nadire'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.435)
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 = '343' AND cd.language_id = '2' AND c2s.store_id = '3' 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 (1.603)
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`) AS tx ON (p.tax_class_id = tx.tax_class_id)
WHERE p2s.store_id = '3' AND p2c.category_id = '343' 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.128)
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.516)
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 20, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
8 (0.134)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"ART COMPOSITE SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
9 (0.905)
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
10 (0.251)
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
11 (0.109)
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
12 (0.115)
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
13 (0.577)
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
14 (0.172)
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 '%"343"%' LIMIT 0, 1000
/var/www/clients/client1/web1/web/catalog/model/module/productbundles.php:106
15 (0.163)
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 '%"343"%' LIMIT 0, 1000
/var/www/clients/client1/web1/web/catalog/model/module/product_recomandate.php:106
16 (0.116)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '3' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:37