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 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 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 De Cap Delphin Trios 1w -45%

Lanterna De Cap Delphin Trios 1w

900013015
Livrare imediată!

36,00Lei(-45%) 19,90Lei

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

Leftail Colmic 1.8'' 4.6cm Black -39%
Exclusiv online!

Leftail Colmic 1.8'' 4.6cm Black

arhkam51
Livrare 48-72 ore

27,91Lei(-39%) 17,10Lei

Leftail Colmic 3.5'' 8.9cm Albino White Glow Fluo -39%
Exclusiv online!

Leftail Colmic 3.5'' 8.9cm Albino White Glow Fluo

arhkam26
Livrare 48-72 ore

27,91Lei(-39%) 17,10Lei

Leftail Colmic 4.5'' 11.4cm Junebug -39%
Exclusiv online!

Leftail Colmic 4.5'' 11.4cm Junebug

arhkam30
Livrare 48-72 ore

36,90Lei(-39%) 22,50Lei

Legatura Nod Fara Nod Mostiro Ss 8kg 10buc -29%

Legatura Nod Fara Nod Mostiro Ss 8kg 10buc

004554-00401-00000
Livrare imediată!

4,90Lei(-29%) 3,50Lei

Lestaj Bigfish Flex Jig Head 20g -11%

Lestaj Bigfish Flex Jig Head 20g

13250020
Livrare imediată!

20,00Lei(-11%) 17,90Lei

Lestaj Bigfish Flex Jig Head 5g -6%

Lestaj Bigfish Flex Jig Head 5g

13250005
Livrare imediată!

10,00Lei(-6%) 9,40Lei

Lestaj Bigfish Flex Jig Head 6g -6%

Lestaj Bigfish Flex Jig Head 6g

13250006
Livrare imediată!

10,00Lei(-6%) 9,40Lei

Lestaj Bigfish Flex Jig Head 7g -6%

Lestaj Bigfish Flex Jig Head 7g

13250007
Livrare imediată!

10,00Lei(-6%) 9,40Lei

Afişare 5841 - 5860 din 9016 (451 pagini)
Queries: 5, Total time: 590.115 ms [By time] [By id] [By file]
1 (0.523)
SELECT data
FROM `oc_session`
WHERE session_id = '10b66859d2aae4832f5d11f811'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.212)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (277.822)
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 (311.462)
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 5840,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:588
5 (0.096)
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