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 - cahkbr54

Produse ce potrivesc criteriilor de căutare


FIR JAXON CROCODILE SPINNING 150m 0.25mm

FIR JAXON CROCODILE SPINNING 150m 0.25mm

zj-crs025a
Livrare imediată!

12,99Lei

FIR TRABUCCO T-FORCE XPS ULTRA SOFT FC403 50MT 0.30MM

FIR TRABUCCO T-FORCE XPS ULTRA SOFT FC403 50MT 0.30MM

053-58-300
Livrare imediată!

65,00Lei

Fir monofilament Kryston Krystonite 0.36mm 1000m
Exclusiv online!

Fir monofilament Kryston Krystonite 0.36mm 1000m

krkry4
Livrare 48-72 ore

129,00Lei

FIR TRABUCCO T-FORCE XPS METHOD FEEDER 0.28-150M

FIR TRABUCCO T-FORCE XPS METHOD FEEDER 0.28-150M

053-96-280
Livrare imediată!

39,00Lei

FIR MONOFILAMENT CARP ZOOM FEEDER COMPETITION EXTREME 200M 0.23MM 7.45KG

FIR MONOFILAMENT CARP ZOOM FEEDER COMPETITION EXTREME 200M 0.23MM 7.45KG

cz2014
Livrare imediată!

19,00Lei

FIR MONOFILAMENT MAVER SMART TT 100M 0.14MM
Exclusiv online!

FIR MONOFILAMENT MAVER SMART TT 100M 0.14MM

731014
Livrare 48-72 ore

27,00Lei

FIR TEXTIL JAXON SUMATO FLUO 125m 0.18mm -21%

FIR TEXTIL JAXON SUMATO FLUO 125m 0.18mm

zj-raf018g
Livrare imediată!

76,01Lei(-21%) 59,90Lei

FIR TEXTIL KRYSTON JACKAL SEMI STIFF COATED 20M 20LB GRAWEL BROWN -21%

FIR TEXTIL KRYSTON JACKAL SEMI STIFF COATED 20M 20LB GRAWEL BROWN

krja3
Livrare imediată!

62,00Lei(-21%) 48,90Lei

Fir Fluorocarbon Sufix Super 21 150m, 0.14mm, 2.00kg
Exclusiv online!

Fir Fluorocarbon Sufix Super 21 150m, 0.14mm, 2.00kg

ds1in015924b2s
Livrare 48-72ore

79,00Lei

Fir Carp Expert Camou 600m 0.25mm

Fir Carp Expert Camou 600m 0.25mm

30103625
Livrare imediată!

25,00Lei

Fir Monofilament Gamakatsu G-line Maro 0.26mm/1855m/5.0kg
Exclusiv online!

Fir Monofilament Gamakatsu G-line Maro 0.26mm/1855m/5.0kg

gk.5110.026
Livrare 24-48 ore

72,94Lei

FIR SAVAGE SOFT FLUOROCARBON 039MM 9.4KG 35M

FIR SAVAGE SOFT FLUOROCARBON 039MM 9.4KG 35M

a.sg.54852
Livrare imediată!

70,58Lei

SAC PVA JAXON PERFORAT CU FIR JAXON 70*100mm
Exclusiv online!

SAC PVA JAXON PERFORAT CU FIR JAXON 70*100mm

lc-pva053
Livrare 48-72 ore

25,00Lei

FIR COLMIC STEEL RESISTANCE NX80 150M 0.35mm
Exclusiv online!

FIR COLMIC STEEL RESISTANCE NX80 150M 0.35mm

nyst15035
Livrare 48-72 ore

62,00Lei

FIR JAXON SATORI PREMIUM 0.20mm 25m
Exclusiv online!

FIR JAXON SATORI PREMIUM 0.20mm 25m

zj-sap020c
Livrare 48-72 ore

7,00Lei

FIR TEXTIL BERKLEY FIRELINE SMOKE 0.25MM 110M -20%
Exclusiv online!

FIR TEXTIL BERKLEY FIRELINE SMOKE 0.25MM 110M

1308659
Livrare 48-72 ore

76,70Lei(-20%) 61,36Lei

FIR TEXTIL JAXON SUMATO FLUO 125m 0.28mm 33.00 kg
Exclusiv online!

FIR TEXTIL JAXON SUMATO FLUO 125m 0.28mm 33.00 kg

zj-raf028g
Livrare 48-72 ore

76,01Lei

FIR SUFIX FEEDER MONO BURGUNDY 300M 0.14MM
Exclusiv online!

FIR SUFIX FEEDER MONO BURGUNDY 300M 0.14MM

sfm14bu300
Livrare 48-72ore

40,00Lei

Fir Erson Taifun 200m 0.30mm

Fir Erson Taifun 200m 0.30mm

30091030
Livrare imediată!

12,00Lei

FIR COLMIC OKY 150M 0.25mm
Exclusiv online!

FIR COLMIC OKY 150M 0.25mm

nyok025
Livrare 48-72 ore

13,49Lei

Afişare 3521 - 3540 din 9511 (476 pagini)
Queries: 8, Total time: 365.509 ms [By time] [By id] [By file]
1 (0.116)
SELECT data
FROM `oc_session`
WHERE session_id = 'aa014304a51a43dfa64cda91a8'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.098)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (0.090)
SELECT *
FROM oc_url_alias
WHERE keyword = 'search'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (329.140)
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('+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:722
5 (35.699)
SELECT p.*, pp.sort_order, pp.viewed, IF ((pp.quantity) > 0, 1, 0) AS array_quantity
FROM `oc_bf_tmp_product` AS p
INNER JOIN `oc_product_description` AS pd ON (pd.product_id = p.product_id)
INNER JOIN `oc_product` AS pp ON (pp.product_id = p.product_id)
WHERE match_filters = 1 AND pd.language_id = '2'
ORDER BY array_quantity DESC, pp.sort_order ASC, pp.viewed DESC, pd.name ASC LIMIT 3520, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
6 (0.115)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"RAPALA VMC ROMANIA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
7 (0.107)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"RAPALA VMC ROMANIA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
8 (0.144)
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