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


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

321,26Lei

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

252,62Lei

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,79Lei

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,81Lei

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ă!

48,69Lei

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

158,61Lei

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

215,59Lei

Snag Bar Extra Carp EXC, Black

Snag Bar Extra Carp EXC, Black

56-9627
Livrare imediată!

21,01Lei

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

294,64Lei

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

273,77Lei

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

252,78Lei

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

AMORTIZOR PAT BROWNING INFLEX2 25MM B725 525 BAR

br.bst81001aa
Livrare 24-48 ore

184,05Lei

GEANTA MIVARDI PENTRU ACCESORII PAT 40 x 25 cm

GEANTA MIVARDI PENTRU ACCESORII PAT 40 x 25 cm

m-epbch
Livrare imediată!

86,41Lei

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

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

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

386,10Lei(-19%) 312,03Lei

AMORTIZOR BROWNING PAT INFLEX2 12MM B725/525/BAR/A5
Exclusiv online!

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

br.bst81003aa
Livrare 24-48 ore

184,05Lei

MULINETA OKUMA EPIXOR XT FD 5500 -14%

MULINETA OKUMA EPIXOR XT FD 5500

epxt-55
Stoc epuizat

431,11Lei(-14%) 371,47Lei

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

412,77Lei

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

367,01Lei

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

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

f3.mlsm55s.ps
Stoc epuizat

43,37Lei(-37%) 27,45Lei

Montura Extra Carp Boilie Rig EXC 555, Nr 2, 11.34kg, 20cm, 2 Buc/Plic

Montura Extra Carp Boilie Rig EXC 555, Nr 2, 11.34kg, 20cm, 2 Buc/Plic

40-6327
Stoc epuizat

14,83Lei

Afişare 1 - 20 din 22 (2 pagini)
Queries: 12, Total time: 2.254 ms [By time] [By id] [By file]
1 (0.116)
SELECT data
FROM `oc_session`
WHERE session_id = '721a68d27f34f8c36f4e4342a7'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.093)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.147)
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.160)
INSERT INTO oc_bf_tmp_product (product_id, sort_order, quantity, manufacturer_id, match_filters, actual_price, sort) VALUES ("230967", "2", "1000", "360", "1", "265.500000000000", "1"),("230969", "2", "1000", "360", "1", "208.780000000000", "2"),("207963", "1", "1000", "11", "1", "236.190000000000", "3"),("207965", "1", "1000", "11", "1", "250.260000000000", "4"),("152325", "1", "1017", "13", "1", "40.240000000000", "5"),("183765", "1", "1000", "423", "1", "131.080000000000", "6"),("238018", "2", "1000", "62", "1", "178.170000000000", "7"),("228177", "2", "1014", "476", "1", "17.360000000000", "8"),("218999", "1", "1000", "401", "1", "243.500000000000", "9"),("219002", "1", "1000", "401", "1", "226.260000000000", "10"),("219005", "1", "1000", "401", "1", "208.910000000000", "11"),("70694", "10", "1000", "222", "1", "152.110000000000", "12"),("11405", "2", "1", "98", "1", "71.410000000000", "13"),("147391", "2", "1000", "17", "1", "257.880000000000", "14"),("149807", "10", "1000", "222", "1", "152.110000000000", "15"),("83849", "2", "0", "17", "1", "307.000000000000", "16"),("230966", "2", "0", "360", "1", "341.130000000000", "17"),("230968", "2", "0", "360", "1", "303.310000000000", "18"),("132269", "1", "0", "20", "1", "22.690000000000", "19"),("222560", "1", "0", "96", "1", "12.260000000000", "20"),("222561", "1", "0", "96", "1", "12.260000000000", "21"),("222562", "1", "0", "96", "1", "12.260000000000", "22")
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:846
5 (0.109)
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.254)
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.145)
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.258)
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
9 (0.110)
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
10 (0.095)
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
11 (0.643)
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
12 (0.124)
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