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 14 zile

Retur simplu in 14 zile.

Vezi mai multe detalii

Căutare

Produse ce potrivesc criteriilor de căutare


PLUMB MAVER ELEVATOR 150GR
Exclusiv online!

PLUMB MAVER ELEVATOR 150GR

75022150
Livrare 48-72 ore

19,90Lei

PLUMB MAVER ELEVATOR 170GR
Exclusiv online!

PLUMB MAVER ELEVATOR 170GR

75022170
Livrare 48-72 ore

21,10Lei

PLUMB BOMB INLINE CU INVELIS PLUTA MAVER 130GR -29%

PLUMB BOMB INLINE CU INVELIS PLUTA MAVER 130GR

75023130
Livrare imediată!

16,01Lei(-29%) 11,31Lei

PLUMB BOMB INLINE CU INVELIS PLUTA MAVER 150GR -30%
Exclusiv online!

PLUMB BOMB INLINE CU INVELIS PLUTA MAVER 150GR

75023150
Livrare 48-72 ore

18,00Lei(-30%) 12,60Lei

PLUMB BOMB INLINE CU INVELIS PLUTA MAVER 170GR -30%
Exclusiv online!

PLUMB BOMB INLINE CU INVELIS PLUTA MAVER 170GR

75023170
Livrare 48-72 ore

19,50Lei(-30%) 13,60Lei

PLUMB MAVER GRIPA DUNG BOOM CU VARTEJ 80GR -35%

PLUMB MAVER GRIPA DUNG BOOM CU VARTEJ 80GR

75009080
Livrare imediată!

8,40Lei(-35%) 5,50Lei

PLUMB SONDARE CARP EXPERT MARKER LEAD

PLUMB SONDARE CARP EXPERT MARKER LEAD

79660122
Livrare imediată!

8,90Lei

PLUMB SONDARE CARP EXPERT MARKER 40GR

PLUMB SONDARE CARP EXPERT MARKER 40GR

79660123
Livrare imediată!

7,60Lei

Plumb Sondare Carp Spirit Marker Lead 140g

Plumb Sondare Carp Spirit Marker Lead 140g

acs550102
Livrare imediată!

21,00Lei

KORDA PLUMB MARKER 3.0OZ
Exclusiv online!

KORDA PLUMB MARKER 3.0OZ

ml3
Livrare 7-14 zile

37,45Lei

PLUMB KORDA MARKER 85g+113g
Exclusiv online!

PLUMB KORDA MARKER 85g+113g

ml2
Livrare 7-14 zile

33,88Lei

PLUMB KORDA MARKER 57G SI 85G
Exclusiv online!

PLUMB KORDA MARKER 57G SI 85G

ml1
Livrare 7-14 zile

37,45Lei

Plumb Pentru Sondat Trakker Marker Lead Pack, 2,3, 4oz, 3buc/plic

Plumb Pentru Sondat Trakker Marker Lead Pack, 2,3, 4oz, 3buc/plic

227870
Livrare imediată!

42,45Lei

Plumbi Fox Grappling Marker 113g

Plumbi Fox Grappling Marker 113g

cld230
Livrare imediată!

43,61Lei

Montura Plumb Pierdut KORDA Dark Matter Leader Hybrid Clip, Clay, 30lbs, 1m
Exclusiv online!

Montura Plumb Pierdut KORDA Dark Matter Leader Hybrid Clip, Clay, 30lbs, 1m

ksz37
Livrare 7-14 zile

39,95Lei

Montura Plumb Pierdut KORDA Dark Matter Leader Hybrid Clip, Gravel, 30lbs, 1m
Exclusiv online!

Montura Plumb Pierdut KORDA Dark Matter Leader Hybrid Clip, Gravel, 30lbs, 1m

ksz36
Livrare 7-14 zile

39,95Lei

Montura Plumb Pierdut KORDA Dark Matter Leader Hybrid Clip, Silt, 30lbs, 1m
Exclusiv online!

Montura Plumb Pierdut KORDA Dark Matter Leader Hybrid Clip, Silt, 30lbs, 1m

ksz38
Livrare 7-14 zile

