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 300 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 - Orange

Produse ce potrivesc criteriilor de căutare


Fir Berkley Whiplash8, Green, 10.7kg, 0.14mm, 150m -15%

Fir Berkley Whiplash8, Green, 10.7kg, 0.14mm, 150m

1579684
Livrare imediată!

112,50Lei(-15%) 96,00Lei

Fir Berkley Whiplash8, Green, 17.6kg, 0.12mm, 150m

Fir Berkley Whiplash8, Green, 17.6kg, 0.12mm, 150m

1579683
Livrare imediată!

112,46Lei

LINGURITA ROTATIVA YARIE 672 BLENDER SP3 GREEN/GOLD 2.1G
Exclusiv online!

LINGURITA ROTATIVA YARIE 672 BLENDER SP3 GREEN/GOLD 2.1G

y67221sp3
Livrare 48-72 ore

39,00Lei

Cort Sloar Quick Up Shelter Green MkII With Heavy Duty Ground Sheet, 2.50x2.05x1.70cm -10%

Cort Sloar Quick Up Shelter Green MkII With Heavy Duty Ground Sheet, 2.50x2.05x1.70cm

bv01mk2
Livrare imediată!

2.369,80Lei(-10%) 2.132,83Lei

ELASTIC PRESTON HOLLO 13H 3M Green
Exclusiv online!

ELASTIC PRESTON HOLLO 13H 3M Green

hel13
Livrare 7-14 zile

67,46Lei

Fir, Textil, Berkley, Sick, Braid,, Moss, Green,, 150m,, 0.23mm,, 23.6kg, 1558729, Fire Textile Rapitori, Fire Textile Rapitori Berkley, Berkley
Fir, Textil, Varivas, Absolute, Premium, PE, X8, Marking, Green,, 150m,, 0.148mm,, 16lb, v23515008, Fire Textile Rapitori, Fire Textile Rapitori Varivas, Varivas
Grub Hide Up Stagger Wide 4", 104 Green Pumpkin Gold Flake, 10.2cm, 4buc/pac
Exclusiv online!

Grub Hide Up Stagger Wide 4", 104 Green Pumpkin Gold Flake, 10.2cm, 4buc/pac

hide17582
Livrare 48-72 ore

41,00Lei

Plumb DKS Pear Inline Camo Green Brown 70g 2buc/plic

Plumb DKS Pear Inline Camo Green Brown 70g 2buc/plic

fpi70
Livrare imediată!

12,03Lei

Shad, Savage, Gear, Fat, Minnow, T-Tail,, Green, Pearl, Yellow,, 10.5cm,, 11g,, 5buc/pac, f1.sg.76995, Shad-uri, Shad-uri Savage Gear, Savage Gear -40%
Exclusiv online!

Shad, Savage, Gear, Fat, Minnow, T-Tail,, Green, Pearl, Yellow,, 10.5cm,, 11g,, 5buc/pac, f1.sg.76995, Shad-uri, Shad-uri Savage Gear, Savage Gear

f1.sg.76995
Livrare 24-48 ore

40,48Lei(-40%) 24,29Lei

Shad, Savage, Gear, Fat, Minnow, T-Tail,, Green, Pearl, Yellow,, 13cm,, 20g,, 5buc/pac, f1.sg.77001, Shad-uri, Shad-uri Savage Gear, Savage Gear -40%
Exclusiv online!

Shad, Savage, Gear, Fat, Minnow, T-Tail,, Green, Pearl, Yellow,, 13cm,, 20g,, 5buc/pac, f1.sg.77001, Shad-uri, Shad-uri Savage Gear, Savage Gear

f1.sg.77001
Livrare 24-48 ore

51,90Lei(-40%) 31,14Lei

FIR CLIMAX TEXTIL IBRAID DIVE OLIVE GREEN, 0.10mm, 275m
Exclusiv online!

FIR CLIMAX TEXTIL IBRAID DIVE OLIVE GREEN, 0.10mm, 275m

9431-10275-010
Livrare 48-72 ore

180,00Lei

Fir Textil Nash Extra Supple Braid, Low Viz Green, 18.14kg, 40lbs, 0.35mm, 1200m
Exclusiv online!

Fir Textil Nash Extra Supple Braid, Low Viz Green, 18.14kg, 40lbs, 0.35mm, 1200m

t6023
Livrare 7-14 zile

783,95Lei

Line Aligner Strategy Pole Position Fixaligner Short, Weedy Green, 10buc/plic -28%

Line Aligner Strategy Pole Position Fixaligner Short, Weedy Green, 10buc/plic

008036-00700-00000
Livrare imediată!

24,70Lei(-28%) 17,90Lei

Nada, Senzor, Top, Amix, Competitie,, Green,, 1kg, snz99312, Nada (Groundbait), Nada (Groundbait) Senzor, Senzor
Broasca Live Target Freestyle Frog, Floro Green / Yellow, 7.5cm, 2buc/pac
Exclusiv online!

Broasca Live Target Freestyle Frog, Floro Green / Yellow, 7.5cm, 2buc/pac

f1.lt.fsf75t512
Livrare 24-48 ore

42,88Lei

Broasca, Live, Target, Hollow, Body, Frog, Walking, Bait,, Floro, Green, /, Yellow,, 5.5cm,, 18g, lt.fgh55t512, Broaste Artificiale, Broaste Artificiale Live Target, Live Target -20%
Con Trakker Anti Tangle Sleeve Large, Green, 10buc/plic
Exclusiv online!

Con Trakker Anti Tangle Sleeve Large, Green, 10buc/plic

228256
Livrare 7-14 zile

19,94Lei

Croseta pt. Boilies Gamakatsu Pole Position Pointed Needle Green
Exclusiv online!

Croseta pt. Boilies Gamakatsu Pole Position Pointed Needle Green

a.gk.8036.618
Livrare 24-48 ore

21,27Lei

ELASTIC PRESTON DURA HOLLO H10 3M Green
Exclusiv online!

ELASTIC PRESTON DURA HOLLO H10 3M Green

held10
Livrare 7-14 zile

85,47Lei

Afişare 361 - 380 din 2812 (141 pagini)
Queries: 9, Total time: 243.077 ms [By time] [By id] [By file]
1 (0.139)
SELECT data
FROM `oc_session`
WHERE session_id = '17cba6c94540129eb408df0e8c'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.142)
SELECT *
FROM oc_platforma_promovari LIMIT 1
/var/www/clients/client1/web1/web/index.php:128
3 (0.103)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:422
4 (0.126)
SELECT *
FROM oc_url_alias
WHERE keyword = 'search'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
5 (230.551)
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` GROUP BY tax_class_id) AS tx ON (p.tax_class_id = tx.tax_class_id)
WHERE p2s.store_id = '0' AND (pd.tag LIKE "%green%") 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:698
6 (11.716)
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 360, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
7 (0.138)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
8 (0.080)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
9 (0.082)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '0' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38