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 REVANS 010MM/1,30KG/100M

FIR MONOFILAMENT REVANS 010MM/1,30KG/100M

e.936.010
Livrare imediată!

4,15Lei

FIR MONOFILAMENT CARBOTEX 020MM/5,60KG/100M
Exclusiv online!

FIR MONOFILAMENT CARBOTEX 020MM/5,60KG/100M

e.4800.020
Livrare 24-48 ore

12,00Lei

FIR TEXTIL JAXON CONCEPT LINE GALBEN FLUO 100m 0.15mm -30%

FIR TEXTIL JAXON CONCEPT LINE GALBEN FLUO 100m 0.15mm

zj-ncy015a
Livrare imediată!

90,00Lei(-30%) 63,00Lei

FIR TEXTIL TRABUCCO DYNA-TEX POWER SILK FEEDER 100m 0.10m 10LB/4.50kg
Exclusiv online!

FIR TEXTIL TRABUCCO DYNA-TEX POWER SILK FEEDER 100m 0.10m 10LB/4.50kg

054-39-010
Livrare 48-72 ore

79,00Lei

FIR COLMIC PROJECT 360 NX30 100M 0.35mm
Exclusiv online!

FIR COLMIC PROJECT 360 NX30 100M 0.35mm

nypr10035
Livrare 48-72 ore

20,00Lei

ATA MATISAJ FUJI A-ULTRA BRIGHT 100m 50 MAROON 006
Exclusiv online!

ATA MATISAJ FUJI A-ULTRA BRIGHT 100m 50 MAROON 006

mftupa0006
Livrare 48-72 ore

21,00Lei

FIR COLMIC RBS 100M 0.105mm
Exclusiv online!

FIR COLMIC RBS 100M 0.105mm

nyrb10
Livrare 48-72 ore

26,00Lei

Fir monofilament Trabucco S-Force Match Pro 0.20mm/5.60kg/100m

Fir monofilament Trabucco S-Force Match Pro 0.20mm/5.60kg/100m

053-25-200
Livrare imediată!

25,00Lei

ATA MATISAJ FUJI A-ULTRA BRIGHT 100m 50 HOT PINK 022
Exclusiv online!

ATA MATISAJ FUJI A-ULTRA BRIGHT 100m 50 HOT PINK 022

mftupa0022
Livrare 48-72 ore

21,00Lei

FIR MONOFILAMENT STROFT ABR 012MM/1,8KG/100M
Exclusiv online!

FIR MONOFILAMENT STROFT ABR 012MM/1,8KG/100M

st.8112
Livrare 24-48 ore

20,71Lei

FIR COLMIC PROJECT 360 NX30 100M 0.45mm
Exclusiv online!

FIR COLMIC PROJECT 360 NX30 100M 0.45mm

nypr10045
Livrare 48-72 ore

21,50Lei

FIR MONOFILAMENT STROFT LOW STRECH 0.12MM/1,8KG/100M
Exclusiv online!

FIR MONOFILAMENT STROFT LOW STRECH 0.12MM/1,8KG/100M

st.7112
Livrare 24-48 ore

21,85Lei

Fir Professional 0.45mm, 100m
Exclusiv online!

Fir Professional 0.45mm, 100m

30001045
Livrare 24-48 ore

7,00Lei

Fir Titan Power 0.45mm 100m

Fir Titan Power 0.45mm 100m

30005045
Livrare imediată!

8,00Lei

ATA MATISAJ FUJI D-METALLIC 100m 30 ROYAL BLUE 912
Exclusiv online!

ATA MATISAJ FUJI D-METALLIC 100m 30 ROYAL BLUE 912

mftmtd0912
Livrare 48-72 ore

76,01Lei

FIR COLMIC RBS 100M 0.145mm
Exclusiv online!

FIR COLMIC RBS 100M 0.145mm

nyrb14
Livrare 48-72 ore

30,00Lei

FIR COLMIC RBS 100M 0.125mm
Exclusiv online!

FIR COLMIC RBS 100M 0.125mm

nyrb12
Livrare 48-72 ore

26,00Lei

FIR COLMIC RBS 100M 0.090mm
Exclusiv online!

FIR COLMIC RBS 100M 0.090mm

nyrb09
Livrare 48-72 ore

26,00Lei

FIR COLMIC RBS 100M 0.165mm
Exclusiv online!

FIR COLMIC RBS 100M 0.165mm

nyrb16
Livrare 48-72 ore

30,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

Afişare 161 - 180 din 769 (39 pagini)
Queries: 4, Total time: 34.954 ms [By time] [By id] [By file]
1 (0.152)
SELECT data
FROM `oc_session`
WHERE session_id = '378a7b5a1f1a178ebdbc7d7829'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.102)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (34.573)
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('+100m' 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.127)
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