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

Produse ce potrivesc criteriilor de căutare


CARLIGE, LEGATE, FOX, Edge, Armapoint, stiff, rig, beaked, Chod, rigs, 30lb, sz4, SHORT, 3BUC, ccr162, Monturi Crap, Monturi Crap Fox, Fox
Carlige, Mustad, Crap, XV2, Chodda, Ochet, Black, Nikel,, Nr.4,, 10buc/pac, m.60554nptx.4, Carlige Crap, Carlige Crap Mustad, Carlige Mustad, Crap Mustad, Mustad
CHOD TOOL KORDA

CHOD TOOL KORDA

a.kcit
Livrare imediată!

33,43Lei

CARLIGE GAMAKATSU G-CARP WIDE GAPE SUPER (CHODDY) NR 8 / 10BUC PER PLIC

CARLIGE GAMAKATSU G-CARP WIDE GAPE SUPER (CHODDY) NR 8 / 10BUC PER PLIC

185034-00800-00000
Livrare imediată!

24,00Lei

MONTURA KORDA CHOD RIG LUNG NR 8 25LB 3BUC PL

MONTURA KORDA CHOD RIG LUNG NR 8 25LB 3BUC PL

a.kcr022
Livrare imediată!

32,89Lei

CARLIGE GAMAKATSU G-CARP WIDE GAPE SUPER (CHODDY) NR 6 / 10BUC PER PLIC

CARLIGE GAMAKATSU G-CARP WIDE GAPE SUPER (CHODDY) NR 6 / 10BUC PER PLIC

185034-00600-00000
Livrare imediată!

24,00Lei

PB HELI-CHOD HOODS GRAVEL

PB HELI-CHOD HOODS GRAVEL

chg05
Livrare imediată!

16,01Lei

ROLE NGT EVA CHOD ZIG BIN 10 ROLLE CUTIE

ROLE NGT EVA CHOD ZIG BIN 10 ROLLE CUTIE

ngt-fla-rig-950
Livrare imediată!

30,00Lei

CARLIG, KORDA, KAMAKURA, CHODDY, MICROBARBED, NR.8, 10BUC/PL, k.kam13, Carlige Crap, Carlige Crap Korda, Korda
Exclusiv online!

CARLIG, KORDA, KAMAKURA, CHODDY, MICROBARBED, NR.8, 10BUC/PL, k.kam13, Carlige Crap, Carlige Crap Korda, Korda

k.kam13
Livrare 24-48 ore

41,78Lei

CIRLIGE KORDA CHODDY NR.8 10BUC/PLIC

CIRLIGE KORDA CHODDY NR.8 10BUC/PLIC

k.kch8
Livrare imediată!

30,15Lei

CARLIG, KORDA, KAMAKURA, CHODDY, MICROBARBED, NR.6, 10BUC/PL, k.kam14, Carlige Crap, Carlige Crap Korda, Korda
MONTURA KORDA CHOD RIG SCURT NR.4 20LB 3BUC PL

MONTURA KORDA CHOD RIG SCURT NR.4 20LB 3BUC PL

a.kcr016
Livrare imediată!

33,22Lei

CARLIGE, MUSTAD, CARP, XV2, CHODDA, NR, 6, 10BUC, m.60554nptx.6, Carlige Crap, Carlige Crap Mustad, Mustad

CARLIGE, MUSTAD, CARP, XV2, CHODDA, NR, 6, 10BUC, m.60554nptx.6, Carlige Crap, Carlige Crap Mustad, Mustad

m.60554nptx.6
Livrare imediată!

15,66Lei

NAKED CHOD KORDA SYSTEM 3BUC/PL
Exclusiv online!

NAKED CHOD KORDA SYSTEM 3BUC/PL

a.kncs
Livrare 24-48 ore

37,13Lei

Carlige Korda Krank Choddy Nr10 10buc/plic

Carlige Korda Krank Choddy Nr10 10buc/plic

k.krch10
Livrare imediată!

30,15Lei

CARLIGE, KORDA, KRANK, CHODY, NR, 8, /10BUC, k.krch8, Carlige Crap, Carlige Crap Korda, Korda

CARLIGE, KORDA, KRANK, CHODY, NR, 8, /10BUC, k.krch8, Carlige Crap, Carlige Crap Korda, Korda

k.krch8
Livrare imediată!

30,15Lei

Anouri Carp Expert Rotunde D-Rig Chod Rig Nr.2 (20buc)

Anouri Carp Expert Rotunde D-Rig Chod Rig Nr.2 (20buc)

82197202
Livrare imediată!

8,00Lei

CARLIG, KORDA, KAMAKURA, CHODDY, MICROBARBED, NR.4, 10BUC/PL, k.kam15, Carlige Crap, Carlige Crap Korda, Korda
PROTECTIE, MONTURA, KORDA, CHODD, RIG, 8BUC/PL, , , a.klsb, Alte Accesorii Monturi, Alte Accesorii Monturi Korda, Korda
Exclusiv online!

PROTECTIE, MONTURA, KORDA, CHODD, RIG, 8BUC/PL, , , a.klsb, Alte Accesorii Monturi, Alte Accesorii Monturi Korda, Korda

a.klsb
Livrare 24-48 ore

25,51Lei

FIR, PB, CHOD-MONO, 15LB, 20M, 0.40MM, chmo15, Fire Monturi Crap, Fire Monturi Crap PB Products, PB Products -38%

FIR, PB, CHOD-MONO, 15LB, 20M, 0.40MM, chmo15, Fire Monturi Crap, Fire Monturi Crap PB Products, PB Products

chmo15
Livrare imediată!

42,00Lei(-38%) 25,89Lei

Afişare 81 - 100 din 187 (10 pagini)
Queries: 13, Total time: 216.829 ms [By time] [By id] [By file]
1 (0.088)
SELECT data
FROM `oc_session`
WHERE session_id = '1fed5c5a3d9c182aeacb9cd7e6'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.091)
SELECT *
FROM oc_platforma_promovari LIMIT 1
/var/www/clients/client1/web1/web/index.php:128
3 (0.109)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:422
4 (213.007)
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 = '2' AND (pd.tag LIKE "%chod%") 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.146)
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:1555
6 (1.053)
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 80, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
7 (0.340)
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:1209
8 (0.088)
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:1231
9 (0.097)
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:996
10 (1.553)
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:910
11 (0.081)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
12 (0.086)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
13 (0.090)
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