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


INELE JAXON VARF NR 4 1.4MM

INELE JAXON VARF NR 4 1.4MM

ok-sl0414
Livrare imediată!

15,01Lei

Lanseta Baracuda Comanche Spin 2702 2SEG 2.70M

Lanseta Baracuda Comanche Spin 2702 2SEG 2.70M

comanche spin 2702
Livrare imediată!

92,90Lei

Lanseta Energo Team Wizard Samurai Spin 2.10m 7-35gr
Exclusiv online!

Lanseta Energo Team Wizard Samurai Spin 2.10m 7-35gr

13187212
Livrare 24-48 ore

200,00Lei

INEL LINEAEFE 1 PICIOR SIC D=8,0MM

INEL LINEAEFE 1 PICIOR SIC D=8,0MM

a9.2999208
Livrare imediată!

2,25Lei

Lanseta DAM Sensomax II Medium Heavy Feeder 3.90m 75-125gr
Exclusiv online!

Lanseta DAM Sensomax II Medium Heavy Feeder 3.90m 75-125gr

2050966325
Livrare 48-72 ore

337,61Lei

Lanseta Energo Team Koss Phantom 2.40m 200-500g 2seg

Lanseta Energo Team Koss Phantom 2.40m 200-500g 2seg

14176240
Livrare imediată!

200,00Lei

LANSETA RYOBI AMAZON FEEDER 120G 3.6M
Exclusiv online!

LANSETA RYOBI AMAZON FEEDER 120G 3.6M

17310360
Livrare 24-48 ore

302,00Lei

Lanseta Trabucco Energhia XR Dynamic Match 4.50m 8-22g
Exclusiv online!

Lanseta Trabucco Energhia XR Dynamic Match 4.50m 8-22g

153-32-450
Livrare 48-72 ore

2.350,00Lei

Lanseta Nevis Fullback Tele 3.60m 80-150g
Exclusiv online!

Lanseta Nevis Fullback Tele 3.60m 80-150g

1696-360
Livrare 48-72 ore

227,00Lei

Lanseta feeder Baracuda Storm 3903 3.90m 40-120g 3seg

Lanseta feeder Baracuda Storm 3903 3.90m 40-120g 3seg

storm feeder 3903
Livrare imediată!

186,90Lei

Lanseta Nevis Nitro Spin Ultra Light 2.10m
Exclusiv online!

Lanseta Nevis Nitro Spin Ultra Light 2.10m

1434-210
Livrare 48-72 ore

168,00Lei

LANSETA JAXON GREY STREAM SPIN 2.65M 5 23G

LANSETA JAXON GREY STREAM SPIN 2.65M 5 23G

wj-dsd26523
Livrare imediată!

270,00Lei

Lanseta WIZARD CLASSIC JIG 2.10M 10-30G

Lanseta WIZARD CLASSIC JIG 2.10M 10-30G

13185210
Livrare imediată!

152,00Lei

SUPORT LANSETA BARCA RAPTURE BOAT ROD STAND MARIME LARGE
Exclusiv online!

SUPORT LANSETA BARCA RAPTURE BOAT ROD STAND MARIME LARGE

084-60-100
Livrare 48-72 ore

95,00Lei

Suport Lanseta Haldorado Feeder Buzz Bar 3X-450 -25%

Suport Lanseta Haldorado Feeder Buzz Bar 3X-450

hd-kt4503x
Livrare imediată!

75,01Lei(-25%) 55,89Lei

Lanseta Nevis Nitro Spin Ultra Light 1.80m
Exclusiv online!

Lanseta Nevis Nitro Spin Ultra Light 1.80m

1434-180
Livrare 48-72 ore

146,00Lei

Lanseta Nevis Legacy Spod 3.60M 4.5-5lbs 2SEGMENTE
Exclusiv online!

Lanseta Nevis Legacy Spod 3.60M 4.5-5lbs 2SEGMENTE

1422-360
Livrare 48-72 ore

292,00Lei

Lanseta spinning Baracuda Jet Spin II 2.40M 10-40g 2SEG

Lanseta spinning Baracuda Jet Spin II 2.40M 10-40g 2SEG

jet spin ii 2402
Livrare imediată!

195,87Lei

Lanseta Zebco Great White GWC Light Pilk 2.40m 150gr

Lanseta Zebco Great White GWC Light Pilk 2.40m 150gr

13094240
Livrare imediată!

211,28Lei

Lanseta Telescopica Lineaeffe Drago 2.10M 20-80g

Lanseta Telescopica Lineaeffe Drago 2.10M 20-80g

l.2025021
Livrare imediată!

39,66Lei

Afişare 3041 - 3060 din 8578 (429 pagini)
Queries: 4, Total time: 244.769 ms [By time] [By id] [By file]
1 (0.152)
SELECT data
FROM `oc_session`
WHERE session_id = '7521e61f23f6303e873df7d967'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.109)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (244.327)
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('+lanseta' 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 (0.181)
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