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


OCHELARI POLARIZATI MIKADO 7516 BLUE/VIOLET

OCHELARI POLARIZATI MIKADO 7516 BLUE/VIOLET

amo-7516-bv
Livrare imediată!

92,41Lei

MOMITOR MAVER PRO-FEEDER PLASTIC GRIP MESH 10GR -13%
Exclusiv online!

MOMITOR MAVER PRO-FEEDER PLASTIC GRIP MESH 10GR

179110
Livrare 48-72 ore

12,00Lei(-13%) 10,45Lei

MOMITOR MAVER PRO-FEEDER PLASTIC GRIP MESH 50GR -17%
Exclusiv online!

MOMITOR MAVER PRO-FEEDER PLASTIC GRIP MESH 50GR

179150
Livrare 48-72 ore

15,60Lei(-17%) 13,00Lei

Lingurita ABU GARCIA Stor Zigge, Glitter RBT, 18g, 5cm, 1buc/pac
Exclusiv online!

Lingurita ABU GARCIA Stor Zigge, Glitter RBT, 18g, 5cm, 1buc/pac

1579816
Livrare 7-14 zile

21,34Lei

Fir Textil Berkley Whiplash8, Yellow, 150m, 0.12mm, 17.6kg

Fir Textil Berkley Whiplash8, Yellow, 150m, 0.12mm, 17.6kg

1579716
Livrare imediată!

107,76Lei

Combo Abu Garcia Revo X3 Casting 662MH, 15-45g, 1.98m, 2seg
Exclusiv online!

Combo Abu Garcia Revo X3 Casting 662MH, 15-45g, 1.98m, 2seg

1579556
Livrare 7-14 zile

805,29Lei

Cizme Zfish Bigfoot Boots, Green, Marime 44

Cizme Zfish Bigfoot Boots, Green, Marime 44

zf-1751
Livrare imediată!

203,40Lei

SHAD SAVAGE GEAR CANNIBAL SHAD OLIVE SMOLT UV 10CM 9G 4BUC/PLIC -29%
Exclusiv online!

SHAD SAVAGE GEAR CANNIBAL SHAD OLIVE SMOLT UV 10CM 9G 4BUC/PLIC

f1.sg.71916
Livrare 24-48 ore

18,61Lei(-29%) 13,27Lei

Shad Zfish Fat Belly, Culoare B5, 10cm, 4buc/pac
Exclusiv online!

Shad Zfish Fat Belly, Culoare B5, 10cm, 4buc/pac

zf-1756-b5
Livrare 48-72ore

15,00Lei

Shad Zfish Fat Belly, Culoare B9, 10cm, 4buc/pac
Exclusiv online!

Shad Zfish Fat Belly, Culoare B9, 10cm, 4buc/pac

zf-1791-b8
Livrare 48-72ore

15,00Lei

Fir BERKLEY DEX Braid X8, Chartreuse, 5.4kg, 0.06mm, 3000m
Exclusiv online!

Fir BERKLEY DEX Braid X8, Chartreuse, 5.4kg, 0.06mm, 3000m

1595316
Livrare 7-14 zile

2.326,44Lei

Agrafa Cu Vartej Zfish Rolling Swivel With T Snap, 43kg, Nr.6, 10buc/plic

Agrafa Cu Vartej Zfish Rolling Swivel With T Snap, 43kg, Nr.6, 10buc/plic

zf-7916
Livrare imediată!

14,98Lei

Lanseta Mitchell Tanager SW Jig EH, 200-400g, 1.80m, 2seg -19%

Lanseta Mitchell Tanager SW Jig EH, 200-400g, 1.80m, 2seg

1579596
Stoc epuizat

204,32Lei(-19%) 164,55Lei

Patura NASH Indulgence Heated Blanket, Standard

Patura NASH Indulgence Heated Blanket, Standard

t9516
Stoc epuizat

702,59Lei

Combo Abu Garcia Revo X Spinning M, 7-28g, 2.13m, 2seg -23%

Combo Abu Garcia Revo X Spinning M, 7-28g, 2.13m, 2seg

1579561
Stoc epuizat

885,62Lei(-23%) 678,79Lei

Vobler Savage Gear Gravity Minnow Mirror Ayu, 5cm, 8g -25%

Vobler Savage Gear Gravity Minnow Mirror Ayu, 5cm, 8g

sg.73516
Stoc epuizat

45,77Lei(-25%) 34,44Lei

Mulineta SAVAGE GEAR Fazor C3000, 5.2:1, 0.23mm/150m -18%

Mulineta SAVAGE GEAR Fazor C3000, 5.2:1, 0.23mm/150m

1609516
Stoc epuizat

763,61Lei(-18%) 625,32Lei

Croseta Zfish Boilie Needle, 7cm

Croseta Zfish Boilie Needle, 7cm

zf-1916
Stoc epuizat

8,09Lei

Afişare 1 - 18 din 18 (1 pagini)
Queries: 14, Total time: 2.051 ms [By time] [By id] [By file]
1 (0.104)
SELECT data
FROM `oc_session`
WHERE session_id = 'edadfe3081128e7aaa5a421594'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.101)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.091)
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.092)
INSERT INTO oc_bf_tmp_product (product_id, sort_order, quantity, manufacturer_id, match_filters, actual_price, sort) VALUES ("166381", "1", "1001", "224", "1", "76.370000000000", "1"),("30515", "2", "1000", "49", "1", "8.640000000000", "2"),("30519", "2", "1000", "49", "1", "10.740000000000", "3"),("239102", "2", "1000", "122", "1", "17.640000000000", "4"),("188051", "1", "1013", "54", "1", "89.060000000000", "5"),("198491", "2", "1000", "122", "1", "665.530000000000", "6"),("226204", "1", "1001", "370", "1", "168.100000000000", "7"),("144403", "2", "1000", "85", "1", "10.970000000000", "8"),("220945", "1", "1000", "370", "1", "12.400000000000", "9"),("220954", "1", "1000", "370", "1", "12.400000000000", "10"),("244245", "1", "1000", "54", "1", "1922.680000000000", "11"),("227061", "1", "1005", "370", "1", "12.380000000000", "12"),("194633", "2", "0", "87", "1", "135.990000000000", "13"),("235882", "2", "0", "59", "1", "580.650000000000", "14"),("195841", "1", "0", "122", "1", "560.980000000000", "15"),("176512", "1", "0", "85", "1", "28.460000000000", "16"),("235853", "1", "0", "85", "1", "516.790000000000", "17"),("217647", "1", "0", "370", "1", "6.690000000000", "18")
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:846
5 (0.115)
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.254)
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.116)
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.106)
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.111)
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.211)
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.088)
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.080)
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 (0.477)
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.105)
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