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


Opritoare Gamakatsu Pole Position Heli Chod Buffer Sleeve, Marime L, 5buc/pac
Exclusiv online!

Opritoare Gamakatsu Pole Position Heli Chod Buffer Sleeve, Marime L, 5buc/pac

a.gk.8036.720
Livrare 24-48 ore

15,82Lei

Carlige Legate cu Inel Gamakatsu Bait Band Rig Allround G1, Nr.12, 0.16mm, 6buc/pac
Exclusiv online!

Carlige Legate cu Inel Gamakatsu Bait Band Rig Allround G1, Nr.12, 0.16mm, 6buc/pac

gk.140327.12
Livrare 24-48 ore

25,64Lei

Carlige Legate cu Inel Gamakatsu Bait Band Rig Allround G1, Nr.8, 0.20mm, 6buc/pac
Exclusiv online!

Carlige Legate cu Inel Gamakatsu Bait Band Rig Allround G1, Nr.8, 0.20mm, 6buc/pac

gk.140327.8
Livrare 24-48 ore

25,64Lei

Carlige Legate cu Inel Gamakatsu Bait Band Rig Allround G1, Nr.10, 0.18mm, 6buc/pac
Exclusiv online!

Carlige Legate cu Inel Gamakatsu Bait Band Rig Allround G1, Nr.10, 0.18mm, 6buc/pac

gk.140327.10
Livrare 24-48 ore

25,64Lei

ANCORA NR 8 GAMAKATSU LEGATA CU FIR TEXTIL 5CM 12KG

ANCORA NR 8 GAMAKATSU LEGATA CU FIR TEXTIL 5CM 12KG

004624-02500-00000
Livrare imediată!

13,30Lei

CARLIGE LEGATE STRATEGY GAMAKATSU ALIGNER 2 BUC NR 6

CARLIGE LEGATE STRATEGY GAMAKATSU ALIGNER 2 BUC NR 6

008541-00706-00000
Livrare imediată!

24,00Lei

CARLIGE LEGATE STRATEGY GAMAKATSU ALIGNER 2 BUC NR 8 -29%

CARLIGE LEGATE STRATEGY GAMAKATSU ALIGNER 2 BUC NR 8

008541-00708-00000
Livrare imediată!

24,00Lei(-29%) 16,99Lei

CARLIGE LEGATE STRATEGY GAMAKATSU ALIGNER 2 BUC NR 4 -29%

CARLIGE LEGATE STRATEGY GAMAKATSU ALIGNER 2 BUC NR 4

008541-00704-00000
Livrare imediată!

24,00Lei(-29%) 16,99Lei

CARLIGE LEGATE STRATEGY GAMAKATSU BASIC SUPER 2 BUC NR 2

CARLIGE LEGATE STRATEGY GAMAKATSU BASIC SUPER 2 BUC NR 2

008541-00102-00000
Livrare imediată!

13,60Lei

CARLIGE LEGATE STRATEGY GAMAKATSU COMBI POP UP 2 BUC NR 2
Exclusiv online!

CARLIGE LEGATE STRATEGY GAMAKATSU COMBI POP UP 2 BUC NR 2

008541-00602-00000
Livrare 48-72 ore

18,60Lei

MONTURA GAMAKATSU BR Nr.12 0.16MM 100CM
Exclusiv online!

MONTURA GAMAKATSU BR Nr.12 0.16MM 100CM

gk.180021.12
Livrare 24-48 ore

17,34Lei

MONTURA GAMAKATSU BR CARP Nr.4/0 2BUC/PLIC
Exclusiv online!

MONTURA GAMAKATSU BR CARP Nr.4/0 2BUC/PLIC

gk.180016.4
Livrare 24-48 ore

17,54Lei

AGRAFA+VARTEJ GAMAKATSU EZ-SNAP 1 11KG 5BUC/PL
Exclusiv online!

AGRAFA+VARTEJ GAMAKATSU EZ-SNAP 1 11KG 5BUC/PL

a7.gk149321.1
Livrare 24-48 ore

24,34Lei

Carlige, Legate, Gamakatsu, Power, Carp, nr.10, 10buc/plic, gk.180037.10.18, Monturi Crap, Monturi Crap Gamakatsu, Monturi Gamakatsu, Crap Gamakatsu, Gamakatsu
MONTURA GAMAKATSU BOILIE 3313NS NR.2 0.25MM 20CM 2BUC/PLIC
Exclusiv online!

MONTURA GAMAKATSU BOILIE 3313NS NR.2 0.25MM 20CM 2BUC/PLIC

gk.180016.2
Livrare 24-48 ore

17,54Lei

MONTURA GAMAKATSU BOILIE 3313NS NR.1 0.25MM 20CM 2BUC/PLIC
Exclusiv online!

MONTURA GAMAKATSU BOILIE 3313NS NR.1 0.25MM 20CM 2BUC/PLIC

gk.180016.1
Livrare 24-48 ore

17,54Lei

CARLIGE LEGATE GAMAKATSU MONT. BOILIE 3313NS NR.6 0.25MM/20CM 2BUC/PL
Exclusiv online!

CARLIGE LEGATE GAMAKATSU MONT. BOILIE 3313NS NR.6 0.25MM/20CM 2BUC/PL

gk.180016.6
Livrare 24-48 ore

17,54Lei

Montura Gamakatsu Method Hair nr.12 0.22 12cm 6buc/plic
Exclusiv online!

Montura Gamakatsu Method Hair nr.12 0.22 12cm 6buc/plic

gk.180052.12
Livrare 24-48 ore

16,14Lei

Montura Gamakatsu Method Hair nr.8 12cm 6buc/plic

Montura Gamakatsu Method Hair nr.8 12cm 6buc/plic

gk.180052.8
Livrare imediată!

17,28Lei

Montura Gamakatsu ethod Hair nr.10 12cm 6buc/plic
Exclusiv online!

Montura Gamakatsu ethod Hair nr.10 12cm 6buc/plic

gk.180053.10
Livrare 24-48 ore

21,27Lei

Afişare 1 - 20 din 21 (2 pagini)
Queries: 5, Total time: 242.167 ms [By time] [By id] [By file]
1 (0.093)
SELECT data
FROM `oc_session`
WHERE session_id = 'a4f70dfcee000f2e7e0ceca6d4'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.126)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:427
3 (241.508)
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 '%monturi%' AND pd.tag LIKE '%gamakatsu%')) 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
4 (0.347)
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 0, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.093)
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