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

Produse ce potrivesc criteriilor de căutare


HUSA LANSETE MATRIX ETHOS PRO STIFF 2 ROD HOLDALL 195CM -54%

HUSA LANSETE MATRIX ETHOS PRO STIFF 2 ROD HOLDALL 195CM

glu086
Stoc epuizat

447,30Lei(-54%) 205,00Lei

HUSA LANSETE KORUM TRANSITION OPPORTUNIST HOLDALL 135X20CM -76%

HUSA LANSETE KORUM TRANSITION OPPORTUNIST HOLDALL 135X20CM

k0290065
Stoc epuizat

324,00Lei(-76%) 77,00Lei

HUSA LANSETE PRESTON SUPERA COMPACT 6 ROD HOLDALL 6 LANSETE + 6 MULINETE 175CM
HUSA LANSETE PRESTON SUPERA COMPACT 6 ROD HOLDALL 6 LANSETE + 6 MULINETE 195CM
Husa Zfish Rod Case Royal Holdall, 3 Compartimente, Kaki, 130cm

Husa Zfish Rod Case Royal Holdall, 3 Compartimente, Kaki, 130cm

zf-2399
Stoc epuizat

199,05Lei

HUSA LANESTE FOX R SERIES 3 ROD HOLDALL 3.60M

HUSA LANESTE FOX R SERIES 3 ROD HOLDALL 3.60M

clu362
Stoc epuizat

517,46Lei

Husa Lanseta Browning 175cm Black Magic S-Line Standard Holdall

Husa Lanseta Browning 175cm Black Magic S-Line Standard Holdall

8552001
Stoc epuizat

112,28Lei

HUSA LANSETE MATRIX ETHOS PRO STIFF 4 ROD HOLDALL 195CM -57%

HUSA LANSETE MATRIX ETHOS PRO STIFF 4 ROD HOLDALL 195CM

glu084
Stoc epuizat

590,39Lei(-57%) 256,00Lei

HUSA LANSETE MATRIX ETHOS PRO HOLDALL MEDIUM 195CM -20%

HUSA LANSETE MATRIX ETHOS PRO HOLDALL MEDIUM 195CM

glu071
Stoc epuizat

402,51Lei(-20%) 322,00Lei

Husa Lanseta DAM Madcat Single Rod Holdall 300cm

Husa Lanseta DAM Madcat Single Rod Holdall 300cm

9053152012
Stoc epuizat

156,89Lei

Husa lansete DAM Detek Rod Holdall 3sec 135x23x8cm

Husa lansete DAM Detek Rod Holdall 3sec 135x23x8cm

9050966299
Stoc epuizat

165,96Lei

HUSA LANSETE PROLOGIC AVENGER PADDED HOLDALL 3.65M 3 plus 3

HUSA LANSETE PROLOGIC AVENGER PADDED HOLDALL 3.65M 3 plus 3

a8.pro.65084
Stoc epuizat

464,99Lei

HUSA LANSETE MATRIX Horizon XL Rigid Rod Holdall 3-6

HUSA LANSETE MATRIX Horizon XL Rigid Rod Holdall 3-6

glu131
Stoc epuizat

1.034,95Lei

Husa Lansete DAM O.T.T. Rod Holdall Hardcase 192x12x8cm

Husa Lansete DAM O.T.T. Rod Holdall Hardcase 192x12x8cm

9050974975
Stoc epuizat

425,83Lei

Husa Lanseta Madcat Single Rod Holdall 360cm

Husa Lanseta Madcat Single Rod Holdall 360cm

9053152013
Stoc epuizat

164,41Lei

Husa Laneste Greys Prodigy Ready Holdall - 2 Rod, 190x32x32cm

Husa Laneste Greys Prodigy Ready Holdall - 2 Rod, 190x32x32cm

1326299
Stoc epuizat

467,46Lei

HUSA PRESTON COMPETITION 6 TUBE HOLDALL 190X17X15CM

HUSA PRESTON COMPETITION 6 TUBE HOLDALL 190X17X15CM

p0130085
Stoc epuizat

323,97Lei

Husa Rigida Preston Hardcase Supera Small Rod Holdall, 185x22x20cm -52%

Husa Rigida Preston Hardcase Supera Small Rod Holdall, 185x22x20cm

p0130061
Stoc epuizat

575,00Lei(-52%) 277,00Lei

Husa Matrix Aquos 6 Tubes Holdall, 1.95cm -52%

Husa Matrix Aquos 6 Tubes Holdall, 1.95cm

glu101
Stoc epuizat

290,71Lei(-52%) 140,00Lei

HUSA PRESTON SUPERA 2 ROD HOLDALL 2 LANSETE + 2 MULINETE 190CM

HUSA PRESTON SUPERA 2 ROD HOLDALL 2 LANSETE + 2 MULINETE 190CM

p0130069
Stoc epuizat

442,76Lei

Afişare 41 - 60 din 62 (4 pagini)
Queries: 6, Total time: 2.977 ms [By time] [By id] [By file]
1 (0.106)
SELECT data
FROM `oc_session`
WHERE session_id = '7daf75ce0e566883c0bbee7427'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.088)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (2.063)
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 = '2' AND (MATCH(pd.tag) AGAINST('+holdall' 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
4 (0.484)
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 40, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.114)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"ZFISHING SPORT WHOLESALE S.R.O"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
6 (0.122)
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