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 300 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 Baitcast Abu Garcia Max 4 Low Profile Reel RH 60LP
Exclusiv online!

Mulineta Baitcast Abu Garcia Max 4 Low Profile Reel RH 60LP

1543125
Livrare 7-14 zile

899,96Lei

Mulineta Penn Squall Low Profile Reel Baitcast LH, 300LP
Exclusiv online!

Mulineta Penn Squall Low Profile Reel Baitcast LH, 300LP

1525506
Livrare 7-14 zile

1.034,96Lei

Mulineta Abu Garcia Revo 5 X-W LP Casting Reel Left Hand
Exclusiv online!

Mulineta Abu Garcia Revo 5 X-W LP Casting Reel Left Hand

1565151
Livrare 7-14 zile

552,46Lei

Mulineta Sakura Kuanza Casting 2.0
Exclusiv online!

Mulineta Sakura Kuanza Casting 2.0

334saprf702962
Livrare 48-72 ore

327,45Lei

MULTIPLICATOR JAXON PRO CASTER XR 200

MULTIPLICATOR JAXON PRO CASTER XR 200

kj-prc200xr
Livrare imediată!

388,00Lei

MULINETA DAIWA TATULA 2018 100HL 8RUL/110MX031/6,3:1

MULINETA DAIWA TATULA 2018 100HL 8RUL/110MX031/6,3:1

d.tat18100hl
Livrare imediată!

1.095,82Lei

MULTIPLICATOR JAXON CASTING FORWARD XL200 7RUL
Exclusiv online!

MULTIPLICATOR JAXON CASTING FORWARD XL200 7RUL

kj-frd200xl
Livrare 48-72 ore

578,99Lei

MULINETA MULTIPLICATOARE PENN COMMANDER 30LWS LH S
Exclusiv online!

MULINETA MULTIPLICATOARE PENN COMMANDER 30LWS LH S

24165030
Livrare 24-48 ore

504,00Lei

Husa Biwaa pentru mulineta casting
Exclusiv online!

Husa Biwaa pentru mulineta casting

b011716
Livrare 48-72 ore

63,00Lei

MULTIPLICATOR, JAXON, CASTING, FORWARD, XR200, 7RUL, kj-frd200xr, Mulinete Casting, Mulinete Casting Jaxon, Jaxon
MULTIPLICATOR TICA Casting Ezi Cast EC101 RH

MULTIPLICATOR TICA Casting Ezi Cast EC101 RH

ec101
Livrare imediată!

210,00Lei

Multiplicator, DAIWA, TATULA, SV, TW, 103XSL, 7RUL, d.10714.101, Mulinete Casting, Mulinete Casting Daiwa, Daiwa
Exclusiv online!

Multiplicator, DAIWA, TATULA, SV, TW, 103XSL, 7RUL, d.10714.101, Mulinete Casting, Mulinete Casting Daiwa, Daiwa

d.10714.101
Livrare 24-48 ore

1.345,16Lei

Husa, Mulineta, Savage, Gear, Neopren, Casting, 100-300, a8.sg.75950, Huse Mulinete, Huse Mulinete Savage Gear, Savage Gear -27%
Exclusiv online!

Husa, Mulineta, Savage, Gear, Neopren, Casting, 100-300, a8.sg.75950, Huse Mulinete, Huse Mulinete Savage Gear, Savage Gear

a8.sg.75950
Livrare 48-72 ore

42,40Lei(-27%) 30,90Lei

MULTIPLICATOR DAIWA VIENTO HD A 8RUL
Exclusiv online!

MULTIPLICATOR DAIWA VIENTO HD A 8RUL

d.10710.010
Livrare 24-48 ore

1.234,38Lei

Mulineta Casting Lucky John Vanrex Cast 30 LH Left Hand
Exclusiv online!

Mulineta Casting Lucky John Vanrex Cast 30 LH Left Hand

lj-6030bc
Livrare 48-72ore

338,00Lei

Mulineta Abu Garcia Ambassadeur Altum DLC 20 Left Hand
Exclusiv online!

Mulineta Abu Garcia Ambassadeur Altum DLC 20 Left Hand

1430454
Livrare 7-14 zile

719,96Lei

Multiplicator Abu Garcia Zenon MG-X-SHS Low Profile Reel, Left -23%
Exclusiv online!

Multiplicator Abu Garcia Zenon MG-X-SHS Low Profile Reel, Left

1552849
Livrare 7-14 zile

1.710,00Lei(-23%) 1.319,00Lei

Mulineta, DAM, Quick, 2, BC, Cast, 0.26mm-210m,, 7.2:1,, 4+1BB, dam.65699, Mulinete Casting, Mulinete Casting D.A.M, Mulinete D.A.M, Casting D.A.M, D.A.M
Ulei Casting Venom Fluid 50ml -32%

Ulei Casting Venom Fluid 50ml

5065010966413
Livrare imediată!

68,00Lei(-32%) 45,90Lei

Multiplicator Abu Garcia Zenon MG-LTX Low Profile Reel, Left -23%
Exclusiv online!

Multiplicator Abu Garcia Zenon MG-LTX Low Profile Reel, Left

1552845
Livrare 7-14 zile

1.935,00Lei(-23%) 1.484,00Lei

Afişare 41 - 60 din 193 (10 pagini)
Queries: 6, Total time: 213.082 ms [By time] [By id] [By file]
1 (0.084)
SELECT data
FROM `oc_session`
WHERE session_id = '1117e26c308adad4e744b73494'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.086)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:427
3 (211.667)
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` GROUP BY tax_class_id) AS tx ON (p.tax_class_id = tx.tax_class_id)
WHERE p2s.store_id = '0' AND ((pd.tag LIKE '%mulinete%' AND pd.tag LIKE '%casting%')) 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:698
4 (0.991)
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.147)
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.107)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '0' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38