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

Căutare

Produse ce potrivesc criteriilor de căutare


FIR JAXON XT-PRO PREMIUM 25m 0.14mm -29%

FIR JAXON XT-PRO PREMIUM 25m 0.14mm

zj-xtp014c
Stoc epuizat

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

SAFETY CLIP JAXON CU BLOCAJ PRO CARP VERDE -40%

SAFETY CLIP JAXON CU BLOCAJ PRO CARP VERDE

ac-pc028b
Stoc epuizat

11,00Lei(-40%) 6,60Lei

FIR MONOFILAMENT PROLOGIC MIMICRY GREEN HELO 1000M 0.40MM

FIR MONOFILAMENT PROLOGIC MIMICRY GREEN HELO 1000M 0.40MM

a.pro.57089
Stoc epuizat

219,48Lei

VOBLER STRIKE PRO 4PYGMY JOINT CM 3.6G 4CM -20%

VOBLER STRIKE PRO 4PYGMY JOINT CM 3.6G 4CM

sp.eg073j.71
Stoc epuizat

31,31Lei(-20%) 25,05Lei

OCHELARI DAIWA PRO POLARIZANTI CLIP ON LENTILA DARK GREY

OCHELARI DAIWA PRO POLARIZANTI CLIP ON LENTILA DARK GREY

d.dpropcfl1
Stoc epuizat

56,39Lei

Kit Montura Plumb Pierdut Prologic Mimicry Distance 10 buc plic

Kit Montura Plumb Pierdut Prologic Mimicry Distance 10 buc plic

a.pro.54404
Stoc epuizat

35,46Lei

CICADA STRIKE PRO 3,3CM/4,3G FARFALLA 781

CICADA STRIKE PRO 3,3CM/4,3G FARFALLA 781

sp.jg007a.781
Stoc epuizat

29,55Lei

MONTURA PROLOGIC SAFETLY CLIP SH LEADER 80CM/45LBS

MONTURA PROLOGIC SAFETLY CLIP SH LEADER 80CM/45LBS

a.pro.50150
Stoc epuizat

37,62Lei

LINIE VARGA JAXON PRO FLOAT ZB 2.0GR 8M 18-14MM NR 10

LINIE VARGA JAXON PRO FLOAT ZB 2.0GR 8M 18-14MM NR 10

sf-zb020
Stoc epuizat

16,01Lei

FIR TEXTIL POWER PRO 135m 0,08mm 4kg Yellow -5%

FIR TEXTIL POWER PRO 135m 0,08mm 4kg Yellow

ppbi13508y
Stoc epuizat

70,00Lei(-5%) 66,50Lei

FIR MONOFILAMENT PROLOGIC BULLDOZER FC YELLOW 033MM/6.7Kg/1000M

FIR MONOFILAMENT PROLOGIC BULLDOZER FC YELLOW 033MM/6.7Kg/1000M

a.pro.54476
Stoc epuizat

117,77Lei

LEST PT. NALUCI STRIKE PRO POWER DOT FOSFO M -20%

LEST PT. NALUCI STRIKE PRO POWER DOT FOSFO M

sp.ad001m.glo
Stoc epuizat

16,96Lei(-20%) 13,57Lei

TUB PRO CARP TUNGSTEN JAXON VERDE 1M -30%

TUB PRO CARP TUNGSTEN JAXON VERDE 1M

ac-pc037b
Stoc epuizat

18,40Lei(-30%) 12,90Lei

OCHELARI POLARIZANTI DAIWA PRO LENTILA NEGRU GRI

OCHELARI POLARIZANTI DAIWA PRO LENTILA NEGRU GRI

d.dpropsg1
Stoc epuizat

169,10Lei

AGRAFA RAPIDA PROLOGIC SPEED LINK LM, 15BUC/PLIC

AGRAFA RAPIDA PROLOGIC SPEED LINK LM, 15BUC/PLIC

a7.pro.49924
Stoc epuizat

22,50Lei

Vobler Lucky John Haira Tiny Plus One Pro Series 33LBF, 201, 3.3cm, 4g, 1buc/pac

Vobler Lucky John Haira Tiny Plus One Pro Series 33LBF, 201, 3.3cm, 4g, 1buc/pac

lj-hat33lbf-201
Stoc epuizat

37,00Lei

Husa Pentru Juvelnic/Minciog Matrix Ethos Pro EVA Triple Net Bag 60x50x25cm -20%

Husa Pentru Juvelnic/Minciog Matrix Ethos Pro EVA Triple Net Bag 60x50x25cm

glu089
Stoc epuizat

245,97Lei(-20%) 196,78Lei

PRASTIE CORMORAN PRO CARP 1002 PENTRU NADIT

PRASTIE CORMORAN PRO CARP 1002 PENTRU NADIT

a.11.01002
Stoc epuizat

37,34Lei

VOBLER STRIKE PRO 3.5CM/2.2G 713 ARCHBACK -20%

VOBLER STRIKE PRO 3.5CM/2.2G 713 ARCHBACK

sp.eg125e.a70.713
Stoc epuizat

32,06Lei(-20%) 25,64Lei

FIR PROLOGIC VIPER ULTRASOFT CAMO SS 15LB/15M

FIR PROLOGIC VIPER ULTRASOFT CAMO SS 15LB/15M

a.pro.49999
Stoc epuizat

29,30Lei

Afişare 3401 - 3420 din 3893 (195 pagini)
Queries: 6, Total time: 90.915 ms [By time] [By id] [By file]
1 (0.104)
SELECT data
FROM `oc_session`
WHERE session_id = '4763541073e612280ad0bd7771'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.103)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (90.246)
CREATE TEMPORARY TABLE oc_bf_tmp_product (PRIMARY KEY (`product_id`), INDEX my_index (match_filters, sort_order, manufacturer_id)) ENGINE=MEMORY SELECT p.product_id, p.sort_order, p.quantity, p.manufacturer_id, "1" AS match_filters, (IF(MIN(ps.price) IS NOT NULL, MIN(ps.price), p.price) * (1 + IFNULL(percent_tax, 0)/100) + IFNULL(fixed_tax, 0)) AS actual_price
FROM `oc_product` AS p
INNER JOIN `oc_product_to_store` AS p2s ON (p2s.product_id = p.product_id)
INNER JOIN `oc_bf_filter` AS f ON (p.product_id = f.product_id)
INNER JOIN `oc_product_description` AS pd ON (pd.product_id = p.product_id)
LEFT JOIN `oc_product_special` AS ps ON (ps.product_id = p.product_id AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()) AND (ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND ps.customer_group_id = '1')
LEFT JOIN ( SELECT SUM(fixed_rate) AS fixed_tax, SUM(percent_rate) AS percent_tax, tax_class_id
FROM `oc_bf_tax_rate`) AS tx ON (p.tax_class_id = tx.tax_class_id)
WHERE p2s.store_id = '3' AND (MATCH(pd.tag) AGAINST('+pro' IN BOOLEAN MODE)) AND p.status_filtru > 0 AND p.price > 0 GROUP BY p.product_id
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:724
4 (0.203)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"ROM-EUROTRADE SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
5 (0.131)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"TACKLE SHOP ARENA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
6 (0.128)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '3' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38