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


Carlige Orange Method Bronze Coated Premium Series 6, Nr.10, 8buc/pac

Carlige Orange Method Bronze Coated Premium Series 6, Nr.10, 8buc/pac

121441hm0610
Livrare imediată!

10,44Lei

Carlige Orange Method Bronze Coated Premium Series 7 Nr.10, 8buc/pac

Carlige Orange Method Bronze Coated Premium Series 7 Nr.10, 8buc/pac

121441hm0710
Livrare imediată!

10,44Lei

Cutie Plano Guide Series Angled System 3700
Exclusiv online!

Cutie Plano Guide Series Angled System 3700

pmc787010
Livrare 7-14 zile

719,96Lei

Cutie Plano Guide Series Stowaway Rack System -25%
Exclusiv online!

Cutie Plano Guide Series Stowaway Rack System

pmc137401
Livrare 7-14 zile

585,00Lei(-25%) 438,00Lei

Vobler Lucky John Haira Tiny Plus One Pro Series 33LBF, 402, 3.3cm, 4g, 1buc/pac

Vobler Lucky John Haira Tiny Plus One Pro Series 33LBF, 402, 3.3cm, 4g, 1buc/pac

lj-hat33lbf-402
Livrare imediată!

37,00Lei

Winterskin Cort Prologic C-Series Bivvy 1 Persoana

Winterskin Cort Prologic C-Series Bivvy 1 Persoana

a8.pro.72818
Livrare imediată!

616,56Lei

Carlige Orange Method Bronze Coated Premium Series 7 Nr.6, 8buc/pac

Carlige Orange Method Bronze Coated Premium Series 7 Nr.6, 8buc/pac

121441hm0706
Livrare imediată!

10,44Lei

Geanta Nash Waterbox 100 Series, 16x9x11cm
Exclusiv online!

Geanta Nash Waterbox 100 Series, 16x9x11cm

t3601
Livrare 7-14 zile

87,99Lei

Geanta Nash Waterbox 115 Series, 16.5x 14x11.5cm
Exclusiv online!

Geanta Nash Waterbox 115 Series, 16.5x 14x11.5cm

t3646
Livrare 7-14 zile

97,98Lei

Geanta Nash Waterbox 120 Series, 23x16.5x14cm -33%

Geanta Nash Waterbox 120 Series, 23x16.5x14cm

t3603
Livrare imediată!

104,32Lei(-33%) 69,48Lei

Geanta Plano Guide Series Tackle Bag 3700 -25%

Geanta Plano Guide Series Tackle Bag 3700

plabg370
Livrare imediată!

630,00Lei(-25%) 472,00Lei

Winterskin Cort Prologic C-Series Bivvy 2 Persoane
Exclusiv online!

Winterskin Cort Prologic C-Series Bivvy 2 Persoane

a8.pro.72819
Livrare 24-48 ore

614,68Lei

Cutie Plano Elite Series Angled System 3700
Exclusiv online!

Cutie Plano Elite Series Angled System 3700

pmc797010
Livrare 7-14 zile

809,60Lei

Geanta Nash Waterbox 105 Series, 16.5x14x5cm
Exclusiv online!

Geanta Nash Waterbox 105 Series, 16.5x14x5cm

t3645
Livrare 7-14 zile

92,99Lei

Geanta Nash Waterbox 140 Series, 32x23.5x18.5cm -34%

Geanta Nash Waterbox 140 Series, 32x23.5x18.5cm

t3605
Livrare imediată!

125,99Lei(-34%) 82,72Lei

Prastie STONFO X Series 407, Distante Medii
Exclusiv online!

Prastie STONFO X Series 407, Distante Medii

8028651004071
Livrare 48-72 ore

34,00Lei

Valigeta Plano Guide Series Tray Tackle Box -25%

Valigeta Plano Guide Series Tray Tackle Box

pmc613403
Livrare imediată!

360,00Lei(-25%) 270,00Lei

Husa Protectie Tamburi Aqua Products Black Series Spool Case, 27.5x10x10cm
Exclusiv online!

Husa Protectie Tamburi Aqua Products Black Series Spool Case, 27.5x10x10cm

404923
Livrare 7-14 zile

114,95Lei

Prastie STONFO X Series 405, Distante Mici
Exclusiv online!

Prastie STONFO X Series 405, Distante Mici

8028651004057
Livrare 48-72 ore

34,00Lei

Nada Benzar Mix Big Series Crap Concurs 1kg

Nada Benzar Mix Big Series Crap Concurs 1kg

94005806
Livrare imediată!

14,00Lei

Afişare 281 - 300 din 591 (30 pagini)
Queries: 4, Total time: 13.924 ms [By time] [By id] [By file]
1 (0.116)
SELECT data
FROM `oc_session`
WHERE session_id = 'b788655879658ac57a8e334f5c'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.080)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (13.571)
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('+series' 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.157)
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