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 Dragon Nano Core Spinn 25 2.45m 5-25g

chc2812245
Livrare imediată!

590,89Lei(-27%) 430,59Lei

Exclusiv online!

460,01Lei(-24%) 351,80Lei

Exclusiv online!

493,99Lei(-24%) 377,22Lei

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

d.11769.365
Livrare imediată!

474,30Lei(-18%) 386,82Lei

310,93Lei(-8%) 285,54Lei

329,05Lei(-8%) 302,12Lei

Exclusiv online!

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

d.11330.394
Livrare 24-48 ore

486,08Lei(-18%) 396,40Lei

320,29Lei(-8%) 294,11Lei

299,00Lei(-6%) 280,62Lei

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

3255196901090
Livrare imediată!

200,00Lei(-39%) 122,92Lei

Exclusiv online!

Lanseta Fl Strategist River 2.40m 70-300g

64-1657
Livrare 24-48 ore

210,00Lei(-8%) 194,08Lei

Exclusiv online!

Lanseta Fl Strategist River 2.70m 70-300g

64-1658
Livrare 24-48 ore

240,00Lei(-8%) 221,55Lei

Lanseta Fl Strategist River 3.00m 70-300g

64-1659
Livrare imediată!

242,00Lei(-8%) 223,58Lei

359,96Lei(-15%) 305,94Lei

Lanseta Fox Eos Pro Tele 3.60m 3.5lb 6seg

crd332
Livrare imediată!

357,80Lei(-18%) 292,72Lei

620,95Lei(-12%) 544,54Lei

674,95Lei(-25%) 509,30Lei

1.394,96Lei(-13%) 1.220,06Lei

584,96Lei(-23%) 448,29Lei

337,46Lei(-23%) 259,27Lei

Afişare 5981 - 6000 din 9256 (463 pagini)
Queries: 5, Total time: 685.715 ms [By time] [By id] [By file]
1 (0.101)
SELECT data
FROM `oc_session`
WHERE session_id = '84626ba68209da46b80808d8a3'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.104)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (337.602)
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 (347.766)
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 5980,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:588
5 (0.142)
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