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 90 zile

Retur simplu in 90 zile.

Vezi mai multe detalii

Căutare

Produse ce potrivesc criteriilor de căutare


FIR MONOFILAMENT SUFIX ADVANCE 780M 0.38MM/13.6KG 5.5/30LB/HI VIS YELLOW

FIR MONOFILAMENT SUFIX ADVANCE 780M 0.38MM/13.6KG 5.5/30LB/HI VIS YELLOW

sav38y780
Livrare imediată!

183,92Lei

Fir Textil Trakker Spod Marker Braid, Portocaliu, 30lbs-13.6kg, 0.28mm, 300m
Exclusiv online!

Fir Textil Trakker Spod Marker Braid, Portocaliu, 30lbs-13.6kg, 0.28mm, 300m

228502
Livrare 7-14 zile

122,97Lei

Fir Monofilament Extra Carp Line Max, Brown, 13.6kg, 0.32mm, 300m
Exclusiv online!

Fir Monofilament Extra Carp Line Max, Brown, 13.6kg, 0.32mm, 300m

30-4423
Livrare 48-72ore

55,41Lei

Fir Monofilament Konger Team Carp Black 0.35mm, 13.5kg, 1000m

Fir Monofilament Konger Team Carp Black 0.35mm, 13.5kg, 1000m

110106228001035
Livrare imediată!

47,52Lei

Fir Konger Team Carp Camou Dark, 1000m, 0.35mm, 13.5kg
Exclusiv online!

Fir Konger Team Carp Camou Dark, 1000m, 0.35mm, 13.5kg

110106229001035
Livrare 48-72 ore

49,86Lei

Fir Monofilament Stroft GTM 0.18mm, 3.6kg, 1000

Fir Monofilament Stroft GTM 0.18mm, 3.6kg, 1000

st.6618
Livrare imediată!

137,49Lei

Fir textil Climax iBRAID CHARTREUSE 135m 0.18mm 16.6kg
Exclusiv online!

Fir textil Climax iBRAID CHARTREUSE 135m 0.18mm 16.6kg

9402-10135-018
Livrare 48-72 ore

89,36Lei

Fir textil Climax iBRAID OLIVE GREEN 135m 0.18mm 16.6kg

Fir textil Climax iBRAID OLIVE GREEN 135m 0.18mm 16.6kg

9403-10135-018
Livrare imediată!

89,36Lei

Fir textil Climax iBRAID FLUO RED 135m 0.18mm 16.6kg
Exclusiv online!

Fir textil Climax iBRAID FLUO RED 135m 0.18mm 16.6kg

9401-10135-018
Livrare 48-72 ore

89,36Lei

Fir Textil WIZARD Ultima 8x Braid, Moss Green, 0.18mm, 13.63kg, 150m
Exclusiv online!

Fir Textil WIZARD Ultima 8x Braid, Moss Green, 0.18mm, 13.63kg, 150m

30902018
Livrare 24-48 ore

63,94Lei

Fir MUSTAD Thor Fluorocarbon Leader, Clear, 0.48mm, 13.5kg, 30m
Exclusiv online!

Fir MUSTAD Thor Fluorocarbon Leader, Clear, 0.48mm, 13.5kg, 30m

m.tfcl048.30c
Livrare 24-48 ore

62,02Lei

Fir Fluorocarbon Claumar Pescar Super Soft 20M 12.6KG 0.30MM

Fir Fluorocarbon Claumar Pescar Super Soft 20M 12.6KG 0.30MM

clm238962
Livrare imediată!

29,90Lei

Fir Fluorocarbon Claumar Pescar Super Soft 20M 14.6KG 0.35MM

Fir Fluorocarbon Claumar Pescar Super Soft 20M 14.6KG 0.35MM

clm238979
Livrare imediată!

29,90Lei

Fir Monofilament Energoteam Wizard Hard Game, Transparent, 0.18mm, 3.6kg, 150m
Exclusiv online!

Fir Monofilament Energoteam Wizard Hard Game, Transparent, 0.18mm, 3.6kg, 150m

30980118
Livrare 24-48 ore

23,27Lei

Fir textil Climax FIR BLADE LINE WHITE 100m 0.18mm 13.0kg
Exclusiv online!

Fir textil Climax FIR BLADE LINE WHITE 100m 0.18mm 13.0kg

9421-00100-018
Livrare 48-72 ore

53,77Lei

Fir Textil ZEOX Element Leader Camo, 31.6kg, 0.35mm, 25m
Exclusiv online!

Fir Textil ZEOX Element Leader Camo, 31.6kg, 0.35mm, 25m

gcz-4110109
Livrare 48-72 ore

11,88Lei

Fir Textil ZEOX Element Leader Silt, 13.3kg, 0.18mm, 25m
Exclusiv online!

Fir Textil ZEOX Element Leader Silt, 13.3kg, 0.18mm, 25m

gcz-4110123
Livrare 48-72 ore

12,90Lei

Fir Textil ZEOX Element Leader Silt, 31.6kg, 0.35mm, 25m
Exclusiv online!

Fir Textil ZEOX Element Leader Silt, 31.6kg, 0.35mm, 25m

gcz-4110129
Livrare 48-72 ore

12,90Lei

Fir Textil ZEOX Element Leader Camo, 13.3kg, 0.18mm, 25m
Exclusiv online!

Fir Textil ZEOX Element Leader Camo, 13.3kg, 0.18mm, 25m

gcz-4110103
Livrare 48-72 ore

11,88Lei

