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 Delphin Xawer Telefloat 390cm 30g -31%

Lanseta Delphin Xawer Telefloat 390cm 30g

101001412
Livrare imediată!

145,00Lei(-31%) 99,90Lei

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%

Lanseta Fl Strategist River 2.40m 70-300g

64-1657
Livrare imediată!

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%
Exclusiv online!

Lanseta Fl Strategist River 3.00m 70-300g

64-1659
Livrare 48-72 ore

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

Lanseta Fox Horizon X3 Abbreviated Handle 3.60m 2.75lbs -14%

Lanseta Fox Horizon X3 Abbreviated Handle 3.60m 2.75lbs

crd287
Livrare imediată!

620,95Lei(-14%) 534,56Lei

Lanseta Fox Horizon X3 Abbreviated Handle 3.60m 3.00lbs 50mm -26%

Lanseta Fox Horizon X3 Abbreviated Handle 3.60m 3.00lbs 50mm

crd297
Livrare imediată!

674,94Lei(-26%) 499,90Lei

Afişare 5601 - 5620 din 8973 (449 pagini)
Queries: 5, Total time: 600.021 ms [By time] [By id] [By file]
1 (0.107)
SELECT data
FROM `oc_session`
WHERE session_id = '4df27aafac0d744fd4af34a596'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.095)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (278.584)
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 (321.085)
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 5600,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:588
5 (0.150)
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