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 - cahkbr54

Produse ce potrivesc criteriilor de căutare


Swimbait Biwaa Spinjet 13cm, 30g, culoare 48 Aquabonita -21%

Swimbait Biwaa Spinjet 13cm, 30g, culoare 48 Aquabonita

b001608
Livrare imediată!

49,00Lei(-21%) 38,90Lei

Swimbait Biwaa Spinjet 13cm, 30g, culoare 28 Gold Pearch
Exclusiv online!

Swimbait Biwaa Spinjet 13cm, 30g, culoare 28 Gold Pearch

b001607
Livrare 48-72 ore

49,00Lei

Swimbait Fox Rage GIANT REPLICANT WOBBLE 27cm 218g Stickleback UV
Exclusiv online!

Swimbait Fox Rage GIANT REPLICANT WOBBLE 27cm 218g Stickleback UV

nre070
Livrare 7-14 zile

80,96Lei

Swimbait Biwaa Spinjet 13cm, 30g, culoare 12 Fire Tiger

Swimbait Biwaa Spinjet 13cm, 30g, culoare 12 Fire Tiger

b001605
Livrare imediată!

49,00Lei

NALUCA SAVAGE GEAR 4D TROUT SPIN 11CM/40G MS 02
Exclusiv online!

NALUCA SAVAGE GEAR 4D TROUT SPIN 11CM/40G MS 02

f1.sg.57415
Livrare 24-48 ore

48,60Lei

Swimbait Fox Rage REPLICANT REALISTIC PIKE 10cm 14g Super Natural Pike -20%

Swimbait Fox Rage REPLICANT REALISTIC PIKE 10cm 14g Super Natural Pike

nre071
Stoc epuizat

26,79Lei(-20%) 21,43Lei

SHAD SAVAGE 4D TROUT RATTLE 12,5CM/35G MS02
Exclusiv online!

SHAD SAVAGE 4D TROUT RATTLE 12,5CM/35G MS02

f1.sg.57406
Livrare 24-48 ore

39,64Lei

SWIMBAIT SAVAGE GEAR 3D HARD PIKE 20CM/59G ALBINO PIKE -20%
Exclusiv online!

SWIMBAIT SAVAGE GEAR 3D HARD PIKE 20CM/59G ALBINO PIKE

f1.sg.71474
Livrare 24-48 ore

91,13Lei(-20%) 72,90Lei

Vobler Swimbait Biwaa Swimbass Real Bass 15cm 65g
Exclusiv online!

Vobler Swimbait Biwaa Swimbass Real Bass 15cm 65g

b001739
Livrare 48-72 ore

108,00Lei

Vobler Biwaa Swimbait Seven Section Arctic Tiger 10cm 17g

Vobler Biwaa Swimbait Seven Section Arctic Tiger 10cm 17g

b001547
Livrare imediată!

110,00Lei

SWIMBAIT SAVAGE GEAR 3D HARD PIKE 20CM/59G RED BELLY PIKE -20%
Exclusiv online!

SWIMBAIT SAVAGE GEAR 3D HARD PIKE 20CM/59G RED BELLY PIKE

f1.sg.71475
Livrare 24-48 ore

91,13Lei(-20%) 72,90Lei

SWIMBAIT Biwaa SPINJET 10cm 18gr 48 Aquabonita
Exclusiv online!

SWIMBAIT Biwaa SPINJET 10cm 18gr 48 Aquabonita

b001658
Livrare 48-72 ore

52,00Lei

SWIMBAIT MAGIC JAXON FISH PIKE 10CM 17GR B
Exclusiv online!

SWIMBAIT MAGIC JAXON FISH PIKE 10CM 17GR B

tx-m10b
Livrare 48-72 ore

78,00Lei

SWIMBAIT Biwaa SPINJET 10cm 18gr 12 Fire Tiger
Exclusiv online!

SWIMBAIT Biwaa SPINJET 10cm 18gr 12 Fire Tiger

b001655
Livrare 48-72 ore

52,00Lei

Swimbait Biwaa Spinjet 5 Rainbow 13cm 30g 1buc
Exclusiv online!

Swimbait Biwaa Spinjet 5 Rainbow 13cm 30g 1buc

b001618
Livrare 48-72 ore

49,00Lei

Swimbait Biwaa Spinjet 5 Sexy Shad 13cm 30g 1buc
Exclusiv online!

Swimbait Biwaa Spinjet 5 Sexy Shad 13cm 30g 1buc

b001619
Livrare 48-72 ore

49,00Lei

Swimbait Biwaa Spinjet 5 Ayu 13cm 30g 1buc
Exclusiv online!

Swimbait Biwaa Spinjet 5 Ayu 13cm 30g 1buc

b001617
Livrare 48-72 ore

49,00Lei

SWIMBAIT SAVAGE GEAR 4D PERCH SHAD 12.5CM/23G LEMON SS05

SWIMBAIT SAVAGE GEAR 4D PERCH SHAD 12.5CM/23G LEMON SS05

f1.sg.71466
Livrare imediată!

36,54Lei

Swimbait Fox Rage Replicat Wobble Zebra UV 7.5cm 10g

Swimbait Fox Rage Replicat Wobble Zebra UV 7.5cm 10g

nre086
Livrare imediată!

33,71Lei

Swimbait Fox Rage Replicant REALISTIC TROUT JOINTED SHALLOW 23cm 158g Super Natural Rainbow Trou
Exclusiv online!

Swimbait Fox Rage Replicant REALISTIC TROUT JOINTED SHALLOW 23cm 158g Super Natural Rainbow Trou

nre063
Livrare 7-14 zile

80,96Lei

Afişare 141 - 160 din 323 (17 pagini)
Queries: 5, Total time: 13.620 ms [By time] [By id] [By file]
1 (0.107)
SELECT data
FROM `oc_session`
WHERE session_id = '30cd56a7f399e7fcb1d4bf1096'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.126)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (11.737)
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('+swimbaits' 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 (1.500)
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 140, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.150)
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