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 - vu.2.5878

Produse ce potrivesc criteriilor de căutare


Tambur De Rezerva Team Feeder Long Cast 6500

Tambur De Rezerva Team Feeder Long Cast 6500

2501-665-01
Livrare imediată!

58,00Lei

Fir monofilament Asso Ultra Cast Fluo Yellow 0.39mm 18.5kg 1000m
Exclusiv online!

Fir monofilament Asso Ultra Cast Fluo Yellow 0.39mm 18.5kg 1000m

607080038
Livrare 48-72 ore

109,54Lei

MULINETA TRABUCCO ADMIRAL SURF & LONG CAST 8000

MULINETA TRABUCCO ADMIRAL SURF & LONG CAST 8000

033-35-200
Livrare imediată!

210,00Lei

MULINETA TRABUCCO ADMIRAL SURF & LONG CAST 10000

MULINETA TRABUCCO ADMIRAL SURF & LONG CAST 10000

033-35-300
Livrare imediată!

260,00Lei

LANSETA SAVAGE GEAR CUSTOM PREDATOR CAST 2.58M 110G 2SEG -30%
Exclusiv online!

LANSETA SAVAGE GEAR CUSTOM PREDATOR CAST 2.58M 110G 2SEG

o.sg.50166
Livrare 24-48 ore

902,76Lei(-30%) 631,93Lei

Fir Trabucco Long Cast 150m/0.25mm
Exclusiv online!

Fir Trabucco Long Cast 150m/0.25mm

052-80-250
Livrare 48-72 ore

16,01Lei

LANSETA SAVAGE GEAR SG2 CAST MEDIUM GAME TRIGGER 2.13M 10-30G 2SEG -20%
Exclusiv online!

LANSETA SAVAGE GEAR SG2 CAST MEDIUM GAME TRIGGER 2.13M 10-30G 2SEG

o.sg.72159
Livrare 24-48 ore

387,19Lei(-20%) 309,75Lei

PLUMB KORDA TOURNAMENT CAST CU VARTEJ 99G
Exclusiv online!

PLUMB KORDA TOURNAMENT CAST CU VARTEJ 99G

a3.ktcs35
Livrare 24-48 ore

11,50Lei

Fir ASSO Ultra Cast Galben Fluo 0.36mm 1000m

Fir ASSO Ultra Cast Galben Fluo 0.36mm 1000m

607080037
Livrare imediată!

99,65Lei

Lanseta Rapture Loomis & Franklin Swimbait Cast 2.05m 28-112g 2seg
Exclusiv online!

Lanseta Rapture Loomis & Franklin Swimbait Cast 2.05m 28-112g 2seg

121-77-042
Livrare 48-72 ore

395,00Lei

TIJA MIKADO LONG CAST PENTRU MOMITOR METHOD FEEDE 13cm 2buc/plic

TIJA MIKADO LONG CAST PENTRU MOMITOR METHOD FEEDE 13cm 2buc/plic

amft-13b
Livrare imediată!

11,00Lei

Mulineta Casting Lucky John Vanrex Cast 30 LH Left Hand
Exclusiv online!

Mulineta Casting Lucky John Vanrex Cast 30 LH Left Hand

lj-6030bc
Livrare 48-72ore

338,00Lei

FIR MONOFILAMENT TRABUCCO T-FORCE XPS MASTER CAST HV 1200M 0.40mm 20.13kg

FIR MONOFILAMENT TRABUCCO T-FORCE XPS MASTER CAST HV 1200M 0.40mm 20.13kg

053-49-940
Livrare imediată!

199,00Lei

FIR MONOFILAMENT TRABUCCO T-FORCE XPS MASTER CAST HV 1200M 0.28mm 9.54kg

FIR MONOFILAMENT TRABUCCO T-FORCE XPS MASTER CAST HV 1200M 0.28mm 9.54kg

053-49-928
Livrare imediată!

159,00Lei

FIR MONOFILAMENT TRABUCCO T-FORCE XPS MASTER CAST HV 1200M 0.25mm 8.35kg

FIR MONOFILAMENT TRABUCCO T-FORCE XPS MASTER CAST HV 1200M 0.25mm 8.35kg

053-49-925
Livrare imediată!

155,00Lei

FIR MONOFILAMENT TRABUCCO T-FORCE XPS MASTER CAST HV 1200M 0.22mm 6.95kg

FIR MONOFILAMENT TRABUCCO T-FORCE XPS MASTER CAST HV 1200M 0.22mm 6.95kg

053-49-922
Livrare imediată!

146,00Lei

FIR MONOFILAMENT TRABUCCO T-FORCE XPS MASTER CAST HV 1200M 0.35mm 15.80kg
Exclusiv online!

FIR MONOFILAMENT TRABUCCO T-FORCE XPS MASTER CAST HV 1200M 0.35mm 15.80kg

053-49-935
Livrare 48-72 ore

195,01Lei

FIR MONOFILAMENT TRABUCCO T-FORCE XPS MASTER CAST HV 1200M 0.30mm 11.92kg

FIR MONOFILAMENT TRABUCCO T-FORCE XPS MASTER CAST HV 1200M 0.30mm 11.92kg

053-49-930
Livrare imediată!

169,00Lei

FIR MONOFILAMENT TRABUCCO T-FORCE XPS MASTER CAST HV 1200M 0.32mm 13.85kg

FIR MONOFILAMENT TRABUCCO T-FORCE XPS MASTER CAST HV 1200M 0.32mm 13.85kg

053-49-932
Livrare imediată!

178,00Lei

PLUMB KORDA TOURNAMENT CAST HELI 112g
Exclusiv online!

PLUMB KORDA TOURNAMENT CAST HELI 112g

a3.ktch4
Livrare 24-48 ore

12,00Lei

Afişare 341 - 360 din 546 (28 pagini)
Queries: 6, Total time: 24.230 ms [By time] [By id] [By file]
1 (0.166)
SELECT data
FROM `oc_session`
WHERE session_id = '3118d52adb7f6bc1b96b930b56'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.117)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (0.119)
SELECT *
FROM oc_url_alias
WHERE keyword = 'search'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (23.497)
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('+cast' 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
5 (0.178)
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.152)
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