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


Mulineta Penn Fathom Il Level Wind LC 50 RH
Exclusiv online!

Mulineta Penn Fathom Il Level Wind LC 50 RH

1481315
Livrare 7-14 zile

1.394,97Lei

Mulineta Penn Squall II Level Wind Reel Box Left Hand, 30WLH
Exclusiv online!

Mulineta Penn Squall II Level Wind Reel Box Left Hand, 30WLH

1545929
Livrare 7-14 zile

764,96Lei

Mulineta Penn Squall II Level Wind Reel Box Right Hand, 15LW
Exclusiv online!

Mulineta Penn Squall II Level Wind Reel Box Right Hand, 15LW

1545924
Livrare 7-14 zile

674,96Lei

Mulineta Penn Fathom Il Level Wind 20
Exclusiv online!

Mulineta Penn Fathom Il Level Wind 20

1481307
Livrare 7-14 zile

1.237,46Lei

Mulineta Penn Fathom Il Level Wind 20 LC
Exclusiv online!

Mulineta Penn Fathom Il Level Wind 20 LC

1481309
Livrare 7-14 zile

1.259,96Lei

Mulineta Penn Warfare Level Wind 30 LC LH
Exclusiv online!

Mulineta Penn Warfare Level Wind 30 LC LH

1366199
Livrare 7-14 zile

584,96Lei

Mulineta Feeder FL Feeder Wind 400R

Mulineta Feeder FL Feeder Wind 400R

7234143551515
Livrare imediată!

96,60Lei

Mulineta Feeder FL Feeder Wind 200R

Mulineta Feeder FL Feeder Wind 200R

2186149168073
Livrare imediată!

89,70Lei

Mulineta FL Feeder Wind 6000

Mulineta FL Feeder Wind 6000

8921615420637
Livrare imediată!

119,90Lei

JACHETA CU GLUGA FOX RAGE WIND BLOCKER JACKET Masura XL -20%

JACHETA CU GLUGA FOX RAGE WIND BLOCKER JACKET Masura XL

npr276
Stoc epuizat

424,89Lei(-20%) 339,91Lei

Protectie Vant Wind Shield Korda Large

Protectie Vant Wind Shield Korda Large

a.kda007
Stoc epuizat

148,16Lei

Jacheta cu Gluga Fox Rage Voyager Wind Blocker, Masura XXXL

Jacheta cu Gluga Fox Rage Voyager Wind Blocker, Masura XXXL

npr535
Stoc epuizat

494,96Lei

Mulineta Penn Rival Level Wind 15LW Reel Box

Mulineta Penn Rival Level Wind 15LW Reel Box

1403990
Stoc epuizat

359,96Lei

Mulineta Penn Warfare Level Wind Right Hand 20 Level Wind LC Reel Box

Mulineta Penn Warfare Level Wind Right Hand 20 Level Wind LC Reel Box

1366190
Stoc epuizat

494,96Lei

Jacheta cu Gluga Fox Rage Voyager Wind Blocker, Masura L

Jacheta cu Gluga Fox Rage Voyager Wind Blocker, Masura L

npr532
Stoc epuizat

494,96Lei

Jacheta cu Gluga Fox Rage Voyager Wind Blocker, Masura M

Jacheta cu Gluga Fox Rage Voyager Wind Blocker, Masura M

npr531
Stoc epuizat

494,96Lei

Mulineta Penn Warfare Level Wind Right Hand 20 Level Wind 20LC Reel Box

Mulineta Penn Warfare Level Wind Right Hand 20 Level Wind 20LC Reel Box

1366193
Stoc epuizat

539,96Lei

Mulineta Penn Rival Level Wind 20LW LC Left Hand Reel Box

Mulineta Penn Rival Level Wind 20LW LC Left Hand Reel Box

1403999
Stoc epuizat

427,46Lei

Jacheta cu Gluga Fox Rage Voyager Wind Blocker, Masura XL

Jacheta cu Gluga Fox Rage Voyager Wind Blocker, Masura XL

npr533
Stoc epuizat

494,96Lei

Jacheta cu Gluga Fox Rage Voyager Wind Blocker, Masura XXL

Jacheta cu Gluga Fox Rage Voyager Wind Blocker, Masura XXL

npr534
Stoc epuizat

494,96Lei

Afişare 81 - 100 din 109 (6 pagini)
Queries: 5, Total time: 4.137 ms [By time] [By id] [By file]
1 (0.148)
SELECT data
FROM `oc_session`
WHERE session_id = 'e3b66aa787519fa05687e6b588'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.121)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (3.087)
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 = '3' AND (MATCH(pd.tag) AGAINST('+wind' 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.642)
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
5 (0.139)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '3' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38