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


Pantaloni Scurti Fox Collection LW Jogger Short Green & Black, Marime L
Exclusiv online!

Pantaloni Scurti Fox Collection LW Jogger Short Green & Black, Marime L

ccl222
Livrare 7-14 zile

103,46Lei

Papuci Dry Walker HEX Open, Black 306, Marime 46

Papuci Dry Walker HEX Open, Black 306, Marime 46

150 / 46 / 306
Livrare imediată!

49,00Lei

Pluta Abu Garcia Bombarda Sink Float Stop, Black, 15g

Pluta Abu Garcia Bombarda Sink Float Stop, Black, 15g

1110089
Livrare imediată!

9,50Lei

Pluta Abu Garcia Bombarda Sink Float Stop, Black, 25g

Pluta Abu Garcia Bombarda Sink Float Stop, Black, 25g

1110091
Livrare imediată!

9,50Lei

Prosop Feeder Bait Black Yellow
Exclusiv online!

Prosop Feeder Bait Black Yellow

fb-prosop
Livrare 48-72 ore

79,00Lei

Rucsac Daiwa Black Widow Compact 52x32x35cm -23%

Rucsac Daiwa Black Widow Compact 52x32x35cm

d.18705.015
Livrare imediată!

261,21Lei(-23%) 200,99Lei

Sapcă Fox Black Snapback Hat

Sapcă Fox Black Snapback Hat

chh029
Livrare imediată!

94,46Lei

Sapca Garbolino Long Visor Squadra, Black/Blue
Exclusiv online!

Sapca Garbolino Long Visor Squadra, Black/Blue

81330govcm2024
Livrare 48-72 ore

62,90Lei

Shad Hide Up Stagger Original 2.5", 143 Watermelon Black Blue Flake, 6.6cm, 2.2g, 7buc/pac

Shad Hide Up Stagger Original 2.5", 143 Watermelon Black Blue Flake, 6.6cm, 2.2g, 7buc/pac

hide23392
Livrare imediată!

36,00Lei

Soarece Live Target Hollow Body Mouse Walking Bait, Black / White, 7cm, 14g -20%
Exclusiv online!

Soarece Live Target Hollow Body Mouse Walking Bait, Black / White, 7cm, 14g

lt.mhb70t403
Livrare 24-48 ore

40,23Lei(-20%) 32,18Lei

Spinnertail Mikado M-Tail 6g, Black Tiger
Exclusiv online!

Spinnertail Mikado M-Tail 6g, Black Tiger

pmmt-6-bt
Livrare 48-72 ore

24,00Lei

Struna DAM Effzett Coated 1x7 Black, 30cm, 20kg. 2buc/pac
Exclusiv online!

Struna DAM Effzett Coated 1x7 Black, 30cm, 20kg. 2buc/pac

a7.dam.56416
Livrare 24-48 ore

8,57Lei

TRICOU SAVAGE GEAR JUNIOR BLACK INK MARIME 12-14 Ani -20%

TRICOU SAVAGE GEAR JUNIOR BLACK INK MARIME 12-14 Ani

a8.sg.76687
Livrare imediată!

79,75Lei(-20%) 63,80Lei

Tricou Trakker CR Logo T-Shirt Black Camo, Marime 3XL

Tricou Trakker CR Logo T-Shirt Black Camo, Marime 3XL

207870
Livrare imediată!

114,95Lei

Vartej Filfishing Crane Swivel Black, nr.2/0, 75kg, 5buc/plic
Exclusiv online!

Vartej Filfishing Crane Swivel Black, nr.2/0, 75kg, 5buc/plic

fil9526
Livrare 48-72 ore

8,00Lei

Vobler Jackall TN60 Trigon, HS Impact Black, 6cm, 8.5g
Exclusiv online!

Vobler Jackall TN60 Trigon, HS Impact Black, 6cm, 8.5g

ja.807166262
Livrare 24-48 ore

111,24Lei

Vobler Live Target Frog Walking Bait, Brown / Black, 11.8cm, 25g -20%
Exclusiv online!

Vobler Live Target Frog Walking Bait, Brown / Black, 11.8cm, 25g

lt.fgw118t503
Livrare 24-48 ore

40,23Lei(-20%) 32,18Lei

Ancora VMC 7548 Black Nickel + Paleta Silver Nr.10, 3buc/pac
Exclusiv online!

Ancora VMC 7548 Black Nickel + Paleta Silver Nr.10, 3buc/pac

7548 bd10 x3
Livrare 48-72ore

39,00Lei

Broasca Live Target Hollow Body Frog Walking Bait, Brown / Black, 5.5cm, 18g -20%
Exclusiv online!

Broasca Live Target Hollow Body Frog Walking Bait, Brown / Black, 5.5cm, 18g

lt.fgh55t503
Livrare 24-48 ore

40,23Lei(-20%) 32,18Lei

Broasca Live Target Hollow Body Frog Walking Bait, Yellow / Black, 5.5cm, 18g -20%
Exclusiv online!

Broasca Live Target Hollow Body Frog Walking Bait, Yellow / Black, 5.5cm, 18g

lt.fgh55t501
Livrare 24-48 ore

40,23Lei(-20%) 32,18Lei

Afişare 721 - 740 din 4755 (238 pagini)
Queries: 5, Total time: 103.370 ms [By time] [By id] [By file]
1 (0.140)
SELECT data
FROM `oc_session`
WHERE session_id = 'af91ec9b4680ebfd46f2734bfd'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.118)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (102.791)
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.192)
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.129)
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