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


MULINETA MAVER LASER 2000 10+1RUL
Exclusiv online!

MULINETA MAVER LASER 2000 10+1RUL

809mla20
Livrare 48-72 ore

339,99Lei

MULINETA MAVER LASER 4000 10+1RUL
Exclusiv online!

MULINETA MAVER LASER 4000 10+1RUL

809mla40
Livrare 48-72 ore

375,00Lei

Mulineta FOX EOS 12000 FS, 4.2:1, 0.34mm/375m, 10+1rul -12%
Exclusiv online!

Mulineta FOX EOS 12000 FS, 4.2:1, 0.34mm/375m, 10+1rul

crl075
Livrare 7-14 zile

854,96Lei(-12%) 749,90Lei

Multiplicator Daiwa Saltiga 2015 15 HL SJ 500m, 6.4:1, 8+1rul
Exclusiv online!

Multiplicator Daiwa Saltiga 2015 15 HL SJ 500m, 6.4:1, 8+1rul

d.saltiga1515hlsj
Livrare 24-48 ore

2.273,46Lei

Mulineta Team Feeder By Dome Gold Serie 4000 10+1rul
Exclusiv online!

Mulineta Team Feeder By Dome Gold Serie 4000 10+1rul

2522-114
Livrare 48-72 ore

563,00Lei

Mulineta MIKADO Catone 8011 Fd 8000, 4.5:1, 0.40mm/440m, 10+1rul
Exclusiv online!

Mulineta MIKADO Catone 8011 Fd 8000, 4.5:1, 0.40mm/440m, 10+1rul

kda171-8011
Livrare 48-72 ore

355,00Lei

Combo Spinning DAM Fun Tech MK1 Spin, Lanseta 2.40m/15-40g + Mulineta 4000/2+1rul

Combo Spinning DAM Fun Tech MK1 Spin, Lanseta 2.40m/15-40g + Mulineta 4000/2+1rul

dam.80898
Livrare imediată!

321,01Lei

MULINETA MAVER LASER 6000 10+1RUL
Exclusiv online!

MULINETA MAVER LASER 6000 10+1RUL

809mla60
Livrare 48-72 ore

405,00Lei

Mulineta DAIWA Saltiga 2022 15 HL SJ 7.1:1, 3mm/400m, 8+1rul
Exclusiv online!

Mulineta DAIWA Saltiga 2022 15 HL SJ 7.1:1, 3mm/400m, 8+1rul

d.saltiga2215hl
Livrare 24-48 ore

3.044,19Lei

Mulineta ABU GARCIA Zenon MG-X Spinning Reel SP2500MS, 6.2:1, 0.20mm/180m, 10+1rul

Mulineta ABU GARCIA Zenon MG-X Spinning Reel SP2500MS, 6.2:1, 0.20mm/180m, 10+1rul

1591766
Livrare imediată!

1.559,99Lei

Mulineta NGT Dynamic 4000 Deluxe Feeder Runner cu Baitrunner 10 Rulm

Mulineta NGT Dynamic 4000 Deluxe Feeder Runner cu Baitrunner 10 Rulm

ngt-frl-dyb-4000
Livrare imediată!

130,00Lei

Mulineta DAIWA Basia Surf 19 45 SCW QD R 4500, 4.9:1, 0.18mm/300m, 7+1rul
Exclusiv online!

Mulineta DAIWA Basia Surf 19 45 SCW QD R 4500, 4.9:1, 0.18mm/300m, 7+1rul

d.basias1945scwqdr
Livrare 24-48 ore

2.558,73Lei

Mulineta TRABUCCO Brave FB 4000, 5.2:1, 0.20mm/265m, 6+1rul
Exclusiv online!

Mulineta TRABUCCO Brave FB 4000, 5.2:1, 0.20mm/265m, 6+1rul

034-19-040
Livrare 48-72 ore

360,00Lei

Mulineta TRABUCCO Brave FB 3000, 5.2:1, 0.20mm/180m, 6+1rul
Exclusiv online!

