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


Carlige Maruto 8714 BL Barbless Nr.10

Carlige Maruto 8714 BL Barbless Nr.10

43011010
Livrare imediată!

10,96Lei

PLUTA JOKER CRAP 3114 3,0G

PLUTA JOKER CRAP 3114 3,0G

60883003
Livrare imediată!

10,06Lei

Carlige Gamakatsu LS-3614, Nr.10, 10buc/pac

Carlige Gamakatsu LS-3614, Nr.10, 10buc/pac

149009-010
Livrare imediată!

14,83Lei

Carlige Gamakatsu LS-3614, Nr.8, 10buc/pac
Exclusiv online!

Carlige Gamakatsu LS-3614, Nr.8, 10buc/pac

149009-008
Livrare 48-72 ore

14,83Lei

Carlige Gamakatsu LS-3614, Nr.12, 10buc/pac
Exclusiv online!

Carlige Gamakatsu LS-3614, Nr.12, 10buc/pac

149009-012
Livrare 48-72 ore

14,83Lei

Carlige Maruto HC 8714 BL barbless 10buc nr 4

Carlige Maruto HC 8714 BL barbless 10buc nr 4

43011004
Livrare imediată!

10,96Lei

Carlig Owner Cps 5114 Negru Killer Nr 1 - 8buc/plic
Exclusiv online!

Carlig Owner Cps 5114 Negru Killer Nr 1 - 8buc/plic

5114003
Livrare 48-72 ore

17,27Lei

Plumb Inline Zfish Flat Pear Lead, 60g, 1buc/pac
Exclusiv online!

Plumb Inline Zfish Flat Pear Lead, 60g, 1buc/pac

55-2214
Livrare 48-72ore

8,70Lei

Carlig Owner Cps 5114 Negru Killer Nr 1/0 - 7buc/plic -22%

Carlig Owner Cps 5114 Negru Killer Nr 1/0 - 7buc/plic

5114002
Livrare imediată!

18,76Lei(-22%) 14,54Lei

FIR MONOFILAMENT PRO FL 3D BIOMETRIC 1200M 0.25MM
Exclusiv online!

FIR MONOFILAMENT PRO FL 3D BIOMETRIC 1200M 0.25MM

64-2214
Livrare 48-72 ore

122,92Lei

CARLIGE COLMIC LEGATE N500 NR 8-0.14 70CM

CARLIGE COLMIC LEGATE N500 NR 8-0.14 70CM

al10814
Livrare imediată!

24,39Lei

CARLIGE COLMIC LEGATE N600 NR 8-0.14 70CM
Exclusiv online!

CARLIGE COLMIC LEGATE N600 NR 8-0.14 70CM

al20814
Livrare 48-72 ore

22,35Lei

CARLIGE COLMIC LEGATE N600 NR 10-0.14 70CM
Exclusiv online!

CARLIGE COLMIC LEGATE N600 NR 10-0.14 70CM

al21014
Livrare 48-72 ore

22,35Lei

CARLIGE COLMIC LEGATE NK800 NR 8-0.14 70CM
Exclusiv online!

CARLIGE COLMIC LEGATE NK800 NR 8-0.14 70CM

al40814
Livrare 48-72 ore

22,35Lei

MULINETA PRO FL DISTANCE CARP METHOD FEEDER 10000 10RULMENTI
Exclusiv online!

MULINETA PRO FL DISTANCE CARP METHOD FEEDER 10000 10RULMENTI

64-1814
Livrare 48-72 ore

275,54Lei

Carlige GARBOLINO Specimen Carp 2490BN Barbless, Nr.14, 12buc
Exclusiv online!

Carlige GARBOLINO Specimen Carp 2490BN Barbless, Nr.14, 12buc

120530goman02490bn-0014
Livrare 48-72 ore

16,04Lei

Carlige GARBOLINO Carp Special Profile 2620BN Barbless, Nr.14, 12buc
Exclusiv online!

Carlige GARBOLINO Carp Special Profile 2620BN Barbless, Nr.14, 12buc

120530goman02620bn-0014
Livrare 48-72 ore

16,04Lei

Carlige legate FUDO BREAM - BN 5 0.14 mm/ 85 cm
Exclusiv online!

Carlige legate FUDO BREAM - BN 5 0.14 mm/ 85 cm

fdsh-004-5
Livrare 48-72ore

11,17Lei

Carlige legate FUDO MAGGOT - BN NR 5 0.14 mm/ 50 cm -9%
Exclusiv online!

Carlige legate FUDO MAGGOT - BN NR 5 0.14 mm/ 50 cm

fdsh-005-5
Livrare 48-72ore

9,99Lei(-9%) 9,14Lei

Vobler Rapala Dives-To, Culoare CRSD, 6cm, 17g -25%

Vobler Rapala Dives-To, Culoare CRSD, 6cm, 17g

dt10 crsd
Stoc epuizat

56,82Lei(-25%) 42,35Lei

Afişare 1 - 20 din 28 (2 pagini)
Queries: 15, Total time: 3.447 ms [By time] [By id] [By file]
1 (0.456)
SELECT data
FROM `oc_session`
WHERE session_id = '891a9f09c20e6b1788ef06ff19'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.143)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.148)
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 ("95959", "2", "1008", "410", "1", "9.060000000000", "1"),("69345", "2", "1010", "415", "1", "8.310000000000", "2"),("228530", "2", "1001", "19", "1", "12.260000000000", "3"),("228525", "2", "1000", "19", "1", "12.260000000000", "4"),("228531", "2", "1000", "19", "1", "12.260000000000", "5"),("113437", "2", "5", "410", "1", "9.060000000000", "6"),("552", "2", "1000", "15", "1", "14.270000000000", "7"),("226244", "1", "1000", "370", "1", "7.190000000000", "8"),("553", "2", "1", "15", "1", "12.020000000000", "9"),("244262", "1", "1000", "13", "1", "101.590000000000", "10"),("13591", "2", "1002", "115", "1", "20.160000000000", "11"),("13609", "2", "1000", "115", "1", "18.470000000000", "12"),("13612", "2", "1000", "115", "1", "18.470000000000", "13"),("13647", "2", "1000", "115", "1", "18.470000000000", "14"),("164039", "1", "1000", "13", "1", "227.720000000000", "15"),("241025", "1", "1000", "119", "1", "13.260000000000", "16"),("241026", "1", "1000", "119", "1", "13.260000000000", "17"),("133239", "2", "1000", "289", "1", "9.230000000000", "18"),("133249", "2", "1000", "289", "1", "7.550000000000", "19"),("98344", "2", "0", "117", "1", "35.000000000000", "20"),("228526", "2", "0", "19", "1", "12.260000000000", "21"),("228527", "2", "0", "19", "1", "11.590000000000", "22"),("133195", "2", "0", "289", "1", "4.480000000000", "23"),("133197", "2", "0", "289", "1", "4.480000000000", "24"),("133251", "2", "0", "289", "1", "4.480000000000", "25"),("133217", "2", "0", "289", "1", "4.480000000000", "26"),("133221", "2", "0", "289", "1", "4.480000000000", "27"),("133223", "2", "0", "289", "1", "4.480000000000", "28")
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:846
5 (0.269)
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.273)
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.142)
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.153)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"TACKLE SHOP ARENA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
9 (0.135)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"TACKLE SHOP ARENA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
10 (0.117)
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
11 (0.284)
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
12 (0.124)
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
13 (0.108)
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
14 (0.749)
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
15 (0.145)
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