39,95Lei

Montura Plumb Pierdut KORDA Dark Matter Leader Hybrid Clip, Clear, 40lbs, 1m
Exclusiv online!

Montura Plumb Pierdut KORDA Dark Matter Leader Hybrid Clip, Clear, 40lbs, 1m

ksz39
Livrare 7-14 zile

39,95Lei

Carp Expert Marker Plumb Marker

Carp Expert Marker Plumb Marker

79660199
Livrare imediată!

15,01Lei

Montura Plumb Pierdut KORDA Dark Matter Leader Hybrid Clip, Weedy Green, 30lbs, 1m
Exclusiv online!

Montura Plumb Pierdut KORDA Dark Matter Leader Hybrid Clip, Weedy Green, 30lbs, 1m

ksz35
Livrare 7-14 zile

37,13Lei

Afişare 1 - 20 din 37 (2 pagini)
Queries: 11, Total time: 2.048 ms [By time] [By id] [By file]
1 (0.113)
SELECT data
FROM `oc_session`
WHERE session_id = '7a8594b593fce7f1b0283aacc7'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.119)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.188)
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.206)
INSERT INTO oc_bf_tmp_product (product_id, sort_order, quantity, manufacturer_id, match_filters, actual_price, sort) VALUES ("30472", "2", "1000", "49", "1", "16.720000000000", "1"),("30473", "2", "1000", "49", "1", "17.730000000000", "2"),("30477", "2", "1002", "49", "1", "9.500000000000", "3"),("30478", "2", "1000", "49", "1", "10.590000000000", "4"),("30479", "2", "1000", "49", "1", "11.430000000000", "5"),("30481", "2", "1", "49", "1", "4.620000000000", "6"),("59880", "2", "1009", "27", "1", "7.480000000000", "7"),("59881", "10", "2", "27", "1", "6.390000000000", "8"),("102293", "2", "1010", "204", "1", "17.650000000000", "9"),("10040", "10", "1000", "73", "1", "31.470000000000", "10"),("143683", "2", "1000", "73", "1", "28.470000000000", "11"),("143681", "2", "1000", "73", "1", "31.470000000000", "12"),("210389", "1", "1004", "476", "1", "35.670000000000", "13"),("59528", "2", "1027", "168", "1", "36.650000000000", "14"),("242941", "1", "1000", "73", "1", "33.570000000000", "15"),("242940", "1", "1000", "73", "1", "33.570000000000", "16"),("242942", "1", "1000", "73", "1", "33.570000000000", "17"),("242943", "1", "1000", "73", "1", "33.570000000000", "18"),("59885", "2", "1006", "27", "1", "12.610000000000", "19"),("242939", "1", "1000", "73", "1", "31.200000000000", "20"),("243007", "2", "1000", "73", "1", "33.570000000000", "21"),("120031", "1", "1010", "73", "1", "27.140000000000", "22"),("120032", "1", "1008", "73", "1", "27.140000000000", "23"),("120030", "1", "1006", "73", "1", "38.860000000000", "24"),("120035", "1", "1006", "73", "1", "27.140000000000", "25"),("120034", "1", "1002", "73", "1", "26.890000000000", "26"),("120033", "1", "1000", "73", "1", "29.160000000000", "27"),("63516", "2", "4", "96", "1", "42.020000000000", "28"),("30496", "2", "0", "49", "1", "6.550000000000", "29"),("30475", "2", "0", "49", "1", "6.300000000000", "30"),("245838", "1", "0", "271", "1", "4.390000000000", "31"),("59526", "2", "0", "168", "1", "20.310000000000", "32"),("243008", "2", "0", "73", "1", "33.570000000000", "33"),("243004", "2", "0", "73", "1", "33.570000000000", "34"),("243009", "2", "0", "73", "1", "33.570000000000", "35"),("243006", "2", "0", "73", "1", "33.570000000000", "36"),("243005", "2", "0", "73", "1", "33.570000000000", "37")
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:846
5 (0.182)
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.230)
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.229)
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
8 (0.126)
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
9 (0.104)
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
10 (0.423)
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
11 (0.128)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '3' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:37