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 CORMORAN 5124 PENTRU LANSETE 155CM

HUSA CORMORAN 5124 PENTRU LANSETE 155CM

a8.65.12455
Livrare imediată!

134,85Lei

Husa lansete Carp Zoom NS Dubla 120x23x12cm
Exclusiv online!

Husa lansete Carp Zoom NS Dubla 120x23x12cm

cz4083
Livrare 48-72 ore

93,00Lei

Picheti NGT DISTANCE STICK SET CU HUSA DE TRANSPORT 3.66M

Picheti NGT DISTANCE STICK SET CU HUSA DE TRANSPORT 3.66M

ngt-fo-distance-dlx
Livrare imediată!

79,00Lei

Husa Lansete Carp Expert Plus 3 Compartimente 160cm

Husa Lansete Carp Expert Plus 3 Compartimente 160cm

73133161
Livrare imediată!

157,00Lei

HUSA CORMORAN 5121 PENTRU LANSETE 175CM

HUSA CORMORAN 5121 PENTRU LANSETE 175CM

a8.65.12175
Livrare imediată!

160,39Lei

Husa Laneste Fox R-Series 2 Rod Sleeve, 165x26x26cm
Exclusiv online!

Husa Laneste Fox R-Series 2 Rod Sleeve, 165x26x26cm

clu359
Livrare 7-14 zile

292,45Lei

Husa Juvelnic Nevis Rotunda 60x10cm

Husa Juvelnic Nevis Rotunda 60x10cm

5213-057
Livrare imediată!

39,00Lei

HUSA INDIVIDUALA CARP ZOOM MARSHALL 205X25CM

HUSA INDIVIDUALA CARP ZOOM MARSHALL 205X25CM

cz7091
Livrare imediată!

125,00Lei

Husa Lansete Carp Expert Plus 2 Compartimente 120cm

Husa Lansete Carp Expert Plus 2 Compartimente 120cm

73132121
Livrare imediată!

79,00Lei

HUSA DAIWA NEOPREN PT. MULINETA BAITCAST 12X12,5CM

HUSA DAIWA NEOPREN PT. MULINETA BAITCAST 12X12,5CM

a8.15802.025
Livrare imediată!

45,11Lei

HUSA LANSETE JAXON X-TEAM 2 CAMO COMPARTIMENTE 135CM

HUSA LANSETE JAXON X-TEAM 2 CAMO COMPARTIMENTE 135CM

uj-xrs135
Livrare imediată!

150,00Lei

LANTERNA LED LENSER P14, 800 LUMENI / 4XAA + HUSA

LANTERNA LED LENSER P14, 800 LUMENI / 4XAA + HUSA

a8.z500901
Livrare imediată!

397,82Lei

Husa lansete Baracuda 3 compartimente OC B2 125CM

Husa lansete Baracuda 3 compartimente OC B2 125CM

b2 - geanta
Livrare imediată!

75,40Lei

HUSA ENERGOTEAM CARP HUNTER 2 COMPARTIMENTE 120CM4
Exclusiv online!

HUSA ENERGOTEAM CARP HUNTER 2 COMPARTIMENTE 120CM4

73232140
Livrare 24-48 ore

131,00Lei

HUSA LANSETE NASH SCOPE OPS SINGLE ROD SKINS 1.85M
Exclusiv online!

HUSA LANSETE NASH SCOPE OPS SINGLE ROD SKINS 1.85M

t3760
Livrare 7-14 zile

145,99Lei

Husa protectie Varf Lanseta Carp Zoom Feeder Competition 19.5cm -21%

Husa protectie Varf Lanseta Carp Zoom Feeder Competition 19.5cm

cz9293
Livrare imediată!

42,99Lei(-21%) 33,90Lei

Husa Lanseta Crap Academy 3 Compartimente 210cm

Husa Lanseta Crap Academy 3 Compartimente 210cm

5110-513
Livrare imediată!

389,00Lei

HUSA LANSETE COLMIC PRAGA SERIA RED 170x20cm
Exclusiv online!

HUSA LANSETE COLMIC PRAGA SERIA RED 170x20cm

pr201a
Livrare 48-72 ore

122,00Lei

HUSA LANSETE CARP EXPERT 3 COMPARTIMENTE 140CM

HUSA LANSETE CARP EXPERT 3 COMPARTIMENTE 140CM

73133140
Livrare imediată!

200,00Lei

Husa rigida lansete Fox Rage Rod Shield 178cm – 198cm -33%

Husa rigida lansete Fox Rage Rod Shield 178cm – 198cm

nlu076
Livrare imediată!

49,46Lei(-33%) 32,90Lei

Afişare 421 - 440 din 1198 (60 pagini)
Queries: 5, Total time: 53.580 ms [By time] [By id] [By file]
1 (0.154)
SELECT data
FROM `oc_session`
WHERE session_id = '5d8dc3ed31b40d89f6bb118015'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.134)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (47.643)
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('+husa' 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.547)
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 420, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.102)
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