Mulineta TRABUCCO Brave FB 3000, 5.2:1, 0.20mm/180m, 6+1rul

034-19-030
Livrare 48-72 ore

339,99Lei

Mulineta SHIMANO Calcutta Conquest BFS XG-LEFT 7.8:1, 6lb/45m, 13+1rul

Mulineta SHIMANO Calcutta Conquest BFS XG-LEFT 7.8:1, 6lb/45m, 13+1rul

23calcutabfs
Stoc epuizat

2.100,00Lei

Mulineta RAPTURE LMF Fly Reel ADR 70mm, 2+1rul

Mulineta RAPTURE LMF Fly Reel ADR 70mm, 2+1rul

032-92-130
Stoc epuizat

170,00Lei

Mulineta Casting Lucky John Multiplier Reel Black Sense Ultimax 10, 159g, 9+1rul
Combo Spinning DAM Fun Tech MK1 Spin, Lanseta 2.10m/10-30g + Mulineta 3000/2+1rul
Mulineta ABU GARCIA Zenon MG-X Spinning Reel SP3000MS, 6.2:1, 0.25mm/130m, 10+1rul -23%

Mulineta ABU GARCIA Zenon MG-X Spinning Reel SP3000MS, 6.2:1, 0.25mm/130m, 10+1rul

1591767
Stoc epuizat

1.559,99Lei(-23%) 1.197,57Lei

MULTIPLICATOR DAIWA TATULA ELITE 19 100XSL 8RUL/135MX032/8,1:1 -23%

MULTIPLICATOR DAIWA TATULA ELITE 19 100XSL 8RUL/135MX032/8,1:1

d.tate19100xsl
Stoc epuizat

1.401,59Lei(-23%) 1.078,15Lei

Afişare 1 - 20 din 22 (2 pagini)
Queries: 13, Total time: 2.067 ms [By time] [By id] [By file]
1 (0.111)
SELECT data
FROM `oc_session`
WHERE session_id = '86300df79a7eb6d8200ff7a1ea'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.123)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.164)
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.146)
INSERT INTO oc_bf_tmp_product (product_id, sort_order, quantity, manufacturer_id, match_filters, actual_price, sort) VALUES ("159981", "2", "1000", "49", "1", "285.710000000000", "1"),("159983", "2", "1000", "49", "1", "315.130000000000", "2"),("82700", "2", "998", "168", "1", "630.170000000000", "3"),("172319", "2", "1000", "11", "1", "1910.470000000000", "4"),("149241", "2", "1000", "484", "1", "473.110000000000", "5"),("235128", "1", "1000", "224", "1", "298.320000000000", "6"),("206645", "1", "1001", "124", "1", "269.760000000000", "7"),("159985", "2", "1000", "49", "1", "340.340000000000", "8"),("244153", "2", "1000", "11", "1", "2558.140000000000", "9"),("231696", "1", "2", "122", "1", "1310.920000000000", "10"),("95723", "2", "4", "287", "1", "109.240000000000", "11"),("244033", "2", "1000", "11", "1", "2150.190000000000", "12"),("236543", "1", "1000", "58", "1", "302.520000000000", "13"),("236533", "1", "1000", "58", "1", "285.710000000000", "14"),("230650", "1", "0", "16", "1", "1764.710000000000", "15"),("220104", "1", "0", "105", "1", "142.860000000000", "16"),("173747", "2", "0", "193", "1", "418.490000000000", "17"),("206643", "1", "0", "124", "1", "260.320000000000", "18"),("231697", "1", "0", "122", "1", "1006.360000000000", "19"),("145951", "1", "0", "11", "1", "906.010000000000", "20"),("193121", "1", "0", "656", "1", "467.640000000000", "21"),("236545", "1", "0", "58", "1", "310.920000000000", "22")
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:846
5 (0.187)
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.255)
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.107)
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
8 (0.080)
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.180)
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.070)
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.066)
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.476)
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.102)
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