Gama variata de produse

La Claumar Pescar poti alege simplu si rapid dintr-o gama variata de articole de pescuit.

Transport Gratuit

Comenzile peste 400 lei pot beneficia de transport gratuit.

Vezi mai multe detalii

Plata cu cardul

Plata cu cardul in rate fara dobanda.

Vezi mai multe detalii

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

Retur simplu in 90 zile.

Vezi mai multe detalii

Căutare - Nomura

Filtreaza

Produse ce potrivesc criteriilor de căutare

Sortare după:

-26%

VOBLER NOMURA TOKYO CRANK FLOATING 912 5.5CM 8.8G

nm.50391205

Stoc epuizat

35,60Lei(-26%) 26,34Lei

-25%

Vobler Nomura Trouty 2.5cm 2.5g Black Blue Glitters

nm.54759202

Stoc epuizat

37,07Lei(-25%) 27,76Lei

-27%

VOBLER NOMURA TOKYOCRANKCL Brown Gold Shiner 5CM 8.8G

nm.50301205

Stoc epuizat

36,09Lei(-27%) 26,21Lei

-26%

VoVobler Nomura Tokyo Crank CL 037 5cm 8.8g

nm.50303705

Stoc epuizat

35,60Lei(-26%) 26,34Lei

-27%

VOBLER NOMURA OKAIDO CRANCK CL Mat Orange Tiger 5CM 8.8G

nm.50606604

Stoc epuizat

36,09Lei(-27%) 26,21Lei

-27%

Vobler Nomura Tokyo Crank CL Light Green Shiner 5cm 8.8g

nm.50306505

Stoc epuizat

36,09Lei(-27%) 26,21Lei

-26%

Lingurita Oscilanta Nomura Isei Tourt, Real Trout, 1.4g, 2.3cm, 1buc/pac

f3.nm.46051414

Stoc epuizat

24,35Lei(-26%) 17,96Lei

Creatura Filex Super Soft Orange, 25mm, 5buc/pac

13010780-7776

Stoc epuizat

13,59Lei

-23%

MULINETA LINEAEFFE NOMURA HARU TROUT AREA 1000

nm.10610910

Stoc epuizat

199,96Lei(-23%) 153,05Lei

-22%

LANSETA SPINNING LINEAEFFE NOMURA AKIRA 2SEG 2,10M/28G

nm.20502821

Stoc epuizat

356,59Lei(-22%) 278,91Lei

-29%

LANSETA SPINNING LINEAEFFE NOMURA AICHI 2.44M 4-24G

nm.20102424

Stoc epuizat

561,61Lei(-29%) 400,74Lei

-22%

Vobler Lineaeffe Nomura Fresh Vibration 10cm/47g, Mangroove

nm.50006310

Stoc epuizat

46,95Lei(-22%) 36,71Lei

-29%

LANSETA SPINNING LINEAEFFE NOMURA AICHI 2SEG 2,32M/3-18G

nm.20101823

Stoc epuizat

531,49Lei(-29%) 379,29Lei

-22%

LANSETA SPINNING LINEAEFFE NOMURA HARU 2SEG 2,40M/15-40G

nm.21104024

Stoc epuizat

335,17Lei(-22%) 262,16Lei

-30%

VOBLER LINEAEFFE NOMURA SHOUTDOWN MINN 5CM/3,1G GREEN YEL

nm.60016805

Stoc epuizat

40,12Lei(-30%) 27,93Lei

-24%

LANSETA Lineaeffe SPINNING NOMURA 2BUC OSAKA 1.98M 0.5-4G

nm.22200419

Stoc epuizat

213,61Lei(-24%) 162,85Lei

-25%

VOBLER LINEAEFFE NOMURA RANGER MINNOW 7CM/13G SILVER GOLD

nm.52212907

Stoc epuizat

38,05Lei(-25%) 28,50Lei

-27%

Vobler Lineaeffe Nomura Floater Minn Culoare Natural Perch 3cm 2.4g

nm.60116703

Stoc epuizat

33,28Lei(-27%) 24,16Lei

-31%

SHAD LINEAEFFE NOMURA ROCKET 7,5CM/2,2G FLUO 8BUC/PL

f1.nm.70402107

Stoc epuizat

32,55Lei(-31%) 22,53Lei

-37%

LANSETA Lineaeffe SPINNING NOMURA 2BUC SAMURAI FUJI 2.10M 3-15G

nm.22211521

Stoc epuizat

340,41Lei(-37%) 213,00Lei

