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


PLUTE MOSTIRO ANDREEA F 1GR 10 BUC
Exclusiv online!

PLUTE MOSTIRO ANDREEA F 1GR 10 BUC

2420011110000
Livrare 48-72 ore

38,00Lei

PLUTE MOSTIRO BOGDAN D 1.5GR(10 BUC
Exclusiv online!

PLUTE MOSTIRO BOGDAN D 1.5GR(10 BUC

2420051215000
Livrare 48-72 ore

38,00Lei

PLUTE MOSTIRO MONA 2.5GR(10 BUC)
Exclusiv online!

PLUTE MOSTIRO MONA 2.5GR(10 BUC)

2420280125000
Livrare 48-72 ore

38,00Lei

PLUTE MOSTIRO ROXANA 1.5GR(10 BUC)
Exclusiv online!

PLUTE MOSTIRO ROXANA 1.5GR(10 BUC)

2420480615000
Livrare 48-72 ore

38,00Lei

Carlige Fudo Umi Tanago with Ring (UMTR-BN) nr.12 BN - Black Nickel 16 buc/plic -39%

Carlige Fudo Umi Tanago with Ring (UMTR-BN) nr.12 BN - Black Nickel 16 buc/plic

3101-12
Livrare imediată!

8,00Lei(-39%) 4,90Lei

SHAD BASS ASSASIN LITL BOSS WB31312 MAMA S 9CM 6 BUC PLIC

SHAD BASS ASSASIN LITL BOSS WB31312 MAMA S 9CM 6 BUC PLIC

091538313120
Livrare imediată!

30,00Lei

HOOK ALIGNER MOSTIRO 10 BUC/PLIC
Exclusiv online!

HOOK ALIGNER MOSTIRO 10 BUC/PLIC

ai-rm161
Livrare 48-72 ore

4,30Lei

PLUTE MOSTIRO STAR RV 1+1 GR (10 BUC)
Exclusiv online!

PLUTE MOSTIRO STAR RV 1+1 GR (10 BUC)

2421310210010
Livrare 48-72 ore

69,00Lei

PLUTE MOSTIRO WAGGLER V OLT 3+4 GR (10 BUC)
Exclusiv online!

PLUTE MOSTIRO WAGGLER V OLT 3+4 GR (10 BUC)

2421350630040
Livrare 48-72 ore

79,00Lei

Agrafe duolock Noike Lure Snap nr.1 Nickel 18 buc/plic

Agrafe duolock Noike Lure Snap nr.1 Nickel 18 buc/plic

noik-snap-1
Livrare imediată!

8,00Lei

PLUTE CORNEL A 1GR(10 BUC)
Exclusiv online!

PLUTE CORNEL A 1GR(10 BUC)

2420140410000
Livrare 48-72 ore

38,00Lei

Twistere Profiblinker Turbotail 5 Cm Fluo Cu Gliter 10 Buc
Exclusiv online!

Twistere Profiblinker Turbotail 5 Cm Fluo Cu Gliter 10 Buc

30a9
Livrare 48-72 ore

21,90Lei

PLUTE MOSTIRO FIXA VIOLETA 1.5GR(10 BUC)
Exclusiv online!

PLUTE MOSTIRO FIXA VIOLETA 1.5GR(10 BUC)

2420220115000
Livrare 48-72 ore

38,00Lei

PLUTE MOSTIRO FIXA VICTOR N 1GR(10 BUC)
Exclusiv online!

PLUTE MOSTIRO FIXA VICTOR N 1GR(10 BUC)

2420210210000
Livrare 48-72 ore

38,00Lei

PLUTE MOSTIRO ANA 0.5GR 10 BUC
Exclusiv online!

PLUTE MOSTIRO ANA 0.5GR 10 BUC

2421130205000
Livrare 48-72 ore

38,00Lei

CARLIGE LEGATE STRATEGY GAMAKATSU COMBI POP UP 2 BUC NR 2
Exclusiv online!

CARLIGE LEGATE STRATEGY GAMAKATSU COMBI POP UP 2 BUC NR 2

008541-00602-00000
Livrare 48-72 ore

18,60Lei

Montura Extra Carp semi-fixa 5 buc

Montura Extra Carp semi-fixa 5 buc

ec6077
Livrare imediată!

13,99Lei

PLUTE MOSTIRO ANDREEA ALB 1.5GR 10 BUC
Exclusiv online!

PLUTE MOSTIRO ANDREEA ALB 1.5GR 10 BUC

2420010115000
Livrare 48-72 ore

38,00Lei

CARLIGE HAYABUSA OFFSET POWER STAGE NR 3/0 20 BUC -29%

CARLIGE HAYABUSA OFFSET POWER STAGE NR 3/0 20 BUC

7316
Livrare imediată!

35,00Lei(-29%) 24,89Lei

Shad 4Predators Slim Shad Floating 9 CM L005 Culoare Blue - Pearl 5 buc/plic

Shad 4Predators Slim Shad Floating 9 CM L005 Culoare Blue - Pearl 5 buc/plic

4p-ss9-l005
Livrare imediată!

10,00Lei

Afişare 1061 - 1080 din 2367 (119 pagini)
Queries: 5, Total time: 96.133 ms [By time] [By id] [By file]
1 (0.086)
SELECT data
FROM `oc_session`
WHERE session_id = '2909410f43189fcabb4da795d1'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.083)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (85.932)
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 = '2' AND (MATCH(pd.tag) AGAINST('+buc' 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 (9.914)
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 1060, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.118)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '2' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38