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


Inele Despicate Mikado, 43.5x0.5mm, 10buc
Exclusiv online!

Inele Despicate Mikado, 43.5x0.5mm, 10buc

hx43.5x0.5
Livrare 48-72 ore

4,00Lei

Jig Mikado Cap Aberdeen Jig, BN, Nr.1/0, 10g, 3buc/plic
Exclusiv online!

Jig Mikado Cap Aberdeen Jig, BN, Nr.1/0, 10g, 3buc/plic

omgajl10-1/0-n
Livrare 48-72 ore

10,00Lei

Jig Mikado Cap Aberdeen Jig, Nr.1, 5g, 3buc/plic
Exclusiv online!

Jig Mikado Cap Aberdeen Jig, Nr.1, 5g, 3buc/plic

omgajl5-1-n
Livrare 48-72 ore

8,00Lei

Jig MIKADO Jaws Triangle BN, Nr.4/0, 8g, 3buc/pac
Exclusiv online!

Jig MIKADO Jaws Triangle BN, Nr.4/0, 8g, 3buc/pac

OMGJCT8-4/0-BN
Livrare 48-72 ore

12,99Lei

Jig MIKADO Sensual BN, Nr.1, 2g, 3buc/pac
Exclusiv online!

Jig MIKADO Sensual BN, Nr.1, 2g, 3buc/pac

OMGAJS2-1-3
Livrare 48-72 ore

7,00Lei

Jig MIKADO Sensual BN, Nr.2, 2g, 3buc/pac
Exclusiv online!

Jig MIKADO Sensual BN, Nr.2, 2g, 3buc/pac

OMGAJS2-2-3
Livrare 48-72 ore

7,00Lei

Line Varga Montura Pluta 004, 1.0g, Fir 0.14/0.12mm, Carlig Nr.16
Exclusiv online!

Line Varga Montura Pluta 004, 1.0g, Fir 0.14/0.12mm, Carlig Nr.16

smsz-004-1.0-16
Livrare 48-72 ore

12,00Lei

Line Varga Montura Pluta 004, 2.0g, Fir 0.14/0.12mm, Carlig Nr.12
Exclusiv online!

Line Varga Montura Pluta 004, 2.0g, Fir 0.14/0.12mm, Carlig Nr.12

smsz-004-2.0
Livrare 48-72 ore

12,00Lei

Mikado Flying Fishunter Wings, Culoare 41, 5.2cm, 5buc/blister
Exclusiv online!

Mikado Flying Fishunter Wings, Culoare 41, 5.2cm, 5buc/blister

pmtf-52-41
Livrare 48-72 ore

11,20Lei

Mikado Flying Fishunter Wings, Culoare 41, 7.1cm, 3buc/blister
Exclusiv online!

Mikado Flying Fishunter Wings, Culoare 41, 7.1cm, 3buc/blister

pmtf-71-41
Livrare 48-72 ore

10,40Lei

Mikado Flying Fishunter Wings, Culoare 90, 5.2cm, 5buc/blister
Exclusiv online!

Mikado Flying Fishunter Wings, Culoare 90, 5.2cm, 5buc/blister

pmtf-52-90
Livrare 48-72 ore

11,20Lei

Mikado Flying Fishunter Wings, Culoare MV, 5.2cm, 5buc/blister
Exclusiv online!

Mikado Flying Fishunter Wings, Culoare MV, 5.2cm, 5buc/blister

pmtf-52-mv
Livrare 48-72 ore

11,20Lei

PLUMB MIKADO PICATURA CU TUB 3g 5buc
Exclusiv online!

PLUMB MIKADO PICATURA CU TUB 3g 5buc

omc-01100-3
Livrare 48-72 ore

4,00Lei

Suport Mikado Picior Umbrela Aix-0465, Black
Exclusiv online!

Suport Mikado Picior Umbrela Aix-0465, Black

aix-0465
Livrare 48-72 ore

35,00Lei

Agrafa Mikado Round Snap XXS, 10buc/plic
Exclusiv online!

Agrafa Mikado Round Snap XXS, 10buc/plic

ama02-090-xxs
Livrare 48-72 ore

7,00Lei

Cagula Mikado Fleece Face, Black
Exclusiv online!

Cagula Mikado Fleece Face, Black

UM-UC007
Livrare 48-72 ore

58,00Lei

Cicada Mikado, Culoare 10, 4.5cm, 5g
Exclusiv online!

Cicada Mikado, Culoare 10, 4.5cm, 5g

PMB-WCA-5-10
Livrare 48-72 ore

17,01Lei

Cicada Mikado, Culoare 11, 4.5cm, 14g

Cicada Mikado, Culoare 11, 4.5cm, 14g

pmb-wca-14-11
Livrare imediată!

20,00Lei

Cicada Mikado, Culoare 11, 4.5cm, 5g
Exclusiv online!

Cicada Mikado, Culoare 11, 4.5cm, 5g

PMB-WCA-5-11
Livrare 48-72 ore

17,01Lei

Cutie Mikado Momeli Termica H509, 11.5x8.5x3.2cm
Exclusiv online!

Cutie Mikado Momeli Termica H509, 11.5x8.5x3.2cm

UACH-H509
Livrare 48-72 ore

24,00Lei

Afişare 2101 - 2120 din 2749 (138 pagini)
Queries: 4, Total time: 46.376 ms [By time] [By id] [By file]
1 (0.173)
SELECT data
FROM `oc_session`
WHERE session_id = 'fdca19db04b6994fa2abd68880'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.105)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (45.921)
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('+mikado' 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.177)
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