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


Port Varf Lanseta Benzar No Limit Method Feeder 3.90m, 100-250g -20%

Port Varf Lanseta Benzar No Limit Method Feeder 3.90m, 100-250g

12344394
Livrare imediată!

149,90Lei(-20%) 119,92Lei

Tronson 02 Trabucco Precision RPL Carp Feeder 3.90m, 120g
Exclusiv online!

Tronson 02 Trabucco Precision RPL Carp Feeder 3.90m, 120g

152-36-390-r02
Livrare 48-72 ore

74,97Lei

Husa Delphin Feeder ELITA 135cm

Husa Delphin Feeder ELITA 135cm

430409135
Livrare imediată!

153,00Lei

Lanseta Trabucco Proxima XP Power Feeder 4.20m, XP-150g, 3+3seg

Lanseta Trabucco Proxima XP Power Feeder 4.20m, XP-150g, 3+3seg

153-75-240
Livrare imediată!

499,00Lei

Brat Trabucco GNT X-Connect Ripple Side Rest
Exclusiv online!

Brat Trabucco GNT X-Connect Ripple Side Rest

116-26-030
Livrare 48-72 ore

120,00Lei

Lanseta Feeder Daiwa 3+2seg Aqualite, 3,60m 150g

Lanseta Feeder Daiwa 3+2seg Aqualite, 3,60m 150g

d.11769.365
Livrare imediată!

497,85Lei

Lanseta Okuma 8K Feeder 3.60m, 40-80g, 3+3seg -20%
Exclusiv online!

Lanseta Okuma 8K Feeder 3.60m, 40-80g, 3+3seg

8k-f-1203mh
Livrare 48-72ore

755,10Lei(-20%) 604,00Lei

Lanseta Ryobi Amazon Feeder 3.60m, 180g, 3+3seg
Exclusiv online!

Lanseta Ryobi Amazon Feeder 3.60m, 180g, 3+3seg

17311360
Livrare 24-48 ore

352,00Lei

Lanseta Trabucco Proxima XP Method+ Feeder 2.70m, M-80g, 2+3seg

Lanseta Trabucco Proxima XP Method+ Feeder 2.70m, M-80g, 2+3seg

153-75-310
Livrare imediată!

320,00Lei

Lanseta Trabucco Proxima XP Method+ Feeder 3.00m, M-80g, 2+3seg

Lanseta Trabucco Proxima XP Method+ Feeder 3.00m, M-80g, 2+3seg

153-75-320
Livrare imediată!

350,00Lei

Suport Berkley Ball Mounting System Quick Release Lock, 10.4 x 5.2cm

Suport Berkley Ball Mounting System Quick Release Lock, 10.4 x 5.2cm

1601104
Livrare imediată!

179,96Lei

Suport Feeder Colmic EVA Double, 25cm
Exclusiv online!

Suport Feeder Colmic EVA Double, 25cm

ap61e
Livrare 48-72 ore

250,00Lei

SUPORT SPATE PRESTON LANSETE FEEDER OFFBOX 36 DELUXE BUT REST ARM
Exclusiv online!

SUPORT SPATE PRESTON LANSETE FEEDER OFFBOX 36 DELUXE BUT REST ARM

p0110004
Livrare 7-14 zile

125,96Lei

Lanseta Feeder Colmic Mirage S31 Still Water ML, 3.60m, 50g, 3+3seg
Exclusiv online!

Lanseta Feeder Colmic Mirage S31 Still Water ML, 3.60m, 50g, 3+3seg

cami81b
Livrare 48-72 ore

890,00Lei

Lanseta Feeder Trabucco Sygnum XS Mini, 3.00m, 2+3seg

Lanseta Feeder Trabucco Sygnum XS Mini, 3.00m, 2+3seg

151-01-110
Livrare imediată!

695,00Lei

Lanseta Trabucco Proxima XP Power Feeder 3.90m, PW-120g, 3+3seg

Lanseta Trabucco Proxima XP Power Feeder 3.90m, PW-120g, 3+3seg

153-75-220
Livrare imediată!

480,00Lei

Suport Berkley Kayak SUP Belly Boat Rod Holder, 20.5cm

Suport Berkley Kayak SUP Belly Boat Rod Holder, 20.5cm

1601109
Livrare imediată!

157,46Lei

Brat Trabucco GNT X-Connect Ripple Cross Long Arm
Exclusiv online!

Brat Trabucco GNT X-Connect Ripple Cross Long Arm

116-26-020
Livrare 48-72 ore

120,00Lei

Feeder Arm Garbolino 90 Multigrip Open EVA Crante
Exclusiv online!

Feeder Arm Garbolino 90 Multigrip Open EVA Crante

90830gomee3904
Livrare 48-72 ore

125,64Lei

Lanseta Cormoran Speciland Feeder 4.20m, 50-150g, 3+3seg

Lanseta Cormoran Speciland Feeder 4.20m, 50-150g, 3+3seg

c.25.5300429
Livrare imediată!

562,03Lei

Afişare 1001 - 1020 din 1501 (76 pagini)
Queries: 6, Total time: 57.603 ms [By time] [By id] [By file]
1 (0.118)
SELECT data
FROM `oc_session`
WHERE session_id = '14c9742dbd15a98c4434fd943e'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.101)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (51.146)
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('+lansete +feeder' 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 (5.971)
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 1000, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.138)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"RAPALA VMC ROMANIA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
6 (0.129)
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