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 300 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


LANSETA SPRO POWER CATCHER 2.40MT 30GR

LANSETA SPRO POWER CATCHER 2.40MT 30GR

002094-00241-00000
Livrare imediată!

177,00Lei

Lanseta Salmo Hornet Pro Medium 2.40m 10-40g 2seg -14%
Exclusiv online!

Lanseta Salmo Hornet Pro Medium 2.40m 10-40g 2seg

qrd002
Livrare 7-14 zile

584,96Lei(-14%) 502,75Lei

LANSETA, SPINNING, DAIWA, 2SEG, NINJA, X, SPIN, 2.40M, 15-50G, d.11205.245, Lansete Rapitori, Lansete Rapitori Daiwa, Daiwa -12%

LANSETA, SPINNING, DAIWA, 2SEG, NINJA, X, SPIN, 2.40M, 15-50G, d.11205.245, Lansete Rapitori, Lansete Rapitori Daiwa, Daiwa

d.11205.245
Livrare imediată!

238,25Lei(-12%) 208,79Lei

Lanseta spinning EnergoTeam BOKOR PRO SPIN 2.40m 10-30/15-40g 1Seg Plus 2 tronsoane

Lanseta spinning EnergoTeam BOKOR PRO SPIN 2.40m 10-30/15-40g 1Seg Plus 2 tronsoane

13175240
Livrare imediată!

286,00Lei

Lanseta, Daiwa, Caldia, Jiggerspin, 2.40M, 7-28g, 2SEG, d.11481.240, Lansete Rapitori, Lansete Rapitori Daiwa, Daiwa -40%
Exclusiv online!

Lanseta, Daiwa, Caldia, Jiggerspin, 2.40M, 7-28g, 2SEG, d.11481.240, Lansete Rapitori, Lansete Rapitori Daiwa, Daiwa

d.11481.240
Livrare 24-48 ore

566,04Lei(-40%) 339,63Lei

Lanseta Cormoran Cross Water Power Jig 2.40M 8-35g 2SEG -20%

Lanseta Cormoran Cross Water Power Jig 2.40M 8-35g 2SEG

c.27.4035240
Livrare imediată!

219,94Lei(-20%) 175,94Lei

Lanseta Delphin Gamer 2.40m 35g 2seg -35%

Lanseta Delphin Gamer 2.40m 35g 2seg

110388240
Livrare imediată!

177,00Lei(-35%) 115,00Lei

Lanseta, Fox, Rage, Prism, X, Travel, Med, Spin, 2.40m, 15-35g, 4seg, nrd336, Lansete Rapitori, Lansete Rapitori Fox Rage, Fox Rage -14%
Exclusiv online!

Lanseta, Fox, Rage, Prism, X, Travel, Med, Spin, 2.40m, 15-35g, 4seg, nrd336, Lansete Rapitori, Lansete Rapitori Fox Rage, Fox Rage

nrd336
Livrare 7-14 zile

593,96Lei(-14%) 510,47Lei

Lanseta DAM Madcat New Black Heavy Duty 2.40m 200-300gr
Exclusiv online!

Lanseta DAM Madcat New Black Heavy Duty 2.40m 200-300gr

mad.70694
Livrare 24-48 ore

298,84Lei

Lanseta Cormoran Cross Water Spinning 2.40M 15-40g 2SEG -30%
Exclusiv online!

Lanseta Cormoran Cross Water Spinning 2.40M 15-40g 2SEG

c.27.4040240
Livrare 24-48 ore

243,56Lei(-30%) 170,49Lei

Lanseta, Daiwa, Ninja, X, Spin, 2.40M, 10-30g, 2SEG, d.11205.242, Lansete Rapitori, Lansete Rapitori Daiwa, Daiwa -20%

Lanseta, Daiwa, Ninja, X, Spin, 2.40M, 10-30g, 2SEG, d.11205.242, Lansete Rapitori, Lansete Rapitori Daiwa, Daiwa

d.11205.242
Livrare imediată!

227,89Lei(-20%) 182,31Lei

Lanseta Daiwa Ninja X 2.40m 30-70g 2SEG -20%

Lanseta Daiwa Ninja X 2.40m 30-70g 2SEG

d.11205.246
Livrare imediată!

265,77Lei(-20%) 212,62Lei

Lanseta DAM Shadow Tele 2.40m 25-40g

Lanseta DAM Shadow Tele 2.40m 25-40g

2040970350
Livrare imediată!

238,46Lei

Lanseta Telescopica DAM New Shadow Mini Spin 2.40m 7-30g 9seg
Exclusiv online!

Lanseta Telescopica DAM New Shadow Mini Spin 2.40m 7-30g 9seg

dam.70794
Livrare 24-48 ore

281,22Lei

Lanseta Spro Freestyle Litz Spin 2.40m 14g 2seg
Exclusiv online!

Lanseta Spro Freestyle Litz Spin 2.40m 14g 2seg

002109-00243-00000
Livrare 48-72 ore

263,39Lei

