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

Produse ce potrivesc criteriilor de căutare


Riguri Filfishing Feeder Snelled Hooks, 90cm, 10buc/plic Nr.14 16mm

Riguri Filfishing Feeder Snelled Hooks, 90cm, 10buc/plic Nr.14 16mm

fil5673
Livrare imediată!

8,12Lei

Riguri Filfishing Feeder Snelled Hooks, 90cm, 10buc/plic Nr.10 18mm

Riguri Filfishing Feeder Snelled Hooks, 90cm, 10buc/plic Nr.10 18mm

fil5659
Livrare imediată!

8,12Lei

Riguri Filfishing Feeder Snelled Hooks, 90cm, 10buc/plic Nr.8 20mm

Riguri Filfishing Feeder Snelled Hooks, 90cm, 10buc/plic Nr.8 20mm

fil5642
Livrare imediată!

8,12Lei

CUTIE K-KARP PENAR RIGURI K-BOX RIGS STORAGE SL

CUTIE K-KARP PENAR RIGURI K-BOX RIGS STORAGE SL

190-74-102
Livrare imediată!

48,70Lei

PENAR RIGID PENTRU RIGURI PRESTON MAG STORE SYSTEM 15" HOOKLENGTH BOX 41X9X2.5CM

PENAR RIGID PENTRU RIGURI PRESTON MAG STORE SYSTEM 15" HOOKLENGTH BOX 41X9X2.5CM

p0220003
Livrare imediată!

115,35Lei

Riguri Matrix MXC-3 Barbless Boilie Pin Nr.14, 2.9kg, 0.180mm, 10cm, 8buc/plic
Exclusiv online!

Riguri Matrix MXC-3 Barbless Boilie Pin Nr.14, 2.9kg, 0.180mm, 10cm, 8buc/plic

grr074
Livrare 7-14 zile

24,74Lei

PENAR NGT PENTRU RIGURI 6 COMPARTIMENTE 72 RIGURI -40%

PENAR NGT PENTRU RIGURI 6 COMPARTIMENTE 72 RIGURI

ngt-fla-rig-920
Stoc epuizat

45,74Lei(-40%) 27,44Lei

Penar Riguri Zeck 25x21x6cm -25%

Penar Riguri Zeck 25x21x6cm

90405160033
Stoc epuizat

154,58Lei(-25%) 115,18Lei

KIT TRAKKO PENAR RIGURI CROSETE -47%

KIT TRAKKO PENAR RIGURI CROSETE

tr8120
Stoc epuizat

57,84Lei(-47%) 30,67Lei

Penar Riguri NASH Rig Pouch, 35x13x3cm

Penar Riguri NASH Rig Pouch, 35x13x3cm

t3575
Stoc epuizat

153,51Lei

CUTIE RIGURI CARP ZOOM -28%

CUTIE RIGURI CARP ZOOM

cz2608
Stoc epuizat

32,42Lei(-28%) 23,35Lei

Penar Riguri Daiwa Black Widow 29x37x4.8cm -24%

Penar Riguri Daiwa Black Widow 29x37x4.8cm

d.18705.005
Stoc epuizat

107,63Lei(-24%) 82,03Lei

Penar Rigid Jaxon pentru Riguri 25x9x5cm -23%

Penar Rigid Jaxon pentru Riguri 25x9x5cm

rh-320
Stoc epuizat

75,23Lei(-23%) 58,08Lei

PENAR PENTRU RIGURI NGT -31%

PENAR PENTRU RIGURI NGT

ngt-fla-rig-940
Stoc epuizat

56,92Lei(-31%) 39,43Lei

PENAR PENTRU RIGURI NGT 900 -23%

PENAR PENTRU RIGURI NGT 900

fla-rig-900
Stoc epuizat

18,30Lei(-23%) 14,16Lei

Penar Mivardi Pentru Riguri Feeder/Match 37cm -30%

Penar Mivardi Pentru Riguri Feeder/Match 37cm

m-hlwm
Stoc epuizat

67,09Lei(-30%) 47,21Lei

Borcane pentru Dipuri Carp Zoom Glug-G Pot Small -36%

Borcane pentru Dipuri Carp Zoom Glug-G Pot Small

cz0671
Stoc epuizat

15,13Lei(-36%) 9,68Lei

Penar Riguri Extra Carp Rig Wallet, 29x13x3.5cm -30%

Penar Riguri Extra Carp Rig Wallet, 29x13x3.5cm

ec7547
Stoc epuizat

56,92Lei(-30%) 39,94Lei

Penar Pentru Riguri Ridge Monkey Armoury Fishing Rig Box, 33x18x35cm -33%

Penar Pentru Riguri Ridge Monkey Armoury Fishing Rig Box, 33x18x35cm

rm758
Stoc epuizat

209,64Lei(-33%) 139,66Lei

Penar Rigid Plus 24 Discuri EVA pentru Riguri Matrix Large 34x12x4cm -28%

