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 300 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 - Fire Monofilament Crap ATTACK

Produse ce potrivesc criteriilor de căutare


Fir Monofilament PROLOGIC XLNT HP GREEN 0.33MM/7.4KG/1000M -40%
Exclusiv online!

Fir Monofilament PROLOGIC XLNT HP GREEN 0.33MM/7.4KG/1000M

a.pro.57102
Livrare 24-48 ore

83,62Lei(-40%) 50,17Lei

FIR MONOFILAMENT PROLOGIC XLNT HP CAMO 033MM/7,4KG/1000M
Exclusiv online!

FIR MONOFILAMENT PROLOGIC XLNT HP CAMO 033MM/7,4KG/1000M

a.pro.44693
Livrare 24-48 ore

76,55Lei

FIR MONOFILAMENT PROLOGIC XLNT HP CAMO 035MM/8,1KG/1000M
Exclusiv online!

FIR MONOFILAMENT PROLOGIC XLNT HP CAMO 035MM/8,1KG/1000M

a.pro.44694
Livrare 24-48 ore

81,38Lei

FIR, MONOFILAMENT, PROLOGIC, XLNT, HP, CAMO, 028MM/5,6KG/1000M, , a.pro.44691, Fire Monofilament Crap, Fire Monofilament Crap Prologic, Prologic
FIR MONOFILAMENT PROLOGIC XLNT HP CAMO 030MM/6,6KG/1000M

FIR MONOFILAMENT PROLOGIC XLNT HP CAMO 030MM/6,6KG/1000M

a.pro.44692
Livrare imediată!

71,55Lei

FIR, MONOFILAMENT, PROLOGIC, XLNT, HP, CAMO, 025MM/4,8KG/1000M, , , a.pro.44690, Fire Monofilament Crap, Fire Monofilament Crap Prologic, Fire Prologic, Monofilament Prologic, Crap Prologic, Prologic -23%
FIR, PROLOGIC, XLNT, HP, CAMO, 022MM, 3,9KG, 1000M, a.pro.44689, Fire Monofilament Crap, Fire Monofilament Crap Prologic, Prologic
LANSETA SAVAGE SPINNING GEAR 2BUC.XLNT3 2,13M/2-10G -30%
Exclusiv online!

LANSETA SAVAGE SPINNING GEAR 2BUC.XLNT3 2,13M/2-10G

o.sg.62359
Livrare 24-48 ore

408,46Lei(-30%) 285,91Lei

FIR, MONOFILAMENT, PROLOGIC, XLNT, HP, GREEN, 1000M, 0.28MM, a.pro.57100, Fire Monofilament Crap, Fire Monofilament Crap Prologic, Prologic -40%
Exclusiv online!

FIR, MONOFILAMENT, PROLOGIC, XLNT, HP, GREEN, 1000M, 0.28MM, a.pro.57100, Fire Monofilament Crap, Fire Monofilament Crap Prologic, Prologic

a.pro.57100
Livrare 24-48 ore

70,38Lei(-40%) 42,23Lei

FIR MONOFILAMENT PROLOGIC XLNT HP GREEN 1000M 0.30MM -40%

FIR MONOFILAMENT PROLOGIC XLNT HP GREEN 1000M 0.30MM

a.pro.57101
Livrare imediată!

75,20Lei(-40%) 45,12Lei

Lanseta Prologic XLNT Big Fish Feeder 3.90m 50-170g

Lanseta Prologic XLNT Big Fish Feeder 3.90m 50-170g

o.pro.60884
Stoc epuizat

272,20Lei

Fir Monofilament PROLOGIC XLNT HP GREEN 0.35MM/8.1KG/1000M -40%

Fir Monofilament PROLOGIC XLNT HP GREEN 0.35MM/8.1KG/1000M

a.pro.57103
Stoc epuizat

86,87Lei(-40%) 52,12Lei

Lanseta Prologic XLNT Feeder 3.60m, 150g, 3seg

Lanseta Prologic XLNT Feeder 3.60m, 150g, 3seg

o.pro.60889
Stoc epuizat

250,91Lei

Lanseta Savage Gear XLNT3 Spin, 2.43m, 3-18g, 2buc

Lanseta Savage Gear XLNT3 Spin, 2.43m, 3-18g, 2buc

o.sg.62364
Stoc epuizat

391,08Lei

LANSETA SAVAGE SPINNING GEAR 2BUC.XLNT3 2,13M/5-18G

LANSETA SAVAGE SPINNING GEAR 2BUC.XLNT3 2,13M/5-18G

o.sg.62360
Stoc epuizat

330,90Lei

Lanseta Savage Gear XLNT3 Trigger, 2.13m, 12-45g, 2buc

Lanseta Savage Gear XLNT3 Trigger, 2.13m, 12-45g, 2buc

o.sg.62369
Stoc epuizat

381,00Lei

Afişare 1 - 16 din 16 (1 pagini)
Queries: 4, Total time: 196.214 ms [By time] [By id] [By file]
1 (0.112)
SELECT data
FROM `oc_session`
WHERE session_id = '894fb46ba833b3c95aa445cb95'
/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:427
3 (195.887)
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` GROUP BY tax_class_id) AS tx ON (p.tax_class_id = tx.tax_class_id)
WHERE p2s.store_id = '0' AND (pd.tag LIKE "%xlnt%") 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:698
4 (0.112)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '0' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38