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


JACHETA KORDA KORE DRYKORE BLACK MARIME XL

JACHETA KORDA KORE DRYKORE BLACK MARIME XL

a8.kcl409
Stoc epuizat

879,60Lei

PALARIE KORDA WATERPROOF OLIVE

PALARIE KORDA WATERPROOF OLIVE

a8.kbh30
Stoc epuizat

102,19Lei

FIR Monofilament Conic KORDA LEADER LONGCHUCK 0.30-0.47mm, 10x5m/50m

FIR Monofilament Conic KORDA LEADER LONGCHUCK 0.30-0.47mm, 10x5m/50m

a.kdcm06
Stoc epuizat

65,00Lei

FIR Monofilament Conic KORDA LEADER LONGCHUCK 0.27-0.47mm, 10x5m/50m

FIR Monofilament Conic KORDA LEADER LONGCHUCK 0.27-0.47mm, 10x5m/50m

a.kdcm05
Stoc epuizat

65,00Lei

MONOFILAMENT KORDA LONGCHUCK 0.33-0.47MM

MONOFILAMENT KORDA LONGCHUCK 0.33-0.47MM

a.kdcm10
Stoc epuizat

65,00Lei

KORDA LEADER DURAKORD DYNEEMA 65LB ROLA 20M

KORDA LEADER DURAKORD DYNEEMA 65LB ROLA 20M

a.dura65
Stoc epuizat

96,59Lei

CARLIG KORDA BASIX WIDE GAPE NR.2 10BUC/PL

CARLIG KORDA BASIX WIDE GAPE NR.2 10BUC/PL

k.kbx026
Stoc epuizat

15,30Lei

FIR INAINTAS KORDA MONOFILAMENT KORDA XT SNAG LEADER SUBLINE BROWN 0.65mm 27.21kg 100M
TRICOU KORDA LIGHT KAMO, MAR.S

TRICOU KORDA LIGHT KAMO, MAR.S

a8.kcl352
Stoc epuizat

148,65Lei

TRICOU KORDA LOYAL MAR.M

TRICOU KORDA LOYAL MAR.M

a8.kcl553
Stoc epuizat

130,10Lei

TRICOU KORDA LIGHT KAMO MAR.L

TRICOU KORDA LIGHT KAMO MAR.L

a8.kcl354
Livrare imediată!

148,65Lei

MONOFILAMENT KORDA LONGCHUCK 0.27-0.47MM, 300M, 4.5-13.6KG

MONOFILAMENT KORDA LONGCHUCK 0.27-0.47MM, 300M, 4.5-13.6KG

a.kdcm08
Stoc epuizat

65,00Lei

MONTURA KORDA BASIX WIDE GAPE BARBLESS 4/25LB 2BUC/PLIC

MONTURA KORDA BASIX WIDE GAPE BARBLESS 4/25LB 2BUC/PLIC

a.kbx017
Stoc epuizat

18,50Lei

PALARIE KORDA WATERPROOF BURGUNDY

PALARIE KORDA WATERPROOF BURGUNDY

a8.kbh15
Stoc epuizat

102,19Lei

MONTURA KORDA BASIX WIDE GAPE BARBLESS 6/18LB 2BUC/PLIC

MONTURA KORDA BASIX WIDE GAPE BARBLESS 6/18LB 2BUC/PLIC

a.kbx018
Stoc epuizat

18,50Lei

Prosop Korda Microfibre Towel

Prosop Korda Microfibre Towel

a8.kda001
Stoc epuizat

55,72Lei

HUSA INDIVIDUALA KORDA COMPAC PADDED SLEEVE LANSETA+MULINETA 163X26X5CM

HUSA INDIVIDUALA KORDA COMPAC PADDED SLEEVE LANSETA+MULINETA 163X26X5CM

a8.klug54
Stoc epuizat

185,22Lei

JACHETA KORDA KORE THERMOLITE OLIVE, MAR.XXL

JACHETA KORDA KORE THERMOLITE OLIVE, MAR.XXL

a8.kcl464
Stoc epuizat

708,79Lei

JACHETA KORDA KORE THERMOLITE OLIVE, MAR.XL

JACHETA KORDA KORE THERMOLITE OLIVE, MAR.XL

a8.kcl463
Stoc epuizat

599,47Lei

PALARIE KORDA LE BOONIE WATERPROOF OLIVE

PALARIE KORDA LE BOONIE WATERPROOF OLIVE

a8.kbh20
Stoc epuizat

105,01Lei

Afişare 681 - 700 din 921 (47 pagini)
Queries: 5, Total time: 22.666 ms [By time] [By id] [By file]
1 (0.144)
SELECT data
FROM `oc_session`
WHERE session_id = 'dde5d86cf986bd6e7e56649e45'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.089)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (18.440)
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('+korda' 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 (3.860)
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 680, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.133)
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