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


LANSETA SAVAGE GEAR SG4 LIGHT GAME 2.51M 3-14G 2SEG
Exclusiv online!

LANSETA SAVAGE GEAR SG4 LIGHT GAME 2.51M 3-14G 2SEG

o.sg.72194
Livrare 24-48 ore

511,87Lei

LANSETA TICA CARP FEEDER 3.60M H 3+2SEG
Exclusiv online!

LANSETA TICA CARP FEEDER 3.60M H 3+2SEG

gvdc364
Livrare 48-72 ore

320,00Lei

LANSETA TRABUCCO ASTORE ISO HUNTER 3.00M 250G 2+3BUC
Exclusiv online!

LANSETA TRABUCCO ASTORE ISO HUNTER 3.00M 250G 2+3BUC

161-67-300
Livrare 48-72 ore

659,00Lei

Lanseta Okuma Psycho Perch UFR Spin 2.30m 3-18g 2seg -13%

Lanseta Okuma Psycho Perch UFR Spin 2.30m 3-18g 2seg

psy-s-772ml
Livrare imediată!

369,00Lei(-13%) 321,90Lei

LANSETA SAVAGE GEAR SG2 MEDIUM GAME 2.51M 7-23G 2SEG

LANSETA SAVAGE GEAR SG2 MEDIUM GAME 2.51M 7-23G 2SEG

o.sg.72156
Livrare imediată!

381,48Lei

Lanseta Garbolino Aquila Bolo Power 5.00m 30gr

Lanseta Garbolino Aquila Bolo Power 5.00m 30gr

20730gofrh8252480-5
Livrare imediată!

376,97Lei

Lanseta Lucky John Anira Stream 2.70m 2-10g 2seg
Exclusiv online!

Lanseta Lucky John Anira Stream 2.70m 2-10g 2seg

ljasm-8102lm
Livrare 48-72ore

479,00Lei

Varf de Rezerva pentru Lansete Matrix Ethos XRD 3.5oz Tip Carbon 3.4mm

Varf de Rezerva pentru Lansete Matrix Ethos XRD 3.5oz Tip Carbon 3.4mm

grd216
Livrare imediată!

107,96Lei

LANSETA FOX EXPLORER TI RODS 8-10FT FULL SHRINK 3.00M 3.00LBS 2SEG
Exclusiv online!

LANSETA FOX EXPLORER TI RODS 8-10FT FULL SHRINK 3.00M 3.00LBS 2SEG

crd349
Livrare 7-14 zile

1.619,96Lei

Lanseta Daiwa Triforce Target Zander Spin 270cm 15-50g 2SEG
Exclusiv online!

Lanseta Daiwa Triforce Target Zander Spin 270cm 15-50g 2SEG

d.11400.276
Livrare 24-48 ore

201,86Lei

Lanseta Rapture Loomis & Franklin Classic Predator 2.13m 7-28g
Exclusiv online!

Lanseta Rapture Loomis & Franklin Classic Predator 2.13m 7-28g

121-77-001
Livrare 48-72 ore

260,00Lei

Varf de Rezerva pentru Lansete Matrix Ethos XRF 1.5oz Tip Carbon 2.8mm
Exclusiv online!

Varf de Rezerva pentru Lansete Matrix Ethos XRF 1.5oz Tip Carbon 2.8mm

grd205
Livrare 7-14 zile

107,96Lei

Lanseta SPORTEX Rapid Feeder Medium XS 3.00m, 80-150g, 2+3seg
Exclusiv online!

Lanseta SPORTEX Rapid Feeder Medium XS 3.00m, 80-150g, 2+3seg

mf3031
Livrare 48-72 ore

899,00Lei

Lanseta Berkley URBN Droopshooter 2.10m 7-28g 2buc -33%

Lanseta Berkley URBN Droopshooter 2.10m 7-28g 2buc

1525593
Livrare imediată!

287,94Lei(-33%) 192,90Lei

Lanseta Gamakatsu Softbait 240cm 10-45g 2seg
Exclusiv online!

Lanseta Gamakatsu Softbait 240cm 10-45g 2seg

gk.24389.800
Livrare 24-48 ore

1.420,87Lei

LANSETA PROLOGIC COMMANDER COMPACT 3.00M, 3.50LBS, 40MM, XD, 2SEG

LANSETA PROLOGIC COMMANDER COMPACT 3.00M, 3.50LBS, 40MM, XD, 2SEG

o.pro.72777
Livrare imediată!

365,31Lei

LANSETA SAVAGE GEAR SGS2 ULTRA LIGHT GAME 2.13M 0.5-7G 2SEG
Exclusiv online!

LANSETA SAVAGE GEAR SGS2 ULTRA LIGHT GAME 2.13M 0.5-7G 2SEG

o.sg.74872
Livrare 24-48 ore

379,16Lei

Lanseta Bolognesa DAM Base-X Bolo 4m 5-25g
Exclusiv online!

Lanseta Bolognesa DAM Base-X Bolo 4m 5-25g

dam.70400
Livrare 24-48 ore

104,80Lei

LANSETA SAVAGE GEAR SG4 MEDIUM GAME 1.98M 7-23G 2SEG
Exclusiv online!

LANSETA SAVAGE GEAR SG4 MEDIUM GAME 1.98M 7-23G 2SEG

o.sg.72197
Livrare 24-48 ore

445,10Lei

LANSETA SPINNING SAVAGE GEAR SGS2 TOPWATER 2.30M 7-25G 2SEG -22%

LANSETA SPINNING SAVAGE GEAR SGS2 TOPWATER 2.30M 7-25G 2SEG

o.sg.74886
Livrare imediată!

385,79Lei(-22%) 299,90Lei

Afişare 4981 - 5000 din 8880 (444 pagini)
Queries: 7, Total time: 280.760 ms [By time] [By id] [By file]
1 (0.159)
SELECT data
FROM `oc_session`
WHERE session_id = 'a8e7ed165a9ca47ddc75f9aed5'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.094)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (0.095)
SELECT *
FROM oc_url_alias
WHERE keyword = 'search'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (245.447)
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('+lansete' 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 (34.585)
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 4980, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
6 (0.194)
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
7 (0.186)
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