Gama variata de produse

La Claumar Pescar poti alege simplu si rapid dintr-o gama variata de articole de pescuit.

Transport Gratuit

Comenzile peste 300 lei pot beneficia de transport gratuit.

Vezi mai multe detalii

Plata cu cardul

Plata cu cardul in rate fara dobanda.

Vezi mai multe detalii

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 simplu in 14 zile

Retur simplu in 14 zile.

Vezi mai multe detalii

Căutare - Lansete Savage

Filtreaza

Produse ce potrivesc criteriilor de căutare

Sortare după:

Exclusiv online!

Lanseta Spro CRX Lure And Spin UL 2.10m 5-20g 2seg

002411-00212-00000

Livrare 48-72 ore

326,00Lei

LANSETA FOX RAGE STREET FIGHTER LIGHT SHAD ROD 220CM 5-20GR

nrd361

Livrare imediată!

404,96Lei

Lanseta Daiwa Ninja X Spin, 2.10m, 5-20g, 2buc

d.11205.211

Livrare imediată!

230,19Lei

Exclusiv online!

Lanseta 13 Fishing Defy Black Spin Gen II 2.13m/5-20g

db2c67mh

Livrare 48-72ore

279,00Lei

Exclusiv online!

Lanseta OKUMA Wave Power Spin 6'0" 183cm 5-20g M 2sec

wp-s-602m

Livrare 48-72ore

134,10Lei

Exclusiv online!

Lanseta Okuma Roadster UFR Spin 2.44m 5-20g 2sec

rst-s-802l

Livrare 48-72ore

224,10Lei

-31%

Lanseta Abu Garcia Mass Beat II Spin 2.24m 5-20g

1445953

Livrare imediată!

749,50Lei(-31%) 520,90Lei

Exclusiv online!

LANSETA FOX RAGE STREET FIGHTER VERSATILE SHAD CASTING 2.10M 5-20G 2SEG

nrd373

Livrare 7-14 zile

404,96Lei

Exclusiv online!

LANSETA FOX RAGE STREET FIGHTER LIGHT SHAD TRAVEL 2.20M 5-20G 4SEG

nrd375

Livrare 7-14 zile

449,96Lei

Exclusiv online!

LANSETA OKUMA HEXANA II SPIN 2.40M 5-20G 2SEG

hxii-s-802l

Livrare 48-72ore

269,09Lei

Exclusiv online!

Combo Abu Garcia Fast Attack Trout Spinning Combo L, 5-20g, 2.10m, 2seg

1561758

Livrare 7-14 zile

449,96Lei

Exclusiv online!

Combo Abu Garcia Max X Red Spinning 602ML, 5-20g, 1.83m, 2seg

1531490

Livrare 7-14 zile

427,46Lei

Exclusiv online!

Combo Spinning Abu Garcia Pro Max Spinning ML, 5-20g, 1.83m, 2seg

1531503

Livrare 7-14 zile

449,96Lei

Exclusiv online!

Lanseta Spinning DAM Steelhead Iconic Spin 2.10m, 5-20g, 2seg

dam.75519

Livrare 24-48 ore

140,65Lei

Exclusiv online!

Combo Abu Garcia Fast Attack Spoon Spinning Combo ML, 5-20g, 2.10m, 2seg

1561757

Livrare 7-14 zile

449,96Lei

Exclusiv online!

Lanseta, Abu, Garcia, Vendetta, V3, Spinning, Rod, 702ML,, 5-20g,, 2.13m,, 2seg, 1544425, Lansete Rapitori, Lansete Rapitori Abu Garcia, Lansete Abu Garcia, Rapitori Abu Garcia, Abu Garcia

1544425

Livrare 7-14 zile

359,96Lei

Exclusiv online!

Lanseta Abu Garcia Vendetta V3 Spinning Rod 804ML, 5-20g, 2.44m, 4seg

1544443

Livrare 7-14 zile

427,46Lei

Exclusiv online!

Lanseta Bolognesa Nevis River Power, 5-20g, 6.00m, 6seg

1779-601

Livrare 48-72 ore

288,00Lei

Lanseta, Spinning, Daiwa, Sweepfire, Telescopica, 2.10m,, 5-20g,, 6seg, d.11421.210, Lansete Rapitori, Lansete Rapitori Daiwa, Daiwa

d.11421.210

Livrare imediată!

175,35Lei

Exclusiv online!

Combo Spinning Abu Garcia Max STX Spinning ML, 5-20g, 2.13m, 2seg

1530862

Livrare 7-14 zile

539,96Lei

Afişare 1 - 20 din 168 (9 pagini)

Queries: 14, Total time: 1,468.529 ms [By time] [By id] [By file]

1 (0.135)

SELECT data
FROM `oc_session`
WHERE session_id = '7a476d8145d97fc13f0ecd2965'

/var/www/clients/client1/web1/web/system/library/session/db.php:23

2 (0.080)

SELECT *
FROM oc_platforma_promovari LIMIT 1

/var/www/clients/client1/web1/web/index.php:128

3 (0.112)

SELECT `trigger`, `action`
FROM oc_event

/var/www/clients/client1/web1/web/index.php:422

4 (639.070)

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 = '0' AND (pd.tag LIKE "%5-20g%") 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 (386.155)

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 = '0' AND (pd.tag LIKE "%5-20g%") 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 (0.153)

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

7 (0.125)

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.123)

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.124)

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

10 (0.190)

SELECT MIN(actual_price) AS min, MAX(actual_price) AS max
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 = '0' AND (pd.tag LIKE "%5-20g%") AND p.status_filtru > 0 AND p.price > 0 GROUP BY p.product_id HAVING match_filters = 1) AS p

/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:1014

11 (441.876)

SELECT COUNT(*) AS val, filter_group, filter_id
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 = '0' AND (pd.tag LIKE "%5-20g%") AND p.status_filtru > 0 AND p.price > 0 GROUP BY p.product_id HAVING match_filters = 1) AS p
INNER JOIN `oc_bf_filter` AS f ON (p.product_id = f.product_id)
WHERE f.language_id = '2' AND f.filter_group NOT LIKE 'a%' GROUP BY filter_group, filter_id

/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:923

12 (0.138)

SELECT *
FROM oc_platforma_promovari

/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4

13 (0.118)

SELECT *
FROM oc_platforma_promovari

/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4

14 (0.130)

SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '0' AND name = 'lichidare_stoc'

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38

Produsul a fost adăugat în coș

Anunță-mă când intră în stoc!

Căutare - Lansete Savage

Produse ce potrivesc criteriilor de căutare