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


Tambur Rezerva Penn Spinfisher Spinning Reel Line Liver, 4500

Tambur Rezerva Penn Spinfisher Spinning Reel Line Liver, 4500

1494739
Stoc epuizat

130,46Lei

Tambur Rezerva Penn Spinfisher Spinning Reel Line Liver, 7500

Tambur Rezerva Penn Spinfisher Spinning Reel Line Liver, 7500

1494887
Stoc epuizat

193,70Lei

Tambur Rezerva Penn Spinfisher Spinning Reel, 10500

Tambur Rezerva Penn Spinfisher Spinning Reel, 10500

1488471
Stoc epuizat

215,96Lei

Husa DAM Intenze pentru 3 Lansete cu Mulineta, 130x33x30cm

Husa DAM Intenze pentru 3 Lansete cu Mulineta, 130x33x30cm

a8.dam.60366
Stoc epuizat

343,34Lei

Mulineta - Combat N.G. 4002 Fd

Mulineta - Combat N.G. 4002 Fd

kda162-4002fd
Stoc epuizat

99,00Lei

Mulineta Abu Garcia Ambassadeur 5601 Jerkbait HS Reel Left Hand

Mulineta Abu Garcia Ambassadeur 5601 Jerkbait HS Reel Left Hand

1339403
Stoc epuizat

1.313,99Lei

Mulineta Abu Garcia Revo ALX Spinning Reel, 2500MSH

Mulineta Abu Garcia Revo ALX Spinning Reel, 2500MSH

1530587
Stoc epuizat

899,96Lei

Mulineta Abu Garcia Revo ALX Spinning Reel, 3000SH

Mulineta Abu Garcia Revo ALX Spinning Reel, 3000SH

1530588
Stoc epuizat

944,96Lei

Mulineta DAIWA Tournament S 6000T ENTO, 0.35mm/360m, 3.5:1, 8rul

Mulineta DAIWA Tournament S 6000T ENTO, 0.35mm/360m, 3.5:1, 8rul

d.10124.065
Stoc epuizat

1.785,40Lei

Mulineta Fin-Nor Marquesa 16 Lever Drag Reel

Mulineta Fin-Nor Marquesa 16 Lever Drag Reel

1531222
Stoc epuizat

1.740,70Lei

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

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

1531228
Stoc epuizat

2.540,73Lei

Mulineta Fin-Nor Marquesa 30 Lever Drag Reel, Lever Drag

Mulineta Fin-Nor Marquesa 30 Lever Drag Reel, Lever Drag

1531224
Stoc epuizat

2.164,24Lei

Mulineta Hardy Bros Narrow Spool Perfect FLY Reel 318 LH

Mulineta Hardy Bros Narrow Spool Perfect FLY Reel 318 LH

1521689
Stoc epuizat

4.096,18Lei

Mulineta Hardy Fly Blind Hardy 150 Anniversary Lightweight Featherweight 3/4WT
Mulineta Mikado Bixlite 3006 FD

Mulineta Mikado Bixlite 3006 FD

kda138-3006fd
Stoc epuizat

181,00Lei

Mulineta Mikado Fly Fly CDL 7/8

Mulineta Mikado Fly Fly CDL 7/8

KDA060-08
Stoc epuizat

374,01Lei

Mulineta Mikado Nexton 5005 Fd

Mulineta Mikado Nexton 5005 Fd

kda115-5005fd
Stoc epuizat

161,99Lei

Mulineta Mikado Sensual Ng 3004 Fd/0,22Mm

Mulineta Mikado Sensual Ng 3004 Fd/0,22Mm

kda151-3004z
Stoc epuizat

127,00Lei

Mulineta Nevis Winner Rapid 40

Mulineta Nevis Winner Rapid 40

2309-340
Stoc epuizat

105,00Lei

MULINETA PRO FL ULTRA CAST CARP FLX SPOD MARKER I

MULINETA PRO FL ULTRA CAST CARP FLX SPOD MARKER I

64-13451
Stoc epuizat

349,00Lei

Afişare 3661 - 3680 din 4376 (219 pagini)
Queries: 5, Total time: 126.803 ms [By time] [By id] [By file]
1 (0.144)
SELECT data
FROM `oc_session`
WHERE session_id = '09b79ba79f889f118537d4cd2b'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.126)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (109.436)
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('+mulinete' 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 (16.971)
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 3660, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.126)
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