Penar Rigid Plus 24 Discuri EVA pentru Riguri Matrix Large 34x12x4cm

gbx004
Stoc epuizat

134,10Lei(-28%) 96,38Lei

Afişare 101 - 120 din 127 (7 pagini)
Queries: 9, Total time: 1.641 ms [By time] [By id] [By file]
1 (0.115)
SELECT data
FROM `oc_session`
WHERE session_id = '2777ba37b2d6155640b1113a47'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.078)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.090)
SELECT *
FROM oc_url_alias
WHERE keyword = 'search'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.164)
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.372)
INSERT INTO oc_bf_tmp_product (product_id, sort_order, quantity, manufacturer_id, match_filters, actual_price, sort) VALUES ("11990", "2", "1001", "24", "1", "67.970000000000", "1"),("166967", "1", "1000", "117", "1", "57.880000000000", "2"),("34749", "2", "1000", "117", "1", "84.780000000000", "3"),("60034", "2", "1001", "24", "1", "64.610000000000", "4"),("40800", "2", "1000", "67", "1", "78.980000000000", "5"),("5762", "2", "1002", "42", "1", "98.310000000000", "6"),("101988", "1", "1001", "115", "1", "49.480000000000", "7"),("79463", "2", "1000", "42", "1", "26.880000000000", "8"),("79464", "2", "1000", "42", "1", "27.720000000000", "9"),("233958", "1", "1000", "163", "1", "22.820000000000", "10"),("57169", "2", "1002", "24", "1", "130.240000000000", "11"),("231596", "1", "1000", "193", "1", "31.080000000000", "12"),("146457", "1", "2", "85", "1", "36.960000000000", "13"),("9418", "2", "1", "54", "1", "121.720000000000", "14"),("87720", "2", "1002", "75", "1", "42.000000000000", "15"),("165595", "2", "1002", "67", "1", "94.110000000000", "16"),("214069", "1", "3", "115", "1", "13.350000000000", "17"),("146595", "1", "1001", "85", "1", "108.330000000000", "18"),("165291", "2", "1000", "543", "1", "123.430000000000", "19"),("146597", "1", "1000", "85", "1", "137.950000000000", "20"),("224271", "2", "1000", "500", "1", "90.090000000000", "21"),("57188", "2", "3", "24", "1", "45.360000000000", "22"),("63726", "2", "1000", "11", "1", "206.440000000000", "23"),("87705", "2", "1002", "670", "1", "126.030000000000", "24"),("175206", "1", "0", "528", "1", "35.000000000000", "25"),("116981", "1", "0", "280", "1", "35.700000000000", "26"),("111991", "1", "0", "13", "1", "24.750000000000", "27"),("111992", "1", "0", "13", "1", "10.000000000000", "28"),("162400", "2", "0", "67", "1", "64.250000000000", "29"),("5830", "2", "0", "42", "1", "88.000000000000", "30"),("97408", "2", "0", "163", "1", "60.380000000000", "31"),("11204", "2", "0", "67", "1", "104.760000000000", "32"),("67136", "2", "0", "434", "1", "52.910000000000", "33"),("102407", "2", "999", "13", "1", "43.600000000000", "34"),("203371", "1", "1000", "357", "1", "17.840000000000", "35"),("90181", "2", "1004", "73", "1", "37.760000000000", "36"),("90182", "2", "1004", "73", "1", "49.430000000000", "37"),("107917", "1", "1000", "58", "1", "51.170000000000", "38"),("203369", "1", "1000", "357", "1", "38.610000000000", "39"),("172215", "2", "1000", "120", "1", "28.680000000000", "40"),("106849", "2", "1000", "49", "1", "396.540000000000", "41"),("106850", "2", "1000", "49", "1", "396.540000000000", "42"),("106851", "2", "1000", "49", "1", "396.540000000000", "43"),("106852", "2", "1000", "49", "1", "396.540000000000", "44"),("101046", "1", "1001", "42", "1", "6.710000000000", "45"),("91184", "2", "1000", "42", "1", "142.840000000000", "46"),("176096", "2", "1000", "42", "1", "72.260000000000", "47"),("176097", "2", "1000", "42", "1", "75.620000000000", "48"),("106830", "2", "1000", "49", "1", "119.230000000000", "49"),("230609", "1", "1000", "285", "1", "19.700000000000", "50"),("198207", "2", "1000", "119", "1", "61.030000000000", "51"),("91159", "2", "1001", "42", "1", "80.660000000000", "52"),("239559", "2", "1001", "13", "1", "22.600000000000", "53"),("239561", "2", "1001", "13", "1", "27.640000000000", "54"),("104170", "2", "1000", "42", "1", "89.060000000000", "55"),("25898", "2", "1000", "75", "1", "64.610000000000", "56"),("130461", "2", "1000", "75", "1", "25.120000000000", "57"),("239558", "2", "1000", "13", "1", "21.750000000000", "58"),("150591", "2", "1000", "58", "1", "47.800000000000", "59"),("220760", "2", "1000", "533", "1", "77.310000000000", "60"),("96322", "2", "2", "97", "1", "12.500000000000", "61"),("209331", "2", "1000", "75", "1", "26.790000000000", "62"),("152875", "1", "1003", "160", "1", "125.340000000000", "63"),("208371", "2", "1001", "119", "1", "322.480000000000", "64"),("237919", "2", "1001", "798", "1", "43.670000000000", "65"),("37736", "2", "1000", "204", "1", "76.370000000000", "66"),("224270", "2", "1000", "500", "1", "72.370000000000", "67"),("231320", "2", "1000", "121", "1", "86.540000000000", "68"),("208373", "2", "1000", "119", "1", "259.180000000000", "69"),("238494", "1", "1000", "285", "1", "12.130000000000", "70"),("239851", "1", "1000", "160", "1", "194.060000000000", "71"),("239860", "1", "1000", "160", "1", "145.740000000000", "72"),("96858", "2", "1000", "27", "1", "54.520000000000", "73"),("101045", "1", "1", "42", "1", "27.720000000000", "74"),("215781", "2", "1005", "648", "1", "68.050000000000", "75"),("227994", "2", "1003", "168", "1", "103.650000000000", "76"),("227995", "2", "1002", "168", "1", "133.150000000000", "77"),("90142", "2", "1000", "75", "1", "15.020000000000", "78"),("99511", "1", "1", "16", "1", "41.590000000000", "79"),("90177", "2", "1016", "73", "1", "24.140000000000", "80"),("90176", "2", "1011", "73", "1", "24.140000000000", "81"),("102406", "2", "1011", "24", "1", "14.270000000000", "82"),("90175", "2", "1004", "73", "1", "24.140000000000", "83"),("237928", "2", "1001", "798", "1", "69.340000000000", "84"),("229886", "2", "1000", "42", "1", "15.120000000000", "85"),("229887", "2", "1000", "42", "1", "12.600000000000", "86"),("208363", "2", "1000", "119", "1", "76.360000000000", "87"),("146207", "2", "7", "528", "1", "13.430000000000", "88"),("125583", "2", "1001", "27", "1", "34.360000000000", "89"),("90178", "2", "1042", "73", "1", "24.140000000000", "90"),("90179", "2", "1012", "73", "1", "22.260000000000", "91"),("118028", "2", "1004", "484", "1", "33.600000000000", "92"),("90180", "2", "1004", "73", "1", "24.790000000000", "93"),("187571", "2", "1001", "96", "1", "10.490000000000", "94"),("247735", "2", "1000", "370", "1", "61.100000000000", "95"),("164525", "1", "1000", "360", "1", "80.210000000000", "96"),("164618", "1", "1000", "360", "1", "87.770000000000", "97"),("136345", "2", "1000", "368", "1", "21.590000000000", "98"),("136349", "2", "1000", "368", "1", "21.590000000000", "99"),("97117", "2", "7", "528", "1", "6.710000000000", "100"),("97113", "2", "6", "528", "1", "6.710000000000", "101"),("97115", "2", "4", "528", "1", "6.710000000000", "102"),("97116", "2", "3", "528", "1", "6.710000000000", "103"),("108174", "1", "1004", "104", "1", "40.250000000000", "104"),("163158", "1", "1007", "360", "1", "95.330000000000", "105"),("165020", "2", "1000", "368", "1", "20.450000000000", "106"),("38935", "2", "0", "287", "1", "22.680000000000", "107"),("201161", "1", "0", "656", "1", "95.190000000000", "108"),("117968", "2", "0", "109", "1", "25.350000000000", "109"),("234442", "2", "0", "59", "1", "126.870000000000", "110"),("26065", "2", "0", "75", "1", "19.300000000000", "111"),("90975", "2", "0", "11", "1", "67.790000000000", "112"),("91157", "2", "0", "42", "1", "48.000000000000", "113"),("34118", "2", "0", "287", "1", "32.590000000000", "114"),("34119", "2", "0", "287", "1", "11.700000000000", "115"),("96623", "2", "0", "98", "1", "39.020000000000", "116"),("90141", "2", "0", "75", "1", "8.000000000000", "117"),("197745", "2", "0", "96", "1", "33.010000000000", "118"),("205241", "2", "0", "358", "1", "115.425000000000", "119"),("82737", "2", "0", "368", "1", "79.650000000000", "120"),("5665", "2", "0", "104", "1", "68.000000000000", "121"),("96988", "2", "0", "96", "1", "7.200000000000", "122"),("97036", "2", "0", "287", "1", "76.230000000000", "123"),("97114", "2", "0", "528", "1", "4.200000000000", "124"),("244805", "2", "0", "798", "1", "56.450000000000", "125"),("167300", "1", "0", "28", "1", "8.400000000000", "126"),("245841", "2", "0", "287", "1", "72.250000000000", "127")
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:846
6 (0.139)
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.445)
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 100, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
8 (0.151)
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.087)
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