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 Monofilament Sufix Tritanium Neon Gold 0.35mm, 9.00kg, 1120m

Fir Monofilament Sufix Tritanium Neon Gold 0.35mm, 9.00kg, 1120m

ds1sy035089g2t
Livrare imediată!

89,00Lei

FIR DAIWA J-BRAID X8 MULTICOLOR 020MM/13KG/150M

FIR DAIWA J-BRAID X8 MULTICOLOR 020MM/13KG/150M

d.12755.020
Livrare imediată!

75,76Lei

FIR TEXTIL CPK XTRA SUPPLE HOOKLINK SINKING, Green/Black, 25lb

FIR TEXTIL CPK XTRA SUPPLE HOOKLINK SINKING, Green/Black, 25lb

999873
Livrare imediată!

29,00Lei

FIR COLMIC ALL ROUND NX50 150M 0.189mm -20%

FIR COLMIC ALL ROUND NX50 150M 0.189mm

nyal150189
Livrare imediată!

25,00Lei(-20%) 19,90Lei

FIR COLMIC PROJECT 360 NX30 300M 0.50mm
Exclusiv online!

FIR COLMIC PROJECT 360 NX30 300M 0.50mm

nypr30050
Livrare 48-72 ore

53,00Lei

Fir Toray Super Strong Olive Green 0.240mm

Fir Toray Super Strong Olive Green 0.240mm

602210021
Livrare imediată!

80,47Lei

Fir Monofilament Filstar Tornado 0.25mm/100m/9.8Kg

Fir Monofilament Filstar Tornado 0.25mm/100m/9.8Kg

laz-00000437
Livrare imediată!

21,00Lei

FIR MONOFILAMENT TRABUCCO MAX PLUS LINE ALLROUND /150mt 0,20MM

FIR MONOFILAMENT TRABUCCO MAX PLUS LINE ALLROUND /150mt 0,20MM

057-00-200
Livrare imediată!

16,01Lei

FIR COLMIC ATOMIC 500M 0.20mm
Exclusiv online!

FIR COLMIC ATOMIC 500M 0.20mm

nyat620
Livrare 48-72 ore

24,00Lei

Fir Cralusso General Prestige 0,14mm 150m

Fir Cralusso General Prestige 0,14mm 150m

33900014
Livrare imediată!

29,00Lei

FIR MONOFILAMENT TRABUCCO XPS VELVET CAST 0.30MM/300MT/9.14KG

FIR MONOFILAMENT TRABUCCO XPS VELVET CAST 0.30MM/300MT/9.14KG

052-15-300
Livrare imediată!

49,00Lei

FIR JAXON XT-PRO PREMIUM 25m 0.08mm -29%
Exclusiv online!

FIR JAXON XT-PRO PREMIUM 25m 0.08mm

zj-xtp008c
Livrare 48-72 ore

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

FIR COLMIC HERAKLES FLR 150M 0.25mm
Exclusiv online!

FIR COLMIC HERAKLES FLR 150M 0.25mm

nyhkf25
Livrare 48-72 ore

85,00Lei

Fir Textil Jaxon SUMATO PREMIUM 10m 0.12mm

Fir Textil Jaxon SUMATO PREMIUM 10m 0.12mm

zj-rap012c
Livrare imediată!

11,00Lei

Fir Monofilament Jaxon Satori Feeder 150m, 0.25mm, 13kg

Fir Monofilament Jaxon Satori Feeder 150m, 0.25mm, 13kg

zj-saf025a
Livrare imediată!

21,00Lei

FIR MAVER SMART FLUOROCARBON 50M 0.14MM

FIR MAVER SMART FLUOROCARBON 50M 0.14MM

633014
Livrare imediată!

49,00Lei

FIR FLUOROCARBON KORDA IQ EXTRA SOFT 12LBS/20MT

FIR FLUOROCARBON KORDA IQ EXTRA SOFT 12LBS/20MT

a.kiqs12
Livrare imediată!

65,00Lei

FIR MONOFILAMENT PROLOGIC MIMICRY MIRAGE XP 038MM/11,3KG/1000M

FIR MONOFILAMENT PROLOGIC MIMICRY MIRAGE XP 038MM/11,3KG/1000M

a.pro.48437
Livrare imediată!

198,62Lei

FIR TEXTIL BERKLEY NEW 2014 FIRELINE GRI 025MM/17,5KG/110M -22%

FIR TEXTIL BERKLEY NEW 2014 FIRELINE GRI 025MM/17,5KG/110M

p.1308659
Livrare imediată!

79,49Lei(-22%) 61,90Lei

FIR COLMIC ALL ROUND NX50 150M 0.350mm
Exclusiv online!

FIR COLMIC ALL ROUND NX50 150M 0.350mm

nyal150350
Livrare 48-72 ore

37,00Lei

Afişare 2161 - 2180 din 9514 (476 pagini)
Queries: 4, Total time: 210.142 ms [By time] [By id] [By file]
1 (0.133)
SELECT data
FROM `oc_session`
WHERE session_id = 'ea33209ce0d23b9b6e42905ae5'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.121)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (209.737)
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 = '2' AND (MATCH(pd.tag) AGAINST('+fir' 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:737
4 (0.151)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '2' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38