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 - Lansete Rapitori FL.

Produse ce potrivesc criteriilor de căutare


Lanseta Penn Regiment III Spin and Pilk, 2.44m, 50-150g, 2buc
Exclusiv online!

Lanseta Penn Regiment III Spin and Pilk, 2.44m, 50-150g, 2buc

1544370
Livrare 7-14 zile

584,96Lei

Lanseta Penn Regiment III Uptide Rod 1002 H, 70-300g, 3.00m, 2seg
Exclusiv online!

Lanseta Penn Regiment III Uptide Rod 1002 H, 70-300g, 3.00m, 2seg

1544367
Livrare 7-14 zile

899,96Lei

Lanseta Prowess Insedia RS, 3.60m, 3.5lb, 2seg
Exclusiv online!

Lanseta Prowess Insedia RS, 3.60m, 3.5lb, 2seg

20233prcrl8070360-2-350
Livrare 48-72 ore

405,42Lei

Lanseta Prowess Insedia RS, 3.90m, 3.5lb, 2seg
Exclusiv online!

Lanseta Prowess Insedia RS, 3.90m, 3.5lb, 2seg

20233prcrl8070390-2-350
Livrare 48-72 ore

419,48Lei

Lanseta Prowess Insedia, 3.00m, 3.25lb, 2seg
Exclusiv online!

Lanseta Prowess Insedia, 3.00m, 3.25lb, 2seg

20233prcrj8070300-2-325
Livrare 48-72 ore

343,86Lei

Lanseta, Prowess, Insedia,, 3.60m,, 3.50lb,, 2seg, 20233prcrj8070360-2-350, Lansete Crap, Lansete Crap Prowess, Prowess
Exclusiv online!

Lanseta, Prowess, Insedia,, 3.60m,, 3.50lb,, 2seg, 20233prcrj8070360-2-350, Lansete Crap, Lansete Crap Prowess, Prowess

20233prcrj8070360-2-350
Livrare 48-72 ore

338,00Lei

Lanseta, Prowess, Scorpium, 3.60m,, 3.00lbs,, 2seg, 20233prcrf8004360-2-3, Lansete Crap, Lansete Crap Prowess, Lansete Prowess, Crap Prowess, Prowess
Lanseta, Prowess, Scorpium, 3.60m,, 3.00lbs,, 3seg, 20233prcrg8004360-3-3, Lansete Crap, Lansete Crap Prowess, Lansete Prowess, Crap Prowess, Prowess
Lanseta Rapture Loomis & Franklin LMF Radius Stream 4-5WT, 2.74m, 4seg
Exclusiv online!

Lanseta Rapture Loomis & Franklin LMF Radius Stream 4-5WT, 2.74m, 4seg

121-71-030
Livrare 48-72 ore

680,00Lei

Lanseta Rapture Seals Master H, 10-60g, 2.60m, 2seg
Exclusiv online!

Lanseta Rapture Seals Master H, 10-60g, 2.60m, 2seg

126-23-550
Livrare 48-72 ore

595,00Lei

Lanseta Relax Dictator 702MH, 2.13m, 10-35g, 2seg
Exclusiv online!

Lanseta Relax Dictator 702MH, 2.13m, 10-35g, 2seg

dictator 702mh
Livrare 48-72ore

279,00Lei

Lanseta Relax Dictator 802H, 2.44m, 12-50g, 2seg

Lanseta Relax Dictator 802H, 2.44m, 12-50g, 2seg

dictator 802h
Livrare imediată!

310,00Lei

Lanseta, Sakura, Horosha, HORS, Spinning, Rod, 904EH,, 14-60g,, 2.74m,, 4seg, 20434saprm802490-4hh, Lansete Rapitori, Lansete Rapitori Sakura, Lansete Sakura, Rapitori Sakura, Sakura
Lanseta Sakura Salt Sniper Spinning SALSS 902 H, 2.70m, 14-42g, 2seg
Exclusiv online!

Lanseta Sakura Salt Sniper Spinning SALSS 902 H, 2.70m, 14-42g, 2seg

20434saprj802290-2h
Livrare 48-72 ore

479,36Lei

Lanseta Sakura Trinis Explora Spin Travel TRXS 704H, 10-40g, 2.13m , 4seg

Lanseta Sakura Trinis Explora Spin Travel TRXS 704H, 10-40g, 2.13m , 4seg

20434saprl801370-4h
Livrare imediată!

935,94Lei

Lanseta Sakura Tsubarea TSA 732 L, 2.20m, 0.5-7g, 2seg
Exclusiv online!

Lanseta Sakura Tsubarea TSA 732 L, 2.20m, 0.5-7g, 2seg

20434satrh800173-2l
Livrare 48-72 ore

403,20Lei

Lanseta, Shakespeare, Skp, Solitude, 3.34m, 1.50lb, 1550401, Lansete Match, Lansete Match Shakespeare, Shakespeare
Exclusiv online!

Lanseta, Shakespeare, Skp, Solitude, 3.34m, 1.50lb, 1550401, Lansete Match, Lansete Match Shakespeare, Shakespeare

1550401
Livrare 7-14 zile

427,46Lei

Lanseta Shakespeare Skp Solitude Big Barbel 3.60m 2.50lb
Exclusiv online!

Lanseta Shakespeare Skp Solitude Big Barbel 3.60m 2.50lb

1550408
Livrare 7-14 zile

449,96Lei

Lanseta Shakespeare Ugly Stik Elite Spin 2.10m, 18-50g

Lanseta Shakespeare Ugly Stik Elite Spin 2.10m, 18-50g

1377254
Livrare imediată!

318,15Lei

Lanseta, Spinning, Daiwa, SweepFire, 1.50m,, 5-10g,, 2seg, d.11445.150, Lansete Rapitori, Lansete Rapitori Daiwa, Daiwa
Exclusiv online!

Lanseta, Spinning, Daiwa, SweepFire, 1.50m,, 5-10g,, 2seg, d.11445.150, Lansete Rapitori, Lansete Rapitori Daiwa, Daiwa

d.11445.150
Livrare 24-48 ore

144,34Lei

Afişare 2181 - 2200 din 8488 (425 pagini)
Queries: 14, Total time: 467.936 ms [By time] [By id] [By file]
1 (0.062)
SELECT data
FROM `oc_session`
WHERE session_id = 'e26076fc52ee8ecd7e0818253a'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.064)
SELECT *
FROM oc_platforma_promovari LIMIT 1
/var/www/clients/client1/web1/web/index.php:128
3 (0.062)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:422
4 (321.455)
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` GROUP BY tax_class_id) AS tx ON (p.tax_class_id = tx.tax_class_id)
WHERE p2s.store_id = '0' AND (pd.tag LIKE "%lanseta%") 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:697
5 (0.701)
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:1547
6 (33.973)
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 2180, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:181
7 (0.126)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"TACKLE SHOP ARENA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
8 (10.397)
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:1202
9 (0.118)
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:1221
10 (2.609)
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:982
11 (98.005)
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:904
12 (0.128)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
13 (0.112)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
14 (0.124)
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