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


Tronson Preston Superium Extension X 7/8 Ext (15/25)
Exclusiv online!

Tronson Preston Superium Extension X 7/8 Ext (15/25)

p4210052
Livrare 7-14 zile

314,96Lei

Tronson Preston Superium Extension X 5/6 Ext (15/25)
Exclusiv online!

Tronson Preston Superium Extension X 5/6 Ext (15/25)

p4210050
Livrare 7-14 zile

247,46Lei

Lanseta Spinning Daiwa Ninja EXT Spin 2.25m, 15-50g, 3seg
Exclusiv online!

Lanseta Spinning Daiwa Ninja EXT Spin 2.25m, 15-50g, 3seg

d.11206.221
Livrare 24-48 ore

285,70Lei

Lanseta Spinning Daiwa Ninja EXT Spin 2.45m, 15-50g, 3seg
Exclusiv online!

Lanseta Spinning Daiwa Ninja EXT Spin 2.45m, 15-50g, 3seg

d.11206.246
Livrare 24-48 ore

302,71Lei

PICHET TELESCOPIC FL CU BURGHIU SI CONECTOR RAPID MAGNETIC BLACK SPOT 50-80CM

PICHET TELESCOPIC FL CU BURGHIU SI CONECTOR RAPID MAGNETIC BLACK SPOT 50-80CM

642133
Livrare imediată!

46,90Lei

Mulineta Nevis Epic Feeder 5000, 5.5:1, 0.20mm/200m, 4rul
Exclusiv online!

Mulineta Nevis Epic Feeder 5000, 5.5:1, 0.20mm/200m, 4rul

2536-450
Livrare 48-72 ore

155,00Lei

Lanseta SENSAS Gunki Spot ED Rod H Fast Reg. 2.28m, 15-40g, 2seg
Exclusiv online!

Lanseta SENSAS Gunki Spot ED Rod H Fast Reg. 2.28m, 15-40g, 2seg

spm.67350
Livrare 24-48 ore

205,79Lei

Snag Bar Extra Carp EXC, Black

Snag Bar Extra Carp EXC, Black

56-9627
Livrare imediată!

19,67Lei

Lanseta Wizard MXT Spinning Rod, 50-100g, 2.70m, 2seg
Exclusiv online!

Lanseta Wizard MXT Spinning Rod, 50-100g, 2.70m, 2seg

13073270
Livrare 24-48 ore

288,79Lei

Lanseta Wizard MXT Spinning Rod, 50-100g, 2.10m, 2seg
Exclusiv online!

Lanseta Wizard MXT Spinning Rod, 50-100g, 2.10m, 2seg

13073210
Livrare 24-48 ore

247,62Lei

Lanseta Wizard MXT Spinning Rod, 50-100g, 2.40m, 2seg
Exclusiv online!

Lanseta Wizard MXT Spinning Rod, 50-100g, 2.40m, 2seg

13073240
Livrare 24-48 ore

268,26Lei

AMORTIZOR PAT BROWNING INFLEX2 25MM B725 525 BAR
Exclusiv online!

AMORTIZOR PAT BROWNING INFLEX2 25MM B725 525 BAR

br.bst81001aa
Livrare 24-48 ore

164,11Lei

GEANTA MIVARDI PENTRU ACCESORII PAT 40 x 25 cm

GEANTA MIVARDI PENTRU ACCESORII PAT 40 x 25 cm

m-epbch
Livrare imediată!

84,00Lei

Lanseta Okuma Epixor Spin 2.58m 15-40g 2buc -21%
Exclusiv online!

Lanseta Okuma Epixor Spin 2.58m 15-40g 2buc

epi-s-862m-1
Livrare 48-72ore

386,10Lei(-21%) 305,90Lei

MULINETA OKUMA EPIXOR XT FD 5500 -14%

MULINETA OKUMA EPIXOR XT FD 5500

epxt-55
Stoc epuizat

423,00Lei(-14%) 365,33Lei

Tronson Preston Superium Extension X 7/8 Ext (35/55/75/95/Carp)

Tronson Preston Superium Extension X 7/8 Ext (35/55/75/95/Carp)

p4210053
Stoc epuizat

404,96Lei

Tronson Preston Superium Extension X 5/6 Ext (35/55/75/95/Carp)

Tronson Preston Superium Extension X 5/6 Ext (35/55/75/95/Carp)

p4210051
Stoc epuizat

359,96Lei

Luneta Gp Optics Spotting Scope Tac Spotter 15-45-60 SAD/PLT

Luneta Gp Optics Spotting Scope Tac Spotter 15-45-60 SAD/PLT

gpo.ts100
Stoc epuizat

5.019,81Lei

VOBLER MUSTAD SCURRY MINNOW 55S 5,5CM/5G PEARL SPOT -40%

VOBLER MUSTAD SCURRY MINNOW 55S 5,5CM/5G PEARL SPOT

f3.mlsm55s.ps
Stoc epuizat

43,38Lei(-40%) 26,03Lei

AMORTIZOR BROWNING PAT INFLEX2 12MM B725/525/BAR/A5 -21%

AMORTIZOR BROWNING PAT INFLEX2 12MM B725/525/BAR/A5

br.bst81003aa
Stoc epuizat

165,37Lei(-21%) 131,26Lei

Afişare 1 - 20 din 24 (2 pagini)
Queries: 13, Total time: 1.523 ms [By time] [By id] [By file]
1 (0.077)
SELECT data
FROM `oc_session`
WHERE session_id = '1691bb2a154c26cfe6946a6573'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.105)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.080)
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.092)
INSERT INTO oc_bf_tmp_product (product_id, sort_order, quantity, manufacturer_id, match_filters, actual_price, sort) VALUES ("230967", "2", "1000", "360", "1", "264.670000000000", "1"),("230969", "2", "1000", "360", "1", "207.950000000000", "2"),("207963", "1", "1000", "11", "1", "240.080000000000", "3"),("207965", "1", "1000", "11", "1", "254.380000000000", "4"),("152325", "1", "1018", "13", "1", "39.410000000000", "5"),("183765", "1", "1000", "423", "1", "130.250000000000", "6"),("238018", "2", "1000", "62", "1", "172.930000000000", "7"),("228177", "2", "1009", "476", "1", "16.530000000000", "8"),("218999", "1", "1000", "401", "1", "242.680000000000", "9"),("219005", "1", "1000", "401", "1", "208.080000000000", "10"),("219002", "1", "1000", "401", "1", "225.430000000000", "11"),("70694", "10", "1000", "222", "1", "137.910000000000", "12"),("11405", "2", "1", "98", "1", "70.590000000000", "13"),("147391", "2", "1000", "17", "1", "257.060000000000", "14"),("83849", "2", "0", "17", "1", "307.000000000000", "15"),("230966", "2", "0", "360", "1", "340.300000000000", "16"),("230968", "2", "0", "360", "1", "302.490000000000", "17"),("224827", "1", "0", "770", "1", "4218.330000000000", "18"),("132269", "1", "0", "20", "1", "21.870000000000", "19"),("149807", "10", "0", "222", "1", "110.300000000000", "20"),("150701", "2", "0", "58", "1", "170.000000000000", "21"),("222561", "1", "0", "96", "1", "11.430000000000", "22"),("222562", "1", "0", "96", "1", "11.430000000000", "23"),("222560", "1", "0", "96", "1", "11.430000000000", "24")
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:846
5 (0.077)
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.174)
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.097)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"RAPALA VMC ROMANIA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
8 (0.072)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"RAPALA VMC ROMANIA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
9 (0.153)
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.066)
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.060)
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.400)
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.070)
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