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


Fir Monofilament Delphin Friz Gri, 0,16mm, 2,4kg, 150m -53%

Fir Monofilament Delphin Friz Gri, 0,16mm, 2,4kg, 150m

101003217
Livrare imediată!

21,00Lei(-53%) 9,90Lei

Fir Monofilament Delphin Friz Gri, 0,18mm, 3,0kg, 150m -53%

Fir Monofilament Delphin Friz Gri, 0,18mm, 3,0kg, 150m

101003218
Livrare imediată!

21,00Lei(-53%) 9,90Lei

Fir Monofilament Delphin Friz Gri, 0,20mm, 3,7kg, 150m -53%

Fir Monofilament Delphin Friz Gri, 0,20mm, 3,7kg, 150m

101003219
Livrare imediată!

21,00Lei(-53%) 9,90Lei

Fir Monofilament Delphin Friz Gri, 0,25mm, 5,5kg, 150m -53%

Fir Monofilament Delphin Friz Gri, 0,25mm, 5,5kg, 150m

101003222
Livrare imediată!

21,00Lei(-53%) 9,90Lei

Fir Monofilament Delphin Mamba Feeder Camuflaj 0.18mm 6.3lbs 200m -52%

Fir Monofilament Delphin Mamba Feeder Camuflaj 0.18mm 6.3lbs 200m

101001640
Livrare imediată!

33,00Lei(-52%) 15,90Lei

Fir Monofilament Delphin Tokyo Portocaliu 0.261 Mm 1200m -51%

Fir Monofilament Delphin Tokyo Portocaliu 0.261 Mm 1200m

101000202
Livrare imediată!

93,00Lei(-51%) 45,90Lei

Fir Monofilament Filstar Alaska 0.10mm/50m/1.6kg -32%

Fir Monofilament Filstar Alaska 0.10mm/50m/1.6kg

laz-00000494
Livrare imediată!

5,30Lei(-32%) 3,61Lei

Fir Monofilament Fluorocarbon Momoi Soflex 100mt / .0.203mm -22%

Fir Monofilament Fluorocarbon Momoi Soflex 100mt / .0.203mm

soflex0203
Livrare imediată!

54,00Lei(-22%) 41,90Lei

Fir Monofilament Fudo Hooks Fdn-1 100m, 0.200mm, 5.48kg -32%

Fir Monofilament Fudo Hooks Fdn-1 100m, 0.200mm, 5.48kg

fdn-1-0.20mm-100m
Livrare imediată!

19,00Lei(-32%) 12,90Lei

Fir Monofilament Fudo Hooks Fdn-1 100m, 0.220mm, 6.65kg -31%

Fir Monofilament Fudo Hooks Fdn-1 100m, 0.220mm, 6.65kg

fdn-1-0.22mm-100m
Livrare imediată!

20,00Lei(-31%) 13,90Lei

Fir Monofilament Genlog Camo Energy Premium Feeder 150 M 0.203 Mm 11kg -21%

Fir Monofilament Genlog Camo Energy Premium Feeder 150 M 0.203 Mm 11kg

gzy-cef-203
Livrare imediată!

29,00Lei(-21%) 22,90Lei

Fir Monofilament Inaintas Conic Berkley Nautil Tapared Transparent, 0.20-0.57mm, 5x15m/75m -22%

Fir Monofilament Inaintas Conic Berkley Nautil Tapared Transparent, 0.20-0.57mm, 5x15m/75m

1560536
Livrare imediată!

55,20Lei(-22%) 42,90Lei

Fir Monofilament Jaxon Uran Power 125m 0.16mm -20%

Fir Monofilament Jaxon Uran Power 125m 0.16mm

zj-urp016g
Livrare imediată!

10,50Lei(-20%) 8,40Lei

Fir Monofilament Jaxon Uran Power 125m 0.22mm -19%

Fir Monofilament Jaxon Uran Power 125m 0.22mm

zj-urp022g
Livrare imediată!

11,00Lei(-19%) 8,90Lei

Fir Monofilament Kryston Oblivion Super Grade Copolymer 0.35mm/15lb/1000m Matt Camou -22%

Fir Monofilament Kryston Oblivion Super Grade Copolymer 0.35mm/15lb/1000m Matt Camou

krobl3
Livrare imediată!

85,00Lei(-22%) 65,90Lei

Fir Monofilament Kryston Oblivion Super Grade Copolymer 0.35mm/15lb/1000m Matt Dark Silt -22%

Fir Monofilament Kryston Oblivion Super Grade Copolymer 0.35mm/15lb/1000m Matt Dark Silt

krobl8
Livrare imediată!

85,00Lei(-22%) 65,90Lei

Fir Monofilament Kryston Snyde Premium Green 0.45mm 1000m -24%

Fir Monofilament Kryston Snyde Premium Green 0.45mm 1000m

krsny5
Livrare imediată!

92,00Lei(-24%) 69,90Lei

Fir Monofilament Maver 619 Competition 0.104mm, 150m -28%
Exclusiv online!

Fir Monofilament Maver 619 Competition 0.104mm, 150m

663104
Livrare 48-72 ore

39,00Lei(-28%) 28,20Lei

Fir Monofilament Maver 619 Competition 0.128mm, 150m -28%
Exclusiv online!

Fir Monofilament Maver 619 Competition 0.128mm, 150m

663128
Livrare 48-72 ore

40,00Lei(-28%) 28,91Lei

Fir Monofilament Maver 619 Competition 0.148mm, 150m -47%

Fir Monofilament Maver 619 Competition 0.148mm, 150m

663148
Livrare imediată!

37,50Lei(-47%) 19,90Lei

Afişare 4641 - 4660 din 8995 (450 pagini)
Queries: 5, Total time: 560.077 ms [By time] [By id] [By file]
1 (0.137)
SELECT data
FROM `oc_session`
WHERE session_id = '667013aa96a5f2f7a8f7d4b223'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.099)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (254.379)
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 (305.312)
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 4640,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:588
5 (0.150)
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