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


Vobler Berkley Dex Stick Shadd, White Chartreuse, 11cm, 39g -20%

Vobler Berkley Dex Stick Shadd, White Chartreuse, 11cm, 39g

1550651
Livrare imediată!

59,96Lei(-20%) 47,67Lei

Vobler Berkley Pulse Fry Deep, Pearl White, 3.8cm, 4.6g -16%

Vobler Berkley Pulse Fry Deep, Pearl White, 3.8cm, 4.6g

1571673
Livrare imediată!

31,46Lei(-16%) 26,32Lei

Vobler Berkley Pulse Fry Shallow, Pearl White, 3.8cm, 4.5g -16%

Vobler Berkley Pulse Fry Shallow, Pearl White, 3.8cm, 4.5g

1571665
Livrare imediată!

31,46Lei(-16%) 26,32Lei

Vobler Black Cat Baby Cranker Sinking, Yellow, Firetiger, 25g, 12cm, 1buc/pac -17%

Vobler Black Cat Baby Cranker Sinking, Yellow, Firetiger, 25g, 12cm, 1buc/pac

3549001
Livrare imediată!

60,00Lei(-17%) 49,60Lei

Vobler Black Cat Baby Cranker Sinking, Yellow, Red Head, 25g, 12cm, 1buc/pac -17%
Exclusiv online!

Vobler Black Cat Baby Cranker Sinking, Yellow, Red Head, 25g, 12cm, 1buc/pac

3549002
Livrare 7-14 zile

60,00Lei(-17%) 49,60Lei

Vobler Black Cat Cranker Sinking, Yellow, Firetiger, 50g, 16cm, 1buc/pac -18%
Exclusiv online!

Vobler Black Cat Cranker Sinking, Yellow, Firetiger, 50g, 16cm, 1buc/pac

3548001
Livrare 7-14 zile

75,00Lei(-18%) 61,81Lei

Vobler Black Cat Cranker Sinking, Yellow, Red Head, 50g, 16cm, 1buc/pac -18%
Exclusiv online!

Vobler Black Cat Cranker Sinking, Yellow, Red Head, 50g, 16cm, 1buc/pac

3548002
Livrare 7-14 zile

75,00Lei(-18%) 61,81Lei

Vobler Black Cat Cranker Sinking, Yellow, Special Green, 50g, 16cm, 1buc/pac -18%
Exclusiv online!

Vobler Black Cat Cranker Sinking, Yellow, Special Green, 50g, 16cm, 1buc/pac

3548004
Livrare 7-14 zile

75,00Lei(-18%) 61,81Lei

Vobler Black Cat Cranker Sinking, Yellow, Zombie, 50g, 16cm, 1buc/pac -18%
Exclusiv online!

Vobler Black Cat Cranker Sinking, Yellow, Zombie, 50g, 16cm, 1buc/pac

3548003
Livrare 7-14 zile

75,00Lei(-18%) 61,81Lei

Vobler Colmic Herakles Waving S 4cm 3gr Black Louis -25%
Exclusiv online!

Vobler Colmic Herakles Waving S 4cm 3gr Black Louis

arhkas07
Livrare 48-72 ore

29,90Lei(-25%) 22,55Lei

Vobler Colmic Herakles Wt-dog Fat 75f 7.5cm 8.5gr Alburno Tiger -25%
Exclusiv online!

Vobler Colmic Herakles Wt-dog Fat 75f 7.5cm 8.5gr Alburno Tiger

arhkie06
Livrare 48-72 ore

37,90Lei(-25%) 28,25Lei

Vobler Colmic Herakles Wt-dog Fat 75f 7.5cm 8.5gr Chartreuse Shine -25%
Exclusiv online!

Vobler Colmic Herakles Wt-dog Fat 75f 7.5cm 8.5gr Chartreuse Shine

arhkie03
Livrare 48-72 ore

37,90Lei(-25%) 28,25Lei

Vobler Colmic Herakles Wt-dog Fat 75f 7.5cm 8.5gr Flash Gold -25%
Exclusiv online!

Vobler Colmic Herakles Wt-dog Fat 75f 7.5cm 8.5gr Flash Gold

arhkie01
Livrare 48-72 ore

37,90Lei(-25%) 28,25Lei

Vobler Colmic Herakles Wt-dog Fat 75f 7.5cm 8.5gr Sarda Pink Belly -25%
Exclusiv online!

Vobler Colmic Herakles Wt-dog Fat 75f 7.5cm 8.5gr Sarda Pink Belly

arhkie02
Livrare 48-72 ore

37,90Lei(-25%) 28,25Lei

Vobler Colmic Herakles Wt-dog Fat 75f 9cm 13.5gr Alburno Tiger -26%
Exclusiv online!

Vobler Colmic Herakles Wt-dog Fat 75f 9cm 13.5gr Alburno Tiger

arhkif06
Livrare 48-72 ore

41,90Lei(-26%) 31,10Lei

Vobler Colmic Herakles Wt-dog Fat 75f 9cm 13.5gr Chartreuse Shine -26%
Exclusiv online!

Vobler Colmic Herakles Wt-dog Fat 75f 9cm 13.5gr Chartreuse Shine

arhkif03
Livrare 48-72 ore

41,90Lei(-26%) 31,10Lei

Vobler Colmic Herakles Wt-dog Fat 75f 9cm 13.5gr Flash Gold -26%
Exclusiv online!

Vobler Colmic Herakles Wt-dog Fat 75f 9cm 13.5gr Flash Gold

arhkif01
Livrare 48-72 ore

41,90Lei(-26%) 31,10Lei

Vobler Colmic Herakles Idroflat 100 7.5cm-19gr Vampire Shad -46%
Exclusiv online!

Vobler Colmic Herakles Idroflat 100 7.5cm-19gr Vampire Shad

aridro1007
Livrare 48-72 ore

46,90Lei(-46%) 25,30Lei

Vobler Fl Fl602 Sinking 55mm 10.5g Depth All Round Colour 105 -12%

Vobler Fl Fl602 Sinking 55mm 10.5g Depth All Round Colour 105

fl602-sinking-allround-55mm-10.5g-105
Livrare imediată!

17,10Lei(-12%) 15,13Lei

Vobler Forest S-cra 25f 1, 25mm, 1.4g -26%
Exclusiv online!

Vobler Forest S-cra 25f 1, 25mm, 1.4g

scra25f-1
Livrare 24-48 ore

70,00Lei(-26%) 51,84Lei

Afişare 2821 - 2840 din 9258 (463 pagini)
Queries: 5, Total time: 629.579 ms [By time] [By id] [By file]
1 (0.093)
SELECT data
FROM `oc_session`
WHERE session_id = '64476d011dd1f1066e4687f2f9'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.083)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (265.922)
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 = '3' 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 (363.308)
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 = '3' 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 2820,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:588
5 (0.173)
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