Afişare 121 - 140 din 171 (9 pagini)

Queries: 8, Total time: 2.114 ms [By time] [By id] [By file]

1 (0.119)

SELECT data
FROM `oc_session`
WHERE session_id = '231c65036b2d0e88efee0513cb'

/var/www/clients/client1/web1/web/system/library/session/db.php:24

2 (0.118)

SELECT `trigger`, `action`
FROM oc_event

/var/www/clients/client1/web1/web/index.php:453

3 (0.112)

SELECT *
FROM oc_url_alias
WHERE keyword = 'search'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48

4 (0.125)

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

5 (0.740)

INSERT INTO oc_bf_tmp_product (product_id, sort_order, quantity, manufacturer_id, match_filters, actual_price, sort) VALUES ("160955", "1", "1000", "554", "1", "219.730000000000", "1"),("249283", "2", "1000", "554", "1", "282.890000000000", "2"),("249287", "2", "1000", "554", "1", "298.970000000000", "3"),("249288", "2", "1000", "554", "1", "316.210000000000", "4"),("249289", "2", "1000", "554", "1", "344.990000000000", "5"),("118626", "10", "1000", "554", "1", "268.740000000000", "6"),("159315", "10", "1000", "554", "1", "216.210000000000", "7"),("198361", "1", "1000", "554", "1", "117.690000000000", "8"),("160957", "1", "1000", "554", "1", "223.590000000000", "9"),("118893", "2", "1000", "554", "1", "19.400000000000", "10"),("115094", "1", "1000", "554", "1", "35.760000000000", "11"),("67966", "2", "1000", "554", "1", "34.230000000000", "12"),("109600", "2", "1000", "554", "1", "20.330000000000", "13"),("109601", "2", "1000", "554", "1", "20.330000000000", "14"),("118407", "2", "1000", "554", "1", "23.310000000000", "15"),("118881", "2", "1000", "554", "1", "12.780000000000", "16"),("240689", "2", "1000", "554", "1", "35.330000000000", "17"),("109589", "2", "1000", "554", "1", "23.310000000000", "18"),("109602", "2", "1000", "554", "1", "20.330000000000", "19"),("118408", "2", "1000", "554", "1", "24.850000000000", "20"),("109604", "2", "2", "554", "1", "19.720000000000", "21"),("109605", "2", "1001", "554", "1", "19.400000000000", "22"),("115082", "2", "1000", "554", "1", "27.760000000000", "23"),("144425", "2", "1000", "554", "1", "23.310000000000", "24"),("240656", "2", "1000", "554", "1", "304.430000000000", "25"),("240658", "2", "1000", "554", "1", "324.690000000000", "26"),("240678", "2", "1000", "554", "1", "311.330000000000", "27"),("240700", "2", "1000", "554", "1", "31.020000000000", "28"),("240701", "2", "1000", "554", "1", "31.020000000000", "29"),("240703", "2", "1000", "554", "1", "31.020000000000", "30"),("240704", "2", "1000", "554", "1", "31.020000000000", "31"),("240705", "2", "1000", "554", "1", "31.020000000000", "32"),("223177", "2", "1000", "554", "1", "24.550000000000", "33"),("223188", "2", "1000", "554", "1", "25.400000000000", "34"),("223192", "2", "1000", "554", "1", "19.800000000000", "35"),("223193", "2", "1000", "554", "1", "19.800000000000", "36"),("109585", "2", "1000", "554", "1", "31.450000000000", "37"),("109587", "2", "1000", "554", "1", "31.450000000000", "38"),("109588", "2", "1000", "554", "1", "31.450000000000", "39"),("169493", "2", "1000", "554", "1", "241.460000000000", "40"),("169495", "2", "1000", "554", "1", "250.520000000000", "41"),("42829", "2", "1000", "554", "1", "12.780000000000", "42"),("238019", "10", "1000", "554", "1", "145.300000000000", "43"),("238020", "10", "1000", "554", "1", "147.070000000000", "44"),("223178", "2", "1000", "554", "1", "24.550000000000", "45"),("223181", "2", "1000", "554", "1", "24.550000000000", "46"),("223182", "2", "1000", "554", "1", "24.550000000000", "47"),("223183", "2", "1000", "554", "1", "25.400000000000", "48"),("223184", "2", "1000", "554", "1", "25.400000000000", "49"),("223187", "2", "1000", "554", "1", "25.400000000000", "50"),("223194", "2", "1000", "554", "1", "7.730000000000", "51"),("169421", "1", "1000", "554", "1", "113.400000000000", "52"),("109586", "2", "1000", "554", "1", "31.450000000000", "53"),("115092", "2", "1000", "554", "1", "31.450000000000", "54"),("169418", "1", "1000", "554", "1", "117.690000000000", "55"),("169419", "1", "1000", "554", "1", "117.690000000000", "56"),("169422", "1", "1000", "554", "1", "110.790000000000", "57"),("169424", "1", "1000", "554", "1", "110.790000000000", "58"),("169426", "1", "1000", "554", "1", "97.860000000000", "59"),("223190", "2", "1000", "554", "1", "19.800000000000", "60"),("169414", "1", "1000", "554", "1", "102.600000000000", "61"),("169415", "1", "1000", "554", "1", "102.600000000000", "62"),("169416", "1", "1000", "554", "1", "95.270000000000", "63"),("169417", "1", "1000", "554", "1", "95.270000000000", "64"),("169480", "2", "1000", "554", "1", "214.730000000000", "65"),("169482", "2", "1000", "554", "1", "216.880000000000", "66"),("169484", "2", "1000", "554", "1", "219.040000000000", "67"),("169487", "2", "1000", "554", "1", "229.390000000000", "68"),("223191", "2", "1000", "554", "1", "19.800000000000", "69"),("118898", "2", "1000", "554", "1", "95.840000000000", "70"),("118908", "2", "1000", "554", "1", "101.090000000000", "71"),("118914", "2", "1000", "554", "1", "107.080000000000", "72"),("118907", "2", "1000", "554", "1", "101.090000000000", "73"),("118909", "2", "1000", "554", "1", "101.160000000000", "74"),("118910", "2", "1000", "554", "1", "101.090000000000", "75"),("83836", "2", "1000", "163", "1", "339.300000000000", "76"),("83837", "2", "1000", "163", "1", "231.430000000000", "77"),("42228", "2", "1000", "163", "1", "220.870000000000", "78"),("120756", "2", "1000", "163", "1", "30.150000000000", "79"),("67962", "2", "1000", "163", "1", "30.150000000000", "80"),("67964", "2", "1000", "163", "1", "30.150000000000", "81"),("233991", "1", "1000", "163", "1", "151.770000000000", "82"),("233992", "1", "1000", "163", "1", "149.570000000000", "83"),("233993", "1", "1000", "163", "1", "141.840000000000", "84"),("37200", "2", "1000", "163", "1", "35.760000000000", "85"),("93123", "2", "1000", "163", "1", "329.650000000000", "86"),("93125", "2", "1000", "163", "1", "413.870000000000", "87"),("141223", "1", "1000", "163", "1", "245.860000000000", "88"),("144455", "2", "1000", "163", "1", "14.760000000000", "89"),("67965", "2", "1000", "163", "1", "34.230000000000", "90"),("42454", "2", "1000", "163", "1", "228.540000000000", "91"),("42473", "2", "1000", "163", "1", "221.210000000000", "92"),("37203", "2", "1000", "163", "1", "35.760000000000", "93"),("37204", "2", "1000", "163", "1", "35.760000000000", "94"),("42423", "2", "1000", "163", "1", "298.060000000000", "95"),("42458", "2", "1000", "163", "1", "204.320000000000", "96"),("36954", "2", "1000", "163", "1", "28.690000000000", "97"),("37097", "2", "1000", "163", "1", "14.760000000000", "98"),("37198", "2", "1000", "163", "1", "35.760000000000", "99"),("83933", "2", "1000", "163", "1", "244.640000000000", "100"),("84528", "2", "1000", "163", "1", "19.080000000000", "101"),("68701", "2", "1000", "163", "1", "318.170000000000", "102"),("36942", "2", "1000", "163", "1", "22.360000000000", "103"),("36943", "2", "1000", "163", "1", "21.770000000000", "104"),("36959", "2", "1000", "163", "1", "28.690000000000", "105"),("36961", "2", "1000", "163", "1", "27.760000000000", "106"),("36962", "2", "1000", "163", "1", "28.690000000000", "107"),("36963", "2", "1000", "163", "1", "28.690000000000", "108"),("36968", "2", "1000", "163", "1", "27.760000000000", "109"),("37093", "2", "1000", "163", "1", "14.760000000000", "110"),("84523", "2", "1000", "163", "1", "29.030000000000", "111"),("84527", "2", "1000", "163", "1", "22.360000000000", "112"),("84553", "2", "1000", "163", "1", "21.730000000000", "113"),("42830", "2", "1000", "163", "1", "12.780000000000", "114"),("37090", "2", "1", "163", "1", "14.990000000000", "115"),("36956", "2", "1000", "163", "1", "27.760000000000", "116"),("84524", "2", "1000", "163", "1", "31.070000000000", "117"),("37065", "2", "1000", "163", "1", "26.500000000000", "118"),("114926", "10", "0", "554", "1", "110.970000000000", "119"),("109633", "2", "0", "554", "1", "26.980000000000", "120"),("142245", "2", "0", "554", "1", "21.770000000000", "121"),("142423", "1", "0", "554", "1", "22.940000000000", "122"),("118409", "2", "0", "554", "1", "21.660000000000", "123"),("118895", "2", "0", "554", "1", "21.770000000000", "124"),("118410", "2", "0", "554", "1", "21.660000000000", "125"),("118894", "2", "0", "554", "1", "21.660000000000", "126"),("223189", "2", "0", "554", "1", "14.840000000000", "127"),("194105", "2", "0", "554", "1", "11.230000000000", "128"),("67409", "2", "0", "163", "1", "126.490000000000", "129"),("42457", "2", "0", "163", "1", "230.500000000000", "130"),("42476", "2", "0", "163", "1", "331.190000000000", "131"),("42881", "2", "0", "163", "1", "30.340000000000", "132"),("42429", "2", "0", "163", "1", "313.460000000000", "133"),("42542", "2", "0", "163", "1", "216.660000000000", "134"),("37145", "2", "0", "163", "1", "23.080000000000", "135"),("112687", "2", "0", "163", "1", "134.590000000000", "136"),("37202", "2", "0", "163", "1", "23.550000000000", "137"),("84544", "2", "0", "163", "1", "19.970000000000", "138"),("36950", "2", "0", "163", "1", "18.620000000000", "139"),("112688", "2", "0", "163", "1", "176.030000000000", "140"),("83892", "2", "0", "163", "1", "156.260000000000", "141"),("84552", "2", "0", "163", "1", "19.970000000000", "142"),("42828", "2", "0", "163", "1", "18.620000000000", "143"),("36946", "2", "0", "163", "1", "21.770000000000", "144"),("114920", "2", "0", "163", "1", "368.090000000000", "145"),("108087", "2", "1002", "120", "1", "12.480000000000", "146"),("172428", "2", "1006", "656", "1", "12.930000000000", "147"),("40735", "2", "1001", "45", "1", "13.690000000000", "148"),("86058", "2", "1000", "115", "1", "36.030000000000", "149"),("168471", "2", "1000", "115", "1", "23.430000000000", "150"),("203639", "1", "1000", "224", "1", "9.150000000000", "151"),("168473", "2", "1000", "115", "1", "32.680000000000", "152"),("154391", "2", "1002", "224", "1", "36.880000000000", "153"),("86067", "2", "1000", "115", "1", "36.880000000000", "154"),("86079", "2", "1000", "115", "1", "55.360000000000", "155"),("169240", "2", "1000", "115", "1", "23.430000000000", "156"),("169229", "2", "1000", "115", "1", "34.360000000000", "157"),("169241", "2", "1000", "115", "1", "23.430000000000", "158"),("169254", "2", "1000", "115", "1", "28.470000000000", "159"),("171983", "1", "1000", "658", "1", "36.260000000000", "160"),("246783", "1", "1005", "809", "1", "6.710000000000", "161"),("246821", "1", "1003", "809", "1", "6.710000000000", "162"),("142997", "1", "3", "611", "1", "21.750000000000", "163"),("247445", "1", "1000", "360", "1", "15.290000000000", "164"),("91185", "2", "1000", "42", "1", "26.880000000000", "165"),("106809", "1", "0", "59", "1", "14.990000000000", "166"),("97080", "2", "0", "98", "1", "8.340000000000", "167"),("171982", "1", "0", "658", "1", "27.720000000000", "168"),("199151", "2", "0", "95", "1", "21.830000000000", "169"),("238677", "1", "0", "11", "1", "2.090000000000", "170"),("251494", "1", "0", "294", "1", "10.590000000000", "171")

/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:846

6 (0.118)

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

7 (0.543)

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 120, 20

/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184

8 (0.239)

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

Produsul a fost adăugat în coș

Anunță-mă când intră în stoc!

Căutare - Nomura

Produse ce potrivesc criteriilor de căutare