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


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 Catana Hg Fe2500 -32%

Mulineta Shimano Catana Hg Fe2500

cat2500hgfe
Livrare imediată!

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

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

Mulineta Shimano Sedona Fj, 2500s -30%

Mulineta Shimano Sedona Fj, 2500s

se2500sfj
Livrare imediată!

376,02Lei(-30%) 265,00Lei

Mulineta Shimano Sedona Fj, 3000c -30%

Mulineta Shimano Sedona Fj, 3000c

sec3000fj
Livrare imediată!

377,04Lei(-30%) 265,00Lei

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

Mulineta Shimano Vanford 2500a -23%

Mulineta Shimano Vanford 2500a

vf2500a
Livrare imediată!

1.296,22Lei(-23%) 996,00Lei

Afişare 9121 - 9140 din 9214 (461 pagini)
Queries: 5, Total time: 645.060 ms [By time] [By id] [By file]
1 (0.173)
SELECT data
FROM `oc_session`
WHERE session_id = '3604abcef71bad3edc148cdf08'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.107)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (313.399)
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 = '0' 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 (331.281)
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 = '0' 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 9120,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:588
5 (0.100)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '0' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:37