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


Lanseta Jaxon Method Feeder Academy X 330 20-60gr -23%

Lanseta Jaxon Method Feeder Academy X 330 20-60gr

wj-cbf33060-x
Livrare imediată!

272,00Lei(-23%) 208,43Lei

Lanseta Shimano Catana Fx Spinning M-f, 2.13m, 7-21g, 2seg -32%

Lanseta Shimano Catana Fx Spinning M-f, 2.13m, 7-21g, 2seg

scatfx70mlc
Livrare imediată!

275,00Lei(-32%) 187,08Lei

Lanseta Shimano Catana Fx Spinning M-f, 2.39m, 14-40g, 2seg -32%

Lanseta Shimano Catana Fx Spinning M-f, 2.39m, 14-40g, 2seg

scatfx710mhc
Livrare imediată!

315,00Lei(-32%) 213,50Lei

Luneta Zeiss V8 1,8-14x50/ir60 Asv -11%
Exclusiv online!

Luneta Zeiss V8 1,8-14x50/ir60 Asv

vz.522111asv.60
Livrare 24-48 ore

16.890,93Lei(-11%) 15.037,60Lei

Luneta Zeiss Conquest V6 2-12x50/ir60 -11%
Exclusiv online!

Luneta Zeiss Conquest V6 2-12x50/ir60

vz.522225.60
Livrare 24-48 ore

9.871,94Lei(-11%) 8.789,14Lei

Luneta Zeiss Conquest V6 M 2-12x50/ir60 -5%
Exclusiv online!

Luneta Zeiss Conquest V6 M 2-12x50/ir60

vz.m522224.60
Livrare 24-48 ore

9.278,16Lei(-5%) 8.789,14Lei

Mad Hook D-rig Gripper Nr 1 -7%
Exclusiv online!

Mad Hook D-rig Gripper Nr 1

6536001
Livrare 7-14 zile

15,00Lei(-7%) 13,96Lei

Manusi Sciera Impermeabile Sensi-dry Marime L -48%
Exclusiv online!

Manusi Sciera Impermeabile Sensi-dry Marime L

a8.sie.43385
Livrare 24-48 ore

112,76Lei(-48%) 58,33Lei

Manusi Sciera Impermeabile Sensi-dry Marime Xl -48%
Exclusiv online!

Manusi Sciera Impermeabile Sensi-dry Marime Xl

a8.sie.43386
Livrare 24-48 ore

112,76Lei(-48%) 58,33Lei

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 Miravel 2500s, 5.0:1, 0.18mm/120m, 6rul -23%

Mulineta Shimano Miravel 2500s, 5.0:1, 0.18mm/120m, 6rul

mir2500s
Livrare imediată!

661,94Lei(-23%) 507,99Lei

Afişare 9101 - 9120 din 9198 (460 pagini)
Queries: 5, Total time: 726.843 ms [By time] [By id] [By file]
1 (0.212)
SELECT data
FROM `oc_session`
WHERE session_id = '6ffcbab1fe7c8fa7d0f9dce9d4'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.139)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (351.717)
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 (374.648)
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 9100,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:588
5 (0.127)
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