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


LANSETA RAPTURE X-RAY RACING S671M X-FAST 2.01 M 3.50-14 G -14%

LANSETA RAPTURE X-RAY RACING S671M X-FAST 2.01 M 3.50-14 G

126-07-600
Livrare imediată!

650,00Lei(-14%) 557,60Lei

Lanseta TAILWALK B-Breamer SSD S710M/SSL, 2.15m, 5-21g, 2seg
Exclusiv online!

Lanseta TAILWALK B-Breamer SSD S710M/SSL, 2.15m, 5-21g, 2seg

tbbssd-s710m
Livrare 24-48 ore

1.016,79Lei

Stopper Jaxon cauciuc negru M

Stopper Jaxon cauciuc negru M

aj-st01m
Livrare imediată!

4,56Lei

Lanseta TAILWALK Bay Mixx SSD S72M, 2.18m, 7-35g, 2seg
Exclusiv online!

Lanseta TAILWALK Bay Mixx SSD S72M, 2.18m, 7-35g, 2seg

tbmssd-s72m
Livrare 24-48 ore

860,20Lei

Lanseta TAILWALK Bay Mixx SSD S76M, 2.28m, 7-40g, 2seg
Exclusiv online!

Lanseta TAILWALK Bay Mixx SSD S76M, 2.28m, 7-40g, 2seg

tbmssd-s76m
Livrare 24-48 ore

900,87Lei

Shad Relax Kopyto Standard Blister, S171, 0.7g, 3cm, 8buc/plic
Exclusiv online!

Shad Relax Kopyto Standard Blister, S171, 0.7g, 3cm, 8buc/plic

bls1-s171-b
Livrare 24-48 ore

10,15Lei

Shad Relax Ohio 2.5 inch Standard, 7.5cm ROH25-S171 10 buc/plic
Exclusiv online!

Shad Relax Ohio 2.5 inch Standard, 7.5cm ROH25-S171 10 buc/plic

oh25-s171
Livrare 24-48 ore

18,30Lei

PLUMB PRO FL INLINE Flat Pear 113G

PLUMB PRO FL INLINE Flat Pear 113G

64-66716
Livrare imediată!

10,06Lei

Spinnertail SENSAS Gunki Shocker Vib 14, Gremille, 3.2cm, 15.6g
Exclusiv online!

Spinnertail SENSAS Gunki Shocker Vib 14, Gremille, 3.2cm, 15.6g

spm.86716
Livrare 24-48 ore

41,42Lei

Spinnertail SENSAS Gunki Shocker Vib 14, UFO, 3.2cm, 15.6g
Exclusiv online!

Spinnertail SENSAS Gunki Shocker Vib 14, UFO, 3.2cm, 15.6g

spm.86718
Livrare 24-48 ore

41,42Lei

LANSETA RAPTURE FINEZZA RV S641ML X-FAST 1.94m
Exclusiv online!

LANSETA RAPTURE FINEZZA RV S641ML X-FAST 1.94m

126-05-700
Livrare 48-72 ore

556,07Lei

Acumulator Agm Vrla 12V 77A Gel Deep Cycle 260mm x 167mm x 210mm

Acumulator Agm Vrla 12V 77A Gel Deep Cycle 260mm x 167mm x 210mm

m6ted
Livrare imediată!

966,97Lei

Lanseta TAILWALK Micro Shore Jigging SSD 89, 2.71m, 3.5-21g, 2seg
Exclusiv online!

Lanseta TAILWALK Micro Shore Jigging SSD 89, 2.71m, 3.5-21g, 2seg

tmsjssd-89
Livrare 24-48 ore

778,86Lei

MOMITOR CU ANTITANGLE JAXON 21cm -11%

MOMITOR CU ANTITANGLE JAXON 21cm

aj-061m
Livrare imediată!

9,00Lei(-11%) 8,02Lei

Rodpod AVID Extremity Pod 3 Post, 140-215x126.5x 87-167cm -24%
Exclusiv online!

Rodpod AVID Extremity Pod 3 Post, 140-215x126.5x 87-167cm

a0480039
Livrare 7-14 zile

854,96Lei(-24%) 653,69Lei

Husa FOX RAGE Rod Shield Casting, Red, 167cm
Exclusiv online!

Husa FOX RAGE Rod Shield Casting, Red, 167cm

nlu139
Livrare 7-14 zile

54,49Lei

LANSETA RAPTURE X-RAY RACING S681MH X-FAST 2.03 M 5.25-17.50 G

LANSETA RAPTURE X-RAY RACING S681MH X-FAST 2.03 M 5.25-17.50 G

126-07-650
Livrare imediată!

698,42Lei

Plumb Filfishing Filex Mini Split Shots, 0.45g

Plumb Filfishing Filex Mini Split Shots, 0.45g

