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 - Shimano

Produse ce potrivesc criteriilor de căutare


ANCORE PROFI BLINKER X STRONG BLACK 4/0 5 BUC
Exclusiv online!

ANCORE PROFI BLINKER X STRONG BLACK 4/0 5 BUC

70p40
Livrare 48-72 ore

23,80Lei

Prosop cu Husa K-Karp K Towel
Exclusiv online!

Prosop cu Husa K-Karp K Towel

193-30-310
Livrare 48-72 ore

27,00Lei

Shad, Fox, Rage, Pro, Natural, Classics, 2, Fire, Tiger, 10cm, nsl1321, Shad-uri, Shad-uri Fox Rage, Fox Rage
TUB PROTECTIE JAXON WAGLERE 39x60CM 45MM
Exclusiv online!

TUB PROTECTIE JAXON WAGLERE 39x60CM 45MM

aj-hn103
Livrare 48-72 ore

21,00Lei

LANSETA MATCH MATRIX X PRO WAGGLER RODS 12FT -14%
Exclusiv online!

LANSETA MATCH MATRIX X PRO WAGGLER RODS 12FT

grd153
Livrare 7-14 zile

1.079,95Lei(-14%) 928,15Lei

ANCORE PROFI BLINKER X STRONG BLACK 6/0 3 BUC
Exclusiv online!

ANCORE PROFI BLINKER X STRONG BLACK 6/0 3 BUC

70p60
Livrare 48-72 ore

34,61Lei

Salopeta Prologic Bank Bound Camo B&B M -20%

Salopeta Prologic Bank Bound Camo B&B M

a8.pro.64553
Livrare imediată!

453,93Lei(-20%) 363,14Lei

Lanseta Spro Freestyle Litz Spin 2.40m 14g 2seg
Exclusiv online!

Lanseta Spro Freestyle Litz Spin 2.40m 14g 2seg

002109-00243-00000
Livrare 48-72 ore

263,39Lei

Saltea Primire Prologic Avenger Roll Up Flat Mat, 95x50cm -50%
Exclusiv online!

Saltea Primire Prologic Avenger Roll Up Flat Mat, 95x50cm

a.pro.65003
Livrare 24-48 ore

228,10Lei(-50%) 114,05Lei

Fir, Textil, Delphin, PROXI, 8, Maro, 20m, 0.08mm, 10.6lbs, 101000096, Fire Monturi Crap, Fire Monturi Crap Delphin, Fire Monturi Feeder, Fire Monturi Feeder Delphin, Delphin
Montura Spro Freestyle Tocka 6g -38%

Montura Spro Freestyle Tocka 6g

004589-00802-00000
Livrare imediată!

12,80Lei(-38%) 7,90Lei

Lanseta, Spro, Freestyle, Litz, Spin, 2.40m, 10g, 2seg, 002109-00241-00000, Lansete Rapitori, Lansete Rapitori Spro, Spro
Exclusiv online!

Lanseta, Spro, Freestyle, Litz, Spin, 2.40m, 10g, 2seg, 002109-00241-00000, Lansete Rapitori, Lansete Rapitori Spro, Spro

002109-00241-00000
Livrare 48-72 ore

263,39Lei

CLESTE SPRO MICRO INELE DESPICATE

CLESTE SPRO MICRO INELE DESPICATE

004702-00235-00000
Livrare imediată!

46,60Lei

LANTERNA LEDLENSER TFX PROPUS 3500 3500LM/LI-ION CABLU USB
Exclusiv online!

LANTERNA LEDLENSER TFX PROPUS 3500 3500LM/LI-ION CABLU USB

a8.z502557
Livrare 24-48 ore

689,19Lei

JACHETA IMAX PROTECH GREY/BLUE MARIME 2XL
Exclusiv online!

JACHETA IMAX PROTECH GREY/BLUE MARIME 2XL

a8.imx.49452
Livrare 24-48 ore

192,40Lei

LANSETA, FEEDER, MATRIX, X, PRO, COMMERCIAL, BOMB, RODS, 11FT, grd151, Lansete Feeder, Lansete Feeder Matrix, Matrix -14%
Exclusiv online!

LANSETA, FEEDER, MATRIX, X, PRO, COMMERCIAL, BOMB, RODS, 11FT, grd151, Lansete Feeder, Lansete Feeder Matrix, Matrix

grd151
Livrare 7-14 zile

1.507,46Lei(-14%) 1.295,58Lei

Lanseta, Spro, Freestyle, Litz, Spin, 2.40m, 21g, 2seg, 002109-00244-00000, Lansete Rapitori, Lansete Rapitori Spro, Spro -38%
Exclusiv online!

Lanseta, Spro, Freestyle, Litz, Spin, 2.40m, 21g, 2seg, 002109-00244-00000, Lansete Rapitori, Lansete Rapitori Spro, Spro

002109-00244-00000
Livrare 48-72 ore

263,39Lei(-38%) 164,01Lei

Mulineta Spro Freestyle Skillz 2000 -38%

Mulineta Spro Freestyle Skillz 2000

001393-00200-00000
Livrare imediată!

373,01Lei(-38%) 232,89Lei

Grub Fox Rage Pro Bulk, Silver Baitfish, 10cm, 1buc/pac -20%

Grub Fox Rage Pro Bulk, Silver Baitfish, 10cm, 1buc/pac

npg036-bucxxx
Livrare imediată!

7,38Lei(-20%) 5,90Lei

Montura Spro Freestyle Tocka 10g
Exclusiv online!

Montura Spro Freestyle Tocka 10g

004589-00803-00000
Livrare 48-72 ore

13,20Lei

Afişare 181 - 200 din 7095 (355 pagini)
Queries: 8, Total time: 789.427 ms [By time] [By id] [By file]
1 (0.108)
SELECT data
FROM `oc_session`
WHERE session_id = '5b548e8da5145d774011a471a4'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.113)
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 (513.922)
SELECT p.product_id, p.sort_order, p.quantity, p.manufacturer_id, "1" AS match_filters, pp.sort_order, pp.viewed, IF ((pp.quantity) > 0, 1, 0) AS array_quantity
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)
INNER JOIN `oc_product` AS pp ON (pp.product_id = p.product_id)
WHERE p2s.store_id = '0' AND (pd.tag LIKE "%pro%") AND p.status_filtru > 0 AND p.price > 0 AND pd.language_id = '2' GROUP BY p.product_id HAVING match_filters = 1
ORDER BY array_quantity DESC, pp.sort_order ASC, pp.viewed DESC, pd.name ASC LIMIT 180, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (274.828)
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 = '0' AND (pd.tag LIKE "%pro%") 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:697
6 (0.124)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
7 (0.106)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
8 (0.117)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '0' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38