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


Stoper Prowess Classic Maro 2placi/plic
Exclusiv online!

Stoper Prowess Classic Maro 2placi/plic

40533prcah0004-brown
Livrare 48-72 ore

9,32Lei

HUSA JUVELNIC CARP ZOOM EVA FEEDER COMPETITION CLASSIC 60X15CM
Exclusiv online!

HUSA JUVELNIC CARP ZOOM EVA FEEDER COMPETITION CLASSIC 60X15CM

cz7892
Livrare 48-72 ore

164,01Lei

LANSETA FEEDER FL CLASSIC COMMERCIAL 3.60M 20-120G 5VARFURI

LANSETA FEEDER FL CLASSIC COMMERCIAL 3.60M 20-120G 5VARFURI

64-1646
Livrare imediată!

269,00Lei

Ochelari Polarizati Korda Classics 0.75 Brown
Exclusiv online!

Ochelari Polarizati Korda Classics 0.75 Brown

a8.k4d18
Livrare 24-48 ore

115,74Lei

LANSETA FEEDER FL CLASSIC COMMERCIAL 3.30M 20-120G 5VARFURI -20%

LANSETA FEEDER FL CLASSIC COMMERCIAL 3.30M 20-120G 5VARFURI

64-1645
Livrare imediată!

250,00Lei(-20%) 199,90Lei

Varga Garbolino Strike Classic Whip, 7.00m
Exclusiv online!

Varga Garbolino Strike Classic Whip, 7.00m

10130gomrh8156700-7
Livrare 48-72 ore

251,66Lei

Swinger Z-Fish Bite Indicator Classic Twin Ball, Red
Exclusiv online!

Swinger Z-Fish Bite Indicator Classic Twin Ball, Red

zf-2385
Livrare 48-72ore

29,70Lei

Combo Lanseta + Mulineta Abu Garcia Cardinal Classic Vildmark 7ft/2.13m Tele
Exclusiv online!

Combo Lanseta + Mulineta Abu Garcia Cardinal Classic Vildmark 7ft/2.13m Tele

1344990
Livrare 7-14 zile

247,46Lei

Swinger Z-Fish Bite Indicator Classic Twin Ball, Blue
Exclusiv online!

Swinger Z-Fish Bite Indicator Classic Twin Ball, Blue

zf-2386
Livrare 48-72ore

29,70Lei

Varga Garbolino Strike Classic Whip, 5.00m
Exclusiv online!

Varga Garbolino Strike Classic Whip, 5.00m

10130gomrh8156500-5
Livrare 48-72 ore

156,49Lei

Porumb artificial Enterprise Tackle Pop-up Sweetcorn Classic Banoffee

Porumb artificial Enterprise Tackle Pop-up Sweetcorn Classic Banoffee

et13fb
Livrare imediată!

20,00Lei

Varga Garbolino Strike Classic Whip, 6.00m
Exclusiv online!

Varga Garbolino Strike Classic Whip, 6.00m

10130gomrh8156600-6
Livrare 48-72 ore

204,00Lei

Carlige Varivas Offset Master Light Class NS Black Nr.4
Exclusiv online!

Carlige Varivas Offset Master Light Class NS Black Nr.4

v7040004
Livrare 48-72 ore

17,01Lei

Briceag Multifunctional Victorinox Classic, Dark Illusion, 5.80cm

Briceag Multifunctional Victorinox Classic, Dark Illusion, 5.80cm

0.6223.3g
Livrare imediată!

124,95Lei

Briceag Multifunctional Victorinox Classic, Drapel, 5.80cm

Briceag Multifunctional Victorinox Classic, Drapel, 5.80cm

0.6223.7r2
Livrare imediată!

153,30Lei

Carlige Wizard Zander Classic Pro Perch Momeala Vie, Nr.4/0, 3buc/plic

Carlige Wizard Zander Classic Pro Perch Momeala Vie, Nr.4/0, 3buc/plic

46540400
Livrare imediată!

16,31Lei

Pelete Gaurite Mivardi Rapid Classic Halibut, 12mm, 10kg
Exclusiv online!

Pelete Gaurite Mivardi Rapid Classic Halibut, 12mm, 10kg

m-rapecha10012
Livrare 48-72 ore

179,00Lei

Porumb artificial Enterprise Tackle Pop-up Sweetcorn Classic Flavour Esterberry

Porumb artificial Enterprise Tackle Pop-up Sweetcorn Classic Flavour Esterberry

et13feb
Livrare imediată!

19,30Lei

Cicada Siliconica Percamax Grim Classic GW, 5.5cm, 13g

Cicada Siliconica Percamax Grim Classic GW, 5.5cm, 13g

dream-m13-gw
Livrare imediată!

28,00Lei

Husa Mulinetă Delphin CLASSA NavIQ XXL -19%

Husa Mulinetă Delphin CLASSA NavIQ XXL

101003694
Livrare imediată!

51,00Lei(-19%) 41,10Lei

Afişare 481 - 500 din 1105 (56 pagini)
Queries: 7, Total time: 988.636 ms [By time] [By id] [By file]
1 (0.108)
SELECT data
FROM `oc_session`
WHERE session_id = '92a8ce87a680cfc84057d52cdf'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.137)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (982.831)
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 "%class%") 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
4 (5.188)
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 480, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.146)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"ZFISHING SPORT WHOLESALE S.R.O"%' 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 '%"ZFISHING SPORT WHOLESALE S.R.O"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
7 (0.103)
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