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 PREMIUM 150m 0.10mm

FIR JAXON CROCODILE PREMIUM 150m 0.10mm

zj-crp010a
Livrare imediată!

10,00Lei

Varga Daiwa Ninja, 5.00m

Varga Daiwa Ninja, 5.00m

d.11628.510
Livrare imediată!

230,43Lei

FIR JAXON SATORI PREMIUM 0.12mm 25m

FIR JAXON SATORI PREMIUM 0.12mm 25m

zj-sap012c
Livrare imediată!

7,00Lei

Fir Cralusso Fluorocarbon Transparent, 0.30mm, 7.55kg, 30+10m

Fir Cralusso Fluorocarbon Transparent, 0.30mm, 7.55kg, 30+10m

33901530
Livrare imediată!

46,01Lei

Fir Jaxon Crocodile Premium 0.45mm/150m/30kg

Fir Jaxon Crocodile Premium 0.45mm/150m/30kg

zj-crp045a
Livrare imediată!

19,00Lei

VARGA LINEAEFFE CARBON 5.00M 25G
Exclusiv online!

VARGA LINEAEFFE CARBON 5.00M 25G

l.2518305
Livrare 24-48 ore

138,80Lei

FIR MONOFILAMENT JAXON URAN POWER 125m 0.45mm

FIR MONOFILAMENT JAXON URAN POWER 125m 0.45mm

zj-urp045g
Livrare imediată!

19,00Lei

FIR JAXON CROCODILE FLUOROCARBON COATED 25m 0.16mm

FIR JAXON CROCODILE FLUOROCARBON COATED 25m 0.16mm

zj-crfc016
Livrare imediată!

4,50Lei

Varga Nevis Patriot 5m -24%

Varga Nevis Patriot 5m

1643-500
Livrare imediată!

229,00Lei(-24%) 173,89Lei

FIR MONOFILAMENT CARBOTEX FLUOROCARBON 018MM/4,25KG/30M

FIR MONOFILAMENT CARBOTEX FLUOROCARBON 018MM/4,25KG/30M

e.3000.018
Livrare imediată!

14,49Lei

Fir Owner Broad Fluorine Treated 0.14mm 150m

Fir Owner Broad Fluorine Treated 0.14mm 150m

11070256045-014
Livrare imediată!

44,82Lei

FIR JAXON CARAT PREMIUM 25 M 0.14 MM

FIR JAXON CARAT PREMIUM 25 M 0.14 MM

zj-kap014c
Livrare imediată!

5,70Lei

Fir Cralusso Fluorocarbon Transparent, 0.20mm, 3.90kg, 30+10m
Exclusiv online!

Fir Cralusso Fluorocarbon Transparent, 0.20mm, 3.90kg, 30+10m

33901520
Livrare 24-48 ore

37,00Lei

Fir Toray Ultimate PA Clear 0185mm

Fir Toray Ultimate PA Clear 0185mm

604210017
Livrare imediată!

17,78Lei

Varga Telescopica DAM Composite Carbon 5.00m
Exclusiv online!

Varga Telescopica DAM Composite Carbon 5.00m

dam.56105
Livrare 24-48 ore

155,15Lei

FIR COLMIC FORMER 600M 0.40mm

FIR COLMIC FORMER 600M 0.40mm

nyfo640
Livrare imediată!

96,00Lei

Fir Fluorocarbon Jaxon Satori Premium Clear, 20m, 0.20mm, 8kg

Fir Fluorocarbon Jaxon Satori Premium Clear, 20m, 0.20mm, 8kg

zj-sagp020f
Livrare imediată!

24,00Lei

FIR MONOFILAMENT MAVER 619 COMPETITION 0.165MM, 150M -49%

FIR MONOFILAMENT MAVER 619 COMPETITION 0.165MM, 150M

663165
Livrare imediată!

39,00Lei(-49%) 19,90Lei

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 Carbotex Bison 0.22MM/5,20KG/100M

Fir monofilament Carbotex Bison 0.22MM/5,20KG/100M

e.6000.022
Livrare imediată!

5,09Lei

Afişare 461 - 480 din 2160 (108 pagini)
Queries: 5, Total time: 79.791 ms [By time] [By id] [By file]
1 (0.187)
SELECT data
FROM `oc_session`
WHERE session_id = '40606322a181c45518ba066345'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.141)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (71.040)
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('+varga' 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 (8.267)
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 460, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.156)
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