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


Shad Relax Kopyto 3inch Standard 7.5cm RKBLS3-S031 10 buc/plic

Shad Relax Kopyto 3inch Standard 7.5cm RKBLS3-S031 10 buc/plic

bls3-s031
Livrare imediată!

20,00Lei

CARLIGE TRABUCCO AKURA 250BR NR 2 15BUC/PLIC
Exclusiv online!

CARLIGE TRABUCCO AKURA 250BR NR 2 15BUC/PLIC

025-96-020
Livrare 48-72 ore

11,00Lei

Carlige VMC 7007 Black Nickel Nr.18 10buc/plic

Carlige VMC 7007 Black Nickel Nr.18 10buc/plic

7007 bn18
Livrare imediată!

12,99Lei

Carlige Fanatik FK-9115 No.12 Goby 8buc/plic
Exclusiv online!

Carlige Fanatik FK-9115 No.12 Goby 8buc/plic

120713fk911512
Livrare 48-72 ore

5,50Lei

Carlige Offset Worm Lucky John 350 nr 4/0 Black Nickel 5 buc/plic

Carlige Offset Worm Lucky John 350 nr 4/0 Black Nickel 5 buc/plic

ljh350-k040
Livrare imediată!

15,01Lei

CARLIGE TRABUCCO AKURA 9400 NR4 15BUC/PLIC
Exclusiv online!

CARLIGE TRABUCCO AKURA 9400 NR4 15BUC/PLIC

026-75-040
Livrare 48-72 ore

12,99Lei

RAPTURE FLEXY BOTTOM JIG 18g 3buc/plic
Exclusiv online!

RAPTURE FLEXY BOTTOM JIG 18g 3buc/plic

188-26-560
Livrare 48-72 ore

9,50Lei

CARLIGE TRABUCCO AKURA 535N NR 1 15BUC/PLIC
Exclusiv online!

CARLIGE TRABUCCO AKURA 535N NR 1 15BUC/PLIC

025-45-010
Livrare 48-72 ore

10,00Lei

Jig Rapture Power Jighead Football 10g Nr.4/0 3buc/plic
Exclusiv online!

Jig Rapture Power Jighead Football 10g Nr.4/0 3buc/plic

188-31-340
Livrare 48-72 ore

8,38Lei

MONTURA SAVAGE CARBON49 T-TREBLE SPIKE 1/0 11CM 2BUC/PLIC
Exclusiv online!

MONTURA SAVAGE CARBON49 T-TREBLE SPIKE 1/0 11CM 2BUC/PLIC

a7.sg.69779
Livrare 24-48 ore

42,66Lei

CARLIGE TRABUCCO AKURA 6001 NR 10 15BUC/PLIC

CARLIGE TRABUCCO AKURA 6001 NR 10 15BUC/PLIC

025-10-100
Livrare imediată!

7,00Lei

Shad Daiwa D.Fin, Chartreuse Tiger, 7.5cm, 10buc/plic

Shad Daiwa D.Fin, Chartreuse Tiger, 7.5cm, 10buc/plic

d.16502.508
Livrare imediată!

31,62Lei

SHAD JAXON INTENSA BRAVO 7CM I 5buc/plic
Exclusiv online!

SHAD JAXON INTENSA BRAVO 7CM I 5buc/plic

tg-inf070i
Livrare 48-72 ore

13,99Lei

Shad Manns 12Cm culoare BFT 5buc/plic

Shad Manns 12Cm culoare BFT 5buc/plic

88015643
Livrare imediată!

11,00Lei

SHAD SAVAGE LB 4D HERRING 11CM/9G/PERCH 4BUC/PLIC
Exclusiv online!

SHAD SAVAGE LB 4D HERRING 11CM/9G/PERCH 4BUC/PLIC

f1.sg.63658
Livrare 24-48 ore

38,01Lei

SOFT BAIT SENSAS GUNKI PEPS DARK WATER KIT II 9CM 4BUC/PLIC
Exclusiv online!

SOFT BAIT SENSAS GUNKI PEPS DARK WATER KIT II 9CM 4BUC/PLIC

f1.spm.32871
Livrare 24-48 ore

19,64Lei

Rac Nomura Baby Creature Glowing Ghost 4cm 8buc/plic
Exclusiv online!

Rac Nomura Baby Creature Glowing Ghost 4cm 8buc/plic

f1.nm.73203204
Livrare 24-48 ore

23,60Lei

Carlig Fanatik FK-1092 No.11 Aji-Feeder 8buc/plic

Carlig Fanatik FK-1092 No.11 Aji-Feeder 8buc/plic

120113fk109211
Livrare imediată!

5,50Lei

ANCORE ENERGOTEAM WIZARD GRIZZLY 954M-1 3X BRONZ NR.10 6buc/plic

ANCORE ENERGOTEAM WIZARD GRIZZLY 954M-1 3X BRONZ NR.10 6buc/plic

49954010
Livrare imediată!

12,50Lei

CARLIGE TRABUCCO XPS 710XB nr 8 25 BUC/PLIC
Exclusiv online!

CARLIGE TRABUCCO XPS 710XB nr 8 25 BUC/PLIC

021-70-080
Livrare 48-72 ore

16,01Lei

Afişare 4601 - 4620 din 10434 (522 pagini)
Queries: 5, Total time: 744.933 ms [By time] [By id] [By file]
1 (0.110)
SELECT data
FROM `oc_session`
WHERE session_id = '413bff130ed1ba3b06ff79c46e'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.089)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (706.087)
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 "%buc/plic%") 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 (38.511)
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 4600, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.136)
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