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 Tubertini Seika Intense Ar Spinning Rod, 5-20g, 2.40m, 2seg -15%

Lanseta Tubertini Seika Intense Ar Spinning Rod, 5-20g, 2.40m, 2seg

07013xx
Livrare imediată!

300,00Lei(-15%) 255,01Lei

Lanseta Tubertini Seika Intense Ar Spinning Rod, 50-100g, 2.70m, 2seg -15%
Exclusiv online!

Lanseta Tubertini Seika Intense Ar Spinning Rod, 50-100g, 2.70m, 2seg

07017xx
Livrare 7-14 zile

459,99Lei(-15%) 391,00Lei

Lanseta Tubertini Seika Justice Rod, 10-35g, 2.70m, 2seg -15%
Exclusiv online!

Lanseta Tubertini Seika Justice Rod, 10-35g, 2.70m, 2seg

07052xx
Livrare 7-14 zile

682,50Lei(-15%) 580,13Lei

Lanseta Tubertini Seika Justice Rod, 15-45g, 2.70m, 2seg -15%

Lanseta Tubertini Seika Justice Rod, 15-45g, 2.70m, 2seg

07051xx
Livrare imediată!

651,00Lei(-15%) 553,35Lei

Lanseta Tubertini Seika Justice Rod, 15-50g, 2.70m, 2seg -15%
Exclusiv online!

Lanseta Tubertini Seika Justice Rod, 15-50g, 2.70m, 2seg

07053xx
Livrare 7-14 zile

688,00Lei(-15%) 584,80Lei

Lanseta Tubertini Seika Justice Rod, 20-70g, 2.70m, 2seg -15%
Exclusiv online!

Lanseta Tubertini Seika Justice Rod, 20-70g, 2.70m, 2seg

07054xx
Livrare 7-14 zile

698,49Lei(-15%) 593,73Lei

Lanseta Tubertini Seika Mimik Spinning Rod, 0-4g, 1.98m, 2seg -15%

Lanseta Tubertini Seika Mimik Spinning Rod, 0-4g, 1.98m, 2seg

03168xx
Livrare imediată!

278,50Lei(-15%) 236,73Lei

Lanseta Tubertini Seika Mimik Spinning Rod, 1-6g, 1.98m, 2seg -15%

Lanseta Tubertini Seika Mimik Spinning Rod, 1-6g, 1.98m, 2seg

03169xx
Livrare imediată!

283,51Lei(-15%) 240,98Lei

Lanseta Ugly Stik Elite Spin 2.40m 20-50g -31%

Lanseta Ugly Stik Elite Spin 2.40m 20-50g

1377255
Livrare imediată!

377,88Lei(-31%) 260,90Lei

Lanseta Zeck Troy, 2.40m, 15-50g, 4seg -26%

Lanseta Zeck Troy, 2.40m, 15-50g, 4seg

20405200246
Livrare imediată!

713,38Lei(-26%) 527,99Lei

Lant Hanger Radical Free Climber Fine Chain 15cm -48%

Lant Hanger Radical Free Climber Fine Chain 15cm

6705104
Livrare imediată!

13,28Lei(-48%) 6,90Lei

Lanterna Cap Energo Team Outdoor Venus Led 2000lm 2 Acumulatori 18650 -26%
Exclusiv online!

Lanterna Cap Energo Team Outdoor Venus Led 2000lm 2 Acumulatori 18650

74957012
Stoc epuizat

104,90Lei(-26%) 77,35Lei

Lanterna Cap Nash Powerbanx Moonshine Micro Lite -25%

Lanterna Cap Nash Powerbanx Moonshine Micro Lite

t3010
Livrare imediată!

115,99Lei(-25%) 86,91Lei

Lanterna De Cap Delphin Polar_x 5 Plus 4 Led -39%

Lanterna De Cap Delphin Polar_x 5 Plus 4 Led

900013010
Livrare imediată!

43,99Lei(-39%) 26,91Lei

Lanterna Frontala Nitecore Headlamp Ut32 (1x18650) Cree Xp-l2 V6 (1100 Lumen) -20%

Lanterna Frontala Nitecore Headlamp Ut32 (1x18650) Cree Xp-l2 V6 (1100 Lumen)

ut32
Livrare imediată!

419,80Lei(-20%) 335,90Lei

Lanterna Ngt De Cap - Xpr Cree Reincarcabil Cu Usb 140 Lumen -25%

Lanterna Ngt De Cap - Xpr Cree Reincarcabil Cu Usb 140 Lumen

ngt-ftl-cree-xpr
Livrare imediată!

79,00Lei(-25%) 59,00Lei

Lanterna Nitecore Military Flashlight Nu05mi Rechargeable Infrared (940nm) -20%

Lanterna Nitecore Military Flashlight Nu05mi Rechargeable Infrared (940nm)

nu05mi
Livrare imediată!

182,20Lei(-20%) 145,91Lei

Larve Berkleys Powerbait Power Maggot Yellow 46, 1cm -30%

Larve Berkleys Powerbait Power Maggot Yellow 46, 1cm

1079209
Livrare imediată!

31,19Lei(-30%) 21,90Lei

Leadcore Carp Zoom Marou 45lb 7m -22%

Leadcore Carp Zoom Marou 45lb 7m

cz6774
Livrare imediată!

42,00Lei(-22%) 32,90Lei

Leader Madcat Cable Black, 10m, 1.35mm, 160kg -23%

Leader Madcat Cable Black, 10m, 1.35mm, 160kg

a.mad.3795160
Livrare imediată!

44,77Lei(-23%) 34,44Lei

Afişare 5961 - 5980 din 9130 (457 pagini)
Queries: 5, Total time: 993.019 ms [By time] [By id] [By file]
1 (0.133)
SELECT data
FROM `oc_session`
WHERE session_id = 'bb401ebd1eb3fb5914c39d1014'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.122)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (416.763)
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 (575.857)
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 5960,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:588
5 (0.144)
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