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 - Bocanci

Produse ce potrivesc criteriilor de căutare


BRANTURI BOCANCI CARP ZOOM 42 -37%

BRANTURI BOCANCI CARP ZOOM 42

cz4672
Stoc epuizat

9,53Lei(-37%) 6,05Lei

BRANTURI BOCANCI CARP ZOOM 43 -37%

BRANTURI BOCANCI CARP ZOOM 43

cz4689
Stoc epuizat

9,53Lei(-37%) 6,05Lei

Bocanci Norfin Snow Green marime 41 -26%

Bocanci Norfin Snow Green marime 41

13980-41
Stoc epuizat

239,96Lei(-26%) 176,93Lei

Bocanci Korum Neoteric Field Boots, Marime 44 -34%

Bocanci Korum Neoteric Field Boots, Marime 44

k0350096
Stoc epuizat

316,12Lei(-34%) 209,54Lei

Bocanci NORFIN NTX Scout, Marime 45 -50%

Bocanci NORFIN NTX Scout, Marime 45

15803-45
Stoc epuizat

814,00Lei(-50%) 407,72Lei

Bocanci NORFIN NTX Scout, Marime 46 -50%

Bocanci NORFIN NTX Scout, Marime 46

15803-46
Stoc epuizat

814,00Lei(-50%) 407,72Lei

BOCANCI JAXON IARNA ZE 46/47 -38%

BOCANCI JAXON IARNA ZE 46/47

ak-bze46/47
Stoc epuizat

216,00Lei(-38%) 133,18Lei

BOCANCI SCIERRA X-FORCE WADING MARIMEA 40 -61%

BOCANCI SCIERRA X-FORCE WADING MARIMEA 40

a8.sie.54599
Stoc epuizat

746,12Lei(-61%) 291,79Lei

BOCANCI PROLOGIC MAX5 HP GRIP-TREK MARIME 44 -23%

BOCANCI PROLOGIC MAX5 HP GRIP-TREK MARIME 44

a8.pro.55641
Stoc epuizat

483,47Lei(-23%) 371,13Lei

BOCANCI PROLOGIC MAX5 HP GRIP-TREK MARIME 45 -23%

BOCANCI PROLOGIC MAX5 HP GRIP-TREK MARIME 45

a8.pro.55642
Stoc epuizat

483,47Lei(-23%) 371,13Lei

Bocanci Korum Ripstop Trail Boot, Marime UK 8 / EU 42 -27%

Bocanci Korum Ripstop Trail Boot, Marime UK 8 / EU 42

k0350116
Stoc epuizat

321,26Lei(-27%) 235,22Lei

Bocanci Korum Ripstop Trail Boot, Marime UK 9 / EU 43 -27%

Bocanci Korum Ripstop Trail Boot, Marime UK 9 / EU 43

k0350117
Stoc epuizat

321,26Lei(-27%) 235,22Lei

Bocanci Korum Ripstop Trail Boot, Marime UK 10 / EU 44 -27%

Bocanci Korum Ripstop Trail Boot, Marime UK 10 / EU 44

k0350118
Stoc epuizat

321,26Lei(-27%) 235,22Lei

Bocanci Korum Ripstop Trail Boot, Marime UK 11 / EU 45 -39%

Bocanci Korum Ripstop Trail Boot, Marime UK 11 / EU 45

k0350119
Stoc epuizat

314,96Lei(-39%) 193,16Lei

Bocanci Korum Ripstop Trail Boot, Marime UK 12 / EU 46 -27%

Bocanci Korum Ripstop Trail Boot, Marime UK 12 / EU 46

k0350120
Stoc epuizat

321,26Lei(-27%) 235,22Lei

Bocanci RIDGE MONKEY APEarel QuickZip All-Weather Boots, Marime 43 -30%

Bocanci RIDGE MONKEY APEarel QuickZip All-Weather Boots, Marime 43

rmc100
Stoc epuizat

595,20Lei(-30%) 418,06Lei

Bocanci Korum Ripstop Trail Boot, Marime UK 7 / EU 41 -39%

Bocanci Korum Ripstop Trail Boot, Marime UK 7 / EU 41

