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 - vu.2.5878

Produse ce potrivesc criteriilor de căutare


STRUNE SPRO INOX 1X7 30CM 18,2KG SW S 2BUC

STRUNE SPRO INOX 1X7 30CM 18,2KG SW S 2BUC

004623-00100-00403
Stoc epuizat

16,51Lei

Strune Nevis Otel 1x7 20cm 10kg

Strune Nevis Otel 1x7 20cm 10kg

8523-120
Stoc epuizat

3,00Lei

STRUNE SPRO INOX 1X7 30CM 13,6KG SS S 2BUC

STRUNE SPRO INOX 1X7 30CM 13,6KG SS S 2BUC

004623-00300-00303
Stoc epuizat

22,00Lei

Strune Nevis Otel 1x7 25cm 10kg

Strune Nevis Otel 1x7 25cm 10kg

8523-125
Stoc epuizat

3,00Lei

STRUNA SAVAGE TITANIUM7 TRACE 30CM 040MM/13KG 2BUC/PL

STRUNA SAVAGE TITANIUM7 TRACE 30CM 040MM/13KG 2BUC/PL

a7.sg.61770
Stoc epuizat

47,45Lei

STRUNA TITAN CARP ZOOM PREDATOR Z 20CM 11KG 2/PLIC

STRUNA TITAN CARP ZOOM PREDATOR Z 20CM 11KG 2/PLIC

cz5579
Stoc epuizat

16,01Lei

STRUNA KEVLAR STRIKE PRO 20CM, 12KG, 3BUC/PAC -20%

STRUNA KEVLAR STRIKE PRO 20CM, 12KG, 3BUC/PAC

a7.sp.kl20203
Stoc epuizat

9,29Lei(-20%) 7,43Lei

STRUNA SAVAGE REGENERATOR TRACE 60CM 100MM/25KG 3BUC/PL

STRUNA SAVAGE REGENERATOR TRACE 60CM 100MM/25KG 3BUC/PL

a7.sg.61772
Stoc epuizat

24,41Lei

Strune Nevis Otel 25cm 10kg

Strune Nevis Otel 25cm 10kg

8522-125
Stoc epuizat

3,00Lei

Struna Dragon Invisible Fluorocarbon Spinning Leader 30cm / 15kg -15%

Struna Dragon Invisible Fluorocarbon Spinning Leader 30cm / 15kg

pdf5041530
Stoc epuizat

13,99Lei(-15%) 11,90Lei

Struna Mustad CoastLock 30cm 25lbs 3buc

Struna Mustad CoastLock 30cm 25lbs 3buc

a7.mwl0050
Stoc epuizat

14,57Lei

Strune Nevis Otel 20cm 10kg

Strune Nevis Otel 20cm 10kg

8522-120
Stoc epuizat

3,00Lei

Struna din titan Delphin BOMB cu agrafa si agrafa rapida 35cm 12kg -26%

Struna din titan Delphin BOMB cu agrafa si agrafa rapida 35cm 12kg

917401235
Stoc epuizat

39,00Lei(-26%) 28,80Lei

Struna Dragon Invisible Fluorocarbon Spinning Leader 30cm / 8kg -15%

Struna Dragon Invisible Fluorocarbon Spinning Leader 30cm / 8kg

pdf5040830
Stoc epuizat

13,99Lei(-15%) 11,90Lei

Struna din titan Delphin BOMB cu agrafa si agrafa rapida 45cm 17kg

Struna din titan Delphin BOMB cu agrafa si agrafa rapida 45cm 17kg

917401745
Stoc epuizat

46,01Lei

Struna Fluorocarbon VMC 45cm 150lbs 2buc/plic

Struna Fluorocarbon VMC 45cm 150lbs 2buc/plic

fl15018
Stoc epuizat

60,50Lei

Struna Fox Rage Predator 49 Strand Steel Wire 10m 12kg

Struna Fox Rage Predator 49 Strand Steel Wire 10m 12kg

fac001
Stoc epuizat

94,46Lei

Struna din titan Delphin BOMB cu agrafa si agrafa rapida 30cm 9kg -24%

Struna din titan Delphin BOMB cu agrafa si agrafa rapida 30cm 9kg

917400930
Stoc epuizat

33,00Lei(-24%) 25,00Lei

FIR TITAN PENTRU STRUNA STROFT NITI POLI 1X7 0,35MM/2M

FIR TITAN PENTRU STRUNA STROFT NITI POLI 1X7 0,35MM/2M

st.3935
Stoc epuizat

92,87Lei

FIR TITAN PENTRU STRUNA STROFT NITI POLI 1X7 0,30MM/2M

FIR TITAN PENTRU STRUNA STROFT NITI POLI 1X7 0,30MM/2M

st.3930
Stoc epuizat

88,17Lei

Afişare 681 - 700 din 722 (37 pagini)
Queries: 6, Total time: 15.477 ms [By time] [By id] [By file]
1 (0.100)
SELECT data
FROM `oc_session`
WHERE session_id = '5e656e1a31b8f7a8a5c3d9c25d'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.067)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (12.445)
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('+strune' 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 (2.687)
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 680, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.102)
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.076)
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