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


VARF MATRIX FEEDER COMMERCIAL FEEDER ROD CARBON TIPS 2.4mm 2 OZ

VARF MATRIX FEEDER COMMERCIAL FEEDER ROD CARBON TIPS 2.4mm 2 OZ

grd159
Stoc epuizat

143,95Lei

VARF MATRIX FEEDER COMMERCIAL FEEDER ROD CARBON TIPS 2.4mm 1.5 OZ

VARF MATRIX FEEDER COMMERCIAL FEEDER ROD CARBON TIPS 2.4mm 1.5 OZ

grd158
Stoc epuizat

143,95Lei

VARF MATRIX FEEDER COMMERCIAL FEEDER ROD CARBON TIPS 2.4mm 2.5 OZ

VARF MATRIX FEEDER COMMERCIAL FEEDER ROD CARBON TIPS 2.4mm 2.5 OZ

grd160
Stoc epuizat

143,95Lei

Geanta Matrix Termica EVA XL Cooler Bag Light Grey -44%

Geanta Matrix Termica EVA XL Cooler Bag Light Grey

glu122
Stoc epuizat

268,30Lei(-44%) 150,00Lei

TAVA MATRIX LATERALA EXTINSA 3D

TAVA MATRIX LATERALA EXTINSA 3D

gmb139
Stoc epuizat

562,47Lei

Geanta Termo Matrix EVA Bait Cool Tray Light Grey -20%

Geanta Termo Matrix EVA Bait Cool Tray Light Grey

glu124
Stoc epuizat

268,30Lei(-20%) 214,64Lei

Geanta Matrix EVA Mini Case -20%

Geanta Matrix EVA Mini Case

glu117
Stoc epuizat

71,52Lei(-20%) 57,22Lei

LANSETA MATCH MATRIX X PRO WAGGLER RODS 12FT -14%

LANSETA MATCH MATRIX X PRO WAGGLER RODS 12FT

grd153
Stoc epuizat

1.079,95Lei(-14%) 928,15Lei

Geanta Matrix Termica EVA Cooler Bag Light Grey -30%

Geanta Matrix Termica EVA Cooler Bag Light Grey

glu123
Stoc epuizat

201,21Lei(-30%) 140,00Lei

Geanta Matrix EVA Inter Case Bowl with Zip Lid 10L -20%

Geanta Matrix EVA Inter Case Bowl with Zip Lid 10L

glu118
Stoc epuizat

102,80Lei(-20%) 82,24Lei

Geanta Matrix EVA Inter Case -20%

Geanta Matrix EVA Inter Case

glu116
Stoc epuizat

76,01Lei(-20%) 60,80Lei

LANSETA FEEDER MATRIX X PRO COMMERCIAL BOMB RODS 11FT -14%

LANSETA FEEDER MATRIX X PRO COMMERCIAL BOMB RODS 11FT

grd151
Stoc epuizat

1.507,46Lei(-14%) 1.295,58Lei

Geanta Matrix EVA XL Storage Bag -20%

Geanta Matrix EVA XL Storage Bag

glu111
Stoc epuizat

169,93Lei(-20%) 135,95Lei

Cap suport Matrix Flexi Rod Butt Grip

Cap suport Matrix Flexi Rod Butt Grip

gba055
Stoc epuizat

34,11Lei

Geanta Matrix EVA XL BAIT TRAY inc 6 TUBS -20%

Geanta Matrix EVA XL BAIT TRAY inc 6 TUBS

glu113
Stoc epuizat

313,07Lei(-20%) 250,46Lei

Geanta Matrix EVA Bowl with Zip Lid 5L -20%

Geanta Matrix EVA Bowl with Zip Lid 5L

glu120
Stoc epuizat

89,40Lei(-20%) 71,52Lei

Scaun Pivotant + Baza Matrix F25 System Swivel Seat -12%

Scaun Pivotant + Baza Matrix F25 System Swivel Seat

gmb117
Stoc epuizat

719,96Lei(-12%) 629,99Lei

TAVA MATRIX LATERALA EXTINSA 3D XL

TAVA MATRIX LATERALA EXTINSA 3D XL

gmb152
Stoc epuizat

626,20Lei

FILET MATRIX 3D-R INSERT THREADS

FILET MATRIX 3D-R INSERT THREADS

gba040
Stoc epuizat

40,46Lei

HUSA LANSETE MATRIX ETHOS PRO STIFF 2 ROD HOLDALL 195CM -54%

HUSA LANSETE MATRIX ETHOS PRO STIFF 2 ROD HOLDALL 195CM

glu086
Stoc epuizat

447,30Lei(-54%) 205,00Lei

Afişare 281 - 300 din 792 (40 pagini)
Queries: 4, Total time: 17.299 ms [By time] [By id] [By file]
1 (0.100)
SELECT data
FROM `oc_session`
WHERE session_id = 'abb2ada9012edca5482fc37fdc'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.096)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (16.901)
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.202)
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