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


Rotativa, Magic, Trout, 3.6g, 2.5cm, Bloody, Spinner, Negru/Alb, , 3369004, Lingurite Pastrav, Lingurite Pastrav Zebco, Zebco
Rotativa, Magic, Trout, 3.6g, 2.5cm, Bloody, Spinner, Galben/Verde, , 3369003, Lingurite Pastrav, Lingurite Pastrav Zebco, Zebco -44%
Rotativa, Magic, Trout, 3.6g, 2.5cm, Bloody, Spinner, Roz/Alb, 3369006, Lingurite Pastrav, Lingurite Pastrav Zebco, Zebco -59%

Rotativa, Magic, Trout, 3.6g, 2.5cm, Bloody, Spinner, Roz/Alb, 3369006, Lingurite Pastrav, Lingurite Pastrav Zebco, Zebco

3369006
Livrare imediată!

26,78Lei(-59%) 10,90Lei

Rotativa, Magic, Trout, 3.6g, 2.5cm, Bloody, Spinner, Rosu/Galben, , , 3369001, Lingurite Pastrav, Lingurite Pastrav Zebco, Zebco
Ochelari Polarizati Norfin NF-2010 Galben
Exclusiv online!

Ochelari Polarizati Norfin NF-2010 Galben

nf-2010
Livrare 48-72ore

71,00Lei

VARF DAIWA PENTRU NINJA X FEEDER GALBEN

VARF DAIWA PENTRU NINJA X FEEDER GALBEN

d.11605.001y
Livrare imediată!

40,86Lei

Wafter 220Baits 6 mm Capsuni Krill 35 ml Alb & Portocaliu

Wafter 220Baits 6 mm Capsuni Krill 35 ml Alb & Portocaliu

5152226497470
Livrare imediată!

25,00Lei

SHAD JACKALL RHYTHM WAVE 3,8INCH SEXY ALBINO 7BUC/PL -20%
Exclusiv online!

SHAD JACKALL RHYTHM WAVE 3,8INCH SEXY ALBINO 7BUC/PL

f1.ja.807128680
Livrare 24-48 ore

50,92Lei(-20%) 40,75Lei

Ochelari Polarizati Norfin Feeder Concept Verde+Galben
Exclusiv online!

Ochelari Polarizati Norfin Feeder Concept Verde+Galben

nf-fc2001
Livrare 48-72ore

125,00Lei

HANGER TRAKKO DLX CULOARE GALBEN
Exclusiv online!

HANGER TRAKKO DLX CULOARE GALBEN

1503
Livrare 48-72ore

18,50Lei

Shad, Lake, Fork, Sickle, Tail, Baby, Shad, 5.6cm, inch.Albino, Shad, 15buc/plic, 01-2600-330, Shad-uri, Shad-uri Lake Fork, Lake Fork
Dumbels, Flotant, Prowess, Eva, Galben, 8mm, 10buc/pac, 40833prcah0015, Porumb Artificial, Porumb Artificial Prowess, Porumb Prowess, Artificial Prowess, Prowess
Ochelari Polarizati Lucky John Galben
Exclusiv online!

Ochelari Polarizati Lucky John Galben

nf-lj2003
Livrare 48-72ore

71,00Lei

Papuci Delphin OCTO Albastru Marime 44 -18%

Papuci Delphin OCTO Albastru Marime 44

101002466
Livrare imediată!

61,00Lei(-18%) 49,90Lei

Papuci Delphin OCTO Albastru Marime 37

Papuci Delphin OCTO Albastru Marime 37

101002461
Livrare imediată!

61,00Lei

Papuci Delphin OCTO Albastru Marime 40

Papuci Delphin OCTO Albastru Marime 40

101002563
Livrare imediată!

61,00Lei

Papuci Delphin OCTO Albastru Marime 38 -18%

Papuci Delphin OCTO Albastru Marime 38

101002462
Livrare imediată!

61,00Lei(-18%) 49,90Lei

Fir, Monofilament, Mikado, Nihonto, Carp, Galben, Fluo, 0.35mm, 600m, znkf6-035, Fire Monofilament Crap, Fire Monofilament Crap Mikado, Mikado
HUSA ENERGOTEAM PROTECTIE VARF LANSETE REGLABILA CU BURETE GALBEN
Exclusiv online!

HUSA ENERGOTEAM PROTECTIE VARF LANSETE REGLABILA CU BURETE GALBEN

cft12850
Livrare 24-48 ore

27,50Lei

Dumbells C&B Pop-Ups Pepene Galben 6mm

Dumbells C&B Pop-Ups Pepene Galben 6mm

6427416146018
Livrare imediată!

23,00Lei

Afişare 101 - 120 din 1788 (90 pagini)
Queries: 9, Total time: 284.946 ms [By time] [By id] [By file]
1 (0.092)
SELECT data
FROM `oc_session`
WHERE session_id = '8058075511c4c65c70a62497f1'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.103)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:427
3 (276.149)
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 "%alb%") 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 (7.989)
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 100, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.166)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"TACKLE SHOP ARENA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
6 (0.132)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"TACKLE SHOP ARENA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
7 (0.109)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"PRODUSE INACTIVE"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
8 (0.110)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"TACKLE SHOP ARENA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
9 (0.097)
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