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 CARBOTEX 027MM/9,95KG/100M

FIR MONOFILAMENT CARBOTEX 027MM/9,95KG/100M

e.4800.027
Stoc epuizat

13,11Lei

FIR PROLOGIC LEADER MIMICRY GREEN HELO 0.40MM/11KG/100M

FIR PROLOGIC LEADER MIMICRY GREEN HELO 0.40MM/11KG/100M

a.pro.57090
Stoc epuizat

49,55Lei

FIR MONOFILAMENT MAVER DYNASTY GREEN 600m 0.20mm -30%

FIR MONOFILAMENT MAVER DYNASTY GREEN 600m 0.20mm

700020
Stoc epuizat

39,00Lei(-30%) 27,30Lei

FIR MONOFILAMENT MAVER SMART ELITE FLUOROCARBON 100M 0.125MM

FIR MONOFILAMENT MAVER SMART ELITE FLUOROCARBON 100M 0.125MM

725125
Stoc epuizat

28,00Lei

FIR MONOFILAMENT GAMAKATSU G-LINE COMPETITION 010MM/1,30KG/100M

FIR MONOFILAMENT GAMAKATSU G-LINE COMPETITION 010MM/1,30KG/100M

gk.5076.010
Stoc epuizat

25,92Lei

Fir Carp Expert UV 300m 0.35mm

Fir Carp Expert UV 300m 0.35mm

30119035
Stoc epuizat

20,00Lei

Fir Daiwa Monofilament TN SW Shock Leader, 0.80mm 40.30kg 50m

Fir Daiwa Monofilament TN SW Shock Leader, 0.80mm 40.30kg 50m

d.12957.080
Stoc epuizat

43,20Lei

Fir Carp Expert Boilie Special Multicolor 0.25mm 300m

Fir Carp Expert Boilie Special Multicolor 0.25mm 300m

30125025
Stoc epuizat

21,50Lei

Fir Select Baits Techno-Line 600m Titan Grey 0.35mm -35%

Fir Select Baits Techno-Line 600m Titan Grey 0.35mm

sel-218035
Stoc epuizat

49,00Lei(-35%) 31,90Lei

FIR MONOFILAMENT MAVER SMART DUAL BAND 600M 0.25MM

FIR MONOFILAMENT MAVER SMART DUAL BAND 600M 0.25MM

626025
Stoc epuizat

63,00Lei

Fir Inaintas Conic P-Line Konico 0.23mm-0.57mm, 5x15m/75m

Fir Inaintas Conic P-Line Konico 0.23mm-0.57mm, 5x15m/75m

750187453
Stoc epuizat

48,00Lei

FIR MONOFILAMENT KORDA CARP LINE 1000M 0.40MM

FIR MONOFILAMENT KORDA CARP LINE 1000M 0.40MM

a.kcm15
Stoc epuizat

83,61Lei

FIR MONOFILAMENT DAIWA T D SALTWATER ALBASTRU TRANSLUCID 300M 0.30MM

FIR MONOFILAMENT DAIWA T D SALTWATER ALBASTRU TRANSLUCID 300M 0.30MM

d.tdlsw30030
Stoc epuizat

46,02Lei

Fir ENERGO TEAM Carp Hunter Feeder 150m 0.25mm 8.30kg

Fir ENERGO TEAM Carp Hunter Feeder 150m 0.25mm 8.30kg

30040125
Stoc epuizat

7,50Lei

FIR MONO CARP ZOOM MARSHAL ORIGO CARP LINE 1000M 0.33mm 8.90kg Fluo Orange -25%

FIR MONO CARP ZOOM MARSHAL ORIGO CARP LINE 1000M 0.33mm 8.90kg Fluo Orange

cz6964
Stoc epuizat

72,99Lei(-25%) 54,80Lei

Fir monofilament Kryston Oblivion Super Grade Copolymer 0.40mm/20lb/1000m matt camou
Fir Delphin FIN Carp ARMADA 1200m Camuflaj 0.28mm 13lbs

Fir Delphin FIN Carp ARMADA 1200m Camuflaj 0.28mm 13lbs

500623428
Stoc epuizat

87,00Lei

FIR TRABUCCO T-FORCE XPS METHOD FEEDER 0.18-150M -42%

FIR TRABUCCO T-FORCE XPS METHOD FEEDER 0.18-150M

053-96-180
Stoc epuizat

31,00Lei(-42%) 18,09Lei

Fir Monofilament Delphin Tokyo Portocaliu 0.286 mm 1200M

Fir Monofilament Delphin Tokyo Portocaliu 0.286 mm 1200M

101000203
Stoc epuizat

100,00Lei

Fir monofilament Climax CULT CRAP FLEXI CHOD MONO HOOKLINK 20m 0.40mm 15lb

Fir monofilament Climax CULT CRAP FLEXI CHOD MONO HOOKLINK 20m 0.40mm 15lb

8700-10002-040
Stoc epuizat

31,00Lei

Afişare 4161 - 4180 din 4621 (232 pagini)
Queries: 7, Total time: 708.269 ms [By time] [By id] [By file]
1 (0.130)
SELECT data
FROM `oc_session`
WHERE session_id = 'cd940b0273d7d8b097a88223d7'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.101)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (707.602)
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 (pd.tag LIKE "%monofilament%") 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 (0.117)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"P-LINE EUROPE S.R.L"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
5 (0.108)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"PRODUSE INACTIVE"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
6 (0.098)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"PRODUSE INACTIVE"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
7 (0.113)
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