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

Filtreaza

Produse ce potrivesc criteriilor de căutare

Sortare după:

-24%

Rucsac Shakespeare Salt Rucksack

1545370

Stoc epuizat

254,18Lei(-24%) 194,16Lei

-23%

Rucsac Shakespeare SKP Combination Rucksack

1552890

Stoc epuizat

412,82Lei(-23%) 315,92Lei

Rucsac NASH Subterfuge Rucksack 35L

t3367

Stoc epuizat

651,75Lei

-24%

Rucsac Shakespeare SKP Compact Rucksack

1550350

Stoc epuizat

323,32Lei(-24%) 246,80Lei

Rucsac NASH Subterfuge Rucksack 50L XL

t3368

Stoc epuizat

794,10Lei

Rucsac NASH Subterfuge Hi-Protect Rucksack, 50x48x27cm

t3641

Stoc epuizat

783,93Lei

-29%

RUCSAC NGT XPR CAMO CU MULTICOMPARTIMENTE

ngt-rucksack-xpr-c

Stoc epuizat

250,12Lei(-29%) 177,94Lei

-17%

Rucsac NGT XPR Green cu Multicompartimente 50.5l

ngt-fla-rucksack-xpr

Stoc epuizat

290,79Lei(-17%) 242,00Lei

Rucksac NGT Quickfish 65L, 47x48x35cm

ngt-fla-rucksack-quickfish

Stoc epuizat

265,37Lei

Rucsac Impermeabil BLACK CAT Seal Waterproof Rucksack, 30ltr, 70x30x14cm

BO110015

Stoc epuizat

298,30Lei

RUCSAC NGT XPR DAPPLE CAMO CU MULTICOMPARTIMENTE 50.5 L

ngt-rucksack-xpr-cam

Stoc epuizat

272,00Lei

-46%

Rucsac Baracuda B14 NC 50L

b14-rucsac 50l

Stoc epuizat

80,31Lei(-46%) 43,20Lei

-33%

Rucsac Baracuda B17 50 Litri

b17-rucsac 50l

Stoc epuizat

74,90Lei(-33%) 49,99Lei

-33%

Rucsac Pentru Cutia Bracuda B23

b23 geanta tip rucsac hs317

Stoc epuizat

124,24Lei(-33%) 83,31Lei

-41%

Rucsac Leech Negru

3021

Stoc epuizat

682,26Lei(-41%) 405,35Lei

-39%

Rucsac B30 Baracuda 70 litri Camuflaj

b30-rucsac pescar 70 l

Stoc epuizat

108,68Lei(-39%) 66,65Lei

-24%

Rucsac Shakespeare SKP Ruckbag

1550348

Stoc epuizat

366,03Lei(-24%) 279,74Lei

-24%

Rucsac Shakespeare SKP Daypack

1550352

Stoc epuizat

280,62Lei(-24%) 213,92Lei

-24%

RUCSAC CORMORAN VERDE 2038 35X45X20CM

a8.65.03038

Stoc epuizat

133,79Lei(-24%) 102,15Lei

Rucsac Cattara 30L, Olive, 33x45x19

tt13868

Stoc epuizat

200,19Lei

Afişare 121 - 140 din 181 (10 pagini)

Queries: 12, Total time: 2.629 ms [By time] [By id] [By file]

1 (0.092)

SELECT data
FROM `oc_session`
WHERE session_id = 'fec5ac1b6d17d03a7e7f6b9ef0'

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

2 (0.096)

SELECT `trigger`, `action`
FROM oc_event

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

3 (0.111)

SELECT *
FROM oc_url_alias
WHERE keyword = 'search'

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

4 (0.176)

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.801)

