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


Vartej NASH Quick Change Helicopter Swivel, Size 8, 10buc/pac

Vartej NASH Quick Change Helicopter Swivel, Size 8, 10buc/pac

t8115
Stoc epuizat

24,38Lei

Grub Relax Turbo Twister Laminat Blister, TL115, 11cm, 8g, 4buc/plic
Exclusiv online!

Grub Relax Turbo Twister Laminat Blister, TL115, 11cm, 8g, 4buc/plic

trt5-tl115-b
Livrare 48-72ore

9,14Lei

Curea Reglabila Graff 1_115
Exclusiv online!

Curea Reglabila Graff 1_115

040-1_115
Livrare 48-72 ore

92,41Lei

Montura Nash Cling On Fused Leader, 40lb, 1m, 1buc/ plic

Montura Nash Cling On Fused Leader, 40lb, 1m, 1buc/ plic

t8175
Livrare imediată!

35,56Lei

Surub Pop-up Nash Sweetcorn Screw, Yellow, Large, 6buc/plic -20%

Surub Pop-up Nash Sweetcorn Screw, Yellow, Large, 6buc/plic

t8110
Livrare imediată!

33,99Lei(-20%) 27,35Lei

Vobler FL FL115 Floating 100mm 15.5g Depth 0.6-1.2m Colour 251

Vobler FL FL115 Floating 100mm 15.5g Depth 0.6-1.2m Colour 251

fl115-floating-0.6-1.2m-100mm-15.5g-251
Livrare imediată!

18,39Lei

Vobler FL FL115 Floating 100mm 15.5g Depth 0.6-1.2m Colour 258

Vobler FL FL115 Floating 100mm 15.5g Depth 0.6-1.2m Colour 258

fl115-floating-0.6-1.2m-100mm-15.5g-258
Livrare imediată!

18,39Lei

Vobler FL FL115 Floating 100mm 15.5g Depth 0.6-1.2m Colour 11

Vobler FL FL115 Floating 100mm 15.5g Depth 0.6-1.2m Colour 11

fl115-floating-0.6-1.2m-100mm-15.5g-11
Livrare imediată!

18,39Lei

Vobler FL FL115 Floating 100mm 15.5g Depth 0.6-1.2m Colour 257

Vobler FL FL115 Floating 100mm 15.5g Depth 0.6-1.2m Colour 257

fl115-floating-0.6-1.2m-100mm-15.5g-257
Livrare imediată!

18,39Lei

Vobler FL FL115 Floating 100mm 15.5g Depth 0.6-1.2m Colour 606

Vobler FL FL115 Floating 100mm 15.5g Depth 0.6-1.2m Colour 606

fl115-floating-0.6-1.2m-100mm-15.5g-606
Livrare imediată!

18,39Lei

Vobler FL FL115 Floating 100mm 15.5g Depth 0.6-1.2m Colour 170

Vobler FL FL115 Floating 100mm 15.5g Depth 0.6-1.2m Colour 170

fl115-floating-0.6-1.2m-100mm-15.5g-170
Livrare imediată!

18,39Lei

Binoclu Hawke Frontier LRF 2300 10x42
Exclusiv online!

Binoclu Hawke Frontier LRF 2300 10x42

vd.38615
Livrare 24-48 ore

6.558,90Lei

SAPCA TICA CU PROTECTIE PENTRU SOARE

SAPCA TICA CU PROTECTIE PENTRU SOARE

mb115
Livrare imediată!

56,92Lei

Groundsheet Nash Titan T3 Heavy Duty

Groundsheet Nash Titan T3 Heavy Duty

t4116
Livrare imediată!

580,58Lei

Carlige Nash Twister Size 5 Micro Barbed -28%

Carlige Nash Twister Size 5 Micro Barbed

t6110
Livrare imediată!

29,29Lei(-28%) 21,24Lei

Carlige Nash Twister Size 8 Micro Barbed

Carlige Nash Twister Size 8 Micro Barbed

t6113
Livrare imediată!

30,48Lei

Winterskin Nash Bank Life Blockhouse Camo Pro Overwrap

Winterskin Nash Bank Life Blockhouse Camo Pro Overwrap

t1153
Livrare imediată!

1.699,06Lei

CUTIT RON THOMPSON ONTARIO PENTRU FILETAT LAMA=15.2CM

CUTIT RON THOMPSON ONTARIO PENTRU FILETAT LAMA=15.2CM

h.tho.58135
Livrare imediată!

32,23Lei

Punga Coghlans impermeabila 12.7 x 17.7 cm
Exclusiv online!

Punga Coghlans impermeabila 12.7 x 17.7 cm

c8415
Livrare 24-48 ore

28,35Lei

