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 Okuma Carbonite RD 2500

Mulineta Okuma Carbonite RD 2500

cr-2500
Stoc epuizat

134,10Lei

Tambur de rezerva adanc Delphin CHIMERA NXT 6T DP aluminium

Tambur de rezerva adanc Delphin CHIMERA NXT 6T DP aluminium

101001235
Stoc epuizat

67,00Lei

Mulineta Abu Garcia Max Pro Spinning SP1000

Mulineta Abu Garcia Max Pro Spinning SP1000

1523228
Stoc epuizat

297,46Lei

Mulineta Delphin ANTIGRAVITY 3T 3000 -29%

Mulineta Delphin ANTIGRAVITY 3T 3000

101001204
Stoc epuizat

482,00Lei(-29%) 344,40Lei

Mulineta Daiwa Emblem 35 SCW QD Type R

Mulineta Daiwa Emblem 35 SCW QD Type R

d.em35scwqdr
Stoc epuizat

920,47Lei

HUSA DAIWA IFS 130X21CM ISERS

HUSA DAIWA IFS 130X21CM ISERS

d.18851.060
Stoc epuizat

128,73Lei

Tambur de rezerva adanc Delphin CHIMERA NXT 5T DP aluminium

Tambur de rezerva adanc Delphin CHIMERA NXT 5T DP aluminium

101001234
Stoc epuizat

67,00Lei

Mulineta DAM Quick Impuls 4 Feeder FD 4000

Mulineta DAM Quick Impuls 4 Feeder FD 4000

3054673068
Stoc epuizat

207,37Lei

Tambur de rezerva adanc Delphin CHIMERA NXT 7T DP aluminium

Tambur de rezerva adanc Delphin CHIMERA NXT 7T DP aluminium

101001236
Stoc epuizat

67,00Lei

Mulineta Trabucco Mantis FDX 4500

Mulineta Trabucco Mantis FDX 4500

034-82-450
Stoc epuizat

135,01Lei

MULINETA TICA GIANT 5000

MULINETA TICA GIANT 5000

g5000
Stoc epuizat

390,00Lei

Mulineta Delphin ANTIGRAVITY 2T 2000

Mulineta Delphin ANTIGRAVITY 2T 2000

101001203
Stoc epuizat

457,00Lei

Mulineta Abu Garcia Revo X 3000 -33%

Mulineta Abu Garcia Revo X 3000

1430447
Stoc epuizat

494,60Lei(-33%) 329,00Lei

Husa FL 2022 Kaki 2 Compartimente 115cm

Husa FL 2022 Kaki 2 Compartimente 115cm

3552208663398
Stoc epuizat

37,90Lei

MULINETA TICA GIANT 14000

MULINETA TICA GIANT 14000

g14000
Stoc epuizat

489,99Lei

Husa FL 2022 Kaki 2 Compartimente 145cm

Husa FL 2022 Kaki 2 Compartimente 145cm

8552223788255
Stoc epuizat

57,91Lei

Mulineta Abu Garcia Max STX 4000

Mulineta Abu Garcia Max STX 4000

1532492
Stoc epuizat

276,21Lei

HUSA INDIVIDUALA KORDA COMPAC PADDED SLEEVE LANSETA+MULINETA 163X26X5CM

HUSA INDIVIDUALA KORDA COMPAC PADDED SLEEVE LANSETA+MULINETA 163X26X5CM

a8.klug54
Stoc epuizat

185,22Lei

Mulineta DAM Quick Impuls 4 Feeder FD 5000

Mulineta DAM Quick Impuls 4 Feeder FD 5000

3054673069
Stoc epuizat

218,46Lei

MULINETA TICA GIANT 3000

MULINETA TICA GIANT 3000

g3000
Stoc epuizat

380,00Lei

Afişare 3001 - 3020 din 4378 (219 pagini)
Queries: 6, Total time: 129.409 ms [By time] [By id] [By file]
1 (0.108)
SELECT data
FROM `oc_session`
WHERE session_id = '81688d120c9078ccd20a47468c'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.114)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (111.923)
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 (17.057)
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 3000, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.109)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"RAPALA VMC ROMANIA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
6 (0.098)
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