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


FIR MONOFILAMENT ASSO SINKING 3X FEEDER - Brown 0.219mm 150m 3.2Kg

FIR MONOFILAMENT ASSO SINKING 3X FEEDER - Brown 0.219mm 150m 3.2Kg

604080035
Stoc epuizat

53,48Lei

Fir Textil ASSO 8xPE Lure Braid 0.10mm 150m

Fir Textil ASSO 8xPE Lure Braid 0.10mm 150m

611080003
Stoc epuizat

114,05Lei

Fir Textil EnergoTeam Koos 12X Monster 0.76mm 300m

Fir Textil EnergoTeam Koos 12X Monster 0.76mm 300m

30397209
Stoc epuizat

382,00Lei

Fir Textil Prologic Viper 3S 30LBS/15M

Fir Textil Prologic Viper 3S 30LBS/15M

a.pro.50086
Stoc epuizat

39,40Lei

FIR NASH MONOFILAMENT BULLET GREEN, 0.40mm, 20lb/9.07kg -49%

FIR NASH MONOFILAMENT BULLET GREEN, 0.40mm, 20lb/9.07kg

t2803
Stoc epuizat

115,99Lei(-49%) 59,48Lei

Lanseta Sportex CATFIRE VERTICAL 195 170-300gr

Lanseta Sportex CATFIRE VERTICAL 195 170-300gr

cf1908
Stoc epuizat

840,00Lei

Fir monofilament Carp Spirit Velocity Impact Abrasion Shock Leader Green 0.50mm/18.15kg/100m
FIR ENERGOTEAM MONOFILAMENT CARP HUNTER FEEDER 600M 0.16mm 3.20kg

FIR ENERGOTEAM MONOFILAMENT CARP HUNTER FEEDER 600M 0.16mm 3.20kg

30040616
Stoc epuizat

15,01Lei

FIR TEXTIL CARP ZOOM CLASSIC BRAID 120m 0.16mm 9.4kg Galben Fluo -20%

FIR TEXTIL CARP ZOOM CLASSIC BRAID 120m 0.16mm 9.4kg Galben Fluo

cz4748
Stoc epuizat

42,00Lei(-20%) 33,61Lei

Delphin Mr ROLLER Fir pentru jaluzele 1000m 0.80mm 69.3lbs

Delphin Mr ROLLER Fir pentru jaluzele 1000m 0.80mm 69.3lbs

500706995
Stoc epuizat

405,00Lei

Fir Monofilament EnergoTeam Specialist Catfish 0.50mm/150m/28.75kg -20%

Fir Monofilament EnergoTeam Specialist Catfish 0.50mm/150m/28.75kg

33230050
Stoc epuizat

16,51Lei(-20%) 13,20Lei

FIR MONOFILAMENT CARBOTEX 022MM/8,40KG/100M

FIR MONOFILAMENT CARBOTEX 022MM/8,40KG/100M

e.4800.022
Stoc epuizat

12,14Lei

FIR TEXTIL BERKLEY NEW 2014 FIRELINE GRI 012MM/6,8KG/110M

FIR TEXTIL BERKLEY NEW 2014 FIRELINE GRI 012MM/6,8KG/110M

p.1308655
Stoc epuizat

79,49Lei

Fir Textil Sunline Siglon PE x4 Light Green 50LB 0.296mm -27%

Fir Textil Sunline Siglon PE x4 Light Green 50LB 0.296mm

sunline-30727
Stoc epuizat

55,00Lei(-27%) 39,90Lei

FIR MONOFILAMENT REVANS 012MM/1,60KG/100M

FIR MONOFILAMENT REVANS 012MM/1,60KG/100M

e.936.012
Stoc epuizat

4,19Lei

FIR MONOFILAMENT TRABUCCO SUPER SOFT 0.25mm/200m

FIR MONOFILAMENT TRABUCCO SUPER SOFT 0.25mm/200m

052-55-250
Stoc epuizat

25,00Lei

Fir PB Products Textil Gatorbraid 2 Tone 1000m 25lbs

Fir PB Products Textil Gatorbraid 2 Tone 1000m 25lbs

pb11502
Stoc epuizat

578,99Lei

FIR MONOFILAMENT DAIWA PROREX S.SOFT 0.33MM/8.3KG/270M PURPLE

FIR MONOFILAMENT DAIWA PROREX S.SOFT 0.33MM/8.3KG/270M PURPLE

d.12821.033
Stoc epuizat

37,60Lei

LANSETA BOLOGNEZA JAXON ZAFFIRA TX 5.00M 3 15G

LANSETA BOLOGNEZA JAXON ZAFFIRA TX 5.00M 3 15G

wj-zfg500
Stoc epuizat

170,00Lei

Fir textil Jaxon Black Horse PE8X Premium 0.22mm/25kg/125m

Fir textil Jaxon Black Horse PE8X Premium 0.22mm/25kg/125m

zj-bhp022g
Stoc epuizat

107,00Lei

Afişare 9381 - 9400 din 10732 (537 pagini)
Queries: 7, Total time: 1,450.923 ms [By time] [By id] [By file]
1 (1.804)
SELECT data
FROM `oc_session`
WHERE session_id = '6b24d59d0544084b3b10b98e0b'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.130)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (1,404.147)
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 (pd.tag LIKE "%fir%") 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:724
4 (44.401)
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 9380, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.169)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"RAPALA VMC ROMANIA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
6 (0.136)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"ABREVIS"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
7 (0.136)
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