Lanseta, Spro, Freestyle, Litz, Spin, 2.40m, 10g, 2seg, 002109-00241-00000, Lansete Rapitori, Lansete Rapitori Spro, Spro
Exclusiv online!

Lanseta, Spro, Freestyle, Litz, Spin, 2.40m, 10g, 2seg, 002109-00241-00000, Lansete Rapitori, Lansete Rapitori Spro, Spro

002109-00241-00000
Livrare 48-72 ore

263,39Lei

LANSETA CORMORAN 2 SEG .RAYCOR X 2.40M/10-35G -30%

LANSETA CORMORAN 2 SEG .RAYCOR X 2.40M/10-35G

c.27.8003524
Livrare imediată!

214,03Lei(-30%) 149,82Lei

Lanseta, Spro, Freestyle, Litz, Spin, 2.40m, 21g, 2seg, 002109-00244-00000, Lansete Rapitori, Lansete Rapitori Spro, Spro -38%
Exclusiv online!

Lanseta, Spro, Freestyle, Litz, Spin, 2.40m, 21g, 2seg, 002109-00244-00000, Lansete Rapitori, Lansete Rapitori Spro, Spro

002109-00244-00000
Livrare 48-72 ore

263,39Lei(-38%) 164,01Lei

Lanseta Cormoran Power Creek Spin 2.40m 20-60g -10%
Exclusiv online!

Lanseta Cormoran Power Creek Spin 2.40m 20-60g

c.27.8560240
Livrare 24-48 ore

188,48Lei(-10%) 169,63Lei

Minciog FOX Horizon X6 42" Carbon Landing Net (Camo Mesh), 2 Tronsoane, 2.40m -25%
Exclusiv online!

Minciog FOX Horizon X6 42" Carbon Landing Net (Camo Mesh), 2 Tronsoane, 2.40m

cln056
Livrare 7-14 zile

1.403,95Lei(-25%) 1.052,96Lei

Afişare 1 - 20 din 579 (29 pagini)
Queries: 11, Total time: 861.377 ms [By time] [By id] [By file]
1 (0.163)
SELECT data
FROM `oc_session`
WHERE session_id = '8ffa43b7d8a06047080c3e9e1a'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.138)
SELECT *
FROM oc_platforma_promovari LIMIT 1
/var/www/clients/client1/web1/web/index.php:128
3 (0.078)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:422
4 (474.508)
SELECT COUNT(1) AS total
FROM ( SELECT p.product_id, p.sort_order, p.quantity, p.manufacturer_id, "1" AS match_filters
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)
WHERE p2s.store_id = '3' AND (pd.tag LIKE "%2.40m%") AND p.status_filtru > 0 AND p.price > 0 GROUP BY p.product_id HAVING match_filters = 1) AS t
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1555
5 (369.440)
SELECT p.product_id, p.sort_order, p.quantity, p.manufacturer_id, "1" AS match_filters, pp.sort_order, pp.viewed, IF ((pp.quantity) > 0, 1, 0) AS array_quantity
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)
INNER JOIN `oc_product` AS pp ON (pp.product_id = p.product_id)
WHERE p2s.store_id = '3' AND (pd.tag LIKE "%2.40m%") AND p.status_filtru > 0 AND p.price > 0 AND pd.language_id = '2' GROUP BY p.product_id HAVING match_filters = 1
ORDER BY array_quantity DESC, pp.sort_order ASC, pp.viewed DESC, pd.name ASC LIMIT 0, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
6 (16.461)
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_product` AS p ON (m.manufacturer_id = p.manufacturer_id)
INNER JOIN `oc_manufacturer_to_store` AS m2s ON (m.manufacturer_id = m2s.manufacturer_id)
INNER JOIN `oc_product_to_category` AS p2c ON (p.product_id = p2c.product_id)
WHERE p.status = 1 AND m2s.store_id = '3' AND p2c.category_id = '226'
ORDER BY m.sort_order, m.name
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:1210
7 (0.133)
SELECT MIN(actual_price) AS min, MAX(actual_price) AS max
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_to_category` AS p2c ON (p.product_id = p2c.product_id)
INNER JOIN `oc_product_description` AS pd ON (pd.product_id = p.product_id)
WHERE p2s.store_id = '3' AND p2c.category_id = '226' AND (pd.tag LIKE "%2.40m%") AND p.status_filtru > 0 AND p.price > 0 HAVING match_filters = 1
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:1066
8 (0.125)
SELECT COUNT(*) AS val, filter_group, filter_id
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_to_category` AS p2c ON (p.product_id = p2c.product_id)
INNER JOIN `oc_product_description` AS pd ON (pd.product_id = p.product_id)
WHERE p2s.store_id = '3' AND p2c.category_id = '226' AND (pd.tag LIKE "%2.40m%") AND p.status_filtru > 0 AND p.price > 0 AND f.language_id = '2' GROUP BY p.product_id, filter_group, filter_id HAVING match_filters = 1
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:911
9 (0.121)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
10 (0.097)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
11 (0.113)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '3' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38