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 Daiwa Trout Area Team Commander 2.10m 1-6g 2seg -18%
Exclusiv online!

Lanseta Daiwa Trout Area Team Commander 2.10m 1-6g 2seg

d.11717.210
Livrare 24-48 ore

506,96Lei(-18%) 416,52Lei

Lanseta Dam Match 4.20m, 8-20g, 3+3seg -20%
Exclusiv online!

Lanseta Dam Match 4.20m, 8-20g, 3+3seg

dam.70330
Livrare 24-48 ore

448,56Lei(-20%) 359,75Lei

Lanseta Dam Nanoflex Pro 2.70m 10-30gr -29%

Lanseta Dam Nanoflex Pro 2.70m 10-30gr

2040956150
Livrare imediată!

384,38Lei(-29%) 272,91Lei

Lanseta Dragon Nano Core Spinn 25 2.45m 5-25g -29%

Lanseta Dragon Nano Core Spinn 25 2.45m 5-25g

chc2812245
Livrare imediată!

590,89Lei(-29%) 422,49Lei

Lanseta Feeder Colmic Sniper 3.60m 130g 3seg -25%
Exclusiv online!

Lanseta Feeder Colmic Sniper 3.60m 130g 3seg

casn10b
Livrare 48-72 ore

459,99Lei(-25%) 345,00Lei

Lanseta Feeder Colmic Sniper 3.90m 130g 3seg -25%
Exclusiv online!

Lanseta Feeder Colmic Sniper 3.90m 130g 3seg

casn10c
Livrare 48-72 ore

494,00Lei(-25%) 369,99Lei

Lanseta Feeder Daiwa 3+2seg Aqualite, 3,60m 150g -20%

Lanseta Feeder Daiwa 3+2seg Aqualite, 3,60m 150g

d.11769.365
Livrare imediată!

474,30Lei(-20%) 379,44Lei

Lanseta Feeder Daiwa 3+2seg Black Widow, 3.60m, 150g -10%

Lanseta Feeder Daiwa 3+2seg Black Widow, 3.60m, 150g

d.11789.365
Livrare imediată!

310,94Lei(-10%) 280,74Lei

Lanseta Feeder Daiwa 3+2seg Black Widow, 3.90m, 150g -10%

Lanseta Feeder Daiwa 3+2seg Black Widow, 3.90m, 150g

d.11789.395
Livrare imediată!

329,05Lei(-10%) 297,05Lei

Lanseta Feeder Daiwa 3+2seg N'zon, 3,96m, 80g -20%
Exclusiv online!

Lanseta Feeder Daiwa 3+2seg N'zon, 3,96m, 80g

d.11330.394
Livrare 24-48 ore

486,08Lei(-20%) 389,76Lei

Lanseta Feeder Daiwa Black Widow, 3.60m, 120g, 3+2seg -10%

Lanseta Feeder Daiwa Black Widow, 3.60m, 120g, 3+2seg

d.11789.361
Livrare imediată!

320,29Lei(-10%) 289,16Lei

Lanseta Feeder Tica New Crystal Multitip Feeder, 3.45-3.90m, 2+3buc -8%

Lanseta Feeder Tica New Crystal Multitip Feeder, 3.45-3.90m, 2+3buc

crystalmultitip345/390
Livrare imediată!

299,00Lei(-8%) 275,00Lei

Lanseta Fl Aqua Tele Spin 3.6m, 15-45g -40%

Lanseta Fl Aqua Tele Spin 3.6m, 15-45g

3255196901090
Livrare imediată!

200,00Lei(-40%) 119,90Lei

Lanseta Fl Strategist River 2.40m 70-300g -10%
Exclusiv online!

Lanseta Fl Strategist River 2.40m 70-300g

64-1657
Livrare 48-72 ore

210,00Lei(-10%) 189,90Lei

Lanseta Fl Strategist River 2.70m 70-300g -10%

Lanseta Fl Strategist River 2.70m 70-300g

64-1658
Livrare imediată!

240,00Lei(-10%) 216,90Lei

Lanseta Fl Strategist River 3.00m 70-300g -10%

Lanseta Fl Strategist River 3.00m 70-300g

64-1659
Livrare imediată!

242,00Lei(-10%) 218,90Lei

Lanseta Fox Eos Pro 3.00m, 3.5lb, 2seg -20%

Lanseta Fox Eos Pro 3.00m, 3.5lb, 2seg

crd325
Livrare imediată!

313,10Lei(-20%) 249,90Lei

Lanseta Fox Eos Pro Spod Marker 3.60m 5lb 2seg -17%

Lanseta Fox Eos Pro Spod Marker 3.60m 5lb 2seg

crd334
Livrare imediată!

359,96Lei(-17%) 299,90Lei

Lanseta Fox Eos Pro Tele 3.60m 3.5lb 6seg -20%

Lanseta Fox Eos Pro Tele 3.60m 3.5lb 6seg

crd332
Livrare imediată!

357,80Lei(-20%) 286,90Lei

Lanseta Fox Eos Pro Tele 3.90m 3.5lb 6seg -21%

Lanseta Fox Eos Pro Tele 3.90m 3.5lb 6seg

crd333
Livrare imediată!

380,21Lei(-21%) 299,90Lei

Afişare 5741 - 5760 din 9102 (456 pagini)
Queries: 5, Total time: 587.486 ms [By time] [By id] [By file]
1 (0.081)
SELECT data
FROM `oc_session`
WHERE session_id = '9e5eb5faa0454348d0cf926489'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.080)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (272.288)
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 (314.872)
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 5740,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:588
5 (0.165)
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