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 SPINNING OKUMA ALARIS SPIN 2.59m 20-60g 2seg -33%

LANSETA SPINNING OKUMA ALARIS SPIN 2.59m 20-60g 2seg

ala-s-862mh
Livrare imediată!

242,11Lei(-33%) 161,40Lei

LANSETA KORUM OPPORTUNIST X QUIVER 8FT 2.45M 15-90G 2+2seg

LANSETA KORUM OPPORTUNIST X QUIVER 8FT 2.45M 15-90G 2+2seg

k0330027
Livrare imediată!

354,00Lei

LANSETA DAIWA BLACK WIDOW CARP 3.60M 2.75LBS 2SEG
Exclusiv online!

LANSETA DAIWA BLACK WIDOW CARP 3.60M 2.75LBS 2SEG

d.11584.361
Livrare 24-48 ore

282,23Lei

LANSETA REIVA FINEMASTER 2.30M 5-21g 2seg
Exclusiv online!

LANSETA REIVA FINEMASTER 2.30M 5-21g 2seg

1441-230
Livrare 48-72 ore

515,00Lei

Lanseta, Harrison, Aviator, Spod, 3.90m,, 5.00lb,, 2seg, ac13spodr, Lansete Crap, Lansete Crap Harrison, Harrison
Exclusiv online!

Lanseta, Harrison, Aviator, Spod, 3.90m,, 5.00lb,, 2seg, ac13spodr, Lansete Crap, Lansete Crap Harrison, Harrison

ac13spodr
Livrare 30-60 zile

2.445,33Lei

Lanseta Daiwa Caldia Jiggerspin 2.10M 8-35g 2SEG -22%

Lanseta Daiwa Caldia Jiggerspin 2.10M 8-35g 2SEG

d.11422.210
Livrare imediată!

599,11Lei(-22%) 469,90Lei

LANSETA REIVA STEAM 2.40M 10-30g 2seg
Exclusiv online!

LANSETA REIVA STEAM 2.40M 10-30g 2seg

1438-241
Livrare 48-72 ore

238,00Lei

LANSETA TRAKKO SPINNING MASTER 2.40m MEDIUM FAST 5-30g 2SEG
Exclusiv online!

LANSETA TRAKKO SPINNING MASTER 2.40m MEDIUM FAST 5-30g 2SEG

trmaster240
Livrare 48-72 ore

229,00Lei

LANSETA SPINNING DAIWA TOURNAMENT AGS JIGGER 2.40M 7-28G 2SEG
Exclusiv online!

LANSETA SPINNING DAIWA TOURNAMENT AGS JIGGER 2.40M 7-28G 2SEG

d.11117.240
Livrare 24-48 ore

2.284,48Lei

Lanseta Okuma PCH Air Spin 2.44m 30-80g 2seg

Lanseta Okuma PCH Air Spin 2.44m 30-80g 2seg

pcha-s-802xh
Livrare imediată!

439,99Lei

Lanseta Okuma LS-6K Carp 3.60m 3lbs 2seg -20%
Exclusiv online!

Lanseta Okuma LS-6K Carp 3.60m 3lbs 2seg

ls-ca-1202mh
Livrare 48-72ore

431,10Lei(-20%) 344,01Lei

LANSETA DAIWA BLACK WIDOW CARP 3.60M 3.5LBS 2SEG -10%
Exclusiv online!

LANSETA DAIWA BLACK WIDOW CARP 3.60M 3.5LBS 2SEG

d.11584.365
Livrare 24-48 ore

286,06Lei(-10%) 257,44Lei

LANSETA SPINNING DAIWA PROREX S 2.40M 10-30G 2SEG
Exclusiv online!

LANSETA SPINNING DAIWA PROREX S 2.40M 10-30G 2SEG

d.11280.241
Livrare 24-48 ore

375,74Lei

Lanseta Okuma LS-6K Carp 3.00m 3lbs 2seg -20%
Exclusiv online!

Lanseta Okuma LS-6K Carp 3.00m 3lbs 2seg

ls-ca-1002mh
Livrare 48-72ore

395,10Lei(-20%) 315,00Lei

LANSETA DAIWA BLACK WIDOW CARP 3.00M 3,5LBS 2seg

LANSETA DAIWA BLACK WIDOW CARP 3.00M 3,5LBS 2seg

d.11584.300
Livrare imediată!

231,46Lei

Lanseta DAM Madcat White Deluxe G2 2.75m, 150-350g, 2seg -29%

Lanseta DAM Madcat White Deluxe G2 2.75m, 150-350g, 2seg

2033151833
Livrare imediată!

702,20Lei(-29%) 498,55Lei

LANSETA ARROW G-FORCE CARP 3.00M 3.00LBS 2SEG
Exclusiv online!

LANSETA ARROW G-FORCE CARP 3.00M 3.00LBS 2SEG

arr.c310.300
Livrare 24-48 ore

215,25Lei

Lanseta Arrow AR Classic Spin 1.82m, 2-12g, 2seg
Exclusiv online!

Lanseta Arrow AR Classic Spin 1.82m, 2-12g, 2seg

arr.s100.180
Livrare 24-48 ore

95,75Lei

Lanseta Shimano Sedona 68ML Split Grip EVA 2.03m 7-21g 2SEG

Lanseta Shimano Sedona 68ML Split Grip EVA 2.03m 7-21g 2SEG

sed68mlfe
Livrare imediată!

384,00Lei

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

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

nrd373
Livrare 7-14 zile

404,96Lei

Afişare 141 - 160 din 3144 (158 pagini)
Queries: 7, Total time: 292.069 ms [By time] [By id] [By file]
1 (0.120)
SELECT data
FROM `oc_session`
WHERE session_id = '6257177d25479a46ff282832b5'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.086)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:427
3 (278.610)
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 "%2seg%") 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:698
4 (12.854)
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 140, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.092)
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
6 (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
7 (0.184)
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