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

Produse ce potrivesc criteriilor de căutare


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

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

sg.63745
Livrare 24-48 ore

34,34Lei(-46%) 18,46Lei

Carabine Coghlans pentru Hamac
Exclusiv online!

Carabine Coghlans pentru Hamac

c1745
Livrare 24-48 ore

63,94Lei

Rucsac Nash Scope OPS Recon Rucksack

Rucsac Nash Scope OPS Recon Rucksack

t3775
Livrare imediată!

580,57Lei

TRICOU PROLOGIC CAMO LOGO GREY MELANGE MAR.M

TRICOU PROLOGIC CAMO LOGO GREY MELANGE MAR.M

a8.pro.73744
Livrare imediată!

99,95Lei

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

232,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

232,88Lei

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

Fes DAM Savage Fold Up Light Grey Melange, One Size

a8.dam.73785
Livrare 24-48 ore

25,98Lei(-45%) 14,21Lei

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

TRICOU SAVAGE GEAR SIGNATURE LOGO BLACK INK MAR.M

a8.sg.73645
Livrare imediată!

105,89Lei(-21%) 83,83Lei

Jacheta DAM Fly Maneci Detasabile, Marime 2XL

Jacheta DAM Fly Maneci Detasabile, Marime 2XL

a8.dam.37145
Livrare imediată!

274,68Lei

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

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

sg.63740
Livrare 24-48 ore

33,09Lei(-46%) 17,82Lei

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

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

sg.63747
Livrare 24-48 ore

34,34Lei(-46%) 18,46Lei

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

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

sg.63742
Livrare imediată!

33,09Lei(-24%) 25,05Lei

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

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

sg.63743
Livrare 24-48 ore

33,09Lei(-46%) 17,82Lei

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

57,67Lei

Hanger Zfish Indicator ZX, Clear
Exclusiv online!

Hanger Zfish Indicator ZX, Clear

zf-3735
Livrare 48-72ore

12,95Lei

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

15,19Lei

Jig Zfish Head, Nr.5/0, 20g, 5buc/plic
Exclusiv online!

Jig Zfish Head, Nr.5/0, 20g, 5buc/plic

zf-3725
Livrare 48-72ore

17,61Lei

MULINETA PRO FL PIONER LAC 5000
Exclusiv online!

MULINETA PRO FL PIONER LAC 5000

64-13345
Livrare 24-48 ore

103,60Lei

Plumb Inline Zfish Catfish Lead, 150g, 1buc/pac

Plumb Inline Zfish Catfish Lead, 150g, 1buc/pac

33-3145
Livrare imediată!

11,35Lei

LANSETA CRAP PRO FL TELE STRATEGIST 3.90M 3.75LBS

LANSETA CRAP PRO FL TELE STRATEGIST 3.90M 3.75LBS

3754-3907
Livrare imediată!

229,68Lei

