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

Oferte speciale


Vobler Colmic Wt-dog 105 10.5cm 17.5gr Green Tiger -29%
Exclusiv online!

Vobler Colmic Wt-dog 105 10.5cm 17.5gr Green Tiger

arhkdd05
Livrare 48-72 ore

38,90Lei(-29%) 27,50Lei

Vobler Colmic Wt-dog 105 10.5cm 17.5gr Matt Sunny -29%
Exclusiv online!

Vobler Colmic Wt-dog 105 10.5cm 17.5gr Matt Sunny

arhkdd04
Livrare 48-72 ore

38,90Lei(-29%) 27,50Lei

Vobler Colmic Wt-dog 105 10.5cm 17.5gr Shad -29%
Exclusiv online!

Vobler Colmic Wt-dog 105 10.5cm 17.5gr Shad

arhkdd03
Livrare 48-72 ore

38,90Lei(-29%) 27,50Lei

Vobler Colmic Wt-dog 110 Slim 11cm 13.5gr Flash Ayu -30%
Exclusiv online!

Vobler Colmic Wt-dog 110 Slim 11cm 13.5gr Flash Ayu

arhkdr04
Livrare 48-72 ore

69,90Lei(-30%) 49,19Lei

Vobler Colmic Wt-dog 110 Slim 11cm 13.5gr Pearl Ayu -30%
Exclusiv online!

Vobler Colmic Wt-dog 110 Slim 11cm 13.5gr Pearl Ayu

arhkdr06
Livrare 48-72 ore

69,90Lei(-30%) 49,19Lei

Vobler Colmic Wt-dog 110 Slim 11cm 13.5gr Shad -30%
Exclusiv online!

Vobler Colmic Wt-dog 110 Slim 11cm 13.5gr Shad

arhkdr05
Livrare 48-72 ore

69,90Lei(-30%) 49,19Lei

Vobler Colmic Wt-dog 110 Slim 11cm 13.5gr Skull -30%
Exclusiv online!

Vobler Colmic Wt-dog 110 Slim 11cm 13.5gr Skull

arhkdr02
Livrare 48-72 ore

69,90Lei(-30%) 49,19Lei

Vobler Colmic Wt-dog 125 F 12.5cm 27gr Green Flash -29%
Exclusiv online!

Vobler Colmic Wt-dog 125 F 12.5cm 27gr Green Flash

arherak09b
Livrare 48-72 ore

33,61Lei(-29%) 23,80Lei

Vobler Colmic Wt-dog 125 F 12.5cm 27gr Tri Shad Colmic -29%
Exclusiv online!

Vobler Colmic Wt-dog 125 F 12.5cm 27gr Tri Shad Colmic

arherak09c
Livrare 48-72 ore

33,61Lei(-29%) 23,80Lei

Vobler Colmic Wt-dog 125hf 12.5cm 28gr Qda -30%
Exclusiv online!

Vobler Colmic Wt-dog 125hf 12.5cm 28gr Qda

arhkde01
Livrare 48-72 ore

87,91Lei(-30%) 61,80Lei

Vobler Colmic Wt-dog 125hf 12.5cm 28gr Sardina Chartreuse -30%
Exclusiv online!

Vobler Colmic Wt-dog 125hf 12.5cm 28gr Sardina Chartreuse

arhkde02
Livrare 48-72 ore

87,91Lei(-30%) 61,80Lei

Vobler Crank Sakura Scb Micro Diver 39mm 4.40gr 101 Crayfish -29%

Vobler Crank Sakura Scb Micro Diver 39mm 4.40gr 101 Crayfish

131234saplh500239-101
Livrare imediată!

48,81Lei(-29%) 34,49Lei

Vobler Duo Jerkbait 100 F 10cm 13.7g Gpa3244 -19%

Vobler Duo Jerkbait 100 F 10cm 13.7g Gpa3244

4525918111519
Livrare imediată!

72,00Lei(-19%) 58,50Lei

Vobler Duo Realis Jerkbait 110 Sp 11cm 16.2g Ccc3816 Wakasagi Nd -14%

Vobler Duo Realis Jerkbait 110 Sp 11cm 16.2g Ccc3816 Wakasagi Nd

duo86480
Livrare imediată!

77,00Lei(-14%) 65,90Lei

Vobler Duo Realis Jerkbait 120 Sp 12cm 18g Ajo0091 Ivory Halo -15%

Vobler Duo Realis Jerkbait 120 Sp 12cm 18g Ajo0091 Ivory Halo

duo66062
Livrare imediată!

83,00Lei(-15%) 70,90Lei

Vobler Duo Realis Vibration 55 Nitro 5.5cm 11.5g Acc3059 Mat Tiger S -19%

Vobler Duo Realis Vibration 55 Nitro 5.5cm 11.5g Acc3059 Mat Tiger S

4525918119584
Livrare imediată!

69,00Lei(-19%) 56,10Lei

Vobler Duo Realis Vibration 55 Nitro 5.5cm 11.5g Ccc3069 Red Tiger S -20%

Vobler Duo Realis Vibration 55 Nitro 5.5cm 11.5g Ccc3069 Red Tiger S

duo37304
Livrare imediată!

69,00Lei(-20%) 55,20Lei

Vobler Forest Ifish 5cm 5g Culoare 1 -9%
Exclusiv online!

Vobler Forest Ifish 5cm 5g Culoare 1

ifish-1
Livrare 48-72ore

55,00Lei(-9%) 50,00Lei

Vobler Holo Select Scamp F Om 7cm 7gr -30%
Exclusiv online!

Vobler Holo Select Scamp F Om 7cm 7gr

vj-sa07fom
Livrare 48-72 ore

33,00Lei(-30%) 23,10Lei

Vobler Jackall Digle 5+ 7.4cm 26.2g Jakko Gill -20%
Exclusiv online!

Vobler Jackall Digle 5+ 7.4cm 26.2g Jakko Gill

ja.807202182
Livrare 24-48 ore

126,88Lei(-20%) 101,50Lei

Afişare 8721 - 8740 din 9150 (458 pagini)
Queries: 6, Total time: 720.694 ms [By time] [By id] [By file]
1 (0.114)
SELECT data
FROM `oc_session`
WHERE session_id = '219715a4bc81f4ae70d1b28649'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.089)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (408.887)
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 (311.344)
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 8720,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:588
5 (0.142)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"TACKLE SHOP ARENA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
6 (0.118)
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