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 - vu.2.5878

Produse ce potrivesc criteriilor de căutare


Lanseta Daiwa Exceler Spin 2.10M 2-10g 2SEG

Lanseta Daiwa Exceler Spin 2.10M 2-10g 2SEG

d.11663.215
Stoc epuizat

305,34Lei

Mulineta Favorite Arena C2500 S -15%

Mulineta Favorite Arena C2500 S

16935071
Stoc epuizat

560,00Lei(-15%) 476,00Lei

Fir Textil Berkley Whiplash 8 Green 150m 0.25mm/39.7kg

Fir Textil Berkley Whiplash 8 Green 150m 0.25mm/39.7kg

p.1446655
Stoc epuizat

124,49Lei

Fir Textil BERKLEY X5 FLURO VERDE 0.08MM/7.6KG/150M

Fir Textil BERKLEY X5 FLURO VERDE 0.08MM/7.6KG/150M

p.1486744
Stoc epuizat

88,61Lei

Fir textil Climax TOUCH 8+ CHARTREUSE FLUO 135m 0.28mm 26.8kg -30%

Fir textil Climax TOUCH 8+ CHARTREUSE FLUO 135m 0.28mm 26.8kg

9363-10135-028
Stoc epuizat

83,00Lei(-30%) 58,00Lei

FIR BERKLEY TEXTIL X9 LOW VIS VERDE 0.14MM 150M

FIR BERKLEY TEXTIL X9 LOW VIS VERDE 0.14MM 150M

p.1486813
Stoc epuizat

149,49Lei

Fir Textil Delphin HERO Verde, 0.25mm, 16.80kg, 300m

Fir Textil Delphin HERO Verde, 0.25mm, 16.80kg, 300m

500793660
Stoc epuizat

67,00Lei

Lanseta FL Aqua Tele Spin 3.3M 15-45g

Lanseta FL Aqua Tele Spin 3.3M 15-45g

2255194979238
Stoc epuizat

138,00Lei

Lanseta Daiwa Trout Area Team Commander 1.95m 0.5-5g 2seg

Lanseta Daiwa Trout Area Team Commander 1.95m 0.5-5g 2seg

d.11716.195
Stoc epuizat

520,46Lei

LANSETA SPINNING CORMORAN RAYCOR X 2.40M 40-100G 2SEG -30%

LANSETA SPINNING CORMORAN RAYCOR X 2.40M 40-100G 2SEG

c.27.8010024
Stoc epuizat

314,53Lei(-30%) 220,17Lei

MULINETA DAIWA LEGALIS LT 1000 5RUL

MULINETA DAIWA LEGALIS LT 1000 5RUL

d.10425.100
Stoc epuizat

444,75Lei

FIR TEXTIL KAMASAKI SUPER BRAID 100M 0.35MM

FIR TEXTIL KAMASAKI SUPER BRAID 100M 0.35MM

30905035
Stoc epuizat

33,61Lei

FIR TEXTIL JAXON HEGEMON 8X FLUO 150m 0.18mm 19kg Galben Fluo

FIR TEXTIL JAXON HEGEMON 8X FLUO 150m 0.18mm 19kg Galben Fluo

zj-def018a
Stoc epuizat

145,00Lei

Lanseta Baracuda Cyclone Spin 2.10m 15-50g 2seg

Lanseta Baracuda Cyclone Spin 2.10m 15-50g 2seg

cyclone spin 2102
Stoc epuizat

132,13Lei

FIR TEXTIL JAXON HEGEMON SUPRA 12X 125m 0.12mm 11kg Dark Olive

FIR TEXTIL JAXON HEGEMON SUPRA 12X 125m 0.12mm 11kg Dark Olive

zj-dsp012a
Stoc epuizat

218,00Lei

Lanseta Sportex CURVE SPIN 210 20gr -25%

Lanseta Sportex CURVE SPIN 210 20gr

ps2101
Stoc epuizat

688,00Lei(-25%) 516,00Lei

Lanseta Baracuda fibra sticla 2seg 2.10m 500g

Lanseta Baracuda fibra sticla 2seg 2.10m 500g

fibra plina 2102
Stoc epuizat

46,90Lei

FIR TEXTIL SUMATO FLUO 125m 0.12mm

FIR TEXTIL SUMATO FLUO 125m 0.12mm

zj-raf012g
Stoc epuizat

76,01Lei

MULINETA LINEAEFFE BASS EVOLUTION FD 2000

MULINETA LINEAEFFE BASS EVOLUTION FD 2000

l.1224620
Stoc epuizat

136,46Lei

Lanseta Cormoran Cross Water UL Spin 1.80M 1-7g 2SEG -20%

Lanseta Cormoran Cross Water UL Spin 1.80M 1-7g 2SEG

c.27.4007180
Stoc epuizat

216,33Lei(-20%) 173,06Lei

Afişare 7121 - 7140 din 7790 (390 pagini)
Queries: 8, Total time: 229.344 ms [By time] [By id] [By file]
1 (0.093)
SELECT data
FROM `oc_session`
WHERE session_id = '35c8b45d6f3dda3107148a19fe'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.094)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (0.114)
SELECT *
FROM oc_url_alias
WHERE keyword = 'search'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (199.846)
CREATE TEMPORARY TABLE oc_bf_tmp_product (PRIMARY KEY (`product_id`), INDEX my_index (match_filters, sort_order, manufacturer_id)) ENGINE=MEMORY SELECT p.product_id, p.sort_order, p.quantity, p.manufacturer_id, "1" AS match_filters, (IF(MIN(ps.price) IS NOT NULL, MIN(ps.price), p.price) * (1 + IFNULL(percent_tax, 0)/100) + IFNULL(fixed_tax, 0)) AS actual_price
FROM `oc_product` AS p
INNER JOIN `oc_product_to_store` AS p2s ON (p2s.product_id = p.product_id)
INNER JOIN `oc_bf_filter` AS f ON (p.product_id = f.product_id)
INNER JOIN `oc_product_description` AS pd ON (pd.product_id = p.product_id)
LEFT JOIN `oc_product_special` AS ps ON (ps.product_id = p.product_id AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()) AND (ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND ps.customer_group_id = '1')
LEFT JOIN ( SELECT SUM(fixed_rate) AS fixed_tax, SUM(percent_rate) AS percent_tax, tax_class_id
FROM `oc_bf_tax_rate`) AS tx ON (p.tax_class_id = tx.tax_class_id)
WHERE p2s.store_id = '2' AND (MATCH(pd.tag) AGAINST('+rapitori' IN BOOLEAN MODE)) AND p.status_filtru > 0 AND p.price > 0 GROUP BY p.product_id
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:737
5 (28.754)
SELECT p.*, pp.sort_order, pp.viewed, IF ((pp.quantity) > 0, 1, 0) AS array_quantity
FROM `oc_bf_tmp_product` AS p
INNER JOIN `oc_product_description` AS pd ON (pd.product_id = p.product_id)
INNER JOIN `oc_product` AS pp ON (pp.product_id = p.product_id)
WHERE match_filters = 1 AND pd.language_id = '2'
ORDER BY array_quantity DESC, pp.sort_order ASC, pp.viewed DESC, pd.name ASC LIMIT 7120, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
6 (0.182)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"EDCRIS COM SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
7 (0.139)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"EDCRIS COM SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
8 (0.122)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '2' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38