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


Lanseta Arrow AR Classic Spin 2.12m, 5-20g, 2seg
Exclusiv online!

Lanseta Arrow AR Classic Spin 2.12m, 5-20g, 2seg

arr.s100.210
Livrare 24-48 ore

108,81Lei

Lanseta Arrow AR-X Spin 2.43, 10-36g, 2seg
Exclusiv online!

Lanseta Arrow AR-X Spin 2.43, 10-36g, 2seg

arr.s110.241
Livrare 24-48 ore

200,66Lei

Lanseta Berkley Cherrywood Spin, 1.80m, 7-28g, 2seg

Lanseta Berkley Cherrywood Spin, 1.80m, 7-28g, 2seg

1531525
Livrare imediată!

127,46Lei

Lanseta Berkley Cherrywood Spin, 2.70m, 15-40g, 2seg

Lanseta Berkley Cherrywood Spin, 2.70m, 15-40g, 2seg

1531542
Livrare imediată!

191,21Lei

Lanseta Berkley Fireflex Spin 702 UL, 2seg, 2.10m, 4-12g -39%

Lanseta Berkley Fireflex Spin 702 UL, 2seg, 2.10m, 4-12g

1345089
Livrare imediată!

222,32Lei(-39%) 135,90Lei

Lanseta Daiwa Tatula XT Spin 2.03m, 1.8-11g, 2seg
Exclusiv online!

Lanseta Daiwa Tatula XT Spin 2.03m, 1.8-11g, 2seg

d.11508.201
Livrare 24-48 ore

459,58Lei

Lanseta Konger Grafitex Spin 2.40m, 25g, 2seg
Exclusiv online!

Lanseta Konger Grafitex Spin 2.40m, 25g, 2seg

20406143011240
Livrare 48-72 ore

135,10Lei

SET PRO FL 8 CARLIGE LEGATE TEXTIL 10CM CU SPIN CARLIG Power Carp Feeder NR 12

SET PRO FL 8 CARLIGE LEGATE TEXTIL 10CM CU SPIN CARLIG Power Carp Feeder NR 12

64-26604
Livrare imediată!

18,90Lei

CARLIGE LEGATE FEEDER PRO FL FLUOROCARBON 10CM 10BUC CARLIG NR 14 CU SPIN

CARLIGE LEGATE FEEDER PRO FL FLUOROCARBON 10CM 10BUC CARLIG NR 14 CU SPIN

64-65092
Livrare imediată!

17,90Lei

CARLIGE LEGATE FEEDER PRO FL FLUOROCARBON 10CM 10BUC CARLIG NR 6 CU SPIN

CARLIGE LEGATE FEEDER PRO FL FLUOROCARBON 10CM 10BUC CARLIG NR 6 CU SPIN

64-65054
Livrare imediată!

17,90Lei

Lanseta Arrow AR-X Spin 2.12, 10-30g, 2seg
Exclusiv online!

Lanseta Arrow AR-X Spin 2.12, 10-30g, 2seg

arr.s110.211
Livrare 24-48 ore

187,19Lei

Lanseta Arrow AR-X Spin 2.12, 15-40g, 2seg
Exclusiv online!

Lanseta Arrow AR-X Spin 2.12, 15-40g, 2seg

arr.s110.212
Livrare 24-48 ore

189,21Lei

Lanseta Konger Grafitex Spin 2.40m, 40g, 2seg
Exclusiv online!

Lanseta Konger Grafitex Spin 2.40m, 40g, 2seg

20406143012240
Livrare 48-72 ore

141,60Lei

Lanseta Konger Grafitex Spin 2.70m, 40g, 2seg
Exclusiv online!

Lanseta Konger Grafitex Spin 2.70m, 40g, 2seg

20406143012270
Livrare 48-72 ore

151,15Lei

LANSETA MIKADO RIVAL LIGHT SPIN 240 c.w. 5-20g 2seg
Exclusiv online!

LANSETA MIKADO RIVAL LIGHT SPIN 240 c.w. 5-20g 2seg

waa801-240
Livrare 48-72 ore

177,00Lei

LANSETA PRO FL AQUA TELE SPIN 2.10M 15-45G

LANSETA PRO FL AQUA TELE SPIN 2.10M 15-45G

6427559089333
Livrare imediată!

95,90Lei

Lanseta Sonik Dominator Travel Spin, 2.74m, 30-50g, 4seg
Exclusiv online!

Lanseta Sonik Dominator Travel Spin, 2.74m, 30-50g, 4seg

dxsp030
Livrare 48-72 ore

272,91Lei

Montura Filex Method Feeder Rig Nr.8, cu Spin 7mm, 2buc/pac

Montura Filex Method Feeder Rig Nr.8, cu Spin 7mm, 2buc/pac

fil9281
Livrare imediată!

7,00Lei

Mulineta Sert Exceed Bobcat Spin 6504 FD

Mulineta Sert Exceed Bobcat Spin 6504 FD

30101seprk77436504fd
Livrare imediată!

199,48Lei

Spin Momeala Black Fighter Bait Sting, 15mm, 8buc/pac

Spin Momeala Black Fighter Bait Sting, 15mm, 8buc/pac

82203915
Livrare imediată!

7,00Lei

Afişare 461 - 480 din 1803 (91 pagini)
Queries: 4, Total time: 55.349 ms [By time] [By id] [By file]
1 (0.103)
SELECT data
FROM `oc_session`
WHERE session_id = '10f6815179a52dc2848d14e000'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.112)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (54.965)
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('+spin' 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.169)
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