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


Agrafa Rapida Lucky John Duolock Snap Tip V Nr.003, 19kg, 10buc/plic

Agrafa Rapida Lucky John Duolock Snap Tip V Nr.003, 19kg, 10buc/plic

ljp5115-003
Livrare imediată!

7,90Lei

CUTIE SAVAGE GEAR PT.NALUCI TIP 3B 18.6X10.3X3.4CM -27%

CUTIE SAVAGE GEAR PT.NALUCI TIP 3B 18.6X10.3X3.4CM

a4.sg.76772
Livrare imediată!

30,10Lei(-27%) 21,90Lei

CUTIE SAVAGE GEAR PT.NALUCI TIP 5A 27.5X18X4.5CM -21%

CUTIE SAVAGE GEAR PT.NALUCI TIP 5A 27.5X18X4.5CM

a4.sg.76775
Livrare imediată!

43,11Lei(-21%) 33,90Lei

VARF TRABUCCO AIRTEK FEEDER TIP CARBON 1/L 3.20x600mm

VARF TRABUCCO AIRTEK FEEDER TIP CARBON 1/L 3.20x600mm

101-00-210
Livrare imediată!

69,00Lei

CUTIE SAVAGE GEAR PT.NALUCI TIP 4A 21.4X11.8X4.5CM

CUTIE SAVAGE GEAR PT.NALUCI TIP 4A 21.4X11.8X4.5CM

a4.sg.76773
Livrare imediată!

39,50Lei

CUTIE SAVAGE GEAR PT.NALUCI TIP 5B 27.5X18X4.5CM

CUTIE SAVAGE GEAR PT.NALUCI TIP 5B 27.5X18X4.5CM

a4.sg.76776
Livrare imediată!

46,80Lei

BRAT TELESCOPIC KORUM TIP TREPIED PENTRU SCAUN FEEDER ARM -37%

BRAT TELESCOPIC KORUM TIP TREPIED PENTRU SCAUN FEEDER ARM

k0300027
Livrare imediată!

377,96Lei(-37%) 239,90Lei

CUTIE SAVAGE GEAR PT.NALUCI TIP 4B SMOKE 27,5X18X5CM -20%
Exclusiv online!

CUTIE SAVAGE GEAR PT.NALUCI TIP 4B SMOKE 27,5X18X5CM

a4.sg.74224
Livrare 24-48 ore

49,18Lei(-20%) 39,34Lei

CUTIE SAVAGE GEAR PT.NALUCI TIP 4B 21.4X11.8X4.5CM

CUTIE SAVAGE GEAR PT.NALUCI TIP 4B 21.4X11.8X4.5CM

a4.sg.76774
Livrare imediată!

36,40Lei

CUTIE SAVAGE GEAR PT.NALUCI TIP 6D 36X22.5X5CM
Exclusiv online!

CUTIE SAVAGE GEAR PT.NALUCI TIP 6D 36X22.5X5CM

a4.sg.76779
Livrare 24-48 ore

58,91Lei

Varf de Rezerva pentru Lansete Arrow SOLID MG 3,0OZ Galben -5%

Varf de Rezerva pentru Lansete Arrow SOLID MG 3,0OZ Galben

arr.fmg.tip
Livrare imediată!

22,80Lei(-5%) 21,71Lei

Banda fixare lansete Korda Compac Tip and Butt Protectors
Exclusiv online!

Banda fixare lansete Korda Compac Tip and Butt Protectors

a8.klug79
Livrare 24-48 ore

104,34Lei

Scaun tip semilună Delphin YOGEEN C2G -25%

Scaun tip semilună Delphin YOGEEN C2G

101002542
Livrare imediată!

457,00Lei(-25%) 345,00Lei

Pensa Dreapta tip Foarfeca Fox Rage, 24cm -33%

Pensa Dreapta tip Foarfeca Fox Rage, 24cm

ntl037
Livrare imediată!

76,46Lei(-33%) 50,90Lei

RACHETA MOSTIRO TIP SPOMB MICA NEAGRA
Exclusiv online!

RACHETA MOSTIRO TIP SPOMB MICA NEAGRA

nn-4452
Livrare 48-72 ore

15,80Lei

Racheta De Nadire Mostiro Tip Spomb Mica, 2 Culori

Racheta De Nadire Mostiro Tip Spomb Mica, 2 Culori

nn-40921
Livrare imediată!

19,00Lei

Husa Varfuri Preston Supera X Tip Safe 80x9x5cm

Husa Varfuri Preston Supera X Tip Safe 80x9x5cm

p0130122
Livrare imediată!

134,96Lei

RACHETA MOSTIRO TIP SPOMB VERDE

RACHETA MOSTIRO TIP SPOMB VERDE

nn-4445
Livrare imediată!

14,70Lei

Plumbi Advance Tip Gemini 110g, 1buc/pac

Plumbi Advance Tip Gemini 110g, 1buc/pac

6264239327350
Livrare imediată!

16,90Lei

SUPORT SPATE PRO FL TIP CUPA Pentru LANSETA

SUPORT SPATE PRO FL TIP CUPA Pentru LANSETA

64-27205
Livrare imediată!

9,90Lei

Afişare 201 - 220 din 420 (21 pagini)
Queries: 5, Total time: 10.948 ms [By time] [By id] [By file]
1 (0.099)
SELECT data
FROM `oc_session`
WHERE session_id = '6672b81d247b1da3f4d903b131'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.099)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (8.835)
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('+tip' 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 (1.794)
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 200, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.121)
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