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


Husa Daiwa Kevlar Pt Lanseta Dintr-o Bucata 1.80mt -20%

Husa Daiwa Kevlar Pt Lanseta Dintr-o Bucata 1.80mt

d.15839.002
Livrare imediată!

63,90Lei(-20%) 50,99Lei

Husa Daiwa Protectie 160x5.5cm -28%
Exclusiv online!

Husa Daiwa Protectie 160x5.5cm

d.ch257886
Livrare 24-48 ore

81,36Lei(-28%) 58,91Lei

Husa Dam Ott Rod Holdall Soft 1 Rod, 171x23x6cm -63%
Exclusiv online!

Husa Dam Ott Rod Holdall Soft 1 Rod, 171x23x6cm

svs74976
Livrare 7-14 zile

174,95Lei(-63%) 64,52Lei

Husa Delphin Dravec Soft 145cm -28%

Husa Delphin Dravec Soft 145cm

430407145
Livrare imediată!

139,00Lei(-28%) 99,95Lei

Husa Individuala Daiwa Husa Is 200x22x12cm Ismlrs -18%

Husa Individuala Daiwa Husa Is 200x22x12cm Ismlrs

d.18851.050
Livrare imediată!

141,70Lei(-18%) 116,27Lei

Husa Individuala Prologic Avenger Lanseta + Mulineta 3.90cm -18%

Husa Individuala Prologic Avenger Lanseta + Mulineta 3.90cm

svs65076
Livrare imediată!

194,36Lei(-18%) 159,10Lei

Husa Individuala Solar Sp C-tech Rod Sleeve Camo, 167cm -17%

Husa Individuala Solar Sp C-tech Rod Sleeve Camo, 167cm

lgct20
Livrare imediată!

189,99Lei(-17%) 158,59Lei

Husa Individuala Solar Sp C-tech Rod Sleeve Camo, 209cm -14%

Husa Individuala Solar Sp C-tech Rod Sleeve Camo, 209cm

lgct22
Livrare imediată!

214,99Lei(-14%) 184,02Lei

Husa Korum Progress Folding Quiver, 26x18x155cm -29%
Exclusiv online!

Husa Korum Progress Folding Quiver, 26x18x155cm

k0290110
Livrare 7-14 zile

414,95Lei(-29%) 296,35Lei

Husa Korum Progress Quiver, 23x23x150cm -28%
Exclusiv online!

Husa Korum Progress Quiver, 23x23x150cm

k0290109
Livrare 7-14 zile

299,95Lei(-28%) 214,50Lei

Husa Laneste Jrc Defender 12-13ft, Rod Sleeve, 229cm -29%

Husa Laneste Jrc Defender 12-13ft, Rod Sleeve, 229cm

1445861
Livrare imediată!

337,51Lei(-29%) 240,97Lei

Husa Lanseta Cu Mulineta Daiwa Widow, 1 Post, 12ft/202x28cm -9%
Exclusiv online!

Husa Lanseta Cu Mulineta Daiwa Widow, 1 Post, 12ft/202x28cm

a8.18705.112
Livrare 24-48 ore

98,98Lei(-9%) 90,08Lei

Husa Lansete Black Cat Battle Cat Single Rod Bag, 155cm -18%
Exclusiv online!

Husa Lansete Black Cat Battle Cat Single Rod Bag, 155cm

8576001
Livrare 7-14 zile

275,00Lei(-18%) 224,49Lei

Husa Lansete Black Cat Battle Cat Single Rod Bag, 180cm -18%
Exclusiv online!

Husa Lansete Black Cat Battle Cat Single Rod Bag, 180cm

8576002
Livrare 7-14 zile

275,00Lei(-18%) 224,49Lei

Husa Lansete Browning Sphere Multi Rod Carrier Xl, 190x17x32cm -35%

Husa Lansete Browning Sphere Multi Rod Carrier Xl, 190x17x32cm

8580024
Livrare imediată!

1.012,00Lei(-35%) 655,72Lei

Husa Lansete Daiwa 12ft 200x25x12cm Is3rh12 -20%
Exclusiv online!

Husa Lansete Daiwa 12ft 200x25x12cm Is3rh12

d.18851.015
Livrare 24-48 ore

385,99Lei(-20%) 309,78Lei

Husa Lansete Dam O.t.t. Rod Holdall Hardcase 192x12x8cm -52%
Exclusiv online!

Husa Lansete Dam O.t.t. Rod Holdall Hardcase 192x12x8cm

svs74975
Livrare 7-14 zile

425,84Lei(-52%) 204,26Lei

Husa Lansete Matrix Horizon Multi Pole Holdall (abs Insert) -18%
Exclusiv online!

Husa Lansete Matrix Horizon Multi Pole Holdall (abs Insert)

glu129
Livrare 7-14 zile

1.124,96Lei(-18%) 917,01Lei

Husa Lineaeffe Compartimentata Ts Carp 2 Lansete + 2 Mulinete 195cm -28%
Exclusiv online!

Husa Lineaeffe Compartimentata Ts Carp 2 Lansete + 2 Mulinete 195cm

a8.6535401
Livrare 24-48 ore

251,90Lei(-28%) 180,29Lei

Husa Lineaeffe Individuala Ts Carp Lanseta + Mulineta 210cm -28%
Exclusiv online!

Husa Lineaeffe Individuala Ts Carp Lanseta + Mulineta 210cm

a8.6535402
Livrare 24-48 ore

216,80Lei(-28%) 155,32Lei

Afişare 5501 - 5520 din 9198 (460 pagini)
Queries: 5, Total time: 633.981 ms [By time] [By id] [By file]
1 (0.146)
SELECT data
FROM `oc_session`
WHERE session_id = 'ed0d10017d4f8d2b909137688d'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.093)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (263.748)
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 (369.850)
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 5500,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:588
5 (0.144)
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