25-5671
Livrare imediată!

8,93Lei

Opritoare Tungsten ZFISH Tungsten Sinkers, Size M, 9buc/pac
Exclusiv online!

Opritoare Tungsten ZFISH Tungsten Sinkers, Size M, 9buc/pac

zf-6718
Livrare 48-72ore

16,87Lei

SPINI MOMEALA PRO FL 5MM 25buc/plic

SPINI MOMEALA PRO FL 5MM 25buc/plic

64-26710
Livrare imediată!

10,06Lei

Afişare 1 - 20 din 51 (3 pagini)
Queries: 12, Total time: 2.357 ms [By time] [By id] [By file]
1 (0.130)
SELECT data
FROM `oc_session`
WHERE session_id = 'ec428b0362914ea00ad60f7bc6'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.070)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.126)
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.169)
INSERT INTO oc_bf_tmp_product (product_id, sort_order, quantity, manufacturer_id, match_filters, actual_price, sort) VALUES ("95028", "2", "1", "105", "1", "460.830000000000", "1"),("232770", "1", "1000", "338", "1", "840.320000000000", "2"),("65586", "2", "1005", "42", "1", "3.770000000000", "3"),("232774", "1", "1000", "338", "1", "710.910000000000", "4"),("232776", "1", "1000", "338", "1", "744.520000000000", "5"),("197823", "2", "1000", "48", "1", "8.390000000000", "6"),("44293", "2", "1000", "48", "1", "15.120000000000", "7"),("211143", "2", "1011", "13", "1", "8.310000000000", "8"),("226660", "1", "1000", "62", "1", "34.230000000000", "9"),("226661", "1", "1000", "62", "1", "34.230000000000", "10"),("94360", "2", "1000", "105", "1", "459.560000000000", "11"),("118630", "1", "1", "305", "1", "799.150000000000", "12"),("232778", "1", "1000", "338", "1", "643.690000000000", "13"),("39505", "2", "2", "42", "1", "6.630000000000", "14"),("233846", "1", "1000", "353", "1", "540.240000000000", "15"),("238063", "1", "1000", "455", "1", "45.030000000000", "16"),("95029", "2", "1001", "105", "1", "577.210000000000", "17"),("227291", "2", "1016", "528", "1", "7.380000000000", "18"),("235648", "2", "1000", "370", "1", "13.940000000000", "19"),("214711", "1", "1001", "13", "1", "8.310000000000", "20"),("225880", "2", "1002", "370", "1", "84.130000000000", "21"),("73980", "2", "1012", "145", "1", "26.450000000000", "22"),("147779", "1", "1000", "17", "1", "552.930000000000", "23"),("248686", "2", "1004", "173", "1", "131.070000000000", "24"),("168170", "1", "1000", "150", "1", "997.830000000000", "25"),("10845", "2", "3", "145", "1", "16.710000000000", "26"),("178880", "1", "1000", "193", "1", "236.120000000000", "27"),("205039", "1", "1000", "150", "1", "2996.650000000000", "28"),("247712", "1", "1000", "150", "1", "1998.010000000000", "29"),("118560", "2", "1000", "105", "1", "11.670000000000", "30"),("78782", "2", "1004", "56", "1", "91.590000000000", "31"),("78785", "2", "1002", "56", "1", "193.260000000000", "32"),("78786", "2", "1000", "56", "1", "216.790000000000", "33"),("78784", "2", "1000", "56", "1", "121.830000000000", "34"),("78787", "2", "1", "56", "1", "13.830000000000", "35"),("78781", "2", "1000", "56", "1", "28.390000000000", "36"),("78780", "2", "1000", "56", "1", "22.340000000000", "37"),("197791", "2", "0", "48", "1", "12.000000000000", "38"),("52130", "2", "0", "115", "1", "10.500000000000", "39"),("241496", "1", "0", "54", "1", "42.270000000000", "40"),("241506", "1", "0", "54", "1", "42.270000000000", "41"),("236233", "1", "0", "85", "1", "203.970000000000", "42"),("236257", "1", "0", "85", "1", "203.970000000000", "43"),("236258", "1", "0", "85", "1", "203.970000000000", "44"),("236232", "1", "0", "85", "1", "203.970000000000", "45"),("236231", "1", "0", "85", "1", "203.970000000000", "46"),("189385", "1", "0", "305", "1", "735.000000000000", "47"),("147783", "1", "0", "17", "1", "540.000000000000", "48"),("153397", "2", "0", "492", "1", "160.000000000000", "49"),("111502", "2", "0", "553", "1", "1058.000000000000", "50"),("78783", "2", "0", "56", "1", "99.810000000000", "51")
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:846
5 (0.113)
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.204)
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.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
8 (0.257)
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.081)
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.071)
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.869)
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.156)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '2' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:37