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 Rapture Acrux 2.43m 10-35g

Lanseta Rapture Acrux 2.43m 10-35g

126-51-400
Stoc epuizat

1.070,00Lei

Lanseta Rapture STX Lure Spin ML 2.10m 5-20g 2seg

Lanseta Rapture STX Lure Spin ML 2.10m 5-20g 2seg

126-70-310
Stoc epuizat

310,00Lei

Lanseta Rapture STX Dropshot Finesse L 2.40m 4-21g 2seg

Lanseta Rapture STX Dropshot Finesse L 2.40m 4-21g 2seg

126-70-120
Stoc epuizat

335,00Lei

Lanseta Rapture STX Lure Spin MH 2.40m 15-45g 2seg

Lanseta Rapture STX Lure Spin MH 2.40m 15-45g 2seg

126-70-330
Stoc epuizat

350,00Lei

Lanseta Rapture STX Softbait H 2.40m 20-60g 2seg

Lanseta Rapture STX Softbait H 2.40m 20-60g 2seg

126-70-420
Stoc epuizat

350,00Lei

Lanseta Trakko Crap Patriot 3.60m/3lbs

Lanseta Trakko Crap Patriot 3.60m/3lbs

trcp12
Stoc epuizat

320,00Lei

Lanseta Shimano Sedona 78M 2.34m/7-35g -37%

Lanseta Shimano Sedona 78M 2.34m/7-35g

sed78mfe
Stoc epuizat

635,00Lei(-37%) 397,00Lei

Lanseta Rapture Loomis Franklin Drop Shot 2.13m 0.8-10g 2seg

Lanseta Rapture Loomis Franklin Drop Shot 2.13m 0.8-10g 2seg

121-77-032
Stoc epuizat

320,00Lei

Lanseta DAM Madcat White Clonk Teaser 2.40m, 200-250gr

Lanseta DAM Madcat White Clonk Teaser 2.40m, 200-250gr

mad.56868
Stoc epuizat

463,89Lei

LANSETA FL CATFISH PASSION PRO 2.10M 300-600G

LANSETA FL CATFISH PASSION PRO 2.10M 300-600G

6427559016087
Stoc epuizat

191,90Lei

LANSETA FL CATFISH PASSION PRO 2.40M 300-600G

LANSETA FL CATFISH PASSION PRO 2.40M 300-600G

6427559016094
Stoc epuizat

209,90Lei

Lanseta Rapture Acrux 2.59m 10-35g

Lanseta Rapture Acrux 2.59m 10-35g

126-51-500
Stoc epuizat

1.120,00Lei

Lanseta Rapture Loomis Franklin Drop Shot 1.93m 0.8-10g 2seg

Lanseta Rapture Loomis Franklin Drop Shot 1.93m 0.8-10g 2seg

121-77-031
Stoc epuizat

310,00Lei

LANSETA FL CATFISH PASSION PRO 3.00M 300-600G

LANSETA FL CATFISH PASSION PRO 3.00M 300-600G

64-19620
Stoc epuizat

276,90Lei

Lanseta Rapture Jigforce Shore Jig 2.80m, 10-60, 2seg

Lanseta Rapture Jigforce Shore Jig 2.80m, 10-60, 2seg

125-91-610
Stoc epuizat

455,00Lei

Lanseta Carp Spirit Magnum X1, 3.96m, 3.50lbs, 2seg

Lanseta Carp Spirit Magnum X1, 3.96m, 3.50lbs, 2seg

acs170008
Stoc epuizat

689,00Lei

Lanseta FL Aqua Picker 2,70m 200g, 2 seg

Lanseta FL Aqua Picker 2,70m 200g, 2 seg

7153172087744
Stoc epuizat

150,00Lei

Lanseta FL Ultra Team 3.90M 4.25Lbs 2Seg

Lanseta FL Ultra Team 3.90M 4.25Lbs 2Seg

6742105704899
Stoc epuizat

216,60Lei

Lanseta Bolognesa Mifine Day Match II 4m

Lanseta Bolognesa Mifine Day Match II 4m

642197865878155
Stoc epuizat

130,00Lei

Lanseta Rapture Jigforce Shore Jig 2.60m, 10-60, 2seg

Lanseta Rapture Jigforce Shore Jig 2.60m, 10-60, 2seg

125-91-600
Stoc epuizat

420,00Lei

Afişare 8481 - 8500 din 8583 (430 pagini)
Queries: 6, Total time: 215.079 ms [By time] [By id] [By file]
1 (0.101)
SELECT data
FROM `oc_session`
WHERE session_id = '795434438eb2253a2a13143285'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.106)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (214.434)
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 (MATCH(pd.tag) AGAINST('+lanseta' IN BOOLEAN MODE)) 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:725
4 (0.164)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"ROM-EUROTRADE SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
5 (0.134)
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.140)
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