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


Lingurita Rotativa Savage Gear Spinner Sticklebait, Sinking, Firetiger Gold, Nr.1, 4.5g
Exclusiv online!

Lingurita Rotativa Savage Gear Spinner Sticklebait, Sinking, Firetiger Gold, Nr.1, 4.5g

sg.82235
Livrare 24-48 ore

28,60Lei

Shad Hide Up Stagger Original 2", 111 Chart Green Gold Flake, 5.9cm, 8buc/pac

Shad Hide Up Stagger Original 2", 111 Chart Green Gold Flake, 5.9cm, 8buc/pac

hide23224
Livrare imediată!

35,00Lei

Shad Hide Up Stagger Original 3" Salt, S-05 Motor Oil Gold Flake, 7.6cm, 4.5 g, 10buc/pac

Shad Hide Up Stagger Original 3" Salt, S-05 Motor Oil Gold Flake, 7.6cm, 4.5 g, 10buc/pac

hide24276
Livrare imediată!

40,00Lei

Shad Konger Blinky, 022 Glitter Gold, 7.5cm, 8buc/pac
Exclusiv online!

Shad Konger Blinky, 022 Glitter Gold, 7.5cm, 8buc/pac

130106337001022
Livrare 48-72 ore

15,93Lei

Vobler IMA Raikiri Vibration 60, 011 Gold Mullet, 6.0cm, 11.0g

Vobler IMA Raikiri Vibration 60, 011 Gold Mullet, 6.0cm, 11.0g

rk60-011
Livrare imediată!

72,99Lei

Vobler IMA Raikiri Vibration 70, 010 Gold Chart Sardines, 7.0cm, 15.0g

Vobler IMA Raikiri Vibration 70, 010 Gold Chart Sardines, 7.0cm, 15.0g

rk70-010
Livrare imediată!

72,99Lei

Vobler IMA Sukari 50SS Deep, 102 Gold Black, 5.0cm, 5.0g

Vobler IMA Sukari 50SS Deep, 102 Gold Black, 5.0cm, 5.0g

su50d-102
Livrare imediată!

87,00Lei

Vobler Jackall Soul Flat 58SF SP, Double Clucth Gold & Black, 5.8cm, 6.8g
Exclusiv online!

Vobler Jackall Soul Flat 58SF SP, Double Clucth Gold & Black, 5.8cm, 6.8g

ja.807205480
Livrare 24-48 ore

107,98Lei

Vobler Mustad Vertebrata Sink Pencil, Gold Pearl Chart, 9.3cm, 16g
Exclusiv online!

Vobler Mustad Vertebrata Sink Pencil, Gold Pearl Chart, 9.3cm, 16g

f3.mtsp.vtb.gpct.90
Livrare 24-48 ore

55,39Lei

Vobler Mustad Vertebrata Sink Pencil, Red Gold, 9.3cm, 16g
Exclusiv online!

Vobler Mustad Vertebrata Sink Pencil, Red Gold, 9.3cm, 16g

f3.mtsp.vtb.rg.90
Livrare 24-48 ore

55,39Lei

Voblerul Duo Realis Crank 48MR Kabuki Floating, Metal Black Gold, 4.8cm, 10.5g

Voblerul Duo Realis Crank 48MR Kabuki Floating, Metal Black Gold, 4.8cm, 10.5g

duo50273
Livrare imediată!

69,00Lei

Carlige Mikado Sensual Chinu Gold, Nr.6, 10buc/plic
Exclusiv online!

Carlige Mikado Sensual Chinu Gold, Nr.6, 10buc/plic

hs10024-6g
Livrare 48-72 ore

6,00Lei

CARLIGE MIKADO SENSUAL SODE Nr.12 Gold 10buc/plic
Exclusiv online!

CARLIGE MIKADO SENSUAL SODE Nr.12 Gold 10buc/plic

hs10004-12g
Livrare 48-72 ore

6,00Lei

Grub Hide Up Stagger Wide 2", 111 Chart Green Gold Flake, 5.9cm, 8buc/pac

Grub Hide Up Stagger Wide 2", 111 Chart Green Gold Flake, 5.9cm, 8buc/pac

hide19173
Livrare imediată!

41,00Lei

Grub Hide Up Stagger Wide 3.3", 111 Chart Green Gold Flake, 8.4cm, 5buc/pac

Grub Hide Up Stagger Wide 3.3", 111 Chart Green Gold Flake, 8.4cm, 5buc/pac

hide19425
Livrare imediată!

41,00Lei

Lingurita Oscilanta Live Target Erratic Shine Sinking, 6cm, 14g, Gold / Black
Exclusiv online!

Lingurita Oscilanta Live Target Erratic Shine Sinking, 6cm, 14g, Gold / Black

f3.lt.ess60sk208
Livrare 24-48 ore

42,88Lei

Lingurita Oscilanta Live Target Flutter Shad Sinking, Gold / Green, 7cm, 28g
Exclusiv online!

Lingurita Oscilanta Live Target Flutter Shad Sinking, Gold / Green, 7cm, 28g

f3.lt.fsj70sk204
Livrare 24-48 ore

47,17Lei

Lingurita Rotativa Savage Gear Spinner Grub, Sinking, Gold Black, Nr.2, 5.8g
Exclusiv online!

Lingurita Rotativa Savage Gear Spinner Grub, Sinking, Gold Black, Nr.2, 5.8g

sg.82469
Livrare 24-48 ore

22,78Lei

Oscilanta Bleak Nr.2/15G/9Cm Gold
Exclusiv online!

Oscilanta Bleak Nr.2/15G/9Cm Gold

pmb-wbk-15-z
Livrare 48-72 ore

8,00Lei

Oscilanta Dancer Nr 2 / 10 G / 5.6 Cm - Gold
Exclusiv online!

Oscilanta Dancer Nr 2 / 10 G / 5.6 Cm - Gold

pmb-wda-10-z
Livrare 48-72 ore

8,00Lei

Afişare 241 - 260 din 1291 (65 pagini)
Queries: 5, Total time: 33.540 ms [By time] [By id] [By file]
1 (0.119)
SELECT data
FROM `oc_session`
WHERE session_id = '1a7106886016a06fbd265ced57'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.127)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (27.975)
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 (MATCH(pd.tag) AGAINST('+gold' 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 (5.200)
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 240, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.119)
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