FIR TEXTIL CARP ZOOM ALLROUND FISHING 110m 0.18mm 13.76kg Verde
Exclusiv online!

FIR TEXTIL CARP ZOOM ALLROUND FISHING 110m 0.18mm 13.76kg Verde

cz0276
Livrare 48-72 ore

31,50Lei

Afişare 1 - 20 din 38 (2 pagini)
Queries: 12, Total time: 2.003 ms [By time] [By id] [By file]
1 (0.127)
SELECT data
FROM `oc_session`
WHERE session_id = '1f310c6c48c5e95bc7c095bb6c'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.107)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.107)
CREATE TEMPORARY TABLE oc_bf_tmp_product ( product_id int PRIMARY KEY, sort_order int, quantity int, manufacturer_id int, match_filters int, actual_price DECIMAL(10, 4), sort int, INDEX my_index (match_filters, sort_order, manufacturer_id) ) ENGINE=MEMORY
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:837
4 (0.131)
INSERT INTO oc_bf_tmp_product (product_id, sort_order, quantity, manufacturer_id, match_filters, actual_price, sort) VALUES ("64437", "2", "1", "135", "1", "152.000000000000", "1"),("210271", "2", "1000", "476", "1", "101.630000000000", "2"),("227032", "1", "1000", "96", "1", "45.790000000000", "3"),("174017", "2", "1003", "500", "1", "39.270000000000", "4"),("181311", "2", "1000", "500", "1", "41.210000000000", "5"),("144049", "2", "1002", "159", "1", "113.630000000000", "6"),("105662", "2", "1000", "128", "1", "73.850000000000", "7"),("105674", "2", "1001", "128", "1", "73.850000000000", "8"),("105650", "2", "1000", "128", "1", "73.850000000000", "9"),("220499", "2", "1000", "401", "1", "52.840000000000", "10"),("229504", "2", "1000", "20", "1", "51.260000000000", "11"),("63649", "-100", "46", "26", "1", "24.710000000000", "12"),("63651", "-100", "29", "26", "1", "24.710000000000", "13"),("205527", "2", "1000", "24", "1", "19.230000000000", "14"),("105580", "2", "1000", "128", "1", "44.440000000000", "15"),("198743", "1", "1000", "782", "1", "9.820000000000", "16"),("198753", "1", "1000", "782", "1", "10.660000000000", "17"),("198765", "1", "1000", "782", "1", "10.660000000000", "18"),("198731", "1", "1000", "782", "1", "9.820000000000", "19"),("35663", "2", "999", "75", "1", "26.030000000000", "20"),("175117", "2", "1005", "124", "1", "28.550000000000", "21"),("105808", "2", "1001", "128", "1", "183.100000000000", "22"),("105596", "2", "1000", "128", "1", "44.440000000000", "23"),("105612", "2", "1000", "128", "1", "44.440000000000", "24"),("228557", "1", "1000", "362", "1", "29.150000000000", "25"),("105812", "2", "1", "128", "1", "422.600000000000", "26"),("192229", "1", "1000", "727", "1", "126.850000000000", "27"),("142015", "2", "1001", "11", "1", "68.270000000000", "28"),("158387", "2", "1006", "54", "1", "23.510000000000", "29"),("203421", "1", "1000", "188", "1", "8.730000000000", "30"),("31177", "2", "1000", "135", "1", "84.780000000000", "31"),("169028", "1", "1004", "54", "1", "36.960000000000", "32"),("248876", "1", "1000", "54", "1", "37.800000000000", "33"),("198691", "1", "0", "59", "1", "330.200000000000", "34"),("198699", "1", "0", "59", "1", "740.310000000000", "35"),("232156", "1", "0", "528", "1", "9.230000000000", "36"),("31167", "2", "0", "135", "1", "47.790000000000", "37"),("109106", "2", "0", "12", "1", "46.850000000000", "38")
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:846
5 (0.086)
SELECT COUNT(1) AS total
FROM ( SELECT p.*
FROM `oc_bf_tmp_product` AS p
WHERE match_filters = 1) AS t
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1593
6 (0.182)
SELECT p.*
FROM `oc_bf_tmp_product` AS p
INNER JOIN `oc_product_description` AS pd ON (pd.product_id = p.product_id)
WHERE match_filters = 1 AND pd.language_id = '2' LIMIT 0, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
7 (0.102)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"ZFISHING SPORT WHOLESALE S.R.O"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
8 (0.271)
SELECT DISTINCT m.manufacturer_id AS id, CONCAT(UCASE(LEFT(m.name, 1)), LCASE(SUBSTRING(m.name, 2))) AS name
FROM `oc_manufacturer` AS m
INNER JOIN `oc_bf_tmp_product` AS p ON (m.manufacturer_id = p.manufacturer_id)
WHERE match_filters = 1
ORDER BY m.sort_order, m.name
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:1393
9 (0.077)
SELECT stock_status_id AS id, name
FROM `oc_stock_status`
WHERE language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:1415
10 (0.066)
SELECT MIN(actual_price) AS min, MAX(actual_price) AS max
FROM `oc_bf_tmp_product` AS p
WHERE match_filters = 1
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:1180
11 (0.612)
SELECT COUNT(1) AS val, filter_group, filter_id
FROM `oc_bf_tmp_product` AS p
INNER JOIN `oc_bf_filter` AS f ON (p.product_id = f.product_id)
WHERE match_filters = 1 AND f.language_id = '2' GROUP BY filter_group, filter_id
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:1094
12 (0.135)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '2' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:37