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


Montura Maver It Jurassic Feeder Link S 5cm 3/plic -16%
Exclusiv online!

Montura Maver It Jurassic Feeder Link S 5cm 3/plic

00430001
Livrare 48-72 ore

37,99Lei(-16%) 31,91Lei

Montura Mivardi Lead Core Rig System + Antitangle Sleeves 2buc/plic -26%

Montura Mivardi Lead Core Rig System + Antitangle Sleeves 2buc/plic

m-acrslccr
Livrare imediată!

31,90Lei(-26%) 23,72Lei

Montura One More Cast Tackle Meta All-in-1 Solid Bag Braid Rig, Nr. 6, 2buc/pac -16%
Exclusiv online!

Montura One More Cast Tackle Meta All-in-1 Solid Bag Braid Rig, Nr. 6, 2buc/pac

omcsr46
Livrare 48-72ore

53,13Lei(-16%) 44,62Lei

Montura Pb Products Kd Rig 06 -18%

Montura Pb Products Kd Rig 06

pb25041
Livrare imediată!

18,50Lei(-18%) 15,13Lei

Montura Pb Ready Made Leafer Weed / Vegetatie, 90cm -21%

Montura Pb Ready Made Leafer Weed / Vegetatie, 90cm

pb21101
Livrare imediată!

28,00Lei(-21%) 22,25Lei

Montura Plumb Pierdut Orange Lead Feed 85g Nr.4 -24%

Montura Plumb Pierdut Orange Lead Feed 85g Nr.4

120241mf39185
Livrare imediată!

21,86Lei(-24%) 16,59Lei

Montura Plumb Pierdut Pb Products Hit Run Tungsten Loaded Leader Slit -25%

Montura Plumb Pierdut Pb Products Hit Run Tungsten Loaded Leader Slit

pb19351
Livrare imediată!

36,51Lei(-25%) 27,35Lei

Montura Prologic 4cm/20lbs Cu Carlig Xc8 Nr.6 3buc -46%

Montura Prologic 4cm/20lbs Cu Carlig Xc8 Nr.6 3buc

a.pro.50126
Livrare imediată!

35,88Lei(-46%) 19,24Lei

Montura Savage Carbon49 T-treble Spike 1/0 11cm 2buc/plic -47%
Exclusiv online!

Montura Savage Carbon49 T-treble Spike 1/0 11cm 2buc/plic

a7.sg.69779
Livrare 24-48 ore

42,66Lei(-47%) 22,68Lei

Montura Savage Carbon49 T-treble Spike 2/0 11.5cm 2buc/plic -47%
Exclusiv online!

Montura Savage Carbon49 T-treble Spike 2/0 11.5cm 2buc/plic

a7.sg.69780
Livrare 24-48 ore

44,00Lei(-47%) 23,37Lei

Montura Savage Gear Carbon Ancora Nr. 1/20 Cm -56%
Exclusiv online!

Montura Savage Gear Carbon Ancora Nr. 1/20 Cm

a.sg.57403
Livrare 24-48 ore

30,67Lei(-56%) 13,48Lei

Montura Savage Gear Carbon Corkscrew, Nr.1, 2buc/plic -27%
Exclusiv online!

Montura Savage Gear Carbon Corkscrew, Nr.1, 2buc/plic

a.sg.61765
Livrare 24-48 ore

31,35Lei(-27%) 22,95Lei

Montura Savage Punch 10g 3buc/plic -46%
Exclusiv online!

Montura Savage Punch 10g 3buc/plic

a.sg.63820
Livrare 24-48 ore

27,79Lei(-46%) 15,13Lei

Montura Savage Punch 15g 3buc/plic -45%
Exclusiv online!

Montura Savage Punch 15g 3buc/plic

a.sg.63821
Livrare 24-48 ore

22,68Lei(-45%) 12,54Lei

Montura Somn Dam Madcat Adjusta P River Deadbait 1.00mm, 3/0-10/0, 180cm, 60g -48%
Exclusiv online!

Montura Somn Dam Madcat Adjusta P River Deadbait 1.00mm, 3/0-10/0, 180cm, 60g

a.mad.55994
Livrare 24-48 ore

85,16Lei(-48%) 44,29Lei

Montura Somn Madcat Screaming Profi River 10/0 -38%

Montura Somn Madcat Screaming Profi River 10/0

a.mad.56000
Livrare imediată!

80,62Lei(-38%) 50,19Lei

Mostiro Kit Monturi Crap - 5buc -19%

Mostiro Kit Monturi Crap - 5buc

4194
Livrare imediată!

12,40Lei(-19%) 10,06Lei

Motor Barca Rhino Electric Outboard Motor Vx 34 -11%

Motor Barca Rhino Electric Outboard Motor Vx 34

9925034
Livrare imediată!

1.349,78Lei(-11%) 1.195,75Lei

Mould Cresta Method Feeder -18%

Mould Cresta Method Feeder

004722-00100-00000
Livrare imediată!

15,90Lei(-18%) 13,10Lei

Mulienta Daiwa Bg 6500, 5.3:1, 0.45mm/340m, 6rul -22%
Exclusiv online!

Mulienta Daiwa Bg 6500, 5.3:1, 0.45mm/340m, 6rul

d.10460.650
Livrare 24-48 ore

860,71Lei(-22%) 670,44Lei

Afişare 6741 - 6760 din 9259 (463 pagini)
Queries: 6, Total time: 595.391 ms [By time] [By id] [By file]
1 (0.133)
SELECT data
FROM `oc_session`
WHERE session_id = '4bc5b7135a538722f1f58f9114'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.157)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (287.427)
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 (307.422)
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 6740,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:588
5 (0.113)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"ONE MORE CAST"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
6 (0.139)
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