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 Abu Garcia Superior Spinning Reel, 3000MSH

Mulineta Abu Garcia Superior Spinning Reel, 3000MSH

1500960
Stoc epuizat

449,96Lei

Mulineta Carp Zoom Competition Osmium Feeder LC6000

Mulineta Carp Zoom Competition Osmium Feeder LC6000

cz2230
Stoc epuizat

255,01Lei

Mulineta Daiwa 23 Airity LT 2500S, 5.1:1, 0.16mm/150m, 11rul

Mulineta Daiwa 23 Airity LT 2500S, 5.1:1, 0.16mm/150m, 11rul

d.10001.250
Stoc epuizat

3.659,75Lei

Mulineta Delphin BRONZ 4T 4000

Mulineta Delphin BRONZ 4T 4000

101003746
Stoc epuizat

82,00Lei

Mulineta Delphin MAGIX 6T DP 6000

Mulineta Delphin MAGIX 6T DP 6000

101003422
Stoc epuizat

213,90Lei

Mulineta Fin-Nor Marquesa 20 Lever Drag Reel

Mulineta Fin-Nor Marquesa 20 Lever Drag Reel

1531223
Stoc epuizat

1.881,93Lei

Mulineta Fin-Nor Marquesa 20 Lever Drag Reel, 2SPD Lever Drag

Mulineta Fin-Nor Marquesa 20 Lever Drag Reel, 2SPD Lever Drag

1531227
Stoc epuizat

2.117,19Lei

Mulineta Fin-Nor Marquesa 40 Lever Drag Reel, 2SPD Lever Drag

Mulineta Fin-Nor Marquesa 40 Lever Drag Reel, 2SPD Lever Drag

1531229
Stoc epuizat

2.681,89Lei

Mulineta Fin-Nor Primal 10 Lever LH Drag High Speed

Mulineta Fin-Nor Primal 10 Lever LH Drag High Speed

1532105
Stoc epuizat

1.364,28Lei

Mulineta Fly Greys Tital Fly Reel 5/6

Mulineta Fly Greys Tital Fly Reel 5/6

1546696
Stoc epuizat

1.317,46Lei

Mulineta Golden Catch Airone 3000M

Mulineta Golden Catch Airone 3000M

gcz-1039011
Stoc epuizat

275,00Lei

Mulineta Golden Catch Airone 4000FD

Mulineta Golden Catch Airone 4000FD

gcz-1039012
Stoc epuizat

310,00Lei

Mulineta Hardy Fly Blind Hardy 150 Anniversary Lightweight ST Aidan 7/8WT

Mulineta Hardy Fly Blind Hardy 150 Anniversary Lightweight ST Aidan 7/8WT

1542640
Stoc epuizat

3.132,26Lei

Mulineta Hardy Fortuna Regent Fly Reel Black 10000

Mulineta Hardy Fortuna Regent Fly Reel Black 10000

1577677
Stoc epuizat

3.229,96Lei

Mulineta Hardy Ultraclick UCL Fly Reel, Olive Bronze, 3000

Mulineta Hardy Ultraclick UCL Fly Reel, Olive Bronze, 3000

1521696
Stoc epuizat

1.189,96Lei

Mulineta Hardy Ultraclick UCL Fly Reel, Olive Bronze, 4000

Mulineta Hardy Ultraclick UCL Fly Reel, Olive Bronze, 4000

1521697
Stoc epuizat

1.232,46Lei

Mulineta Hardy Ultradisc UDLA Fly Reel, Gun Metal Green, 7000

Mulineta Hardy Ultradisc UDLA Fly Reel, Gun Metal Green, 7000

1521703
Stoc epuizat

1.912,46Lei

Mulineta Hardy Zane Carbon Fly Reel 8000

Mulineta Hardy Zane Carbon Fly Reel 8000

1513750
Stoc epuizat

2.634,96Lei

Mulineta Mikado Black Crystal 2005 FD

Mulineta Mikado Black Crystal 2005 FD

kda140-2005fd
Stoc epuizat

429,99Lei

Mulineta Mikado Intro 3003FD

Mulineta Mikado Intro 3003FD

kda156-3003fd
Stoc epuizat

114,00Lei

Afişare 2621 - 2640 din 3509 (176 pagini)
Queries: 7, Total time: 110.438 ms [By time] [By id] [By file]
1 (0.142)
SELECT data
FROM `oc_session`
WHERE session_id = '1e16d7af8eda255ae7045fec08'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.108)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (95.797)
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('+mulineta' 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 (13.975)
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 2620, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.172)
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.095)
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.149)
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