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


Briceag JAXON Pochet Knife NS102, 15x8cm
Exclusiv online!

Briceag JAXON Pochet Knife NS102, 15x8cm

aj-ns102
Livrare 48-72 ore

33,00Lei

Caciula Maver UK IARNA BEANIE
Exclusiv online!

Caciula Maver UK IARNA BEANIE

n1055
Livrare 48-72 ore

78,00Lei

VARF LANSETA TRABUCCO SPECTRUM XTC COMPETITION 1082/1182 Tip Medium 58cm
Exclusiv online!

VARF LANSETA TRABUCCO SPECTRUM XTC COMPETITION 1082/1182 Tip Medium 58cm

150-81-002
Livrare 48-72 ore

99,00Lei

VARF LANSETA TRABUCCO SPECTRUM XTC COMPETITION 1082/1182 Tip Heavy 53cm
Exclusiv online!

VARF LANSETA TRABUCCO SPECTRUM XTC COMPETITION 1082/1182 Tip Heavy 53cm

150-81-003
Livrare 48-72 ore

99,00Lei

STARLITE JAXON 4.0X39mm
Exclusiv online!

STARLITE JAXON 4.0X39mm

ak-na002
Livrare 48-72 ore

2,20Lei

BRICEAG JAXON 4 FUNCTII 23/13CM
Exclusiv online!

BRICEAG JAXON 4 FUNCTII 23/13CM

ak-ng002
Livrare 48-72 ore

165,01Lei

STARLITE JAXON 4.0X39mm ALBASTRU

STARLITE JAXON 4.0X39mm ALBASTRU

ak-na102
Livrare imediată!

1,40Lei

PANTALONI Maver UK CARGO XXXL
Exclusiv online!

PANTALONI Maver UK CARGO XXXL

n1189
Livrare 48-72 ore

195,01Lei

BORSETA Maver UK MV-R EVA ACCESORII LARGE 41x27.5x10cm

BORSETA Maver UK MV-R EVA ACCESORII LARGE 41x27.5x10cm

n1402
Livrare imediată!

173,00Lei

Jacheta Maver Soft Shell marime XXL -25%
Exclusiv online!

Jacheta Maver Soft Shell marime XXL

n1014
Livrare 48-72 ore

325,00Lei(-25%) 244,00Lei

Jacheta Maver Soft Shell marime XXXL -25%
Exclusiv online!

Jacheta Maver Soft Shell marime XXXL

n1015
Livrare 48-72 ore

325,00Lei(-25%) 244,00Lei

SET Maver UK HANORAC TRICURI SAPCA MAVER TEAM Marime: L
Exclusiv online!

SET Maver UK HANORAC TRICURI SAPCA MAVER TEAM Marime: L

n1262
Livrare 48-72 ore

470,00Lei

Spinner Bait Fox Rage, 20g, Ayu, 1buc/pac
Exclusiv online!

Spinner Bait Fox Rage, 20g, Ayu, 1buc/pac

nsa082
Livrare 7-14 zile

44,96Lei

PREDUCEA PRO FL 5MM

PREDUCEA PRO FL 5MM

64-66082
Livrare imediată!

10,90Lei

CARLIGE MAVER SERIA INVINCIBLE CS22 CARP FINESSE NR 16
Exclusiv online!

CARLIGE MAVER SERIA INVINCIBLE CS22 CARP FINESSE NR 16

g1012
Livrare 48-72 ore

10,00Lei

Lanseta Madcat Green Heavy Duty 2.70m 200-400gr -23%
Exclusiv online!

Lanseta Madcat Green Heavy Duty 2.70m 200-400gr

mad.71088
Livrare 48-72ore

445,10Lei(-23%) 341,90Lei

TRICOU SAVAGE GEAR CANNIBAL BLUE MARIME S
Exclusiv online!

TRICOU SAVAGE GEAR CANNIBAL BLUE MARIME S

a8.sg.71582
Livrare 24-48 ore

133,51Lei

Lanseta Madcat Green Allround 2.85m, 100-300g, 2seg
Exclusiv online!

Lanseta Madcat Green Allround 2.85m, 100-300g, 2seg

mad.71092
Livrare 24-48 ore

500,26Lei

Carlig Mustad Carp Power 10829 nr.8

Carlig Mustad Carp Power 10829 nr.8

m.10829blm.8
Livrare imediată!

12,13Lei

Carlige Maver Seria Elite ES40 Silverfish Wide Gape nr 20
Exclusiv online!

Carlige Maver Seria Elite ES40 Silverfish Wide Gape nr 20

g1052
Livrare 48-72 ore

10,00Lei

