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 Korda Basix Mainline 0.40mm, 15lb, 1000m

Fir Monofilament Korda Basix Mainline 0.40mm, 15lb, 1000m

a.kbx045
Livrare imediată!

69,66Lei

Carlige Korda Choddy Barbless Nr. 8
Exclusiv online!

Carlige Korda Choddy Barbless Nr. 8

k.kchb8
Livrare 24-48 ore

30,15Lei

Atractant Korda Goo Spicy Squid Power Bait Smoke 115Ml

Atractant Korda Goo Spicy Squid Power Bait Smoke 115Ml

a0.goo16
Livrare imediată!

95,58Lei

CROSETA KORDA BASIX PT. BOILIES VERDE

CROSETA KORDA BASIX PT. BOILIES VERDE

a.kbx023
Livrare imediată!

18,54Lei

CUTIE KORDA ACCESORII TACKLE BOX BUNDLE DEAL

CUTIE KORDA ACCESORII TACKLE BOX BUNDLE DEAL

a4.kbox16
Livrare imediată!

371,53Lei

Borseta Korda Semi-Rigida pentru Accesorii Compac 220 Kamo 28x20x12cm
Exclusiv online!

Borseta Korda Semi-Rigida pentru Accesorii Compac 220 Kamo 28x20x12cm

a4.klug23
Livrare 24-48 ore

125,41Lei

Carlige Korda Kamakura Wide Gape X Nr 8 10buc/cutie

Carlige Korda Kamakura Wide Gape X Nr 8 10buc/cutie

k.kam28
Livrare imediată!

41,77Lei

KICKER KORDA RIG ALIGNER VERDE 10BUC/PLIC MARIME M

KICKER KORDA RIG ALIGNER VERDE 10BUC/PLIC MARIME M

a.kick15
Livrare imediată!

27,83Lei

Tricou Korda Kore Digital Camo TK BLack Mar. XXL

Tricou Korda Kore Digital Camo TK BLack Mar. XXL

a8.kcl267
Livrare imediată!

130,07Lei

CACIULA KORDA CAMO
Exclusiv online!

CACIULA KORDA CAMO

a8.kbh09
Livrare 24-48 ore

74,32Lei

Vartej Rapid cu Anou Korda PTFE QC Ring, Nr.8, 8buc/plic
Exclusiv online!

Vartej Rapid cu Anou Korda PTFE QC Ring, Nr.8, 8buc/plic

a.kmw004
Livrare 24-48 ore

30,63Lei

Montura Korda Spinner Hook Sections Kurv Microbarbed Nr 6
Exclusiv online!

Montura Korda Spinner Hook Sections Kurv Microbarbed Nr 6

a.kcr131
Livrare 24-48 ore

27,80Lei

CON PROTECTIE KORDA BASIX ANTI TANGLE CAUCIUC 10BUC/PL

CON PROTECTIE KORDA BASIX ANTI TANGLE CAUCIUC 10BUC/PL

a.kbx025
Livrare imediată!

12,50Lei

Vartej cu Anou Korda PTFE, Nr.11, 8buc/plic
Exclusiv online!

Vartej cu Anou Korda PTFE, Nr.11, 8buc/plic

a.kmw001
Livrare 24-48 ore

30,62Lei

FIR TEXTIL KORDA SUB BRAID SINKING 20LBS/450M
Exclusiv online!

FIR TEXTIL KORDA SUB BRAID SINKING 20LBS/450M

a.sbb3
Livrare 24-48 ore

255,35Lei

Set ceai Korda Compac Tea
Exclusiv online!

Set ceai Korda Compac Tea

a4.klug13
Livrare 24-48 ore

209,06Lei

Carlige Korda Klor Nr.8, 10buc/pac -22%

Carlige Korda Klor Nr.8, 10buc/pac

k.klor8
Livrare imediată!

29,86Lei(-22%) 23,19Lei

HANORAC KORDA KORE BLACK ZIP MARIMEA XL
Exclusiv online!

HANORAC KORDA KORE BLACK ZIP MARIMEA XL

a8.kcl232
Livrare 24-48 ore

232,11Lei

SET KORDA MONTURA LEDCORE+PLUMB PIERDUT WEED 3BUC/PL

SET KORDA MONTURA LEDCORE+PLUMB PIERDUT WEED 3BUC/PL

a.llhqw
Livrare imediată!

41,78Lei

Surub cu Vartej Korda Micro Ring Bait Medium, 5buc/plic

Surub cu Vartej Korda Micro Ring Bait Medium, 5buc/plic

a.kmw008
Livrare imediată!

25,51Lei

Afişare 501 - 520 din 922 (47 pagini)
Queries: 10, Total time: 24.864 ms [By time] [By id] [By file]
1 (0.106)
SELECT data
FROM `oc_session`
WHERE session_id = '1a8b81bccdb74d8a6200515761'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.107)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (17.111)
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 (0.175)
SELECT COUNT(1) AS total
FROM ( SELECT p.*
FROM `oc_bf_tmp_product` AS p
WHERE match_filters = 1) AS t
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1561
5 (0.126)
SELECT *
FROM oc_url_alias
WHERE `query` = 'product_id=68314'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:169
6 (0.528)
SELECT DISTINCT m.manufacturer_id AS id, CONCAT(UCASE(LEFT(m.name, 1)), LCASE(SUBSTRING(m.name, 2))) AS name
FROM `oc_manufacturer` AS m
INNER JOIN `oc_bf_tmp_product` AS p ON (m.manufacturer_id = p.manufacturer_id)
WHERE match_filters = 1
ORDER BY m.sort_order, m.name
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:1248
7 (0.105)
SELECT stock_status_id AS id, name
FROM `oc_stock_status`
WHERE language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:1270
8 (0.237)
SELECT MIN(actual_price) AS min, MAX(actual_price) AS max
FROM `oc_bf_tmp_product` AS p
WHERE match_filters = 1
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:1035
9 (6.243)
SELECT COUNT(1) AS val, filter_group, filter_id
FROM `oc_bf_tmp_product` AS p
INNER JOIN `oc_bf_filter` AS f ON (p.product_id = f.product_id)
WHERE match_filters = 1 AND f.language_id = '2' GROUP BY filter_group, filter_id
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:949
10 (0.127)
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