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

Produse ce potrivesc criteriilor de căutare


JACHETA KORDA KORE THERMOLITE Negru MAR.XL
Exclusiv online!

JACHETA KORDA KORE THERMOLITE Negru MAR.XL

a8.kcl469
Livrare 24-48 ore

708,79Lei

JACHETA BLASER SHERPA FLEECE DARK OLIVE MAR.XL
Exclusiv online!

JACHETA BLASER SHERPA FLEECE DARK OLIVE MAR.XL

bl.122030.009.xl
Livrare 24-48 ore

1.077,18Lei

TRICOU, SAVAGE, GEAR, NIGHT, UV, BLACK, WATERPRINT, MAR.XL, a8.sg.73901, Tricouri, Tricouri Savage Gear, Savage Gear -40%
Exclusiv online!

TRICOU, SAVAGE, GEAR, NIGHT, UV, BLACK, WATERPRINT, MAR.XL, a8.sg.73901, Tricouri, Tricouri Savage Gear, Savage Gear

a8.sg.73901
Livrare 24-48 ore

148,63Lei(-40%) 89,18Lei

HANORAC SAVAGE GEAR FIGHTER STRETCH BURNT OLIVE MELANGE MAR.XL

HANORAC SAVAGE GEAR FIGHTER STRETCH BURNT OLIVE MELANGE MAR.XL

a8.sg.73896
Livrare imediată!

142,06Lei

HANORAC, , KORDA, KORE, ZIP, PRO, OLIVE, MAR.XL, a8.kcl752, Hanorace, Hanorace Korda, Korda

HANORAC, , KORDA, KORE, ZIP, PRO, OLIVE, MAR.XL, a8.kcl752, Hanorace, Hanorace Korda, Korda

a8.kcl752
Livrare imediată!

301,63Lei

TRICOU SAVAGE GEAR FIGHTER STRETCH BURNT OLIVE MELANGE MAR.XL -20%
Exclusiv online!

TRICOU SAVAGE GEAR FIGHTER STRETCH BURNT OLIVE MELANGE MAR.XL

a8.sg.73891
Livrare 24-48 ore

134,10Lei(-20%) 107,28Lei

SHORT SAVAGE GEAR MARINE SEA BLUE MAR.XL -20%
Exclusiv online!

SHORT SAVAGE GEAR MARINE SEA BLUE MAR.XL

a8.sg.73917
Livrare 24-48 ore

189,94Lei(-20%) 151,95Lei

COSTUM PROLOGIC COMFORT THERMO MAX5 2 BUC MAR.XL -10%
Exclusiv online!

COSTUM PROLOGIC COMFORT THERMO MAX5 2 BUC MAR.XL

a8.pro.48045
Livrare 24-48 ore

978,76Lei(-10%) 880,89Lei

JACHETA, PROLOGIC, COMMANDER, FLEECE, MAR.XL, a8.pro.49477, Geci si Jachete, Geci si Jachete Prologic, Prologic

JACHETA, PROLOGIC, COMMANDER, FLEECE, MAR.XL, a8.pro.49477, Geci si Jachete, Geci si Jachete Prologic, Prologic

a8.pro.49477
Livrare imediată!

333,56Lei

PANTALON PROLOGIC CARGO MAR.XL -23%

PANTALON PROLOGIC CARGO MAR.XL

a8.pro.51534
Livrare imediată!

259,49Lei(-23%) 199,90Lei

TRICOU, PROLOGIC, BANK, BOUND, CUSTOM, MAR.XL, a8.pro.59480, Tricouri, Tricouri Prologic, Prologic -20%
Exclusiv online!

TRICOU, PROLOGIC, BANK, BOUND, CUSTOM, MAR.XL, a8.pro.59480, Tricouri, Tricouri Prologic, Prologic

a8.pro.59480
Livrare 24-48 ore

48,83Lei(-20%) 39,06Lei

MANUSI OKUMA MOTIF MAR.XL
Exclusiv online!

MANUSI OKUMA MOTIF MAR.XL

a8.okr.f001w.xl
Livrare 24-48 ore

82,57Lei

MANUSI SAVAGE SUPER STRETCH NEOPREN MAR.XL -20%
Exclusiv online!

MANUSI SAVAGE SUPER STRETCH NEOPREN MAR.XL

a8.sg.59208
Livrare 24-48 ore

144,00Lei(-20%) 115,20Lei

PELERINA, ARROW, LUNGA, KAKI, MAR.XL, a8.pel.kl.xl, Pelerine si costume ploaie, Pelerine si costume ploaie Arrow, Arrow
Exclusiv online!

PELERINA, ARROW, LUNGA, KAKI, MAR.XL, a8.pel.kl.xl, Pelerine si costume ploaie, Pelerine si costume ploaie Arrow, Arrow

a8.pel.kl.xl
Livrare 24-48 ore

101,64Lei

MANUSI, MUSTAD, CASTING, MAR.XL, a8.gl002.xl, Manusi Ciorapi, Manusi Ciorapi Mustad, Mustad
Exclusiv online!

MANUSI, MUSTAD, CASTING, MAR.XL, a8.gl002.xl, Manusi Ciorapi, Manusi Ciorapi Mustad, Mustad

a8.gl002.xl
Livrare 24-48 ore

121,37Lei

MANUSI MUSTAD LANDING MAR.XL
Exclusiv online!

MANUSI MUSTAD LANDING MAR.XL

a8.gl001.xl
Livrare 24-48 ore

106,91Lei

MANUSI MUSTAD SUN MAR.XL
Exclusiv online!

MANUSI MUSTAD SUN MAR.XL

a8.gl003.xl
Livrare 24-48 ore

87,80Lei

TRICOU, SAVAGE, SIMPLY, SAVAGE, POLO, BLEUMARIN, MAR.XL, a8.sg.62283, Tricouri, Tricouri Savage Gear, Savage Gear
Exclusiv online!

TRICOU, SAVAGE, SIMPLY, SAVAGE, POLO, BLEUMARIN, MAR.XL, a8.sg.62283, Tricouri, Tricouri Savage Gear, Savage Gear

a8.sg.62283
Livrare 24-48 ore

141,96Lei

MOMITOR FEEDER LINEAEFFE SPYRAL MAR.XL

MOMITOR FEEDER LINEAEFFE SPYRAL MAR.XL

a.4922430
Livrare imediată!

2,81Lei

TRICOU GURU GRADIENT LOGO BLACK MAR.XL
Exclusiv online!

TRICOU GURU GRADIENT LOGO BLACK MAR.XL

a8.gu.gcl214
Livrare 24-48 ore

130,07Lei

Afişare 21 - 40 din 68 (4 pagini)
Queries: 6, Total time: 195.821 ms [By time] [By id] [By file]
1 (0.133)
SELECT data
FROM `oc_session`
WHERE session_id = 'ac1f800798afd611e5e15fb8a5'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.102)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:427
3 (0.121)
SELECT *
FROM oc_url_alias
WHERE keyword = 'search'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (194.856)
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 "%mar.xl%") 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
5 (0.471)
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 20, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
6 (0.138)
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