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


Jig Fudo Bila BN black nickel nr.3/0 21gr 7buc/plic

Jig Fudo Bila BN black nickel nr.3/0 21gr 7buc/plic

jfb-3/0-021
Livrare imediată!

15,01Lei

Jig Fudo Bila BN black nickel nr.2/0 14gr 7buc/plic

Jig Fudo Bila BN black nickel nr.2/0 14gr 7buc/plic

jfb-2/0-014
Livrare imediată!

15,01Lei

CARLIG FUDO RYUSEN TWO SLICED BN (black nickel) Nr.14 18buc/plic -20%

CARLIG FUDO RYUSEN TWO SLICED BN (black nickel) Nr.14 18buc/plic

2901-14
Livrare imediată!

10,00Lei(-20%) 8,00Lei

Vartej VMC black nickel nr.6 23kg 12buc/plic
Exclusiv online!

Vartej VMC black nickel nr.6 23kg 12buc/plic

3540 bk6 x12
Livrare 48-72ore

9,00Lei

CREATURA SAVAGE GEAR 3D CRAYFISH RATTLING 5.5CM 1.6G BLUE BLACK -40%
Exclusiv online!

CREATURA SAVAGE GEAR 3D CRAYFISH RATTLING 5.5CM 1.6G BLUE BLACK

f1.sg.72592
Livrare 24-48 ore

31,23Lei(-40%) 18,74Lei

Grub Rapture Fun Tail Grub 3.3 Black Pumpkin
Exclusiv online!

Grub Rapture Fun Tail Grub 3.3 Black Pumpkin

188-00-786
Livrare 48-72 ore

20,00Lei

JIG SUMATO BLACK SLIM 3/0-12GR 3/plic

JIG SUMATO BLACK SLIM 3/0-12GR 3/plic

gj-sd3/012b
Livrare imediată!

13,49Lei

BUZZBAR KORDA ALUMINIU PT.2 LANSETE 16.5CM BLACK
Exclusiv online!

BUZZBAR KORDA ALUMINIU PT.2 LANSETE 16.5CM BLACK

a.ksing25
Livrare 24-48 ore

194,73Lei

Tricou polo Gamakatsu Black marime M -20%
Exclusiv online!

Tricou polo Gamakatsu Black marime M

a8.gk.7278.200
Livrare 24-48 ore

113,53Lei(-20%) 90,82Lei

JIG JAXON SUMATO BLACK SLIM MICRO 4-6GR 3buc/plic

JIG JAXON SUMATO BLACK SLIM MICRO 4-6GR 3buc/plic

gj-sc0406
Livrare imediată!

12,00Lei

Vartej VMC black nickel nr.12 14kg 16buc/plic
Exclusiv online!

Vartej VMC black nickel nr.12 14kg 16buc/plic

3540 bk12 x16
Livrare 48-72ore

9,00Lei

CARLIGE FUDO CATFISH CATS BN black nickel Nr.9/0 3buc/plic -50%

CARLIGE FUDO CATFISH CATS BN black nickel Nr.9/0 3buc/plic

6901-9/0
Livrare imediată!

24,00Lei(-50%) 12,00Lei

JIG SUMATO BLACK SLIM 3/0-8GR 3/plic

JIG SUMATO BLACK SLIM 3/0-8GR 3/plic

gj-sd3/008b
Livrare imediată!

12,99Lei

Vartej VMC black nickel nr.10 15kg 15 buc/plic
Exclusiv online!

Vartej VMC black nickel nr.10 15kg 15 buc/plic

3540 bk10 x15
Livrare 48-72ore

9,00Lei

JIG SUMATO BLACK SLIM 2/0-10GR 3/plic -21%

JIG SUMATO BLACK SLIM 2/0-10GR 3/plic

gj-sd2/010b
Livrare imediată!

11,50Lei(-21%) 9,04Lei

Jig Fudo Bila BN black nickel nr.3/0 14gr 7buc/plic

Jig Fudo Bila BN black nickel nr.3/0 14gr 7buc/plic

jfb-3/0-014
Livrare imediată!

15,01Lei

JIG JAXON TANAMI MICRO BLACK NICKEL 2GR 10BUC

JIG JAXON TANAMI MICRO BLACK NICKEL 2GR 10BUC

gj-xc28
Livrare imediată!

42,00Lei

Micro Jig Fudo Bila nr.3/0 BN black nickel 3.5gr 7buc/plic

Micro Jig Fudo Bila nr.3/0 BN black nickel 3.5gr 7buc/plic

mjfb-3/0-035
Livrare imediată!

15,01Lei

Micro Jig Fudo Bila nr.1/0 BN black nickel 3.5g 8buc/plic

Micro Jig Fudo Bila nr.1/0 BN black nickel 3.5g 8buc/plic

mjfb-1/0-035
Livrare imediată!

15,01Lei

Vartej VMC black nickel nr.4 24kg 10buc/plic
Exclusiv online!

Vartej VMC black nickel nr.4 24kg 10buc/plic

3540 bk4 x10
Livrare 48-72ore

9,00Lei

Afişare 2001 - 2020 din 4758 (238 pagini)
Queries: 8, Total time: 100.030 ms [By time] [By id] [By file]
1 (0.081)
SELECT data
FROM `oc_session`
WHERE session_id = 'ec202779c5329abc0b6792107b'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.076)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (99.252)
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('+black' 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.151)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"RAPALA VMC ROMANIA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
5 (0.126)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"RAPALA VMC ROMANIA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
6 (0.122)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"RAPALA VMC ROMANIA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
7 (0.124)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"RAPALA VMC ROMANIA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
8 (0.098)
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