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


TRICOU PROLOGIC CAMO LOGO GREY MELANGE MAR.L -30%
Exclusiv online!

TRICOU PROLOGIC CAMO LOGO GREY MELANGE MAR.L

a8.pro.73745
Livrare 24-48 ore

97,28Lei(-30%) 68,09Lei

CICADA SAVAGE GEAR SWITCH BLADE MINNOW 6CM/18G PEARL WHITE -40%
Exclusiv online!

CICADA SAVAGE GEAR SWITCH BLADE MINNOW 6CM/18G PEARL WHITE

sg.63745
Livrare 24-48 ore

34,34Lei(-40%) 20,60Lei

Carabine Coghlans pentru Hamac
Exclusiv online!

Carabine Coghlans pentru Hamac

c1745
Livrare 24-48 ore

61,00Lei

Rucsac Nash Scope OPS Recon Rucksack

Rucsac Nash Scope OPS Recon Rucksack

t3775
Livrare imediată!

569,99Lei

Vobler Storm Chug Bug Saltwater Culoare 1375 11cm 26g
Exclusiv online!

Vobler Storm Chug Bug Saltwater Culoare 1375 11cm 26g

cbs11 1375
Livrare 48-72ore

42,00Lei

TRICOU PROLOGIC CAMO LOGO GREY MELANGE MAR.M

TRICOU PROLOGIC CAMO LOGO GREY MELANGE MAR.M

a8.pro.73744
Livrare imediată!

97,29Lei

HANORAC PROLOGIC EDEN ZIP BLACK CAVIAR MARIME XL
Exclusiv online!

HANORAC PROLOGIC EDEN ZIP BLACK CAVIAR MARIME XL

a8.pro.73754
Livrare 24-48 ore

231,88Lei

HANORAC PROLOGIC EDEN ZIP BLACK CAVIAR MARIME XXL
Exclusiv online!

HANORAC PROLOGIC EDEN ZIP BLACK CAVIAR MARIME XXL

a8.pro.73755
Livrare 24-48 ore

231,88Lei

Fes DAM Savage Fold Up Light Grey Melange, One Size -40%
Exclusiv online!

Fes DAM Savage Fold Up Light Grey Melange, One Size

a8.dam.73785
Livrare 24-48 ore

25,98Lei(-40%) 15,59Lei

TRICOU SAVAGE GEAR SIGNATURE LOGO BLACK INK MAR.M -23%

TRICOU SAVAGE GEAR SIGNATURE LOGO BLACK INK MAR.M

a8.sg.73645
Livrare imediată!

105,89Lei(-23%) 81,46Lei

CICADA SAVAGE GREAR SWITCH BLADE MINNOW 5CM/11G OLIVE SMOLT -29%

CICADA SAVAGE GREAR SWITCH BLADE MINNOW 5CM/11G OLIVE SMOLT

sg.63742
Livrare imediată!

33,09Lei(-29%) 23,65Lei

Jacheta DAM Fly Maneci Detasabile, Marime 2XL

Jacheta DAM Fly Maneci Detasabile, Marime 2XL

a8.dam.37145
Livrare imediată!

336,45Lei

CICADA SAVAGE GEAR SWITCH BLADE MINNOW 6CM/18G OLIVE SMOLT -40%
Exclusiv online!

CICADA SAVAGE GEAR SWITCH BLADE MINNOW 6CM/18G OLIVE SMOLT

sg.63747
Livrare 24-48 ore

34,34Lei(-40%) 20,60Lei

CICADA SAVAGE GREAR SWITCH BLADE MINNOW 5CM/11G PEARL WHITE -20%
Exclusiv online!

CICADA SAVAGE GREAR SWITCH BLADE MINNOW 5CM/11G PEARL WHITE

sg.63740
Livrare 24-48 ore

33,09Lei(-20%) 26,47Lei

CICADA SAVAGE GREAR SWITCH BLADE MINNOW 5CM/11G BLUE PINK SMOLT -40%
Exclusiv online!

CICADA SAVAGE GREAR SWITCH BLADE MINNOW 5CM/11G BLUE PINK SMOLT

sg.63743
Livrare 24-48 ore

33,09Lei(-40%) 19,85Lei

CUTIE PELETE BALLISTOL LANA PT CURATAT TEAVA CAL.16 30BUC/PL
Exclusiv online!

CUTIE PELETE BALLISTOL LANA PT CURATAT TEAVA CAL.16 30BUC/PL

vk.23245
Livrare 24-48 ore

48,17Lei

SAPCA TREESCO LED MARO -28%
Exclusiv online!

SAPCA TREESCO LED MARO

bt.3475
Livrare 24-48 ore

57,30Lei(-28%) 41,06Lei

Boilies Dynamite Baits Pop-up Robin Red 15mm 1Kg
Exclusiv online!

Boilies Dynamite Baits Pop-up Robin Red 15mm 1Kg

dy045
Livrare 48-72ore

