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


Saltea De Primire NGT 110 x 70cm

Saltea De Primire NGT 110 x 70cm

ngt-fu-mat-beaine-555
Livrare imediată!

149,99Lei

MARGELE MONTURI CARP ZOOM SOFT 8 MM VERDE MAT

MARGELE MONTURI CARP ZOOM SOFT 8 MM VERDE MAT

cz1793
Livrare imediată!

7,50Lei

MARGELE TULIP CARP ZOOM FEEDER COMPETITION VERDE MAT

MARGELE TULIP CARP ZOOM FEEDER COMPETITION VERDE MAT

cz5440
Livrare imediată!

9,50Lei

MARGELE MONTURI CARP ZOOM SOFT 4 MM VERDE MAT
Exclusiv online!

MARGELE MONTURI CARP ZOOM SOFT 4 MM VERDE MAT

cz1779
Livrare 48-72 ore

8,50Lei

TAIL RUBBERS CARP ZOOM 3/6MM VERDE MAT
Exclusiv online!

TAIL RUBBERS CARP ZOOM 3/6MM VERDE MAT

cz1946
Livrare 48-72 ore

8,00Lei

MARGELE MONTURI CARP ZOOM SOFT 6 MM VERDE MAT
Exclusiv online!

MARGELE MONTURI CARP ZOOM SOFT 6 MM VERDE MAT

cz1786
Livrare 48-72 ore

8,50Lei

INELE MONTURI CARP ZOOM ROTUNDE 3.1 MM NEGRU MAT

INELE MONTURI CARP ZOOM ROTUNDE 3.1 MM NEGRU MAT

cz1748
Livrare imediată!

13,99Lei

VARTEJ CU AGRAFA RAPIDA MOSTIRO SI SIGURANTA MAT BLACK NR 8 5BUC -24%

VARTEJ CU AGRAFA RAPIDA MOSTIRO SI SIGURANTA MAT BLACK NR 8 5BUC

4459ms
Livrare imediată!

12,99Lei(-24%) 9,90Lei

Saltea NGT Primire Crap Session 110x70cm

Saltea NGT Primire Crap Session 110x70cm

ngt-fu-mat-beanie-555
Livrare imediată!

149,99Lei

Rezerve Dispozitiv Anti Tantari ThermaCELL Backpacker Mat-Only Refills 48h

Rezerve Dispozitiv Anti Tantari ThermaCELL Backpacker Mat-Only Refills 48h

m-48
Livrare imediată!

93,90Lei

VARTEJ RAPID CARP ZOOM NR 8 NEGRU MAT

VARTEJ RAPID CARP ZOOM NR 8 NEGRU MAT

cz2004
Livrare imediată!

13,99Lei

VARTEJ MONTURI CARP ZOOM NR 4 NEGRU MAT
Exclusiv online!

VARTEJ MONTURI CARP ZOOM NR 4 NEGRU MAT

cz2011
Livrare 48-72 ore

8,50Lei

CARLIG MUSTAD CRAP XV2 CURVE BL.MAT Nr.2
Exclusiv online!

CARLIG MUSTAD CRAP XV2 CURVE BL.MAT Nr.2

m.60545npbm.2
Livrare 24-48 ore

12,39Lei

SALTEA DE RECEPTIE FOX RAGE PREDATOR UNHOOKING MAT
Exclusiv online!

SALTEA DE RECEPTIE FOX RAGE PREDATOR UNHOOKING MAT

flu003
Livrare 7-14 zile

431,95Lei

Vobler DUO Realis Pencil 110, ACC3059 Mat Tiger, 20.5g, 11cm -14%

Vobler DUO Realis Pencil 110, ACC3059 Mat Tiger, 20.5g, 11cm

4525918036348
Livrare imediată!

72,00Lei(-14%) 61,90Lei

Vobler Illex Diving Chubby Mat Tiger 3.8cm 4.3gr
Exclusiv online!

Vobler Illex Diving Chubby Mat Tiger 3.8cm 4.3gr

si.93879
Livrare 24-48 ore

109,80Lei

Cicada Sakura Micro Soukouss Blade 35mm 7g Mat Pink Tiger

Cicada Sakura Micro Soukouss Blade 35mm 7g Mat Pink Tiger

130634saplg501435-m14
Livrare imediată!

31,34Lei

Vobler Rapture Pro Under Silent Sinking, Chartreuse Mat, 6.5cm, 11g

Vobler Rapture Pro Under Silent Sinking, Chartreuse Mat, 6.5cm, 11g

180-02-927
Livrare imediată!

26,00Lei

Cicada Sakura Micro Soukouss Blade 35mm 7g Mat Tiger

Cicada Sakura Micro Soukouss Blade 35mm 7g Mat Tiger

130634saplg501435-m06
Livrare imediată!

31,34Lei

Crank Sakura SCB 100 F 53mm 10.70gr M06 Mat Tiger
Exclusiv online!

Crank Sakura SCB 100 F 53mm 10.70gr M06 Mat Tiger

131234saple500353-m06
Livrare 48-72 ore

49,83Lei

Afişare 101 - 120 din 222 (12 pagini)
Queries: 5, Total time: 7.532 ms [By time] [By id] [By file]
1 (0.147)
SELECT data
FROM `oc_session`
WHERE session_id = '0526a3400b9150ca00cdf9d59e'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.073)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (6.111)
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('+mat' 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.103)
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 100, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.098)
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