INSERT INTO oc_bf_tmp_product (product_id, sort_order, quantity, manufacturer_id, match_filters, actual_price, sort) VALUES ("166172", "2", "1", "59", "1", "370.560000000000", "1"),("228219", "2", "1000", "168", "1", "266.260000000000", "2"),("228048", "2", "1000", "168", "1", "360.790000000000", "3"),("83528", "2", "1", "59", "1", "703.340000000000", "4"),("83685", "2", "1", "59", "1", "479.810000000000", "5"),("249998", "2", "1000", "476", "1", "589.020000000000", "6"),("249999", "2", "1000", "476", "1", "420.950000000000", "7"),("244229", "1", "1000", "73", "1", "525.990000000000", "8"),("166896", "2", "1000", "122", "1", "303.310000000000", "9"),("166897", "2", "1000", "122", "1", "267.210000000000", "10"),("244120", "1", "1000", "73", "1", "546.830000000000", "11"),("244146", "1", "1000", "73", "1", "399.940000000000", "12"),("127535", "2", "1002", "455", "1", "454.570000000000", "13"),("251300", "1", "1000", "294", "1", "208.600000000000", "14"),("242780", "2", "1000", "455", "1", "364.570000000000", "15"),("190231", "1", "1000", "203", "1", "417.640000000000", "16"),("34750", "2", "1000", "117", "1", "437.720000000000", "17"),("158141", "2", "1000", "17", "1", "504.940000000000", "18"),("116757", "2", "1", "280", "1", "59.640000000000", "19"),("116417", "2", "1000", "47", "1", "241.170000000000", "20"),("98173", "2", "1000", "117", "1", "261.250000000000", "21"),("151845", "1", "1000", "364", "1", "98.220000000000", "22"),("111260", "1", "1000", "73", "1", "389.840000000000", "23"),("235984", "1", "1000", "11", "1", "151.980000000000", "24"),("236343", "2", "1", "109", "1", "194.110000000000", "25"),("98172", "2", "1000", "117", "1", "261.250000000000", "26"),("222864", "1", "1000", "768", "1", "106.630000000000", "27"),("222868", "1", "1000", "768", "1", "127.640000000000", "28"),("222870", "1", "1000", "768", "1", "252.840000000000", "29"),("222871", "1", "1000", "768", "1", "203.260000000000", "30"),("222873", "1", "1000", "768", "1", "165.450000000000", "31"),("204553", "2", "1000", "476", "1", "547.000000000000", "32"),("204557", "2", "1000", "476", "1", "420.950000000000", "33"),("113806", "1", "1000", "11", "1", "214.580000000000", "34"),("22358", "2", "1", "12", "1", "117.550000000000", "35"),("151183", "1", "1", "121", "1", "135.200000000000", "36"),("108366", "1", "1", "469", "1", "109.980000000000", "37"),("92055", "2", "1002", "47", "1", "384.860000000000", "38"),("244052", "1", "1000", "73", "1", "462.800000000000", "39"),("249614", "1", "1000", "54", "1", "390.740000000000", "40"),("168751", "2", "1003", "122", "1", "267.210000000000", "41"),("91320", "2", "1001", "42", "1", "154.610000000000", "42"),("151847", "1", "1001", "364", "1", "135.280000000000", "43"),("147959", "1", "1001", "54", "1", "153.770000000000", "44"),("8443", "2", "1000", "42", "1", "143.690000000000", "45"),("91232", "2", "1000", "42", "1", "219.310000000000", "46"),("91321", "2", "1000", "42", "1", "177.300000000000", "47"),("178262", "2", "1000", "122", "1", "160.490000000000", "48"),("204555", "2", "1000", "476", "1", "589.020000000000", "49"),("110398", "2", "1000", "238", "1", "1602.040000000000", "50"),("149693", "1", "1000", "20", "1", "50.910000000000", "51"),("127943", "2", "1000", "238", "1", "965.030000000000", "52"),("4416", "2", "2", "98", "1", "286.540000000000", "53"),("166895", "2", "1", "122", "1", "149.480000000000", "54"),("169211", "2", "1", "280", "1", "132.760000000000", "55"),("79970", "2", "1001", "122", "1", "231.920000000000", "56"),("186159", "1", "1001", "353", "1", "250.370000000000", "57"),("176882", "2", "1000", "42", "1", "159.650000000000", "58"),("108673", "2", "1000", "75", "1", "218.390000000000", "59"),("186759", "1", "1000", "455", "1", "133.900000000000", "60"),("214113", "1", "1000", "224", "1", "115.870000000000", "61"),("93074", "2", "1000", "271", "1", "412.600000000000", "62"),("177171", "1", "1000", "11", "1", "198.000000000000", "63"),("229188", "1", "1000", "20", "1", "313.360000000000", "64"),("229559", "1", "1000", "20", "1", "317.980000000000", "65"),("148077", "1", "2", "122", "1", "149.480000000000", "66"),("57032", "2", "1", "67", "1", "255.360000000000", "67"),("221642", "1", "1000", "357", "1", "314.660000000000", "68"),("166899", "2", "1003", "122", "1", "267.210000000000", "69"),("94229", "2", "1002", "67", "1", "184.860000000000", "70"),("186011", "1", "1000", "353", "1", "241.920000000000", "71"),("92053", "2", "1000", "19", "1", "513.980000000000", "72"),("229223", "1", "1000", "20", "1", "84.930000000000", "73"),("229224", "1", "1000", "20", "1", "65.910000000000", "74"),("229225", "1", "1000", "20", "1", "100.510000000000", "75"),("229226", "1", "1000", "20", "1", "111.520000000000", "76"),("229557", "1", "1000", "20", "1", "183.270000000000", "77"),("239880", "2", "1000", "238", "1", "429.720000000000", "78"),("229558", "1", "1000", "20", "1", "201.890000000000", "79"),("96616", "2", "2", "98", "1", "488.220000000000", "80"),("182333", "2", "2", "98", "1", "174.780000000000", "81"),("84352", "2", "1", "75", "1", "76.370000000000", "82"),("227958", "1", "1002", "168", "1", "455.330000000000", "83"),("221643", "1", "2", "357", "1", "284.400000000000", "84"),("245129", "2", "1000", "27", "1", "70.670000000000", "85"),("116301", "2", "1000", "123", "1", "144.230000000000", "86"),("223676", "1", "1000", "768", "1", "168.810000000000", "87"),("237152", "2", "1000", "122", "1", "187.080000000000", "88"),("237153", "2", "1000", "122", "1", "135.230000000000", "89"),("146269", "1", "1", "98", "1", "138.640000000000", "90"),("121100", "1", "1", "98", "1", "90.740000000000", "91"),("222160", "1", "1000", "357", "1", "189.870000000000", "92"),("186761", "2", "1000", "455", "1", "285.170000000000", "93"),("221516", "1", "3", "357", "1", "314.660000000000", "94"),("172312", "1", "1001", "656", "1", "321.700000000000", "95"),("179819", "1", "1000", "683", "1", "168.810000000000", "96"),("179823", "1", "1000", "683", "1", "252.840000000000", "97"),("67229", "2", "1000", "67", "1", "152.930000000000", "98"),("231332", "1", "1000", "121", "1", "257.970000000000", "99"),("179820", "1", "1000", "683", "1", "168.810000000000", "100"),("187863", "2", "1001", "455", "1", "233.600000000000", "101"),("179822", "1", "1000", "683", "1", "252.840000000000", "102"),("231205", "2", "1000", "357", "1", "681.460000000000", "103"),("174779", "1", "1000", "191", "1", "125.200000000000", "104"),("186755", "2", "1001", "455", "1", "133.900000000000", "105"),("165525", "1", "1000", "224", "1", "252.000000000000", "106"),("186765", "2", "1000", "455", "1", "164.160000000000", "107"),("6325", "2", "1000", "117", "1", "429.310000000000", "108"),("174778", "2", "1000", "191", "1", "222.680000000000", "109"),("193001", "1", "1000", "731", "1", "936.960000000000", "110"),("227113", "1", "1000", "238", "1", "715.650000000000", "111"),("110401", "2", "1000", "271", "1", "248.640000000000", "112"),("169583", "2", "1000", "269", "1", "241.350000000000", "113"),("229183", "2", "1000", "238", "1", "608.430000000000", "114"),("192999", "1", "1000", "731", "1", "1118.800000000000", "115"),("34752", "2", "1001", "117", "1", "328.470000000000", "116"),("192987", "1", "1000", "731", "1", "490.160000000000", "117"),("83545", "2", "1", "59", "1", "244.510000000000", "118"),("178249", "1", "1000", "122", "1", "515.120000000000", "119"),("178250", "1", "1001", "122", "1", "43.600000000000", "120"),("174962", "1", "0", "191", "1", "160.460000000000", "121"),("173777", "1", "0", "191", "1", "261.090000000000", "122"),("239380", "2", "0", "59", "1", "538.640000000000", "123"),("173761", "1", "0", "191", "1", "203.970000000000", "124"),("239411", "2", "0", "59", "1", "656.280000000000", "125"),("234524", "2", "0", "59", "1", "647.880000000000", "126"),("96438", "2", "0", "287", "1", "147.060000000000", "127"),("175248", "2", "0", "287", "1", "200.000000000000", "128"),("220755", "1", "0", "287", "1", "219.310000000000", "129"),("251470", "1", "0", "294", "1", "246.530000000000", "130"),("114417", "2", "0", "287", "1", "228.570000000000", "131"),("116642", "2", "0", "280", "1", "35.700000000000", "132"),("116758", "2", "0", "280", "1", "41.310000000000", "133"),("116761", "2", "0", "280", "1", "68.850000000000", "134"),("171965", "1", "0", "660", "1", "335.000000000000", "135"),("116765", "2", "0", "280", "1", "55.080000000000", "136"),("173758", "1", "0", "191", "1", "231.190000000000", "137"),("173763", "1", "0", "191", "1", "176.790000000000", "138"),("22357", "2", "0", "12", "1", "84.420000000000", "139"),("222872", "1", "0", "768", "1", "165.450000000000", "140"),("233298", "1", "0", "533", "1", "427.750000000000", "141"),("49524", "2", "0", "290", "1", "88.090000000000", "142"),("222869", "1", "0", "768", "1", "230.160000000000", "143"),("91322", "2", "0", "42", "1", "138.000000000000", "144"),("99727", "1", "0", "67", "1", "114.980000000000", "145"),("100524", "1", "0", "82", "1", "135.880000000000", "146"),("145481", "1", "0", "222", "1", "390.770000000000", "147"),("113698", "2", "0", "24", "1", "42.000000000000", "148"),("113803", "1", "0", "11", "1", "141.490000000000", "149"),("142335", "2", "0", "332", "1", "240.000000000000", "150"),("223617", "1", "0", "768", "1", "126.790000000000", "151"),("5937", "2", "0", "42", "1", "283.000000000000", "152"),("223616", "1", "0", "768", "1", "152.000000000000", "153"),("35442", "2", "0", "109", "1", "168.000000000000", "154"),("146263", "2", "0", "98", "1", "136.250000000000", "155"),("149695", "1", "0", "20", "1", "43.600000000000", "156"),("142333", "2", "0", "332", "1", "212.000000000000", "157"),("196909", "2", "0", "332", "1", "196.000000000000", "158"),("163491", "2", "0", "455", "1", "291.640000000000", "159"),("81921", "2", "0", "123", "1", "215.620000000000", "160"),("108361", "1", "0", "469", "1", "168.810000000000", "161"),("116300", "2", "0", "123", "1", "187.700000000000", "162"),("232740", "2", "0", "98", "1", "132.050000000000", "163"),("236395", "1", "0", "796", "1", "1198.100000000000", "164"),("242726", "2", "0", "238", "1", "209.020000000000", "165"),("59656", "2", "0", "67", "1", "139.230000000000", "166"),("121096", "1", "0", "98", "1", "252.100000000000", "167"),("92056", "2", "0", "85", "1", "217.580000000000", "168"),("225710", "1", "0", "11", "1", "467.170000000000", "169"),("101102", "2", "0", "117", "1", "275.000000000000", "170"),("179821", "1", "0", "683", "1", "100.000000000000", "171"),("180545", "1", "0", "685", "1", "300.000000000000", "172"),("189079", "1", "0", "203", "1", "244.760000000000", "173"),("174774", "2", "0", "191", "1", "127.900000000000", "174"),("144925", "1", "0", "357", "1", "527.750000000000", "175"),("192983", "1", "0", "222", "1", "228.880000000000", "176"),("229515", "2", "0", "269", "1", "389.190000000000", "177"),("173829", "2", "0", "238", "1", "1202.010000000000", "178"),("100224", "1", "0", "271", "1", "412.600000000000", "179"),("103685", "1", "0", "168", "1", "305.530000000000", "180"),("130303", "1", "0", "469", "1", "168.810000000000", "181")

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

6 (0.184)

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.522)

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.135)

SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"EDCRIS COM SRL"%' AND language_id = '2'

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

9 (0.149)

SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"EDCRIS COM SRL"%' AND language_id = '2'

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

10 (0.120)

SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"EDCRIS COM SRL"%' AND language_id = '2'

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

11 (0.074)

SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"EDCRIS COM SRL"%' AND language_id = '2'

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

12 (0.169)

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

Produse ce potrivesc criteriilor de căutare