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


Monofilament Nevis Sensor Fluo 600m 0.25mm

Monofilament Nevis Sensor Fluo 600m 0.25mm

3201-625
Livrare imediată!

36,00Lei

Lingura Rotativa 4gr DAM Effzett Fluo Trio
Exclusiv online!

Lingura Rotativa 4gr DAM Effzett Fluo Trio

803090050
Livrare 48-72 ore

12,99Lei

POP-UP FLUO TUTTI FRUTTI 10MM MAINLINE
Exclusiv online!

POP-UP FLUO TUTTI FRUTTI 10MM MAINLINE

a0.m.m13009
Livrare 24-48 ore

54,12Lei

Tub Antinod Cralusso fluo 120mm 3buc 3101

Tub Antinod Cralusso fluo 120mm 3buc 3101

82075812
Livrare imediată!

8,00Lei

FIR TEXTIL JAXON MONOLITH FLUO 125m 0.20mm
Exclusiv online!

FIR TEXTIL JAXON MONOLITH FLUO 125m 0.20mm

zj-gof020g
Livrare 48-72 ore

110,00Lei

Oscilanta Madcat A-Static Rattlin Spoons 110gr Fluo Yellow UV
Exclusiv online!

Oscilanta Madcat A-Static Rattlin Spoons 110gr Fluo Yellow UV

13083166121
Livrare 48-72 ore

85,97Lei

FIR TEXTIL JAXON MONOLITH FLUO 125m 0.22mm
Exclusiv online!

FIR TEXTIL JAXON MONOLITH FLUO 125m 0.22mm

zj-gof022g
Livrare 48-72 ore

110,00Lei

TWISTERE PROFIBLINKER ZANDERTAIL 5CM FLUO CU SCLIPICI 5 BUC/PLIC

TWISTERE PROFIBLINKER ZANDERTAIL 5CM FLUO CU SCLIPICI 5 BUC/PLIC

31d9
Livrare imediată!

17,70Lei

Fir Monofilament Carbotex Matrix Fluo Galben, 1000m 0.35mm/15.45kg
Exclusiv online!

Fir Monofilament Carbotex Matrix Fluo Galben, 1000m 0.35mm/15.45kg

e.1000.035
Livrare 24-48 ore

30,90Lei

FIR MONO CARP ZOOM MARSHAL ORIGO CARP LINE 1000M 0.37mm 10.40kg Fluo Orange -25%

FIR MONO CARP ZOOM MARSHAL ORIGO CARP LINE 1000M 0.37mm 10.40kg Fluo Orange

cz6971
Livrare imediată!

72,99Lei(-25%) 54,80Lei

Fir textil YGK X-Braid X8 Upgrade PE Fluo Green 0.26mm 20.41kg 200m
Exclusiv online!

Fir textil YGK X-Braid X8 Upgrade PE Fluo Green 0.26mm 20.41kg 200m

x00725
Livrare 48-72ore

180,00Lei

Fir ASSO Ultra Cast Verde Fluo 0.22mm 150m
Exclusiv online!

Fir ASSO Ultra Cast Verde Fluo 0.22mm 150m

603080006
Livrare 48-72 ore

16,86Lei

FIR MONO CARP ZOOM MARSHAL ORIGO CARP LINE 1000M 0.28mm 6.40kg Fluo Pink -44%

FIR MONO CARP ZOOM MARSHAL ORIGO CARP LINE 1000M 0.28mm 6.40kg Fluo Pink

cz7008
Livrare imediată!

65,00Lei(-44%) 36,65Lei

TUB ANTITANGLE CARP EXPERT FLUO 7.5CM
Exclusiv online!

TUB ANTITANGLE CARP EXPERT FLUO 7.5CM

79018907
Livrare 24-48 ore

7,00Lei

Fir ASSO Ultra Cast Galben Fluo 0.30mm

Fir ASSO Ultra Cast Galben Fluo 0.30mm

602080004
Livrare imediată!

36,13Lei

FIR ENERGOTEAM MONOFILAMENT CARP HUNTER FLUO 150M 0.35mm 13.90kg

FIR ENERGOTEAM MONOFILAMENT CARP HUNTER FLUO 150M 0.35mm 13.90kg

30042135
Livrare imediată!

9,50Lei

FIR MONO CARP ZOOM MARSHAL ORIGO CARP LINE 1000M 0.23mm 4.80kg Fluo Pink -25%

FIR MONO CARP ZOOM MARSHAL ORIGO CARP LINE 1000M 0.23mm 4.80kg Fluo Pink

cz6988
Livrare imediată!

65,00Lei(-25%) 48,80Lei

Monofilament Nevis Sensor Fluo 300m 0.22mm

Monofilament Nevis Sensor Fluo 300m 0.22mm

3201-322
Livrare imediată!

19,00Lei

Porumb Flotant Carp Spirit Fluo - Galben 10Buc -25%

Porumb Flotant Carp Spirit Fluo - Galben 10Buc

acs010096
Livrare imediată!

8,00Lei(-25%) 6,00Lei

Inel Gold Star Cu Bucsa (Ceramica Fluo) 32.0mm
Exclusiv online!

Inel Gold Star Cu Bucsa (Ceramica Fluo) 32.0mm

81001320
Livrare 24-48 ore

9,50Lei

Afişare 461 - 480 din 1272 (64 pagini)
Queries: 6, Total time: 33.498 ms [By time] [By id] [By file]
1 (0.135)
SELECT data
FROM `oc_session`
WHERE session_id = 'eb74d1bf100ddd5ee9d65e6a0b'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.149)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (28.324)
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('+fluo' 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 (4.610)
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 460, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.132)
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.148)
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