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


Monocular Atn Vedere Termica Ots Xlt S 25mm, 2.5-10x, 160x120 -19%
Exclusiv online!

Monocular Atn Vedere Termica Ots Xlt S 25mm, 2.5-10x, 160x120

vat.timnoxlt125xs
Livrare 24-48 ore

2.400,00Lei(-19%) 1.939,94Lei

Mulineta Daiwa Caldia Lt 2500d-xh 6rul 2500 D-xh 0.28mm/150m -29%
Exclusiv online!

Mulineta Daiwa Caldia Lt 2500d-xh 6rul 2500 D-xh 0.28mm/150m

d.10412.256
Livrare 24-48 ore

1.291,88Lei(-29%) 920,52Lei

Mulineta Daiwa Caldia Lt 6rul 4000 D-cxh 0.37mm/150m -29%
Exclusiv online!

Mulineta Daiwa Caldia Lt 6rul 4000 D-cxh 0.37mm/150m

d.10412.405
Livrare 24-48 ore

1.315,19Lei(-29%) 937,10Lei

Mulineta Daiwa Certate G Lt 3000d-chx 10rul/150mx023mm/6,2:1 -29%
Exclusiv online!

Mulineta Daiwa Certate G Lt 3000d-chx 10rul/150mx023mm/6,2:1

d.10407.831
Livrare 24-48 ore

2.821,43Lei(-29%) 2.009,21Lei

Mulineta Daiwa Lexa E Lt 2000 5rul/150mx014mm/5,3:1 -41%
Exclusiv online!

Mulineta Daiwa Lexa E Lt 2000 5rul/150mx014mm/5,3:1

d.10226.200
Livrare 24-48 ore

969,94Lei(-41%) 574,54Lei

Mulineta Nomura Kintaro 1000 0.20mm/200m -18%
Exclusiv online!

Mulineta Nomura Kintaro 1000 0.20mm/200m

nm.10741010
Livrare 24-48 ore

320,40Lei(-18%) 261,61Lei

Mulineta Okuma Epixor Ls Fd 6rul/300mx020mm/6,0:1 -6%

Mulineta Okuma Epixor Ls Fd 6rul/300mx020mm/6,0:1

epl-30s
Livrare imediată!

314,10Lei(-6%) 294,86Lei

Mulineta Shimano Aero 4000 -27%

Mulineta Shimano Aero 4000

aero4000
Livrare imediată!

625,00Lei(-27%) 457,55Lei

Mulineta Shimano Aero C5000 -30%

Mulineta Shimano Aero C5000

aeroc5000
Livrare imediată!

650,00Lei(-30%) 455,50Lei

Mulineta Shimano Catana Fe2500 -35%

Mulineta Shimano Catana Fe2500

cat2500fe
Livrare imediată!

259,99Lei(-35%) 169,99Lei

Mulineta Shimano Catana Fec3000 -36%

Mulineta Shimano Catana Fec3000

catc3000fe
Livrare imediată!

260,00Lei(-36%) 165,72Lei

Mulineta Shimano Catana Hg Fe2500 -32%

Mulineta Shimano Catana Hg Fe2500

cat2500hgfe
Livrare imediată!

260,00Lei(-32%) 176,91Lei

Mulineta Shimano Sienna 2000fg -36%

Mulineta Shimano Sienna 2000fg

sn2000fg
Livrare imediată!

200,00Lei(-36%) 128,10Lei

Mulineta Shimano Sienna C3000 Fg -36%

Mulineta Shimano Sienna C3000 Fg

snc3000fg
Livrare imediată!

200,00Lei(-36%) 128,10Lei

Mulineta Shimano Ultegra Xse Competition 3500, 4.3:1, 0.20mm/200m, 4+1rul -24%

Mulineta Shimano Ultegra Xse Competition 3500, 4.3:1, 0.20mm/200m, 4+1rul

ult3500xsec
Livrare imediată!

950,00Lei(-24%) 724,97Lei

Pantaloni Treesco Supra Renfort Verzi, Marime 2 / M -32%
Exclusiv online!

Pantaloni Treesco Supra Renfort Verzi, Marime 2 / M

bt.1026.2
Livrare 24-48 ore

42,23Lei(-32%) 28,83Lei

Pistol Co2 Airsoft Umarex Beretta M9a3 6mm, 22bb, 1.3j -20%
Exclusiv online!

Pistol Co2 Airsoft Umarex Beretta M9a3 6mm, 22bb, 1.3j

vu.2.6507
Livrare 24-48 ore

977,70Lei(-20%) 782,85Lei

Pistol Umarex Co2 Airsoft Beretta Ai 6mm 23bb 1.3j -24%
Exclusiv online!

Pistol Umarex Co2 Airsoft Beretta Ai 6mm 23bb 1.3j

vu.2.6505
Livrare 24-48 ore

928,84Lei(-24%) 707,11Lei

Pompa Aer Maver -20%

Pompa Aer Maver

2958000
Livrare imediată!

113,99Lei(-20%) 91,39Lei

Prindere Arrow Int. Fixa Argo D=26mm/h=13,5mm -45%
Exclusiv online!

Prindere Arrow Int. Fixa Argo D=26mm/h=13,5mm

va.177.00273
Livrare 24-48 ore

587,78Lei(-45%) 321,05Lei

Afişare 9221 - 9240 din 9309 (466 pagini)
Queries: 5, Total time: 683.662 ms [By time] [By id] [By file]
1 (0.110)
SELECT data
FROM `oc_session`
WHERE session_id = 'd4db55cf11797b2ad2e62ca443'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.078)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (356.497)
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 (326.876)
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 9220,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:588
5 (0.101)
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