FIR TEXTIL STROFT GTP GRI E1 4.75KG/100M -27%
Exclusiv online!

FIR TEXTIL STROFT GTP GRI E1 4.75KG/100M

st.77115
Livrare 24-48 ore

117,39Lei(-27%) 85,47Lei

Afişare 1 - 20 din 54 (3 pagini)
Queries: 12, Total time: 2.675 ms [By time] [By id] [By file]
1 (0.133)
SELECT data
FROM `oc_session`
WHERE session_id = '7ebbefb44dbd13ea912f40aa59'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.147)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.122)
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.164)
INSERT INTO oc_bf_tmp_product (product_id, sort_order, quantity, manufacturer_id, match_filters, actual_price, sort) VALUES ("235163", "2", "0", "59", "1", "20.150000000000", "1"),("197971", "1", "1000", "48", "1", "7.550000000000", "2"),("168239", "10", "1000", "137", "1", "76.370000000000", "3"),("187753", "2", "6", "59", "1", "29.390000000000", "4"),("119846", "2", "4", "59", "1", "22.600000000000", "5"),("118179", "1", "1008", "13", "1", "15.200000000000", "6"),("118181", "1", "1008", "13", "1", "15.200000000000", "7"),("118177", "1", "1007", "13", "1", "15.200000000000", "8"),("118180", "1", "1005", "13", "1", "15.200000000000", "9"),("118182", "1", "1005", "13", "1", "15.200000000000", "10"),("118178", "1", "1003", "13", "1", "15.200000000000", "11"),("168451", "10", "1000", "445", "1", "5420.580000000000", "12"),("35459", "2", "1004", "113", "1", "47.040000000000", "13"),("83684", "2", "2", "59", "1", "479.820000000000", "14"),("106804", "1", "12", "59", "1", "17.550000000000", "15"),("106807", "1", "7", "59", "1", "25.190000000000", "16"),("171245", "2", "2", "59", "1", "1404.180000000000", "17"),("110784", "4", "1001", "86", "1", "26.640000000000", "18"),("72826", "2", "1000", "464", "1", "23.430000000000", "19"),("48608", "2", "1000", "159", "1", "70.640000000000", "20"),("115187", "1", "2", "85", "1", "13.890000000000", "21"),("109134", "2", "1000", "47", "1", "65.200000000000", "22"),("248401", "1", "1010", "13", "1", "7.460000000000", "23"),("248403", "1", "1009", "13", "1", "7.460000000000", "24"),("144397", "2", "1000", "85", "1", "14.130000000000", "25"),("248696", "1", "1008", "13", "1", "7.460000000000", "26"),("166981", "1", "0", "59", "1", "17.630000000000", "27"),("234277", "2", "0", "59", "1", "21.830000000000", "28"),("235160", "2", "0", "59", "1", "20.150000000000", "29"),("235164", "2", "0", "59", "1", "20.150000000000", "30"),("83332", "2", "0", "59", "1", "1420.980000000000", "31"),("100591", "1", "0", "59", "1", "80.240000000000", "32"),("73099", "2", "0", "464", "1", "6.830000000000", "33"),("167652", "1", "0", "59", "1", "3139.480000000000", "34"),("106805", "1", "0", "59", "1", "17.550000000000", "35"),("106806", "1", "0", "59", "1", "13.930000000000", "36"),("106808", "1", "0", "59", "1", "13.930000000000", "37"),("111872", "1", "0", "23", "1", "90.000000000000", "38"),("132921", "2", "0", "59", "1", "328.550000000000", "39"),("234418", "2", "0", "59", "1", "46.200000000000", "40"),("234809", "10", "0", "59", "1", "210.870000000000", "41"),("37565", "2", "0", "47", "1", "13.170000000000", "42"),("234064", "2", "0", "59", "1", "62.170000000000", "43"),("234156", "2", "0", "59", "1", "25.190000000000", "44"),("203663", "2", "0", "59", "1", "14.370000000000", "45"),("80999", "10", "0", "445", "1", "99.410000000000", "46"),("84686", "2", "0", "85", "1", "198.970000000000", "47"),("234126", "2", "0", "59", "1", "25.190000000000", "48"),("234127", "2", "0", "59", "1", "25.190000000000", "49"),("234128", "2", "0", "59", "1", "25.190000000000", "50"),("234512", "1", "0", "59", "1", "412.590000000000", "51"),("138377", "1", "0", "85", "1", "21.870000000000", "52"),("198701", "1", "0", "59", "1", "740.310000000000", "53"),("83667", "2", "0", "59", "1", "152.080000000000", "54")
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:846
5 (0.081)
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.262)
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.112)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"TACKLE SHOP ARENA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
8 (0.276)
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.090)
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.085)
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 (1.094)
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.109)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '0' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:37