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


MONTURA FEEDER FL METHOD FARA TIJA 30G CARLIG NR 10 SPIN 10MM CU PORUMB FLOTANT E G

MONTURA FEEDER FL METHOD FARA TIJA 30G CARLIG NR 10 SPIN 10MM CU PORUMB FLOTANT E G

64-1969-30-10
Livrare imediată!

14,12Lei

Lanseta feeder Team Feeder Pro Method L 300cm 10 30g

Lanseta feeder Team Feeder Pro Method L 300cm 10 30g

1849-300
Livrare imediată!

355,87Lei

Carlige MARUTO 9644-BN, Nr.10, 10buc/pac
Exclusiv online!

Carlige MARUTO 9644-BN, Nr.10, 10buc/pac

43502010
Livrare 24-48 ore

12,08Lei

Carlige Somn Nevis 9644, Nr.10/0, 3buc/pac
Exclusiv online!

Carlige Somn Nevis 9644, Nr.10/0, 3buc/pac

5652-010
Livrare 48-72 ore

12,49Lei

MONTURA FEEDER FL METHOD FARA TIJA 30G CARLIG NR6 SPIN 10MM CU PORUMB FLOTANT E G
Exclusiv online!

MONTURA FEEDER FL METHOD FARA TIJA 30G CARLIG NR6 SPIN 10MM CU PORUMB FLOTANT E G

64-1969-30-6
Livrare 24-48 ore

14,12Lei

MONTURA FEEDER FL METHOD FARA TIJA 30G CARLIG NR 8 SPIN 10MM CU PORUMB FLOTANT E G

MONTURA FEEDER FL METHOD FARA TIJA 30G CARLIG NR 8 SPIN 10MM CU PORUMB FLOTANT E G

64-1969-30-8
Livrare imediată!

14,12Lei

Sticla Termoizolanta STANLEY The Quick-Flip Water Bottle 0.7L / 24oz, Charcoal
Exclusiv online!

Sticla Termoizolanta STANLEY The Quick-Flip Water Bottle 0.7L / 24oz, Charcoal

10-09149-030
Livrare 24-48 ore

140,82Lei

Cana Termoizolanta STANLEY The Trigger-Action Travel Mug 0.47L / 16oz, Hammertone Green
Exclusiv online!

Cana Termoizolanta STANLEY The Trigger-Action Travel Mug 0.47L / 16oz, Hammertone Green

10-06439-030
Livrare 24-48 ore

145,91Lei

Momitor Feeder Chaos Inline, Anti Tangle, 30g

Momitor Feeder Chaos Inline, Anti Tangle, 30g

88-1647
Livrare imediată!

5,45Lei

LANSETA FEEDER FL CLASSIC COMMERCIAL 3.60M 20-120G 5VARFURI

LANSETA FEEDER FL CLASSIC COMMERCIAL 3.60M 20-120G 5VARFURI

64-1646
Livrare imediată!

274,52Lei

LANSETA FEEDER FL CLASSIC COMMERCIAL 3.30M 20-120G 5VARFURI
Exclusiv online!

LANSETA FEEDER FL CLASSIC COMMERCIAL 3.30M 20-120G 5VARFURI

64-1645
Livrare 24-48 ore

256,22Lei

LANSETA FEEDER FL CLASSIC COMMERCIAL 3.90M 20-120G 5VARFURI
Exclusiv online!

LANSETA FEEDER FL CLASSIC COMMERCIAL 3.90M 20-120G 5VARFURI

64-1647
Livrare 24-48 ore

245,94Lei

Lanseta feeder Team Feeder Pro Method L 390cm 40 100g
Exclusiv online!

Lanseta feeder Team Feeder Pro Method L 390cm 40 100g

1849-390
Livrare 48-72 ore

523,64Lei

Sticla Termoizolanta de Apa STANLEY Quick Flip Water Bottle, Azure, 0.7L