69,00Lei

Hanger Zfish Indicator ZX, Clear
Exclusiv online!

Hanger Zfish Indicator ZX, Clear

zf-3735
Livrare 48-72ore

11,75Lei

Plumb cu Vartej KORDA Distance Casting Swivel, 4.5oz/126g, 1buc/pac
Exclusiv online!

Plumb cu Vartej KORDA Distance Casting Swivel, 4.5oz/126g, 1buc/pac

dcs45
Livrare 7-14 zile

13,95Lei

Afişare 1 - 20 din 50 (3 pagini)
Queries: 14, Total time: 3.729 ms [By time] [By id] [By file]
1 (0.200)
SELECT data
FROM `oc_session`
WHERE session_id = '1f7f03c7b476807a4847ac6808'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.098)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.168)
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.303)
INSERT INTO oc_bf_tmp_product (product_id, sort_order, quantity, manufacturer_id, match_filters, actual_price, sort) VALUES ("124811", "1", "1000", "47", "1", "57.220000000000", "1"),("109782", "2", "1000", "85", "1", "17.310000000000", "2"),("73208", "2", "1000", "464", "1", "51.260000000000", "3"),("83685", "2", "1", "59", "1", "478.980000000000", "4"),("100452", "2", "1000", "177", "1", "35.290000000000", "5"),("124805", "1", "1", "47", "1", "81.760000000000", "6"),("120776", "1", "1000", "47", "1", "194.860000000000", "7"),("120778", "1", "1000", "47", "1", "194.860000000000", "8"),("183071", "2", "1000", "124", "1", "13.100000000000", "9"),("124899", "1", "1", "85", "1", "68.450000000000", "10"),("109779", "2", "1001", "85", "1", "19.870000000000", "11"),("175185", "10", "1001", "124", "1", "282.730000000000", "12"),("109783", "2", "1000", "85", "1", "17.310000000000", "13"),("109778", "2", "1000", "85", "1", "22.240000000000", "14"),("109780", "2", "1000", "85", "1", "16.680000000000", "15"),("84815", "10", "1000", "157", "1", "40.480000000000", "16"),("110264", "2", "1000", "156", "1", "34.500000000000", "17"),("32188", "2", "1000", "178", "1", "81.024000000000", "18"),("217845", "1", "1000", "370", "1", "9.870000000000", "19"),("240524", "2", "1000", "73", "1", "11.720000000000", "20"),("211485", "2", "1000", "370", "1", "13.720000000000", "21"),("205767", "1", "1000", "13", "1", "83.950000000000", "22"),("221575", "1", "1018", "370", "1", "8.550000000000", "23"),("128417", "2", "1000", "85", "1", "611.123200000000", "24"),("227169", "2", "1000", "48", "1", "9.920000000000", "25"),("209211", "1", "1000", "370", "1", "535.620000000000", "26"),("239715", "1", "1002", "13", "1", "59.580000000000", "27"),("167283", "2", "1001", "113", "1", "231.090000000000", "28"),("239710", "1", "1001", "13", "1", "51.180000000000", "29"),("213539", "2", "0", "126", "1", "66.390000000000", "30"),("193831", "2", "0", "59", "1", "78.140000000000", "31"),("124807", "1", "0", "47", "1", "62.900000000000", "32"),("49624", "2", "0", "47", "1", "90.680000000000", "33"),("59596", "2", "0", "49", "1", "292.000000000000", "34"),("124809", "1", "0", "47", "1", "57.220000000000", "35"),("10556", "2", "0", "178", "1", "44.000000000000", "36"),("143189", "1", "0", "85", "1", "33.080000000000", "37"),("128273", "2", "0", "85", "1", "67.710000000000", "38"),("94900", "2", "0", "271", "1", "11.430000000000", "39"),("83774", "2", "0", "59", "1", "352.930000000000", "40"),("109774", "2", "0", "85", "1", "19.220000000000", "41"),("109781", "2", "0", "85", "1", "19.870000000000", "42"),("109784", "2", "0", "85", "1", "20.610000000000", "43"),("109785", "2", "0", "85", "1", "20.610000000000", "44"),("234520", "1", "0", "59", "1", "147.890000000000", "45"),("97778", "2", "0", "178", "1", "55.040000000000", "46"),("124915", "2", "0", "85", "1", "405.600000000000", "47"),("22086", "2", "0", "85", "1", "57.020000000000", "48"),("120699", "1", "0", "85", "1", "90.480000000000", "49"),("130677", "1", "0", "85", "1", "273.330000000000", "50")
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:846
5 (0.158)
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.279)
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.127)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"RAPALA VMC ROMANIA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
8 (0.191)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"RAPALA VMC ROMANIA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
9 (0.108)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"ZFISHING SPORT WHOLESALE S.R.O"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
10 (0.365)
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
11 (0.106)
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
12 (0.095)
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
13 (1.233)
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
14 (0.298)
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