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


SHAD DAIWA D.SWIM 14CM PRO GREEN/4BUC

SHAD DAIWA D.SWIM 14CM PRO GREEN/4BUC

d.16506.114
Livrare imediată!

25,64Lei

Fir Cormoran Textil CoraStrong 8Braid, Green, 035MM/37,5KG/135M

Fir Cormoran Textil CoraStrong 8Braid, Green, 035MM/37,5KG/135M

c.32.8013535
Livrare imediată!

35,14Lei

PLUTA MOSTIRO WAGGLER GREEN FV 3+5 GR

PLUTA MOSTIRO WAGGLER GREEN FV 3+5 GR

2421300630050-bucxxx
Livrare imediată!

9,00Lei

CONURI SPRO C-TEC ANTITANLE SLEEVE GREEN 8BUC

CONURI SPRO C-TEC ANTITANLE SLEEVE GREEN 8BUC

008620-00016-00000
Livrare imediată!

7,40Lei

Shad Armored Craw 10cm 04 Green Pumpkin 6/plic
Exclusiv online!

Shad Armored Craw 10cm 04 Green Pumpkin 6/plic

b000448
Livrare 48-72 ore

25,00Lei

ATA MATISAJ FUJI DULL A-NOCP 100m 50 NEON GREEN 503
Exclusiv online!

ATA MATISAJ FUJI DULL A-NOCP 100m 50 NEON GREEN 503

mftnpa0503
Livrare 48-72 ore

21,00Lei

FIR TEXTIL WFT STRONG GREEN 300M 0.22mm 32kg
Exclusiv online!

FIR TEXTIL WFT STRONG GREEN 300M 0.22mm 32kg

30441322
Livrare 24-48 ore

352,00Lei

Shad Noike Ninja 4inch 10.2cm 01 Green Pumpkin 6 buc
Exclusiv online!

Shad Noike Ninja 4inch 10.2cm 01 Green Pumpkin 6 buc

noik-ninj4-01
Livrare 48-72ore

28,00Lei

FIR TEXTIL SPRO GOT BRAID GREEN 0.10MM 150M SPIDERWIRE
Exclusiv online!

FIR TEXTIL SPRO GOT BRAID GREEN 0.10MM 150M SPIDERWIRE

005300-00110-00000
Livrare 48-72 ore

72,00Lei

HYPERVIBE COLMIC 3.5" 8.9cm PLUM GREEN FLK -40%
Exclusiv online!

HYPERVIBE COLMIC 3.5" 8.9cm PLUM GREEN FLK

arhkdt06
Livrare 48-72 ore

39,00Lei(-40%) 23,40Lei

Mansoane Protectie The One Heli Buffer Green 10buc -20%
Exclusiv online!

Mansoane Protectie The One Heli Buffer Green 10buc

79017961
Livrare 24-48 ore

13,99Lei(-20%) 11,20Lei

Fir ASSO Ultra Molecular Shield Dark Green 0.31mm 300m
Exclusiv online!

Fir ASSO Ultra Molecular Shield Dark Green 0.31mm 300m

602080013
Livrare 48-72 ore

44,30Lei

Fir Cormoran Textil CoraStrong 8Braid, Green, 025MM/18,8KG/135M

Fir Cormoran Textil CoraStrong 8Braid, Green, 025MM/18,8KG/135M

c.32.8013525
Livrare imediată!

35,14Lei

FIR TEXTIL WFT STRONG GREEN 150M 0.18mm 22kg
Exclusiv online!

FIR TEXTIL WFT STRONG GREEN 150M 0.18mm 22kg

30441118
Livrare 24-48 ore

159,00Lei

Shad Bait Biwaa Armored Craw 10cm culoare 03 Orange/Green
Exclusiv online!

Shad Bait Biwaa Armored Craw 10cm culoare 03 Orange/Green

b000397
Livrare 48-72 ore

25,00Lei

Pelete De Carlig Dynamite Baits Swim Stim Durable Hook Pellets 6mm Betanine Green

Pelete De Carlig Dynamite Baits Swim Stim Durable Hook Pellets 6mm Betanine Green

dy1431
Livrare imediată!

28,00Lei

Fir monofilament Kryston Snyde Premium Green 0.35mm 1000m
Exclusiv online!

Fir monofilament Kryston Snyde Premium Green 0.35mm 1000m

krsny3
Livrare 48-72 ore

96,00Lei

Fir ASSO Ultra Molecular Shield Dark Green 0.28mm 150m
Exclusiv online!

Fir ASSO Ultra Molecular Shield Dark Green 0.28mm 150m

604080027
Livrare 48-72 ore

24,95Lei

Line Aligner DAM MAD Line Aligner 7-10 Green Short

Line Aligner DAM MAD Line Aligner 7-10 Green Short

4070952174
Livrare imediată!

24,54Lei

Fir ASSO Hard Skin Siliconed Green 0.28mm 300m

Fir ASSO Hard Skin Siliconed Green 0.28mm 300m

607080024
Livrare imediată!

42,57Lei

Afişare 1161 - 1180 din 2791 (140 pagini)
Queries: 6, Total time: 79.987 ms [By time] [By id] [By file]
1 (0.127)
SELECT data
FROM `oc_session`
WHERE session_id = 'd353003f7f0f116a84cebfd9ff'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.099)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (67.580)
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('+green' 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 (11.881)
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 1160, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.131)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"TACKLE SHOP ARENA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
6 (0.169)
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