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 Berkley URBN Roamer Spinning Rod, 2.10m, 15g, 4seg -51%

Lanseta Berkley URBN Roamer Spinning Rod, 2.10m, 15g, 4seg

1527382
Stoc epuizat

449,50Lei(-51%) 220,94Lei

Lanseta Bolognesa Filfishing Filex Hulk, 30g, 5m, 5seg

Lanseta Bolognesa Filfishing Filex Hulk, 30g, 5m, 5seg

fil8735
Stoc epuizat

245,00Lei

Lanseta Carp Zoom Competition Osmium Feeder, 50-140g, 3.60m, 3+3seg

Lanseta Carp Zoom Competition Osmium Feeder, 50-140g, 3.60m, 3+3seg

cz3091
Stoc epuizat

380,00Lei

Lanseta Carp Zoom Resistant Carp, 3.00lbs, 3.00m, 2seg

Lanseta Carp Zoom Resistant Carp, 3.00lbs, 3.00m, 2seg

cz1707
Stoc epuizat

120,00Lei

Lanseta Crap Delphin Nirvana Crp, 3.60m, 3.00lbs, 2seg

Lanseta Crap Delphin Nirvana Crp, 3.60m, 3.00lbs, 2seg

101001481
Stoc epuizat

717,00Lei

Lanseta Daiwa Black Widow Carp 3.90m, 3.5lbs

Lanseta Daiwa Black Widow Carp 3.90m, 3.5lbs

d.bwc3312ax
Stoc epuizat

347,04Lei

Lanseta Daiwa Pro Staff Extra Fast 2.50m, 60-140g, 2seg

Lanseta Daiwa Pro Staff Extra Fast 2.50m, 60-140g, 2seg

d.11320.245
Stoc epuizat

1.197,62Lei

Lanseta Daiwa Prorex XR BC 2.40, 40-120g, 2seg

Lanseta Daiwa Prorex XR BC 2.40, 40-120g, 2seg

d.11336.245
Stoc epuizat

927,16Lei

Lanseta Delphin Armada NX BlackWay Cork 3.00m, 2.50lbs, 2seg

Lanseta Delphin Armada NX BlackWay Cork 3.00m, 2.50lbs, 2seg

101002522
Stoc epuizat

224,60Lei

Lanseta Delphin ETNA E3 Cork 2.70m, 2.50lbs, 2seg

Lanseta Delphin ETNA E3 Cork 2.70m, 2.50lbs, 2seg

101000542
Stoc epuizat

307,00Lei

Lanseta Delphin ETNA E3 Cork 3.90m, 3.50lbs, 2seg -29%

Lanseta Delphin ETNA E3 Cork 3.90m, 3.50lbs, 2seg

101000281
Stoc epuizat

477,00Lei(-29%) 339,00Lei

Lanseta Delphin EXPLOZA HARD 2.10m, 60g, 2seg -25%

Lanseta Delphin EXPLOZA HARD 2.10m, 60g, 2seg

101003135
Stoc epuizat

198,00Lei(-25%) 148,80Lei

Lanseta Delphin EXPLOZA HARD 3.00m, 70g, 2seg -30%

Lanseta Delphin EXPLOZA HARD 3.00m, 70g, 2seg

101003138
Stoc epuizat

254,01Lei(-30%) 177,30Lei

Lanseta Delphin Lycan Tele Feeder, 80g, 3.30m, 4+1seg

Lanseta Delphin Lycan Tele Feeder, 80g, 3.30m, 4+1seg

101003232
Stoc epuizat

281,99Lei

Lanseta Delphin Method CONXEPT 3.30m, 60g, 3+3seg

Lanseta Delphin Method CONXEPT 3.30m, 60g, 3+3seg

101003236
Stoc epuizat

249,60Lei

Lanseta Delphin RIVERA NX, 2.10m, 150g, 2 seg

Lanseta Delphin RIVERA NX, 2.10m, 150g, 2 seg

101002622
Stoc epuizat

272,00Lei

Lanseta Delphin Zandera B-CAST, 2.10m, 5-28g, 2seg -30%

Lanseta Delphin Zandera B-CAST, 2.10m, 5-28g, 2seg

101002620
Stoc epuizat

325,00Lei(-30%) 228,19Lei

Lanseta Delphin ZOMBIE 3.00m, 65g, 2seg

Lanseta Delphin ZOMBIE 3.00m, 65g, 2seg

101003155
Stoc epuizat

198,60Lei

LANSETA FEEDER PRO FL ROYAL X 3.60M 60-180G

LANSETA FEEDER PRO FL ROYAL X 3.60M 60-180G

7253240308877
Stoc epuizat

159,90Lei

Lanseta Filfishing Monster Catfish, 2.85m, 150-400g, 2seg

Lanseta Filfishing Monster Catfish, 2.85m, 150-400g, 2seg

fil4742
Stoc epuizat

259,00Lei

Afişare 6701 - 6720 din 8888 (445 pagini)
Queries: 6, Total time: 903.987 ms [By time] [By id] [By file]
1 (0.100)
SELECT data
FROM `oc_session`
WHERE session_id = 'bc3007af5919145f0c9d0b0f37'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.073)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (0.088)
SELECT *
FROM oc_url_alias
WHERE keyword = 'search'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (862.158)
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 = '3' AND (pd.tag LIKE "%lansete%") 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:724
5 (41.338)
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 6700, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
6 (0.230)
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