Afişare 1 - 20 din 67 (4 pagini)
Queries: 12, Total time: 2.263 ms [By time] [By id] [By file]
1 (0.081)
SELECT data
FROM `oc_session`
WHERE session_id = 'b18aae2954f2a7a4e63d539a88'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.075)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.127)
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.201)
INSERT INTO oc_bf_tmp_product (product_id, sort_order, quantity, manufacturer_id, match_filters, actual_price, sort) VALUES ("228882", "2", "1000", "42", "1", "27.730000000000", "1"),("108549", "2", "1000", "49", "1", "65.550000000000", "2"),("116480", "2", "1000", "58", "1", "83.190000000000", "3"),("116481", "2", "1000", "58", "1", "83.190000000000", "4"),("39295", "2", "1000", "42", "1", "1.850000000000", "5"),("104115", "2", "1000", "42", "1", "138.660000000000", "6"),("40169", "2", "3", "42", "1", "1.180000000000", "7"),("108571", "2", "1000", "49", "1", "163.870000000000", "8"),("106829", "2", "1", "49", "1", "145.380000000000", "9"),("38005", "2", "1000", "49", "1", "205.040000000000", "10"),("38006", "2", "1000", "49", "1", "205.040000000000", "11"),("106849", "2", "1000", "49", "1", "394.960000000000", "12"),("224506", "1", "1000", "455", "1", "37.780000000000", "13"),("214071", "2", "1016", "13", "1", "9.160000000000", "14"),("54606", "2", "1000", "49", "1", "8.400000000000", "15"),("154407", "2", "1000", "492", "1", "287.310000000000", "16"),("143121", "10", "1000", "85", "1", "112.190000000000", "17"),("175188", "2", "1000", "492", "1", "420.390000000000", "18"),("33768", "2", "1", "20", "1", "10.190000000000", "19"),("38167", "2", "1000", "49", "1", "8.400000000000", "20"),("38177", "2", "1000", "49", "1", "8.400000000000", "21"),("101599", "1", "1000", "42", "1", "6.720000000000", "22"),("225534", "1", "1", "59", "1", "88.240000000000", "23"),("117566", "2", "1", "455", "1", "28.330000000000", "24"),("33767", "2", "1011", "20", "1", "10.710000000000", "25"),("97764", "2", "1004", "178", "1", "85.721600000000", "26"),("94591", "2", "1003", "271", "1", "8.940000000000", "27"),("13486", "2", "1001", "115", "1", "15.130000000000", "28"),("17526", "2", "1001", "42", "1", "31.930000000000", "29"),("13479", "2", "1000", "115", "1", "14.710000000000", "30"),("13480", "2", "1000", "115", "1", "14.710000000000", "31"),("13483", "2", "1000", "115", "1", "14.710000000000", "32"),("13485", "2", "1000", "115", "1", "14.710000000000", "33"),("13487", "2", "1000", "115", "1", "15.130000000000", "34"),("17528", "2", "1000", "42", "1", "31.930000000000", "35"),("94592", "2", "1000", "271", "1", "8.940000000000", "36"),("48017", "2", "1000", "49", "1", "20.170000000000", "37"),("10537", "2", "1000", "178", "1", "49.318400000000", "38"),("237241", "1", "3", "351", "1", "37.820000000000", "39"),("13482", "2", "2", "115", "1", "9.300000000000", "40"),("94594", "2", "1002", "271", "1", "7.770000000000", "41"),("94593", "2", "1000", "271", "1", "8.940000000000", "42"),("90945", "2", "1000", "85", "1", "245.580000000000", "43"),("72136", "2", "1", "149", "1", "57.980000000000", "44"),("115132", "1", "1000", "85", "1", "21.090000000000", "45"),("234585", "1", "1000", "455", "1", "20.390000000000", "46"),("138239", "1", "1000", "85", "1", "10.380000000000", "47"),("109479", "2", "1000", "85", "1", "23.540000000000", "48"),("200489", "1", "1025", "13", "1", "25.130000000000", "49"),("201689", "1", "1018", "13", "1", "21.760000000000", "50"),("238056", "1", "1000", "455", "1", "43.450000000000", "51"),("116430", "2", "10", "85", "1", "9.560000000000", "52"),("35717", "2", "0", "75", "1", "7.800000000000", "53"),("106789", "2", "0", "49", "1", "161.000000000000", "54"),("40759", "2", "0", "67", "1", "6.770000000000", "55"),("83357", "2", "0", "59", "1", "226.050000000000", "56"),("232562", "2", "0", "533", "1", "162.070000000000", "57"),("33763", "2", "0", "20", "1", "10.710000000000", "58"),("107611", "1", "0", "12", "1", "192.330000000000", "59"),("33765", "2", "0", "20", "1", "7.660000000000", "60"),("224196", "10", "0", "261", "1", "261.980000000000", "61"),("59726", "2", "0", "67", "1", "230.640000000000", "62"),("13484", "2", "0", "115", "1", "11.300000000000", "63"),("13481", "2", "0", "115", "1", "11.300000000000", "64"),("53215", "2", "0", "67", "1", "32.290000000000", "65"),("109154", "2", "0", "47", "1", "14.680000000000", "66"),("109639", "2", "0", "85", "1", "26.980000000000", "67")
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:846
5 (0.123)
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.228)
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.101)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"PRODUSE INACTIVE"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
8 (0.225)
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.074)
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.069)
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 (0.843)
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.116)
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