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


Lanseta Colmic Herakles Black Weapon Revenge Spin 1.98m -36%

Lanseta Colmic Herakles Black Weapon Revenge Spin 1.98m

cahkbwr01
Livrare imediată!

772,00Lei(-36%) 491,59Lei

Lanseta Colmic Herakles Black Weapon Revenge Spin 2.03m -36%

Lanseta Colmic Herakles Black Weapon Revenge Spin 2.03m

cahkbwr02
Livrare imediată!

833,00Lei(-36%) 529,01Lei

Lanseta Colmic Herakles Black Weapon Revenge Spin 2.15m -37%

Lanseta Colmic Herakles Black Weapon Revenge Spin 2.15m

cahkbwr04
Livrare imediată!

819,01Lei(-37%) 519,91Lei

Lanseta Colmic Herakles Kiar Reef 2.18m 8 28g -27%

Lanseta Colmic Herakles Kiar Reef 2.18m 8 28g

cahkkr02
Livrare imediată!

955,00Lei(-27%) 699,90Lei

Lanseta Colmic Herakles Kiar Reef 2.30m 15 45g -23%

Lanseta Colmic Herakles Kiar Reef 2.30m 15 45g

cahkkr04
Livrare imediată!

910,00Lei(-23%) 699,90Lei

Lanseta Colmic Herakles Kiar Reef 690 M 2.05m 5 18g -25%
Exclusiv online!

Lanseta Colmic Herakles Kiar Reef 690 M 2.05m 5 18g

cahkkr01
Livrare 48-72 ore

819,90Lei(-25%) 614,90Lei

Lanseta Colmic Herakles Kiar Reef 690 M 2.23m 20 80g -25%
Exclusiv online!

Lanseta Colmic Herakles Kiar Reef 690 M 2.23m 20 80g

cahkkr03
Livrare 48-72 ore

890,91Lei(-25%) 668,90Lei

Lanseta Colmic Premium Indyo Cast 7" 1/4-3/4 Medium Heavy -30%
Exclusiv online!

Lanseta Colmic Premium Indyo Cast 7" 1/4-3/4 Medium Heavy

cahkpr04
Livrare 48-72 ore

1.359,90Lei(-30%) 951,90Lei

Lanseta Cormoran 3+3buc.speciland Srp Feeder 3,60/50-150g -30%
Exclusiv online!

Lanseta Cormoran 3+3buc.speciland Srp Feeder 3,60/50-150g

c.25.5150369
Livrare 24-48 ore

386,08Lei(-30%) 270,26Lei

Lanseta Cormoran 3+3buc.speciland Srp Feeder 3,60/60-180g -20%
Exclusiv online!

Lanseta Cormoran 3+3buc.speciland Srp Feeder 3,60/60-180g

c.25.5180369
Livrare 24-48 ore

426,44Lei(-20%) 341,15Lei

Lanseta Cormoran 3+3buc.speciland Srp Feeder 3,90/60-180g -20%
Exclusiv online!

Lanseta Cormoran 3+3buc.speciland Srp Feeder 3,90/60-180g

c.25.5180399
Livrare 24-48 ore

434,35Lei(-20%) 347,48Lei

Lanseta Cormoran Black Master Jigger, 2.70m, 7-28g, 2buc -30%
Exclusiv online!

Lanseta Cormoran Black Master Jigger, 2.70m, 7-28g, 2buc

c.27.2028270
Livrare 24-48 ore

214,38Lei(-30%) 150,96Lei

Lanseta Cormoran Black Master Spin, 2.70m, 35-80g, 2seg -23%

Lanseta Cormoran Black Master Spin, 2.70m, 35-80g, 2seg

c.27.2080270
Livrare imediată!

261,32Lei(-23%) 201,90Lei

Lanseta Cormoran Cross Water Ul Spin 2.20m 3-14g 2seg -23%

Lanseta Cormoran Cross Water Ul Spin 2.20m 3-14g 2seg

c.27.4014220
Livrare imediată!

251,83Lei(-23%) 193,90Lei

Lanseta Cormoran Gf Feeder Pro H 3.60m, 50-150g, 3+3seg -20%

Lanseta Cormoran Gf Feeder Pro H 3.60m, 50-150g, 3+3seg

c.25.2150367
Livrare imediată!

366,26Lei(-20%) 293,00Lei

Lanseta Cormoran Gf Feeder Pro Mh 3.90m, 40-120g, 3+3seg -20%

Lanseta Cormoran Gf Feeder Pro Mh 3.90m, 40-120g, 3+3seg

c.25.2120397
Livrare imediată!

308,88Lei(-20%) 247,10Lei

Lanseta Cormoran Power Creek 2.10m 5-20g 2seg -19%
Exclusiv online!

Lanseta Cormoran Power Creek 2.10m 5-20g 2seg

c.27.8520210
Livrare 24-48 ore

146,89Lei(-19%) 118,41Lei

Lanseta Daiwa 2buc. Ninja X Carp 3,00m/3lbs -20%

Lanseta Daiwa 2buc. Ninja X Carp 3,00m/3lbs

d.11595.315
Livrare imediată!

304,24Lei(-20%) 244,30Lei

Lanseta Daiwa 2buc.windcast Carp 3,60m/3lbs B -14%

Lanseta Daiwa 2buc.windcast Carp 3,60m/3lbs B

d.11684.361
Livrare imediată!

644,94Lei(-14%) 554,66Lei

Lanseta Daiwa Aqualite Feeder 3.60m 120g 3+2seg -20%
Exclusiv online!

Lanseta Daiwa Aqualite Feeder 3.60m 120g 3+2seg

d.11769.362
Livrare 24-48 ore

436,27Lei(-20%) 349,92Lei

Afişare 5641 - 5660 din 9036 (452 pagini)
Queries: 5, Total time: 584.206 ms [By time] [By id] [By file]
1 (0.119)
SELECT data
FROM `oc_session`
WHERE session_id = '9681b19d73f2f186a84f239241'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.113)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (262.561)
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 (321.295)
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 5640,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:588
5 (0.118)
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