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


Husa Lansete Avid Carp Compound Double Rod Sleeve 12ft 205cm

Husa Lansete Avid Carp Compound Double Rod Sleeve 12ft 205cm

a0430056
Stoc epuizat

267,26Lei

Husa Lansete DAM O.T.T. Rod Holdall Hardcase 192x12x8cm

Husa Lansete DAM O.T.T. Rod Holdall Hardcase 192x12x8cm

9050974975
Stoc epuizat

425,83Lei

Husa Lanseta Madcat Single Rod Holdall 360cm

Husa Lanseta Madcat Single Rod Holdall 360cm

9053152013
Stoc epuizat

164,41Lei

HUSA LANSETE CARP ZOOM PREDATOR-Z HANZO EVA ROD BAG 145cm

HUSA LANSETE CARP ZOOM PREDATOR-Z HANZO EVA ROD BAG 145cm

cz7915
Stoc epuizat

139,00Lei

Rod Pod Ngt Quick Fish Mk2 3 Posturi

Rod Pod Ngt Quick Fish Mk2 3 Posturi

ngt-fp-quickfish-mk2
Stoc epuizat

239,99Lei

Porumb artificial Enterprise Tackle Pop-up Sweetcorn Classic Monster Crab Rod Hutchinson
Husa Flexibila Lansete Rapitor RTB Rod Cover Green Chartreuse

Husa Flexibila Lansete Rapitor RTB Rod Cover Green Chartreuse

rtb8156
Stoc epuizat

27,00Lei

Lanseta Shakespeare Cedar Canyon Stream Fly Rod 2.74m, Clasa 7-8, 3seg

Lanseta Shakespeare Cedar Canyon Stream Fly Rod 2.74m, Clasa 7-8, 3seg

1546660
Stoc epuizat

130,46Lei

Lanseta Pastrav Abu Garcia Carabus Distinct CDST Rod 642UL, 1.90m, 0.8-4g, 2seg
Husa Flexibila Lansete Rapitor RTB Rod Cover Black & Red

Husa Flexibila Lansete Rapitor RTB Rod Cover Black & Red

rtb8157
Stoc epuizat

27,00Lei

Rod-pod Delphin BRONX 2G STALX -21%

Rod-pod Delphin BRONX 2G STALX

101002704
Stoc epuizat

284,01Lei(-21%) 224,01Lei

Rod Pod Fox Eos 2 & 3 Rod Tri-Pod

Rod Pod Fox Eos 2 & 3 Rod Tri-Pod

crp049
Stoc epuizat

494,96Lei

Rod Pod Spro C-Tec Compact 3 Posturi

Rod Pod Spro C-Tec Compact 3 Posturi

006540-00023-00000
Stoc epuizat

302,00Lei

Banda Fixare Lansete RTB Neoprene Rod Straps

Banda Fixare Lansete RTB Neoprene Rod Straps

5940000623333
Stoc epuizat

8,90Lei

Benzi Aqua Products Neoprene Rod Straps, 2buc

Benzi Aqua Products Neoprene Rod Straps, 2buc

410122
Stoc epuizat

69,95Lei

Husa Laneste Greys Prodigy Ready Holdall - 2 Rod, 190x32x32cm

Husa Laneste Greys Prodigy Ready Holdall - 2 Rod, 190x32x32cm

1326299
Stoc epuizat

467,46Lei

Husa Rigida Preston Hardcase Supera Small Rod Holdall, 185x22x20cm -52%

Husa Rigida Preston Hardcase Supera Small Rod Holdall, 185x22x20cm

p0130061
Stoc epuizat

575,00Lei(-52%) 277,00Lei

Lanseta Pastrav Abu Garcia Carabus Extreme Rod CEX UL, 1.85m, 0.5-4g, 2seg

Lanseta Pastrav Abu Garcia Carabus Extreme Rod CEX UL, 1.85m, 0.5-4g, 2seg

1525861
Stoc epuizat

1.529,96Lei

Lanseta Shakespeare Cedar Canyon Summit Fly Rod 2.44m, Clasa 4, 4seg

Lanseta Shakespeare Cedar Canyon Summit Fly Rod 2.44m, Clasa 4, 4seg

1546651
Stoc epuizat

269,96Lei

Rod Pod Carp Expert President 4, 95x25x10cm

Rod Pod Carp Expert President 4, 95x25x10cm

77100178
Stoc epuizat

736,00Lei

Afişare 1421 - 1440 din 1502 (76 pagini)
Queries: 4, Total time: 37.952 ms [By time] [By id] [By file]
1 (0.505)
SELECT data
FROM `oc_session`
WHERE session_id = '3e69b3e4f1a7f35f6f0add9c4b'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.179)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (37.112)
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('+rod' 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.156)
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