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 - vu.2.5878

Produse ce potrivesc criteriilor de căutare


Ghete Kodra Kombat Maro, Marime 46
Exclusiv online!

Ghete Kodra Kombat Maro, Marime 46

a8.kcl514
Livrare 24-48 ore

597,48Lei

Porumb Artificial Korda Pop-Up Citrus Zing Orange 12buc/plic
Exclusiv online!

Porumb Artificial Korda Pop-Up Citrus Zing Orange 12buc/plic

a.kpb44
Livrare 24-48 ore

18,54Lei

Boilies Korda Artificial Essential Cell Slow Sinking Boilie 15mm, 9buc/pac
Exclusiv online!

Boilies Korda Artificial Essential Cell Slow Sinking Boilie 15mm, 9buc/pac

a.kpb50
Livrare 24-48 ore

19,87Lei

Korda Galeata Compac, 8L

Korda Galeata Compac, 8L

a.klug141
Livrare imediată!

78,69Lei

Line Aligner Korda Kicker X-Large Green, 10buc/pac
Exclusiv online!

Line Aligner Korda Kicker X-Large Green, 10buc/pac

a.kick17
Livrare 24-48 ore

26,82Lei

Boilies Korda Artificial Cell Slow Sinking Boilie 15mm, 9buc/pac
Exclusiv online!

Boilies Korda Artificial Cell Slow Sinking Boilie 15mm, 9buc/pac

a.kpb49
Livrare 24-48 ore

19,87Lei

Fir Monofilament Korda Basix Mainline 0.35mm, 12lb, 500m
Exclusiv online!

Fir Monofilament Korda Basix Mainline 0.35mm, 12lb, 500m

a.kbx008
Livrare 24-48 ore

37,00Lei

PLUMB KORDA CAST CU VARTEJ 91G
Exclusiv online!

PLUMB KORDA CAST CU VARTEJ 91G

a3.ktcs325
Livrare 24-48 ore

12,46Lei

Vartej Rapid cu Anou Korda Spinner Ring XX, Nr.11, 10buc/pac

Vartej Rapid cu Anou Korda Spinner Ring XX, Nr.11, 10buc/pac

a.kmw011
Livrare imediată!

23,11Lei

Carlige Legate Korda Loop Rigs Klor6 30lb, 3buc

Carlige Legate Korda Loop Rigs Klor6 30lb, 3buc

a.krr013
Livrare imediată!

25,43Lei

Fir Fluorocarbon Korda Boom Stiff Link Low Vis Green 15m, 0.45mm, 6.80kg

Fir Fluorocarbon Korda Boom Stiff Link Low Vis Green 15m, 0.45mm, 6.80kg

a.kboom45
Livrare imediată!

65,00Lei

Papuci Korda Kore Slip Ons Kamo Black, Marimea 40
Exclusiv online!

Papuci Korda Kore Slip Ons Kamo Black, Marimea 40

a8.kcl245
Livrare 24-48 ore

185,00Lei

Papuci Korda Kore Slip Ons Kamo Black, Marimea 41
Exclusiv online!

Papuci Korda Kore Slip Ons Kamo Black, Marimea 41

a8.kcl246
Livrare 24-48 ore

185,00Lei

Atractant Korda GOO Frutti Di Mare Supreme, 115ml
Exclusiv online!

Atractant Korda GOO Frutti Di Mare Supreme, 115ml

a0.goo51
Livrare 24-48 ore

95,58Lei

Carlige Legate Korda Loop Rigs Klor4 30lb, 3buc

Carlige Legate Korda Loop Rigs Klor4 30lb, 3buc

a.krr012
Livrare imediată!

25,43Lei

Protectie pentru Maner & Varf Lanseta Korda Camo
Exclusiv online!

Protectie pentru Maner & Varf Lanseta Korda Camo

a8.klug132
Livrare 24-48 ore

92,61Lei

Vartej Rapid cu Anou Korda PTFE Spinner Ring XX, Nr.11, 8buc/pac

Vartej Rapid cu Anou Korda PTFE Spinner Ring XX, Nr.11, 8buc/pac

a.kmw013
Livrare imediată!

32,38Lei

Clips pentru Monturi Korda Hook Klips 10buc/pac
Exclusiv online!

Clips pentru Monturi Korda Hook Klips 10buc/pac

a.kmw010
Livrare 24-48 ore

25,51Lei

Perna Korda Thermakore Camo, Marime L

Perna Korda Thermakore Camo, Marime L

a8.klug48
Livrare imediată!

166,81Lei

Vartej Rapid Korda Spinner XX, Nr.11, 10buc/pac
Exclusiv online!

Vartej Rapid Korda Spinner XX, Nr.11, 10buc/pac

a.kmw012
Livrare 24-48 ore

23,11Lei

Afişare 621 - 640 din 921 (47 pagini)
Queries: 11, Total time: 29.480 ms [By time] [By id] [By file]
1 (0.077)
SELECT data
FROM `oc_session`
WHERE session_id = '7bcafc36bfb33e46885e772717'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.092)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (0.101)
SELECT *
FROM oc_url_alias
WHERE keyword = 'search'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (18.135)
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
5 (0.172)
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
6 (3.649)
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 620, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
7 (0.524)
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
8 (0.092)
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
9 (0.206)
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
10 (6.333)
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
11 (0.099)
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