k0350115
Stoc epuizat

314,96Lei(-39%) 193,16Lei

Bocanci Preston DriFish Field Boots, Marime UK 10 / EU 44 -28%

Bocanci Preston DriFish Field Boots, Marime UK 10 / EU 44

p0200407
Stoc epuizat

412,76Lei(-28%) 298,74Lei

Bocanci FOX RAGE Pro Series Thermal Boots, Marime 46 (UK12) -27%

Bocanci FOX RAGE Pro Series Thermal Boots, Marime 46 (UK12)

nfw026
Stoc epuizat

482,32Lei(-27%) 352,88Lei

Bocanci Greys Tail Wading Boot Felt, Black, Nr.44-45 -15%

Bocanci Greys Tail Wading Boot Felt, Black, Nr.44-45

1593873
Stoc epuizat

425,01Lei(-15%) 359,91Lei

Afişare 121 - 140 din 209 (11 pagini)
Queries: 9, Total time: 2.130 ms [By time] [By id] [By file]
1 (0.102)
SELECT data
FROM `oc_session`
WHERE session_id = '85c7c5268cd3d27c84d32a4be0'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.112)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.101)
SELECT *
FROM oc_url_alias
WHERE keyword = 'search'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.132)
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.812)
INSERT INTO oc_bf_tmp_product (product_id, sort_order, quantity, manufacturer_id, match_filters, actual_price, sort) VALUES ("8701", "2", "1001", "42", "1", "223.510000000000", "1"),("8695", "2", "1000", "42", "1", "191.590000000000", "2"),("8696", "2", "1000", "42", "1", "191.590000000000", "3"),("153349", "10", "1000", "617", "1", "574.060000000000", "4"),("153351", "10", "1000", "617", "1", "574.060000000000", "5"),("153353", "10", "1000", "617", "1", "574.060000000000", "6"),("153355", "10", "1000", "617", "1", "574.060000000000", "7"),("153357", "10", "1000", "617", "1", "574.060000000000", "8"),("3141", "2", "1000", "12", "1", "232.150000000000", "9"),("85010", "2", "1000", "75", "1", "188.140000000000", "10"),("85011", "2", "1000", "75", "1", "188.140000000000", "11"),("26608", "2", "1000", "75", "1", "7.880000000000", "12"),("85008", "2", "1", "75", "1", "201.830000000000", "13"),("112642", "1", "1", "124", "1", "425.840000000000", "14"),("179089", "1", "1", "357", "1", "261.260000000000", "15"),("143213", "1", "1000", "47", "1", "360.060000000000", "16"),("143211", "1", "1002", "47", "1", "357.130000000000", "17"),("208457", "1", "1000", "75", "1", "182.260000000000", "18"),("208463", "1", "1000", "75", "1", "182.260000000000", "19"),("208465", "1", "1000", "75", "1", "182.260000000000", "20"),("208467", "1", "1000", "75", "1", "182.260000000000", "21"),("208469", "1", "1000", "75", "1", "182.260000000000", "22"),("208471", "1", "1000", "75", "1", "182.260000000000", "23"),("111671", "1", "1", "448", "1", "425.840000000000", "24"),("111696", "1", "1", "448", "1", "425.840000000000", "25"),("238108", "2", "1", "358", "1", "450.400000000000", "26"),("234547", "1", "1000", "455", "1", "398.610000000000", "27"),("234548", "1", "1000", "455", "1", "398.610000000000", "28"),("234549", "1", "1000", "455", "1", "398.610000000000", "29"),("234550", "1", "1000", "455", "1", "398.610000000000", "30"),("234551", "1", "1000", "455", "1", "398.610000000000", "31"),("239878", "2", "1000", "203", "1", "351.250000000000", "32"),("239882", "2", "1000", "203", "1", "351.250000000000", "33"),("239883", "2", "1000", "203", "1", "351.250000000000", "34"),("244289", "2", "1000", "47", "1", "338.640000000000", "35"),("244290", "2", "1000", "47", "1", "338.640000000000", "36"),("244297", "2", "1000", "47", "1", "338.640000000000", "37"),("244299", "2", "1000", "47", "1", "338.640000000000", "38"),("244300", "2", "1000", "47", "1", "338.640000000000", "39"),("244301", "2", "1000", "47", "1", "338.640000000000", "40"),("241173", "2", "1001", "168", "1", "265.500000000000", "41"),("224546", "2", "1000", "168", "1", "266.260000000000", "42"),("224547", "2", "1000", "168", "1", "266.260000000000", "43"),("224548", "2", "1000", "168", "1", "266.260000000000", "44"),("224549", "2", "1000", "168", "1", "266.260000000000", "45"),("224550", "2", "1000", "168", "1", "266.260000000000", "46"),("224551", "2", "1000", "168", "1", "266.260000000000", "47"),("241174", "2", "1000", "168", "1", "266.260000000000", "48"),("241171", "2", "1000", "168", "1", "265.500000000000", "49"),("241172", "2", "1000", "168", "1", "265.500000000000", "50"),("132949", "2", "2", "59", "1", "244.510000000000", "51"),("132919", "2", "2", "59", "1", "328.550000000000", "52"),("132925", "2", "1", "59", "1", "328.550000000000", "53"),("132951", "2", "1", "59", "1", "244.510000000000", "54"),("236659", "2", "1001", "47", "1", "357.130000000000", "55"),("236660", "2", "1001", "47", "1", "357.130000000000", "56"),("105161", "2", "1000", "42", "1", "542.840000000000", "57"),("51464", "2", "1000", "42", "1", "426.030000000000", "58"),("170336", "2", "1000", "137", "1", "581.410000000000", "59"),("236646", "2", "1000", "47", "1", "357.130000000000", "60"),("236648", "2", "1000", "47", "1", "357.130000000000", "61"),("238540", "2", "1000", "11", "1", "353.520000000000", "62"),("238541", "2", "1000", "11", "1", "353.520000000000", "63"),("238542", "2", "1000", "11", "1", "353.520000000000", "64"),("238543", "2", "1000", "11", "1", "353.520000000000", "65"),("238544", "2", "1000", "11", "1", "353.520000000000", "66"),("105167", "2", "1000", "42", "1", "521.830000000000", "67"),("105168", "2", "1000", "42", "1", "521.830000000000", "68"),("197117", "2", "1000", "73", "1", "542.840000000000", "69"),("240868", "2", "1000", "73", "1", "542.840000000000", "70"),("240869", "2", "1000", "73", "1", "542.840000000000", "71"),("240870", "2", "1000", "73", "1", "542.840000000000", "72"),("240871", "2", "1000", "73", "1", "542.840000000000", "73"),("240873", "2", "1000", "73", "1", "542.840000000000", "74"),("240874", "2", "1000", "73", "1", "542.840000000000", "75"),("240875", "2", "1000", "73", "1", "542.840000000000", "76"),("240876", "2", "1000", "73", "1", "542.840000000000", "77"),("240877", "2", "1000", "73", "1", "542.840000000000", "78"),("229672", "2", "1000", "360", "1", "341.130000000000", "79"),("229674", "2", "1000", "360", "1", "341.130000000000", "80"),("229676", "2", "1000", "360", "1", "341.130000000000", "81"),("238864", "2", "1000", "203", "1", "420.990000000000", "82"),("238865", "2", "1000", "203", "1", "420.990000000000", "83"),("238866", "2", "1000", "203", "1", "420.990000000000", "84"),("238867", "2", "1000", "203", "1", "420.990000000000", "85"),("238868", "2", "1000", "203", "1", "420.990000000000", "86"),("238869", "2", "1000", "203", "1", "420.990000000000", "87"),("238870", "2", "1000", "203", "1", "420.990000000000", "88"),("238873", "2", "1000", "203", "1", "420.990000000000", "89"),("238874", "2", "1000", "203", "1", "420.990000000000", "90"),("238875", "2", "1000", "203", "1", "420.990000000000", "91"),("238938", "2", "1000", "85", "1", "472.260000000000", "92"),("238939", "2", "1000", "85", "1", "472.260000000000", "93"),("238940", "2", "1000", "85", "1", "472.260000000000", "94"),("238944", "2", "1000", "85", "1", "472.260000000000", "95"),("238945", "2", "1000", "85", "1", "472.260000000000", "96"),("238948", "2", "1000", "85", "1", "472.260000000000", "97"),("92113", "2", "1000", "85", "1", "157.570000000000", "98"),("238932", "2", "1000", "85", "1", "472.260000000000", "99"),("238933", "2", "1000", "85", "1", "472.260000000000", "100"),("238934", "2", "1000", "85", "1", "472.260000000000", "101"),("238935", "2", "1000", "85", "1", "472.260000000000", "102"),("238936", "2", "1000", "85", "1", "472.260000000000", "103"),("238937", "2", "1000", "85", "1", "472.260000000000", "104"),("163522", "1", "1000", "253", "1", "779.840000000000", "105"),("173085", "1", "1000", "253", "1", "662.980000000000", "106"),("173089", "1", "1000", "253", "1", "662.980000000000", "107"),("173091", "1", "1000", "253", "1", "662.980000000000", "108"),("134073", "10", "1000", "253", "1", "471.610000000000", "109"),("129923", "10", "1000", "253", "1", "395.790000000000", "110"),("129927", "10", "1000", "253", "1", "395.790000000000", "111"),("3135", "2", "0", "12", "1", "180.930000000000", "112"),("3139", "2", "0", "12", "1", "180.930000000000", "113"),("3821", "2", "0", "12", "1", "180.930000000000", "114"),("3822", "2", "0", "12", "1", "180.930000000000", "115"),("163209", "2", "0", "469", "1", "124.500000000000", "116"),("163210", "2", "0", "469", "1", "124.500000000000", "117"),("163212", "2", "0", "469", "1", "124.500000000000", "118"),("172681", "1", "0", "469", "1", "126.790000000000", "119"),("172682", "1", "0", "469", "1", "126.790000000000", "120"),("26609", "2", "0", "75", "1", "5.000000000000", "121"),("26610", "2", "0", "75", "1", "5.000000000000", "122"),("132621", "2", "0", "332", "1", "146.220000000000", "123"),("179092", "1", "0", "357", "1", "173.170000000000", "124"),("233134", "2", "0", "332", "1", "336.960000000000", "125"),("233135", "2", "0", "332", "1", "336.960000000000", "126"),("8705", "2", "0", "42", "1", "110.070000000000", "127"),("110286", "2", "0", "237", "1", "241.150000000000", "128"),("110278", "2", "0", "47", "1", "306.720000000000", "129"),("110279", "2", "0", "47", "1", "306.720000000000", "130"),("186127", "1", "0", "357", "1", "194.400000000000", "131"),("186129", "1", "0", "357", "1", "194.400000000000", "132"),("186131", "1", "0", "357", "1", "194.400000000000", "133"),("186133", "1", "0", "357", "1", "159.640000000000", "134"),("186135", "1", "0", "357", "1", "194.400000000000", "135"),("238109", "2", "0", "358", "1", "345.503000000000", "136"),("186125", "1", "0", "357", "1", "159.640000000000", "137"),("184083", "1", "0", "360", "1", "246.890000000000", "138"),("234552", "1", "0", "455", "1", "291.640000000000", "139"),("239881", "2", "0", "203", "1", "297.450000000000", "140"),("239884", "2", "0", "203", "1", "297.450000000000", "141"),("248956", "2", "0", "476", "1", "408.390000000000", "142"),("248958", "2", "0", "476", "1", "408.390000000000", "143"),("248959", "2", "0", "476", "1", "408.390000000000", "144"),("248960", "2", "0", "476", "1", "408.390000000000", "145"),("248961", "2", "0", "476", "1", "408.390000000000", "146"),("239886", "2", "0", "203", "1", "297.450000000000", "147"),("244867", "2", "0", "124", "1", "208.200000000000", "148"),("244868", "2", "0", "124", "1", "208.200000000000", "149"),("244869", "2", "0", "124", "1", "208.200000000000", "150"),("244870", "2", "0", "124", "1", "208.200000000000", "151"),("105175", "2", "0", "168", "1", "149.280000000000", "152"),("126803", "2", "0", "168", "1", "166.640000000000", "153"),("126811", "2", "0", "168", "1", "149.280000000000", "154"),("251273", "2", "0", "360", "1", "341.360000000000", "155"),("251274", "2", "0", "360", "1", "341.360000000000", "156"),("251275", "2", "0", "360", "1", "341.360000000000", "157"),("251276", "2", "0", "360", "1", "341.360000000000", "158"),("251277", "2", "0", "360", "1", "341.360000000000", "159"),("171123", "2", "0", "59", "1", "328.550000000000", "160"),("171124", "2", "0", "59", "1", "328.550000000000", "161"),("171132", "2", "0", "59", "1", "244.510000000000", "162"),("171133", "2", "0", "59", "1", "244.510000000000", "163"),("171134", "2", "0", "59", "1", "244.510000000000", "164"),("128831", "2", "0", "469", "1", "126.570000000000", "165"),("128833", "2", "0", "469", "1", "125.180000000000", "166"),("128837", "2", "0", "469", "1", "125.180000000000", "167"),("128839", "2", "0", "469", "1", "126.790000000000", "168"),("132915", "2", "0", "59", "1", "328.550000000000", "169"),("132917", "2", "0", "59", "1", "328.550000000000", "170"),("132921", "2", "0", "59", "1", "328.550000000000", "171"),("132923", "2", "0", "59", "1", "328.550000000000", "172"),("132941", "2", "0", "59", "1", "244.510000000000", "173"),("132947", "2", "0", "59", "1", "244.510000000000", "174"),("132953", "2", "0", "59", "1", "244.510000000000", "175"),("132955", "2", "0", "59", "1", "244.510000000000", "176"),("241175", "2", "0", "168", "1", "266.260000000000", "177"),("241167", "2", "0", "168", "1", "266.260000000000", "178"),("236645", "2", "0", "47", "1", "282.600000000000", "179"),("236650", "2", "0", "47", "1", "282.600000000000", "180"),("240872", "2", "0", "73", "1", "542.840000000000", "181"),("240878", "2", "0", "73", "1", "542.840000000000", "182"),("229673", "2", "0", "360", "1", "341.130000000000", "183"),("229675", "2", "0", "360", "1", "341.130000000000", "184"),("238872", "2", "0", "203", "1", "356.950000000000", "185"),("229677", "2", "0", "360", "1", "341.130000000000", "186"),("238871", "2", "0", "203", "1", "356.950000000000", "187"),("92112", "2", "0", "85", "1", "152.830000000000", "188"),("92114", "2", "0", "85", "1", "152.830000000000", "189"),("163525", "1", "0", "253", "1", "600.260000000000", "190"),("163526", "1", "0", "253", "1", "600.260000000000", "191"),("110290", "2", "0", "253", "1", "391.310000000000", "192"),("84779", "10", "0", "253", "1", "243.500000000000", "193"),("173088", "1", "0", "253", "1", "510.220000000000", "194"),("173090", "1", "0", "253", "1", "510.220000000000", "195"),("173094", "1", "0", "253", "1", "695.690000000000", "196"),("94277", "10", "0", "253", "1", "675.290000000000", "197"),("94278", "10", "0", "253", "1", "675.290000000000", "198"),("100114", "10", "0", "253", "1", "675.290000000000", "199"),("39026", "10", "0", "253", "1", "675.290000000000", "200"),("134065", "10", "0", "253", "1", "360.150000000000", "201"),("134069", "10", "0", "253", "1", "360.150000000000", "202"),("134071", "10", "0", "253", "1", "362.760000000000", "203"),("134075", "10", "0", "253", "1", "362.760000000000", "204"),("129925", "10", "0", "253", "1", "304.330000000000", "205"),("129929", "10", "0", "253", "1", "304.330000000000", "206"),("129833", "10", "0", "253", "1", "304.330000000000", "207"),("129831", "10", "0", "253", "1", "316.590000000000", "208"),("72087", "2", "3", "35", "1", "10.910000000000", "209")
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:846
6 (0.108)
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.441)
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.158)
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
9 (0.164)
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