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 90 zile

Retur simplu in 90 zile.

Vezi mai multe detalii

Oferte speciale


Fir Textil Jaxon Hegemon 8x Fluo 150m 0.20mm 22kg Galben Fluo -17%

Fir Textil Jaxon Hegemon 8x Fluo 150m 0.20mm 22kg Galben Fluo

zj-def020a
Livrare imediată!

130,99Lei(-17%) 108,68Lei

Fir Textil Jaxon Hegemon 8x Fluo 150m 0.22mm 25kg Galben Fluo -17%

Fir Textil Jaxon Hegemon 8x Fluo 150m 0.22mm 25kg Galben Fluo

zj-def022a
Livrare imediată!

130,99Lei(-17%) 108,68Lei

Fir Textil Jaxon Hegemon 8x Premium 150m 0.14mm 15kg -18%

Fir Textil Jaxon Hegemon 8x Premium 150m 0.14mm 15kg

zj-dep014a
Livrare imediată!

144,99Lei(-18%) 118,85Lei

Fir Textil Jaxon Monolith Fluo 125m 0.16mm -20%

Fir Textil Jaxon Monolith Fluo 125m 0.16mm

zj-gof016g
Livrare imediată!

97,01Lei(-20%) 77,23Lei

Fir Textil Jaxon Monolith Fluo 125m 0.18mm -28%
Exclusiv online!

Fir Textil Jaxon Monolith Fluo 125m 0.18mm

zj-gof018g
Livrare 48-72 ore

104,00Lei(-28%) 75,02Lei

Fir Textil Jaxon Monolith Fluo 125m 0.22mm -28%
Exclusiv online!

Fir Textil Jaxon Monolith Fluo 125m 0.22mm

zj-gof022g
Livrare 48-72 ore

110,00Lei(-28%) 79,29Lei

Fir Textil Jaxon Sumato Fluo 125m 0.14mm -19%

Fir Textil Jaxon Sumato Fluo 125m 0.14mm

zj-raf014g
Livrare imediată!

76,00Lei(-19%) 61,92Lei

Fir Textil Korum Smokeshield Coated Braid, 10lbs, 10m -38%
Exclusiv online!

Fir Textil Korum Smokeshield Coated Braid, 10lbs, 10m

k0400004
Livrare 7-14 zile

74,95Lei(-38%) 46,73Lei

Fir Textil Korum Smokeshield Coated Braid, 20lbs, 10m -38%
Exclusiv online!

Fir Textil Korum Smokeshield Coated Braid, 20lbs, 10m

k0400006
Livrare 7-14 zile

74,95Lei(-38%) 46,73Lei

Fir Textil Lazer Elite Braid 0.18mm/11.9kg/10m -9%

Fir Textil Lazer Elite Braid 0.18mm/11.9kg/10m

1025118
Livrare imediată!

10,50Lei(-9%) 9,53Lei

Fir Textil Lazer Elite Braid 0.20mm/14.3kg/10m -9%

Fir Textil Lazer Elite Braid 0.20mm/14.3kg/10m

1025120
Livrare imediată!

10,50Lei(-9%) 9,53Lei

Fir Textil Maver Green Power 135m, 0.07mm, 4.8kg -19%

Fir Textil Maver Green Power 135m, 0.07mm, 4.8kg

741007
Livrare imediată!

60,00Lei(-19%) 48,69Lei

Fir Textil Momoi Jigline Mx8, Moss Green, 125m, 0.16mm, 11kg/23lbs -17%

Fir Textil Momoi Jigline Mx8, Moss Green, 125m, 0.16mm, 11kg/23lbs

jiglmx8016
Livrare imediată!

110,00Lei(-17%) 91,39Lei

Fir Textil Momoi Jigline Mx8, Yellow Fluo, 125m, 0.10mm, 6kg/14lbs -19%

Fir Textil Momoi Jigline Mx8, Yellow Fluo, 125m, 0.10mm, 6kg/14lbs

jiglmx8ylw010
Livrare imediată!

129,91Lei(-19%) 104,60Lei

Fir Textil Momoi Ryujin Pe Braided, Moss Green, 22kg, 0.26mm, 300m -14%
Exclusiv online!

Fir Textil Momoi Ryujin Pe Braided, Moss Green, 22kg, 0.26mm, 300m

ryu026mg
Livrare 48-72 ore

198,00Lei(-14%) 169,69Lei

Fir Textil Mustad Demon Perfect Braid 8, Chartreuse, 0.10mm, 4.5kg, 150m -48%
Exclusiv online!

Fir Textil Mustad Demon Perfect Braid 8, Chartreuse, 0.10mm, 4.5kg, 150m

m.ml98.dpb10.165c
Livrare 24-48 ore

115,93Lei(-48%) 59,94Lei

Fir Textil Mustad Demon Perfect Braid 8, Chartreuse, 0.12mm, 5.4kg, 150m -48%
Exclusiv online!

Fir Textil Mustad Demon Perfect Braid 8, Chartreuse, 0.12mm, 5.4kg, 150m

m.ml98.dpb12.165c
Livrare 24-48 ore

115,93Lei(-48%) 59,94Lei

Fir Textil Mustad Demon Perfect Braid 8, Chartreuse, 0.14mm, 6.8kg, 150m -48%
Exclusiv online!

Fir Textil Mustad Demon Perfect Braid 8, Chartreuse, 0.14mm, 6.8kg, 150m

m.ml98.dpb15.165c
Livrare 24-48 ore

110,36Lei(-48%) 57,31Lei

Fir Textil Mustad Demon Perfect Braid 8, Chartreuse, 0.16mm, 8.2kg, 150m -48%
Exclusiv online!

Fir Textil Mustad Demon Perfect Braid 8, Chartreuse, 0.16mm, 8.2kg, 150m

m.ml98.dpb18.165c
Livrare 24-48 ore

110,36Lei(-48%) 57,31Lei

Fir Textil Mustad Demon Perfect Braid 8, Chartreuse, 0.18mm, 9.0kg, 150m -48%
Exclusiv online!

Fir Textil Mustad Demon Perfect Braid 8, Chartreuse, 0.18mm, 9.0kg, 150m

m.ml98.dpb20.165c
Livrare 24-48 ore

102,86Lei(-48%) 53,29Lei

Afişare 5141 - 5160 din 9190 (460 pagini)
Queries: 5, Total time: 785.982 ms [By time] [By id] [By file]
1 (0.169)
SELECT data
FROM `oc_session`
WHERE session_id = '76911a3e4f18cc0cf0dd4ed8ba'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.207)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (422.531)
SELECT COUNT(1) AS total
FROM oc_product_special ps
LEFT JOIN oc_product p ON (ps.product_id = p.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE p.status = '1' AND p2s.store_id = '2' AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) AND p.quantity > '0'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1714
4 (362.912)
SELECT DISTINCT ps.product_id
FROM oc_product_special ps
LEFT JOIN oc_product p ON (ps.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE p.status = '1' AND p.quantity > '0' AND p2s.store_id = '2' AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) GROUP BY ps.product_id
ORDER BY p.sort_order ASC, LCASE(pd.name) ASC LIMIT 5140,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:588
5 (0.163)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '2' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:37