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


FOARFECA FIR TEXTIL KORDA

FOARFECA FIR TEXTIL KORDA

a.krzb
Livrare imediată!

40,65Lei

Fir Textil Benzar Braided Method Hooklink 10M, 0.12mm, 7.65kg

Fir Textil Benzar Braided Method Hooklink 10M, 0.12mm, 7.65kg

30598012
Livrare imediată!

13,99Lei

Fir Textil Berkley Whiplash 8 Crystal 0.28mm 47.1kg 150m

Fir Textil Berkley Whiplash 8 Crystal 0.28mm 47.1kg 150m

p.1446626
Livrare imediată!

124,49Lei

FIR TEXTIL SUFIX MATRIX PRO 135M 0.60MM 200LB 90.0KG MID.GREEN -26%

FIR TEXTIL SUFIX MATRIX PRO 135M 0.60MM 200LB 90.0KG MID.GREEN

ds1wt15011tb1p
Livrare imediată!

129,00Lei(-26%) 95,90Lei

FIR TEXTIL SUFIX MATRIX PRO 135M 0.30MM 60LB 27.0KG MID.GREEN -29%

FIR TEXTIL SUFIX MATRIX PRO 135M 0.30MM 60LB 27.0KG MID.GREEN

ds1wt04141tb1p
Livrare imediată!

99,00Lei(-29%) 70,21Lei

FIR TEXTIL DAIWA J-BRAID X8 VERDE 0.13MM 8,0KG 150M
Exclusiv online!

FIR TEXTIL DAIWA J-BRAID X8 VERDE 0.13MM 8,0KG 150M

d.12751.013
Livrare 24-48 ore

82,40Lei

FIR TEXTIL DAIWA J-BRAID X8 VERDE 0.10MM 6,0KG 150M
Exclusiv online!

FIR TEXTIL DAIWA J-BRAID X8 VERDE 0.10MM 6,0KG 150M

d.12751.010
Livrare 24-48 ore

82,44Lei

FIR TEXTIL LINEAEFFE JAPAN BRAID 4X VERDE 150M 0.18MM

FIR TEXTIL LINEAEFFE JAPAN BRAID 4X VERDE 150M 0.18MM

l.3016018
Livrare imediată!

42,82Lei

MONTURA MOSTIRO BOMBA VOPSITA TIJA PB INT FIR TEXTIL FIR DE PAR 2 AC NR 4

MONTURA MOSTIRO BOMBA VOPSITA TIJA PB INT FIR TEXTIL FIR DE PAR 2 AC NR 4

1701920100204
Livrare imediată!

9,00Lei

FIR TEXTIL CARP ZOOM FEEDER 100m 0.06mm 4.24kg -26%

FIR TEXTIL CARP ZOOM FEEDER 100m 0.06mm 4.24kg

cz0207
Livrare imediată!

31,00Lei(-26%) 22,90Lei

FOARFECA PROLOGIC PENTRU FIR TEXTIL

FOARFECA PROLOGIC PENTRU FIR TEXTIL

a.pro.49960
Livrare imediată!

63,86Lei

FIR TEXTIL LINEAEFFE JAPAN BRAID 4X VERDE 150M 0.16MM

FIR TEXTIL LINEAEFFE JAPAN BRAID 4X VERDE 150M 0.16MM

l.3016016
Livrare imediată!

42,82Lei

FIR TEXTIL GAMAKATSU G-POWER PREMIUM YELLOW 012MM/7,2KG/135M
Exclusiv online!

FIR TEXTIL GAMAKATSU G-POWER PREMIUM YELLOW 012MM/7,2KG/135M

gk.5140.112
Livrare 24-48 ore

96,49Lei

Fir textil Jaxon Black Horse PE8X Premium 0.10mm/7kg/125m -21%

Fir textil Jaxon Black Horse PE8X Premium 0.10mm/7kg/125m

zj-bhp010g
Livrare imediată!

127,00Lei(-21%) 99,90Lei

Fir Cormoran Textil CoraStrong 8Braid, Green, 010MM/6,3KG/135M

Fir Cormoran Textil CoraStrong 8Braid, Green, 010MM/6,3KG/135M

c.32.8013510
Livrare imediată!

35,14Lei

FIR TEXTIL KRYSTON JACKAL SEMI STIFF COATED 20M 20LB WEED GREEN -21%

FIR TEXTIL KRYSTON JACKAL SEMI STIFF COATED 20M 20LB WEED GREEN

krja1
Livrare imediată!

62,00Lei(-21%) 48,90Lei

Fir textil Kryston Super Nova Solid Bag Supple Gravel Brown 25lb 20m

Fir textil Kryston Super Nova Solid Bag Supple Gravel Brown 25lb 20m

krsu8
Livrare imediată!

48,00Lei

FIR TEXTIL VARIVAS AVANI ROCK BEAT PE 150M 24.8LB -30%

FIR TEXTIL VARIVAS AVANI ROCK BEAT PE 150M 24.8LB

v2115015
Livrare imediată!

125,00Lei(-30%) 87,50Lei

FIR TEXTIL VARIVAS HIGH GRADE PE VERDE STEALTH 150m 13.1lb -20%

FIR TEXTIL VARIVAS HIGH GRADE PE VERDE STEALTH 150m 13.1lb

v2031501
Livrare imediată!

110,00Lei(-20%) 88,00Lei

FIR TEXTIL VARIVAS SUPER TROUT ADVANCE DOUBLE CROSS PE 8X 100m 6lb -21%

FIR TEXTIL VARIVAS SUPER TROUT ADVANCE DOUBLE CROSS PE 8X 100m 6lb

v41210006
Livrare imediată!

195,01Lei(-21%) 153,90Lei

Afişare 921 - 940 din 3377 (169 pagini)
Queries: 4, Total time: 89.206 ms [By time] [By id] [By file]
1 (0.130)
SELECT data
FROM `oc_session`
WHERE session_id = '3cf02f0d42e13eaebb08c1ad5d'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.100)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (88.832)
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('+textil' 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.144)
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