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


Pluta Trakko 11500, 4.00g

Pluta Trakko 11500, 4.00g

11500-4
Livrare imediată!

6,90Lei

Carlige Gamakatsu 3310f 25BUC/PLIC nr 5

Carlige Gamakatsu 3310f 25BUC/PLIC nr 5

146575-00500-00000
Livrare imediată!

20,62Lei

Mulineta Shimano Nasci C3000 HGFC 6.2:1, 0.25mm/210m, 6rul
Exclusiv online!

Mulineta Shimano Nasci C3000 HGFC 6.2:1, 0.25mm/210m, 6rul

sh.nasc3000hgfc
Livrare 24-48 ore

389,60Lei

Mulineta Shimano Nasci C3000 FC 4.7:1, 0.25mm/260m, 6rul
Exclusiv online!

Mulineta Shimano Nasci C3000 FC 4.7:1, 0.25mm/260m, 6rul

sh.nas4000fc
Livrare 24-48 ore

416,57Lei

Varga Spro Spartan Tele Fish 5m

Varga Spro Spartan Tele Fish 5m

002808-00500-00000
Livrare imediată!

55,91Lei

Varga C-TEC Governor 5m

Varga C-TEC Governor 5m

002371-00500-00000
Livrare imediată!

152,50Lei

Jig Spro Rotund HD Gamakatsu 23, Nr.5/0, 18g, 3buc/plic

Jig Spro Rotund HD Gamakatsu 23, Nr.5/0, 18g, 3buc/plic

004931-00500-00018
Livrare imediată!

18,79Lei

GEANTA SPRO BACK PACK +4 CUTII
Exclusiv online!

GEANTA SPRO BACK PACK +4 CUTII

006203-00500-00000
Livrare 48-72 ore

416,87Lei

ANCORA NR 8 GAMAKATSU LEGATA CU FIR TEXTIL 5CM 12KG

ANCORA NR 8 GAMAKATSU LEGATA CU FIR TEXTIL 5CM 12KG

004624-02500-00000
Livrare imediată!

14,52Lei

Mulineta DAM Madcat Dominion Spinning 10500, 0.56mm/395m, 4.2:1, 6+1rul
Exclusiv online!

Mulineta DAM Madcat Dominion Spinning 10500, 0.56mm/395m, 4.2:1, 6+1rul

mad.1610433
Livrare 24-48 ore

831,45Lei

GEANTA SPRO FREESTYLE CU 1 CUTIE TWISTERE 21X6X15 CM
Exclusiv online!

GEANTA SPRO FREESTYLE CU 1 CUTIE TWISTERE 21X6X15 CM

006205-00500-00000
Livrare 48-72 ore

96,58Lei

Mulineta SAVAGE GEAR Fazor C2000, 5.2:1, 0.16mm/150m
Exclusiv online!

Mulineta SAVAGE GEAR Fazor C2000, 5.2:1, 0.16mm/150m

1609515
Livrare 7-14 zile

683,27Lei

Mulineta SAVAGE GEAR Fazor C3000, 5.2:1, 0.23mm/150m
Exclusiv online!

Mulineta SAVAGE GEAR Fazor C3000, 5.2:1, 0.23mm/150m

1609516
Livrare 7-14 zile

763,61Lei

Sapca Nash Scope HD 5 Panel Hat, Marime Univ.

Sapca Nash Scope HD 5 Panel Hat, Marime Univ.

c0560
Stoc epuizat

112,84Lei

Mulineta Shimano Sahara C3000 FJ 4+1rul -30%

Mulineta Shimano Sahara C3000 FJ 4+1rul

shc3000fj
Stoc epuizat

455,00Lei(-30%) 319,26Lei

Kit 4 Mulinete Prowess Insedia C5004 FD -29%

Kit 4 Mulinete Prowess Insedia C5004 FD

95020036
Stoc epuizat

1.444,51Lei(-29%) 1.024,89Lei

Varga Mivardi Active Pole 5m, 5-25g -29%

Varga Mivardi Active Pole 5m, 5-25g

miv-ap500
Stoc epuizat

80,31Lei(-29%) 56,65Lei

Mulineta SHIMANO Nasci C3000 FC, 5.0:1, 0.25mm/210m, 5+1rul

Mulineta SHIMANO Nasci C3000 FC, 5.0:1, 0.25mm/210m, 5+1rul

nasc3000fc
Stoc epuizat

544,98Lei

Bluza de Corp NASH ZT Merino Stage 1 Top, Marime S

Bluza de Corp NASH ZT Merino Stage 1 Top, Marime S

c6300
Stoc epuizat

397,55Lei

Mulineta SHIMANO Aero XR C5000, 4.7:1, 0.30mm/240m, 5+1rul -39%

Mulineta SHIMANO Aero XR C5000, 4.7:1, 0.30mm/240m, 5+1rul

aeroxrc5000
Stoc epuizat

849,99Lei(-39%) 518,21Lei

Afişare 1 - 20 din 20 (1 pagini)
Queries: 13, Total time: 1.956 ms [By time] [By id] [By file]
1 (0.184)
SELECT data
FROM `oc_session`
WHERE session_id = '4173e168b022c7793ee04db168'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.099)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.186)
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 ("189259", "2", "19", "109", "1", "5.700000000000", "1"),("159", "2", "1007", "19", "1", "17.040000000000", "2"),("187037", "10", "1000", "16", "1", "321.980000000000", "3"),("187035", "10", "1000", "16", "1", "344.270000000000", "4"),("94406", "2", "1", "67", "1", "46.210000000000", "5"),("146071", "2", "1", "502", "1", "126.030000000000", "6"),("165435", "1", "1001", "67", "1", "15.530000000000", "7"),("41256", "2", "1000", "67", "1", "344.520000000000", "8"),("39585", "2", "1", "67", "1", "12.000000000000", "9"),("227096", "1", "1000", "124", "1", "687.150000000000", "10"),("59745", "2", "1000", "67", "1", "79.820000000000", "11"),("235852", "1", "1000", "85", "1", "564.690000000000", "12"),("235853", "1", "1000", "85", "1", "631.080000000000", "13"),("171131", "1", "0", "59", "1", "93.260000000000", "14"),("164599", "10", "0", "16", "1", "263.850000000000", "15"),("201229", "2", "0", "120", "1", "847.020000000000", "16"),("95856", "2", "0", "98", "1", "46.820000000000", "17"),("230651", "10", "0", "16", "1", "450.400000000000", "18"),("232246", "1", "0", "59", "1", "328.550000000000", "19"),("238615", "4", "0", "16", "1", "428.270000000000", "20")
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:846
5 (0.155)
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.193)
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.095)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"ROM-EUROTRADE SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
8 (0.074)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"ROM-EUROTRADE SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
9 (0.169)
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.067)
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.063)
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.420)
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.081)
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