Filtreaza

Lanseta Fl Flx30 B 3.96m 4.00lbs 2seg

Lanseta Fl Flx30 B 3.96m 4.00lbs 2seg

1185213565450
Stoc epuizat

466,50Lei

Lanseta Delphin Impala Carper 3.00m 2.75lbs 2segmente

Lanseta Delphin Impala Carper 3.00m 2.75lbs 2segmente

101000546
Stoc epuizat

248,20Lei

Lanseta Delphin Impala Carper 3.90m 3.50lbs 2 Segmente

Lanseta Delphin Impala Carper 3.90m 3.50lbs 2 Segmente

101000284
Stoc epuizat

319,21Lei

Lanseta Prologic C3 Fulcrum Spod / Marker 3.60m, 5.00lbs, 2seg

Lanseta Prologic C3 Fulcrum Spod / Marker 3.60m, 5.00lbs, 2seg

o.pro.72644
Stoc epuizat

1.007,11Lei

Lanseta Delphin Impala Carper 3.60m 3.00lbs 2 Segmente

Lanseta Delphin Impala Carper 3.60m 3.00lbs 2 Segmente

101000283
Stoc epuizat

456,00Lei

Lanseta Delphin Etna E3 Trip 390cm 3.50lbs Telefi 2seg

Lanseta Delphin Etna E3 Trip 390cm 3.50lbs Telefi 2seg

101001485
Stoc epuizat

451,00Lei

Lanseta Delphin Partisan Carp 360cm 3.50lbs 3seg

Lanseta Delphin Partisan Carp 360cm 3.50lbs 3seg

101001405
Stoc epuizat

254,01Lei

Lanseta Crap Delphin Stalktrip 2.10m 2.25lbs 2seg

Lanseta Crap Delphin Stalktrip 2.10m 2.25lbs 2seg

101001275
Stoc epuizat

150,00Lei

Lanseta Delphin Etna E3 Trip 360cm 3.00lbs Telefi 2seg

Lanseta Delphin Etna E3 Trip 360cm 3.00lbs Telefi 2seg

101001483
Stoc epuizat

359,00Lei

Lanseta Delphin Etna E3 Trip 360cm 3.25lbs Telefi 2seg

Lanseta Delphin Etna E3 Trip 360cm 3.25lbs Telefi 2seg

101001484
Stoc epuizat

374,01Lei

Lanseta Fl Flx Spod 6.00lbs 2seg

Lanseta Fl Flx Spod 6.00lbs 2seg

8315215102763
Stoc epuizat

399,80Lei

Lanseta Mifine Parossa 3.60 3.50lbs 3seg

Lanseta Mifine Parossa 3.60 3.50lbs 3seg

5114174998584
Stoc epuizat

170,82Lei

Lanseta Carpzoom Cork Action Ca3 Crap 3.9m 3.5lb 3 Sec

Lanseta Carpzoom Cork Action Ca3 Crap 3.9m 3.5lb 3 Sec

cz5850
Stoc epuizat

335,00Lei

Lanseta Carpzoom Cork Action Ca3 Crap 3.6m 3.0lb 3 Sec

Lanseta Carpzoom Cork Action Ca3 Crap 3.6m 3.0lb 3 Sec

cz5843
Stoc epuizat

310,00Lei

Lanseta Crap Delphin Corsa Black Carp 3.60m 3.00lb 3seg

Lanseta Crap Delphin Corsa Black Carp 3.60m 3.00lb 3seg

101001270
Stoc epuizat

338,00Lei

Lanseta Crap Delphin Corsa Black Carp 3.00m 2.75lb 2seg

Lanseta Crap Delphin Corsa Black Carp 3.00m 2.75lb 2seg

101001266
Stoc epuizat

281,99Lei

Lanseta Crap Delphin Corsa Black Carp 3.30m 3.00lb 2seg

Lanseta Crap Delphin Corsa Black Carp 3.30m 3.00lb 2seg

101001267
Stoc epuizat

292,00Lei

Lanseta Crap Delphin Corsa Black Carp 3.60m 3.25lb 2seg

Lanseta Crap Delphin Corsa Black Carp 3.60m 3.25lb 2seg

101001269
Stoc epuizat

359,00Lei

Lanseta Fox Horizon X5-s Full Shrink 3.60 - 3.25lbs 2seg -30%

Lanseta Fox Horizon X5-s Full Shrink 3.60 - 3.25lbs 2seg

crd338
Stoc epuizat

2.024,96Lei(-30%) 1.417,47Lei

Lanseta Crap Delphin Stalktrip 2.40m 2.5lbs 2seg

Lanseta Crap Delphin Stalktrip 2.40m 2.5lbs 2seg

101001276
Stoc epuizat

184,40Lei

Afişare 681 - 700 din 1049 (53 pagini)

Daca esti pasionat de pescuitul la crap, ai nimerit unde trebuie. In sectiunea Lansete Crap vei gasi lansete pentru crap de la cele mai mici preturi pana la modele de la producatori de renume cum ar fi Daiwa, Shimano, Fox, Maver, Sportex.

In categoria Lansete Crap exista o mare varietate de lansete pentru incepatori si profesionisti. 

Daca nu stii ce lanseta de crap ar fi potrivita pentru stilul tau de pescuit, nu ezita sa suni la nr de telefon afisat pe site, si iti va raspunde intotdeauna un specialist in pescuitul crapului care iti poate da mai multe detalii.

Queries: 11, Total time: 23.558 ms [By time] [By id] [By file]
1 (0.121)
SELECT data
FROM `oc_session`
WHERE session_id = '5306fb31575b70032d9fc0fa89'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.112)
SELECT *
FROM oc_platforma_promovari LIMIT 1
/var/www/clients/client1/web1/web/index.php:128
3 (0.110)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:422
4 (0.139)
SELECT *
FROM oc_url_alias
WHERE keyword = 'pescuit-la-crap'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
5 (0.124)
SELECT *
FROM oc_url_alias
WHERE keyword = 'lansete-crap-218'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
6 (0.409)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '218' AND cd.language_id = '2' AND c2s.store_id = '2' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46
7 (17.771)
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_to_category` AS p2c ON (p.product_id = p2c.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 = '2' AND p2c.category_id = '218' 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
8 (0.144)
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
9 (4.360)
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 DESC LIMIT 680, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:181
10 (0.143)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
11 (0.125)
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