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


Lingurita Oscilanta Dara Killer Argintata Atom 9 Gr -15%

Lingurita Oscilanta Dara Killer Argintata Atom 9 Gr

1403100100900
Livrare imediată!

19,00Lei(-15%) 16,15Lei

Lingurita Oscilanta Dara Killer Argintata Dolinger Mic Cu Solzi 6g -15%

Lingurita Oscilanta Dara Killer Argintata Dolinger Mic Cu Solzi 6g

1403210100600
Livrare imediată!

19,00Lei(-15%) 16,15Lei

Lingurita Oscilanta Dara Killer Argintata Felie Pepene 10gr -18%

Lingurita Oscilanta Dara Killer Argintata Felie Pepene 10gr

1403010101000
Livrare imediată!

19,00Lei(-18%) 15,57Lei

Lingurita Oscilanta Dara Killer Argintata Frunza 2d 9gr -15%

Lingurita Oscilanta Dara Killer Argintata Frunza 2d 9gr

1402690100900
Livrare imediată!

19,00Lei(-15%) 16,15Lei

Lingurita Oscilanta Dara Killer Argintata Frunza 6d 7gr -15%

Lingurita Oscilanta Dara Killer Argintata Frunza 6d 7gr

1402730100700
Livrare imediată!

19,00Lei(-15%) 16,15Lei

Lingurita Oscilanta Dara Killer Argintata Frunza Mare 13gr -18%

Lingurita Oscilanta Dara Killer Argintata Frunza Mare 13gr

1402990101300
Livrare imediată!

19,00Lei(-18%) 15,57Lei

Lingurita Oscilanta Dara Killer Argintata Olandeza 4d 10gr -15%

Lingurita Oscilanta Dara Killer Argintata Olandeza 4d 10gr

1402830101000
Livrare imediată!

19,00Lei(-15%) 16,15Lei

Lingurita Oscilanta Dara Killer Argintata Painica 7gr -15%

Lingurita Oscilanta Dara Killer Argintata Painica 7gr

1403170100800
Livrare imediată!

19,00Lei(-15%) 16,15Lei

Lingurita Oscilanta Dara Killer Argintata Piscot Cu Solzi 10gr -15%

Lingurita Oscilanta Dara Killer Argintata Piscot Cu Solzi 10gr

1403180101000
Livrare imediată!

19,00Lei(-15%) 16,15Lei

Lingurita Oscilanta Dara Killer Argintata Profing 12gr -15%

Lingurita Oscilanta Dara Killer Argintata Profing 12gr

1403000101200
Livrare imediată!

19,00Lei(-15%) 16,15Lei

Lingurita Oscilanta Dara Killer Argintata Tac 1d 15gr -15%

Lingurita Oscilanta Dara Killer Argintata Tac 1d 15gr

1402100101500
Livrare imediată!

19,00Lei(-15%) 16,15Lei

Lingurita Oscilanta Dara Killer Argintata Tac 1d 21gr -15%

Lingurita Oscilanta Dara Killer Argintata Tac 1d 21gr

1402100102100
Livrare imediată!

19,00Lei(-15%) 16,15Lei

Lingurita Oscilanta Dara Killer Galbena Frunza 6d 8,5gr -21%

Lingurita Oscilanta Dara Killer Galbena Frunza 6d 8,5gr

1402730208500
Livrare imediată!

16,50Lei(-21%) 13,10Lei

Lingurita Oscilanta Dara Killer Galbena Piscot 3d 10gr -21%

Lingurita Oscilanta Dara Killer Galbena Piscot 3d 10gr

1402220201000
Livrare imediată!

16,50Lei(-21%) 13,10Lei

Lingurita Oscilanta Dara Killer Galbena Tac 1d 15gr -21%

Lingurita Oscilanta Dara Killer Galbena Tac 1d 15gr

1402100201500
Livrare imediată!

16,50Lei(-21%) 13,10Lei

Lingurita Oscilanta Dara Killer Galbena Tac 8gr -21%

Lingurita Oscilanta Dara Killer Galbena Tac 8gr

1402900200800
Livrare imediată!

16,50Lei(-21%) 13,10Lei

Lingurita Oscilanta Ilba Linus Bicolora Pink-gold 15gr -19%

Lingurita Oscilanta Ilba Linus Bicolora Pink-gold 15gr

il-227902
Livrare imediată!

22,40Lei(-19%) 18,17Lei

Lingurita Oscilanta Jackall Tricoroll 7.4cm, 19g, Flash Chartreuse -27%
Exclusiv online!

Lingurita Oscilanta Jackall Tricoroll 7.4cm, 19g, Flash Chartreuse

f3.ja.418098672
Livrare 24-48 ore

48,17Lei(-27%) 35,30Lei

Lingurita Oscilanta Jackall Tricoroll 7.4cm, 19g, Stripe Ayu -27%
Exclusiv online!

Lingurita Oscilanta Jackall Tricoroll 7.4cm, 19g, Stripe Ayu

f3.ja.418098641
Livrare 24-48 ore

48,17Lei(-27%) 35,30Lei

Lingurita Oscilanta Lucky John Eos, Culoare 004, 4.8cm, 12g -15%
Exclusiv online!

Lingurita Oscilanta Lucky John Eos, Culoare 004, 4.8cm, 12g

ljeos12-004
Livrare 24-48 ore

24,50Lei(-15%) 20,93Lei

Afişare 6421 - 6440 din 9198 (460 pagini)
Queries: 5, Total time: 710.464 ms [By time] [By id] [By file]
1 (0.095)
SELECT data
FROM `oc_session`
WHERE session_id = '829df9e96efcdd064873ab0c2a'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.102)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (330.645)
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 (379.446)
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 6420,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:588
5 (0.176)
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