Sticla Termoizolanta de Apa STANLEY Quick Flip Water Bottle, Azure, 0.7L

10-09149-141
Livrare imediată!

143,29Lei

Lanseta feeder Team Feeder Pro Method L 330cm 15 40g

Lanseta feeder Team Feeder Pro Method L 330cm 15 40g

1849-330
Livrare imediată!

379,25Lei

Momitor Zfish Method Feeder Coil Anti tangle Weight, 30g, 1buc/pac
Exclusiv online!

Momitor Zfish Method Feeder Coil Anti tangle Weight, 30g, 1buc/pac

99-1644
Livrare 48-72ore

7,71Lei

MONTURA FEEDER FL METHOD FARA TIJA 40G CARLIG NR 10 SPIN 10MM CU PORUMB FLOTANT E G
Exclusiv online!

MONTURA FEEDER FL METHOD FARA TIJA 40G CARLIG NR 10 SPIN 10MM CU PORUMB FLOTANT E G

64-1969-40-10
Livrare 24-48 ore

14,12Lei

Fir Textil Filfishing Filex Feeder Braid, 0.16mm, 10.6kg, 25m

Fir Textil Filfishing Filex Feeder Braid, 0.16mm, 10.6kg, 25m

30-9649
Stoc epuizat

21,08Lei

Lanseta feeder Team Feeder Pro Method L 380cm 30 90g -31%

Lanseta feeder Team Feeder Pro Method L 380cm 30 90g

1849-380
Stoc epuizat

523,64Lei(-31%) 361,79Lei

Lanseta feeder Team Feeder Pro Method L 350cm 20 50g

Lanseta feeder Team Feeder Pro Method L 350cm 20 50g

1849-350
Stoc epuizat

419,92Lei

Afişare 1 - 20 din 22 (2 pagini)
Queries: 13, Total time: 1.887 ms [By time] [By id] [By file]
1 (0.082)
SELECT data
FROM `oc_session`
WHERE session_id = 'df7b8444deae3520740ff70832'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.102)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.106)
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.096)
INSERT INTO oc_bf_tmp_product (product_id, sort_order, quantity, manufacturer_id, match_filters, actual_price, sort) VALUES ("163876", "1", "1", "13", "1", "11.670000000000", "1"),("81062", "2", "1", "484", "1", "294.110000000000", "2"),("61082", "2", "1000", "410", "1", "9.980000000000", "3"),("179010", "1", "1000", "423", "1", "10.320000000000", "4"),("163879", "1", "1000", "13", "1", "11.670000000000", "5"),("163878", "1", "1003", "13", "1", "11.670000000000", "6"),("210553", "10", "1000", "751", "1", "116.380000000000", "7"),("210551", "10", "1000", "751", "1", "120.590000000000", "8"),("221564", "1", "1029", "370", "1", "4.500000000000", "9"),("164200", "2", "1003", "13", "1", "226.880000000000", "10"),("164198", "2", "1000", "13", "1", "211.750000000000", "11"),("164202", "2", "1000", "13", "1", "203.260000000000", "12"),("81067", "2", "1000", "484", "1", "432.760000000000", "13"),("239233", "10", "2", "751", "1", "118.420000000000", "14"),("81063", "2", "2", "484", "1", "313.430000000000", "15"),("227312", "1", "1000", "370", "1", "6.370000000000", "16"),("163880", "1", "1000", "13", "1", "11.670000000000", "17"),("227261", "1", "0", "528", "1", "17.420000000000", "18"),("81066", "2", "0", "484", "1", "299.000000000000", "19"),("81065", "2", "0", "484", "1", "347.040000000000", "20"),("119963", "1", "0", "423", "1", "162.000000000000", "21"),("81064", "2", "0", "484", "1", "297.000000000000", "22")
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:846
5 (0.095)
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.220)
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.156)
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.139)
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.228)
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.095)
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.077)
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 (0.399)
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.092)
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