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

Produse ce potrivesc criteriilor de căutare


LANSETA PRO FL ETERNITY TELE CARP 150G 3.90M

LANSETA PRO FL ETERNITY TELE CARP 150G 3.90M

3224240860591
Livrare imediată!

159,90Lei

Lanseta Relax Dictator 702M, 2.13m, 7-28g, 2seg
Exclusiv online!

Lanseta Relax Dictator 702M, 2.13m, 7-28g, 2seg

dictator 702m
Livrare 48-72ore

279,00Lei

Lanseta Ryobi Num One M, 4-21g, 2.40m, 2seg
Exclusiv online!

Lanseta Ryobi Num One M, 4-21g, 2.40m, 2seg

ry163240
Livrare 24-48 ore

274,21Lei

Lanseta Sakura Tsubarea TSA 702 ULST 2.13m, 0.3-5g, 2seg
Exclusiv online!

Lanseta Sakura Tsubarea TSA 702 ULST 2.13m, 0.3-5g, 2seg

20434satrh800170-2ulst
Livrare 48-72 ore

404,97Lei

Lanseta Serie Walter Manta EVO XT-R Feeder XH, 4.20m, 50-150g, 3+3seg

Lanseta Serie Walter Manta EVO XT-R Feeder XH, 4.20m, 50-150g, 3+3seg

170840
Livrare imediată!

649,50Lei

Lanseta Serie Walter Racer Feeder PQ, 100g, 3.90m, 3+3seg

Lanseta Serie Walter Racer Feeder PQ, 100g, 3.90m, 3+3seg

swrf390pq
Livrare imediată!

879,20Lei

Lanseta Shakespeare Skp Solitude Feeder 3.65m, 2+1 Seg
Exclusiv online!

Lanseta Shakespeare Skp Solitude Feeder 3.65m, 2+1 Seg

1550417
Livrare 7-14 zile

517,46Lei

Lanseta Sonik Dominator Travel Spin, 2.74m, 30-50g, 4seg
Exclusiv online!

Lanseta Sonik Dominator Travel Spin, 2.74m, 30-50g, 4seg

dxsp030
Livrare 48-72 ore

272,91Lei

LANSETA SPINNING PRO FL MEBARU 2.14M 0.5-5G

LANSETA SPINNING PRO FL MEBARU 2.14M 0.5-5G

64-7411
Livrare imediată!

143,89Lei

LANSETA SPINNING PRO FL MURROW 1.98M 0.2-6G

LANSETA SPINNING PRO FL MURROW 1.98M 0.2-6G

64-4103
Livrare imediată!

137,90Lei

Lanseta Sportex Illusion 2.45m, 17-53g, 2seg

Lanseta Sportex Illusion 2.45m, 17-53g, 2seg

il2402
Livrare imediată!

729,01Lei

Lanseta Sportex Illusion 2.45m, 23-73g, 2seg

Lanseta Sportex Illusion 2.45m, 23-73g, 2seg

il2403
Livrare imediată!

770,00Lei

Lanseta Telescopica Mikado Intro Power Telerod, 150g, 3.30m, 8seg
Exclusiv online!

Lanseta Telescopica Mikado Intro Power Telerod, 150g, 3.30m, 8seg

WAA798-330
Livrare 48-72 ore

235,00Lei

Lanseta Telescopica Mitchell Suprema Troutista S3 Rods M, 4.30m, 10-20g, 7seg
Exclusiv online!

Lanseta Telescopica Mitchell Suprema Troutista S3 Rods M, 4.30m, 10-20g, 7seg

1542767
Livrare 7-14 zile

267,96Lei

Lanseta Wizard Active Skill Spinning Rod, 12-65g, 2.10m, 2seg
Exclusiv online!

Lanseta Wizard Active Skill Spinning Rod, 12-65g, 2.10m, 2seg

13163210
Livrare 24-48 ore

125,00Lei

Lanseta Wizard Active Skill Spinning Rod, 12-65g, 2.40m, 2seg
Exclusiv online!

Lanseta Wizard Active Skill Spinning Rod, 12-65g, 2.40m, 2seg

13163240
Livrare 24-48 ore

130,00Lei

Lanseta Wizard Active Skill Spinning Rod, 12-65g, 2.70m, 2seg
Exclusiv online!

Lanseta Wizard Active Skill Spinning Rod, 12-65g, 2.70m, 2seg

13163270
Livrare 24-48 ore

140,00Lei

Lanseta Wizard Active Skill Spinning Rod, 5-23g, 2.10m, 2seg
Exclusiv online!

Lanseta Wizard Active Skill Spinning Rod, 5-23g, 2.10m, 2seg

13161210
Livrare 24-48 ore

115,00Lei

Lanseta Wizard Active Skill Spinning Rod, 7-38g, 2.10m, 2seg
Exclusiv online!

Lanseta Wizard Active Skill Spinning Rod, 7-38g, 2.10m, 2seg

13162210
Livrare 24-48 ore

120,00Lei

Lanseta Wizard Micro Jig Spinning Rod, 3-15g, 2.25m, 2seg
Exclusiv online!

Lanseta Wizard Micro Jig Spinning Rod, 3-15g, 2.25m, 2seg

13172226
Livrare 24-48 ore

250,00Lei

Afişare 2061 - 2080 din 8583 (430 pagini)
Queries: 5, Total time: 216.786 ms [By time] [By id] [By file]
1 (0.147)
SELECT data
FROM `oc_session`
WHERE session_id = '7243c134b598233f81d490a39e'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.130)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (216.254)
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:737
4 (0.130)
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
5 (0.125)
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