Afişare 1 - 20 din 61 (4 pagini)
Queries: 13, Total time: 2.875 ms [By time] [By id] [By file]
1 (0.081)
SELECT data
FROM `oc_session`
WHERE session_id = '089e0244b4bc05392db897b34b'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.103)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.081)
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.195)
INSERT INTO oc_bf_tmp_product (product_id, sort_order, quantity, manufacturer_id, match_filters, actual_price, sort) VALUES ("109782", "2", "1000", "85", "1", "15.260000000000", "1"),("73208", "2", "1000", "464", "1", "52.840000000000", "2"),("83685", "2", "1", "59", "1", "479.810000000000", "3"),("124805", "1", "1", "47", "1", "82.600000000000", "4"),("120776", "1", "1000", "47", "1", "192.460000000000", "5"),("120778", "1", "1000", "47", "1", "192.460000000000", "6"),("183071", "2", "1000", "124", "1", "11.740000000000", "7"),("124899", "1", "1", "85", "1", "69.280000000000", "8"),("175185", "10", "1001", "124", "1", "227.010000000000", "9"),("109778", "2", "1000", "85", "1", "14.730000000000", "10"),("109783", "2", "1000", "85", "1", "15.260000000000", "11"),("109779", "2", "1", "85", "1", "20.700000000000", "12"),("109780", "2", "1000", "85", "1", "14.730000000000", "13"),("84815", "10", "1000", "157", "1", "47.660000000000", "14"),("217845", "1", "1000", "370", "1", "10.700000000000", "15"),("240524", "2", "1000", "73", "1", "12.550000000000", "16"),("211485", "2", "1000", "370", "1", "14.550000000000", "17"),("205767", "1", "1000", "13", "1", "85.620000000000", "18"),("221575", "1", "1010", "370", "1", "9.380000000000", "19"),("181461", "1", "1004", "13", "1", "189.820000000000", "20"),("113469", "2", "1003", "24", "1", "9.560000000000", "21"),("181459", "1", "1002", "13", "1", "181.410000000000", "22"),("96113", "2", "1001", "24", "1", "9.560000000000", "23"),("96117", "2", "1001", "24", "1", "9.560000000000", "24"),("11023", "2", "1000", "56", "1", "13.850000000000", "25"),("96114", "2", "1000", "24", "1", "9.560000000000", "26"),("96115", "2", "1000", "24", "1", "9.980000000000", "27"),("96118", "2", "1000", "24", "1", "10.830000000000", "28"),("113470", "2", "1000", "24", "1", "9.560000000000", "29"),("227169", "2", "1000", "48", "1", "10.740000000000", "30"),("209211", "1", "1000", "370", "1", "536.450000000000", "31"),("113471", "2", "1002", "24", "1", "10.830000000000", "32"),("239715", "1", "1002", "13", "1", "60.400000000000", "33"),("113491", "2", "1000", "24", "1", "10.830000000000", "34"),("167283", "2", "1", "113", "1", "231.920000000000", "35"),("128417", "2", "1000", "85", "1", "612.185600000000", "36"),("124811", "1", "0", "47", "1", "44.030000000000", "37"),("213539", "2", "0", "126", "1", "67.210000000000", "38"),("100452", "2", "0", "177", "1", "27.000000000000", "39"),("193831", "2", "0", "59", "1", "78.970000000000", "40"),("124807", "1", "0", "47", "1", "62.900000000000", "41"),("59596", "2", "0", "49", "1", "292.000000000000", "42"),("49624", "2", "0", "47", "1", "90.680000000000", "43"),("124809", "1", "0", "47", "1", "58.040000000000", "44"),("94900", "2", "0", "271", "1", "12.260000000000", "45"),("128273", "2", "0", "85", "1", "67.710000000000", "46"),("83774", "2", "0", "59", "1", "353.760000000000", "47"),("109774", "2", "0", "85", "1", "19.220000000000", "48"),("109781", "2", "0", "85", "1", "19.870000000000", "49"),("109784", "2", "0", "85", "1", "20.610000000000", "50"),("109785", "2", "0", "85", "1", "20.610000000000", "51"),("234520", "1", "0", "59", "1", "148.720000000000", "52"),("110264", "2", "0", "156", "1", "30.000000000000", "53"),("97778", "2", "0", "178", "1", "43.000000000000", "54"),("32188", "2", "0", "178", "1", "51.000000000000", "55"),("22086", "2", "0", "85", "1", "57.020000000000", "56"),("124915", "2", "0", "85", "1", "406.420000000000", "57"),("120699", "1", "0", "85", "1", "91.310000000000", "58"),("130677", "1", "0", "85", "1", "273.330000000000", "59"),("96116", "2", "0", "24", "1", "5.750000000000", "60"),("239710", "1", "0", "13", "1", "30.000000000000", "61")
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:846
5 (0.084)
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.214)
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.138)
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
8 (0.115)
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
9 (0.324)
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
10 (0.104)
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
11 (0.090)
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
12 (1.219)
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
13 (0.127)
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