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


FIR MONOFILAMENT MAVER SMART MRT 500M 0.35MM -50%

FIR MONOFILAMENT MAVER SMART MRT 500M 0.35MM

638035
Stoc epuizat

120,00Lei(-50%) 60,00Lei

FIR MONOFILAMENT MAVER JURASSIC TOC FLUO 100M 0.165MM -30%

FIR MONOFILAMENT MAVER JURASSIC TOC FLUO 100M 0.165MM

669165
Stoc epuizat

13,30Lei(-30%) 9,31Lei

FIR MONOFILAMENT MAVER SMART WONDERFUL 150M 0.28MM -50%

FIR MONOFILAMENT MAVER SMART WONDERFUL 150M 0.28MM

702028
Stoc epuizat

15,20Lei(-50%) 7,60Lei

FIR MONOFILAMENT STROFT ABR 018MM/3,6KG/100M

FIR MONOFILAMENT STROFT ABR 018MM/3,6KG/100M

st.8118
Stoc epuizat

25,54Lei

Spray Garbolino Intretinere Varga Nettoyant Cannes 300ml

Spray Garbolino Intretinere Varga Nettoyant Cannes 300ml

40330gclean
Stoc epuizat

50,98Lei

FIR MONOFILAMENT MAVER SMART ELITE REEL 150M 0.170MM -50%

FIR MONOFILAMENT MAVER SMART ELITE REEL 150M 0.170MM

723170
Stoc epuizat

34,80Lei(-50%) 17,40Lei

FIR MONOFILAMENT MAVER SMART GENESIS 1000M 0.10MM -50%

FIR MONOFILAMENT MAVER SMART GENESIS 1000M 0.10MM

681010
Stoc epuizat

70,00Lei(-50%) 35,00Lei

FIR MONOFILAMENT MAVER SMART TT 100M 0.20MM

FIR MONOFILAMENT MAVER SMART TT 100M 0.20MM

731020
Stoc epuizat

30,00Lei

FIR COLMIC OKY 150M 0.50mm

FIR COLMIC OKY 150M 0.50mm

nyok050
Stoc epuizat

18,50Lei

FIR MONOFILAMENT MAVER SMART ZERO SK SINNKING 600M 0.194MM -50%

FIR MONOFILAMENT MAVER SMART ZERO SK SINNKING 600M 0.194MM

615194
Stoc epuizat

90,00Lei(-50%) 45,01Lei

FIR MONOFILAMENT MAVER SMART ZERO SK SINNKING 150M 0.276MM -50%

FIR MONOFILAMENT MAVER SMART ZERO SK SINNKING 150M 0.276MM

619276
Stoc epuizat

38,20Lei(-50%) 19,10Lei

FIR JAXON CROCODILE PREMIUM 25m 0.08mm

FIR JAXON CROCODILE PREMIUM 25m 0.08mm

zj-crp008c
Stoc epuizat

4,00Lei

FIR JAXON CARAT PREMIUM 150m 0.30mm

FIR JAXON CARAT PREMIUM 150m 0.30mm

zj-kap030a
Stoc epuizat

18,50Lei

FIR COLMIC MIMETIX 50M 0.110mm

FIR COLMIC MIMETIX 50M 0.110mm

nymi110
Stoc epuizat

30,00Lei

FIR MONOFILAMENT CARBOTEX 033MM/14.15KG/100M

FIR MONOFILAMENT CARBOTEX 033MM/14.15KG/100M

e.4800.033
Stoc epuizat

13,77Lei

FIR MONOFILAMENT MAVER SMART MRT 500M 0.14MM -50%

FIR MONOFILAMENT MAVER SMART MRT 500M 0.14MM

638014
Stoc epuizat

43,49Lei(-50%) 21,71Lei

FIR COLMIC OKY 150M 0.35mm

FIR COLMIC OKY 150M 0.35mm

nyok035
Stoc epuizat

15,01Lei

FIR COLMIC MIMETIX 0.17MM 50M

FIR COLMIC MIMETIX 0.17MM 50M

nymi170
Stoc epuizat

30,00Lei

FIR JAXON ETERNUM PREMIUM 25m 0.08mm

FIR JAXON ETERNUM PREMIUM 25m 0.08mm

zj-etpc008
Stoc epuizat

5,50Lei

FIR MONOFILAMENT CARBOTEX 022MM/8,40KG/100M

FIR MONOFILAMENT CARBOTEX 022MM/8,40KG/100M

e.4800.022
Stoc epuizat

12,14Lei

Afişare 1581 - 1600 din 2182 (110 pagini)
Queries: 4, Total time: 71.258 ms [By time] [By id] [By file]
1 (0.100)
SELECT data
FROM `oc_session`
WHERE session_id = '0bc3ceb20ae7bc180106c4dc88'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.135)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (70.895)
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('+varga' 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.128)
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