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 FLUOROCARBON SUFIX INVISILINE CLEAR W/SOCKET 20M 0.30MM

FIR FLUOROCARBON SUFIX INVISILINE CLEAR W/SOCKET 20M 0.30MM

sil30c20h
Stoc epuizat

49,00Lei

Fir ASSO Fluorocarbon Invisible Clear 0.28mm 50m

Fir ASSO Fluorocarbon Invisible Clear 0.28mm 50m

605080008
Stoc epuizat

44,87Lei

CUTIE MEIHO REVERSIBLE 165 CLEAR -27%

CUTIE MEIHO REVERSIBLE 165 CLEAR

rev165c
Stoc epuizat

85,00Lei(-27%) 62,00Lei

CUTIE MEIHO REVERSIBLE 100 CLEAR

CUTIE MEIHO REVERSIBLE 100 CLEAR

rev100c
Stoc epuizat

59,00Lei

Fir Dragon Nano Crystal Clear 0.18mm / 4.5kg -15%

Fir Dragon Nano Crystal Clear 0.18mm / 4.5kg

pdf3240018
Stoc epuizat

11,95Lei(-15%) 10,16Lei

FIR MONOFILAMENT DAIWA TD SUPER SOFT CLEAR 030MM 8.6KG 135M

FIR MONOFILAMENT DAIWA TD SUPER SOFT CLEAR 030MM 8.6KG 135M

d.12853.030
Stoc epuizat

24,60Lei

Tub Termocontractabil Climax CULT CRAP SHRINK TUBES 50cm 1.6mm Clear

Tub Termocontractabil Climax CULT CRAP SHRINK TUBES 50cm 1.6mm Clear

9900-00020-160
Stoc epuizat

22,00Lei

Fir Textil Rapture Dyna-Tex Clear Ice 0.25mm 12.7kg 100m

Fir Textil Rapture Dyna-Tex Clear Ice 0.25mm 12.7kg 100m

054-90-250
Stoc epuizat

45,01Lei

FLUOROCARBON RIDGE MONKEY 20MT 15LB CLEAR -35%

FLUOROCARBON RIDGE MONKEY 20MT 15LB CLEAR

rm-t 048
Stoc epuizat

52,00Lei(-35%) 33,80Lei

VOBLER ILLEX CHUBBY POPPER 42 4,2CM/3,3G CLEAR BLEAK

VOBLER ILLEX CHUBBY POPPER 42 4,2CM/3,3G CLEAR BLEAK

si.00050
Stoc epuizat

109,73Lei

Fir P-LINE SHINSEI FLUOROCARBON 25 M 0.535 MM CLEAR

Fir P-LINE SHINSEI FLUOROCARBON 25 M 0.535 MM CLEAR

750187920
Stoc epuizat

85,00Lei

Fir monofilament P-Line CXX Hi-Vis Clear Fluo 0.23mm/6lb/274m

Fir monofilament P-Line CXX Hi-Vis Clear Fluo 0.23mm/6lb/274m

750187251
Stoc epuizat

49,00Lei

Fir Inaintas P-LINE CXX LEADER MATERIAL 50 M 0.188 MM CRYSTAL CLEAR

Fir Inaintas P-LINE CXX LEADER MATERIAL 50 M 0.188 MM CRYSTAL CLEAR

750186290
Stoc epuizat

12,00Lei

Tub Black Cat Silicon 5-2mm 1m Clear

Tub Black Cat Silicon 5-2mm 1m Clear

6612002
Stoc epuizat

22,03Lei

Fir Inaintas P-LINE CXX LEADER MATERIAL 50 M 0.165 MM CRYSTAL CLEAR

Fir Inaintas P-LINE CXX LEADER MATERIAL 50 M 0.165 MM CRYSTAL CLEAR

750186289
Stoc epuizat

11,00Lei

Fir P-LINE FLOROCLEAR 1000 M 0.28MM Clear

Fir P-LINE FLOROCLEAR 1000 M 0.28MM Clear

750187628
Stoc epuizat

68,00Lei

Fir Rapture SFT PRESENTATION WF 8 INT 30m MATT CLEAR

Fir Rapture SFT PRESENTATION WF 8 INT 30m MATT CLEAR

050-15-010
Stoc epuizat

290,00Lei

Fir Monofilament Benzar River Feeder Mono Clear Transparent 150m 0.20mm 5.90kg
Fir P-LINE CFX FLUOROCARBONIO 50 M 0.34 MM 15Lb CLEAR

Fir P-LINE CFX FLUOROCARBONIO 50 M 0.34 MM 15Lb CLEAR

750186209
Stoc epuizat

45,01Lei

Fir Asso New Micron 3 Clear 0.070mm 100m 0.51kg

Fir Asso New Micron 3 Clear 0.070mm 100m 0.51kg

111108204
Stoc epuizat

38,57Lei

Afişare 501 - 520 din 585 (30 pagini)
Queries: 13, Total time: 30.341 ms [By time] [By id] [By file]
1 (0.122)
SELECT data
FROM `oc_session`
WHERE session_id = '421426030dc4eed334927c2db7'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.112)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (24.665)
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('+clear' 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 (4.495)
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 500, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.122)
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.105)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"CARP INTELLIGENCE LTD"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
7 (0.099)
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
8 (0.097)
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
9 (0.095)
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
10 (0.095)
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
11 (0.096)
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
12 (0.096)
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
13 (0.142)
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