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

Produse ce potrivesc criteriilor de căutare


MINCIOG DAIWA PROREX 2,40M 80X70CM -20%

MINCIOG DAIWA PROREX 2,40M 80X70CM

a2.d15809.580
Stoc epuizat

347,15Lei(-20%) 277,73Lei

MINCIOG DAIWA PROREX 2,20M 80X70CM

MINCIOG DAIWA PROREX 2,20M 80X70CM

a2.d15809.680
Stoc epuizat

205,52Lei

MINCIOG SAVAGE GEAR TELE FULL FRAME ROUND 46X56X50CM 99-150CM

MINCIOG SAVAGE GEAR TELE FULL FRAME ROUND 46X56X50CM 99-150CM

a2.sg.71107
Stoc epuizat

248,42Lei

CAP MINCIOG DELPHIN SYMBOL 100x100cm

CAP MINCIOG DELPHIN SYMBOL 100x100cm

101001498
Stoc epuizat

180,00Lei

Maner minciog Delphin SYMBOL NXT 2.20m 2seg -25%

Maner minciog Delphin SYMBOL NXT 2.20m 2seg

101002514
Stoc epuizat

188,00Lei(-25%) 141,00Lei

Maner pentru minciog Delphin ATAK! SINGLE 40cm -32%

Maner pentru minciog Delphin ATAK! SINGLE 40cm

101002515
Stoc epuizat

53,00Lei(-32%) 36,00Lei

Maner pentru minciog Delphin ATAK! SINGLE 90cm -19%

Maner pentru minciog Delphin ATAK! SINGLE 90cm

101002516
Stoc epuizat

68,00Lei(-19%) 55,00Lei

MANER MINCIOG GURU 2BUC A CLASS 300 PT. MINCIOG 3M

MANER MINCIOG GURU 2BUC A CLASS 300 PT. MINCIOG 3M

a2.gu.gac019
Stoc epuizat

254,70Lei

Cap Minciog Plutitor Delphin Atack SPR 60X50mm -35%

Cap Minciog Plutitor Delphin Atack SPR 60X50mm

101002352
Stoc epuizat

108,00Lei(-35%) 70,00Lei

Cap Minciog Plutitor Delphin Hybrid 60x50cm -40%

Cap Minciog Plutitor Delphin Hybrid 60x50cm

101002354
Stoc epuizat

118,00Lei(-40%) 71,00Lei

Cap Minciog Plutitor Delphin Atack SPR 50X40mm -35%

Cap Minciog Plutitor Delphin Atack SPR 50X40mm

101002351
Stoc epuizat

93,00Lei(-35%) 60,00Lei

COADA MINCIOG TELESCOPICA FL TEAM FEEDER POWER FIGHTER 3.00M

COADA MINCIOG TELESCOPICA FL TEAM FEEDER POWER FIGHTER 3.00M

3102-3003
Stoc epuizat

111,90Lei

Minciog Maver Gummy Arm 50x40cm

Minciog Maver Gummy Arm 50x40cm

1979001
Stoc epuizat

254,01Lei

MANER MINCIOG TELESCOPIC KORUM OPPORTUNIST NET HANDLE 1.80M

MANER MINCIOG TELESCOPIC KORUM OPPORTUNIST NET HANDLE 1.80M

k0380014
Stoc epuizat

193,46Lei

Minciog Complet Filfishing Filex ERA 100x100x100cm + Maner 1.80m

Minciog Complet Filfishing Filex ERA 100x100x100cm + Maner 1.80m

fil0647
Stoc epuizat

125,00Lei

COADA MINCIOG TELESCOPICA FL TEAM FEEDER POWER FIGHTER 3.50M

COADA MINCIOG TELESCOPICA FL TEAM FEEDER POWER FIGHTER 3.50M

3102-3504
Stoc epuizat

103,90Lei

CAP MINCIOG KORUM FOLDING LATEX TRIANGLE NET 30"

CAP MINCIOG KORUM FOLDING LATEX TRIANGLE NET 30"

k0380021
Stoc epuizat

152,96Lei

MANER MINCIOG PRESTON RESPONSE CARP HANDLE 2.70m

MANER MINCIOG PRESTON RESPONSE CARP HANDLE 2.70m

p0230002
Stoc epuizat

359,96Lei

CAP MINCIOG KORUM FOLDING TRIANGLE NET 72CM

CAP MINCIOG KORUM FOLDING TRIANGLE NET 72CM

k0380016
Stoc epuizat

143,95Lei

CAP DE MINCIOG KORUM FAST NET HEAD 26"

CAP DE MINCIOG KORUM FAST NET HEAD 26"

k0380029
Stoc epuizat

166,46Lei

Afişare 1021 - 1040 din 1357 (68 pagini)
Queries: 5, Total time: 48.440 ms [By time] [By id] [By file]
1 (0.149)
SELECT data
FROM `oc_session`
WHERE session_id = 'e339f5ec665aedd05d17221de0'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.089)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (42.443)
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('+minciog' 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 (5.621)
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 1020, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.138)
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