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


Cosulet Matrix Finned Feeder Large, 30g

Cosulet Matrix Finned Feeder Large, 30g

gfr133
Livrare imediată!

11,21Lei

Fir Monofilament Carbotex Matrix MATRIX Green 0.28MM/10.25KG/300M -20%

Fir Monofilament Carbotex Matrix MATRIX Green 0.28MM/10.25KG/300M

e.1030.028
Livrare imediată!

25,39Lei(-20%) 20,33Lei

COADA MINCIOG MATRIX AQUOS POWER 3.00M

COADA MINCIOG MATRIX AQUOS POWER 3.00M

gln058
Livrare imediată!

380,21Lei

Cap minciog Matrix Carp Landing Net 55 x 45cm

Cap minciog Matrix Carp Landing Net 55 x 45cm

gln045
Livrare imediată!

76,46Lei

Vartej Matrix Hooklength Swivels 18

Vartej Matrix Hooklength Swivels 18

gac366
Livrare imediată!

13,46Lei

Fir Monofilament Carbotex MATRIX Green 0.35MM/15.45KG/300M -20%
Exclusiv online!

Fir Monofilament Carbotex MATRIX Green 0.35MM/15.45KG/300M

e.1030.035
Livrare 24-48 ore

29,54Lei(-20%) 23,62Lei

Cosulet Feeder Matrix Open End Large 45g

Cosulet Feeder Matrix Open End Large 45g

gfr008
Livrare imediată!

11,21Lei

Cosulet Matrix Finned Feeder Medium, 30g -30%

Cosulet Matrix Finned Feeder Medium, 30g

gfr130
Livrare imediată!

11,21Lei(-30%) 7,90Lei

Cosulet Matrix Finned Feeder Large, 45g

Cosulet Matrix Finned Feeder Large, 45g

gfr135
Livrare imediată!

11,21Lei

TAVA MATRIX SELF SUPPORTING SIDE TRAYS X Large 570 x 570mm

TAVA MATRIX SELF SUPPORTING SIDE TRAYS X Large 570 x 570mm

gba049
Livrare imediată!

494,96Lei

Fir Monofilament Carbotex Matrix Fluo Galben, 1000m 0.28mm/10.25kg -20%
Exclusiv online!

Fir Monofilament Carbotex Matrix Fluo Galben, 1000m 0.28mm/10.25kg

e.1000.028
Livrare 24-48 ore

28,18Lei(-20%) 22,54Lei

Fir Monofilament Carbotex Matrix Fluo Galben, 1000m 0.26mm/8.95kg
Exclusiv online!

Fir Monofilament Carbotex Matrix Fluo Galben, 1000m 0.26mm/8.95kg

e.1000.026
Livrare 24-48 ore

21,42Lei

Suport Matrix 3D-R Brolley Bracket Short pentru Scaun Modular 18cm

Suport Matrix 3D-R Brolley Bracket Short pentru Scaun Modular 18cm

gba030
Livrare imediată!

121,46Lei

CUTIE ACCESORII MATRIX 8 Compartimente Deep 365x220x80mm

CUTIE ACCESORII MATRIX 8 Compartimente Deep 365x220x80mm

gbx008
Livrare imediată!

69,31Lei

Geanta Matrix Ethos Pro Net Accessory Bag

Geanta Matrix Ethos Pro Net Accessory Bag

glu074
Livrare imediată!

415,91Lei

LANSETA HORIZON X PRO DISTANCE FEEDER RODS 13.1ft 4.0m 130g -14%

LANSETA HORIZON X PRO DISTANCE FEEDER RODS 13.1ft 4.0m 130g

grd176
Livrare imediată!

1.754,96Lei(-14%) 1.508,30Lei

VARF LANSETA MATRIX Spare Feeder Tip 2.5oz Carbon

VARF LANSETA MATRIX Spare Feeder Tip 2.5oz Carbon

grd181
Livrare imediată!

157,46Lei

Cosulet Matrix Finned Feeder Medium, 40g -30%

Cosulet Matrix Finned Feeder Medium, 40g

gfr131
Livrare imediată!

11,21Lei(-30%) 7,90Lei

Portofel Matrix Ethos Pro Accessory Bag Medium -29%

Portofel Matrix Ethos Pro Accessory Bag Medium

glu081
Livrare imediată!

71,52Lei(-29%) 50,98Lei

Cosulet Perforat Matrix Open End Small 15G

Cosulet Perforat Matrix Open End Small 15G

gfr001
Livrare imediată!

11,21Lei

Afişare 161 - 180 din 792 (40 pagini)
Queries: 4, Total time: 19.187 ms [By time] [By id] [By file]
1 (0.136)
SELECT data
FROM `oc_session`
WHERE session_id = '485eb8d4b3af081436637c2558'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.103)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (18.778)
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('+matrix' 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 (0.170)
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