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 - vu.2.5878

Produse ce potrivesc criteriilor de căutare


Husa lansete Fox Camolite Tri Sleeve 3.90M
Exclusiv online!

Husa lansete Fox Camolite Tri Sleeve 3.90M

clu297
Livrare 7-14 zile

809,95Lei

Husa Delphin Carp MISIA 300-2 165cm

Husa Delphin Carp MISIA 300-2 165cm

430408165
Livrare imediată!

161,99Lei

Husa Lanseta DAM Madcat Single Rod Holdall 270cm

Husa Lanseta DAM Madcat Single Rod Holdall 270cm

9053152011
Livrare imediată!

119,20Lei

HUSA LANSETE JAXON X-TEAM 3 CAMO COMPARTIMENTE 125CM
Exclusiv online!

HUSA LANSETE JAXON X-TEAM 3 CAMO COMPARTIMENTE 125CM

uj-xrt125
Livrare 48-72 ore

198,00Lei

HUSA LANSETE JAXON X-TEAM 3 CAMO COMPARTIMENTE 155CM
Exclusiv online!

HUSA LANSETE JAXON X-TEAM 3 CAMO COMPARTIMENTE 155CM

uj-xrt155
Livrare 48-72 ore

250,00Lei

HUSA LANSETE Baracuda B9 NC 90CM 3 compartimente camuflaj

HUSA LANSETE Baracuda B9 NC 90CM 3 compartimente camuflaj

b9 - geanta
Livrare imediată!

61,45Lei

HUSA LANSETA JAXON SPINNING 125CM

HUSA LANSETA JAXON SPINNING 125CM

um-pod125
Livrare imediată!

110,00Lei

HUSA JAXON LANSETE X-TEAM 3 COMPARTIMENTE 150CM

HUSA JAXON LANSETE X-TEAM 3 COMPARTIMENTE 150CM

uj-xau150
Livrare imediată!

155,00Lei

Husa 4 lansete Baracuda crap C1-T 190cm

Husa 4 lansete Baracuda crap C1-T 190cm

c1 - t
Livrare imediată!

329,90Lei

HUSA lansete Spomb Double Rod Jacket 390CM

HUSA lansete Spomb Double Rod Jacket 390CM

dlu005
Livrare imediată!

323,95Lei

HUSA LANSETE JAXON X-TEAM 3 COMPARTIMENTE 135CM XAM

HUSA LANSETE JAXON X-TEAM 3 COMPARTIMENTE 135CM XAM

uj-xam135
Livrare imediată!

172,00Lei

HUSA Carp Zoom MULINETA NEOPREN L
Exclusiv online!

HUSA Carp Zoom MULINETA NEOPREN L

cz2484
Livrare 48-72 ore

42,99Lei

HUSA LANSETE ENERGOTEAM METHOD 3 COMPARTIMENTE 165CM
Exclusiv online!

HUSA LANSETE ENERGOTEAM METHOD 3 COMPARTIMENTE 165CM

73146150
Livrare 24-48 ore

200,00Lei

Husa lansete Baracuda C6-T 208cm 4Lansete

Husa lansete Baracuda C6-T 208cm 4Lansete

c6 - t
Livrare imediată!

359,90Lei

HUSA PROLOGIC AVENGER COMPACT 3 LANSETE 1.37M
Exclusiv online!

HUSA PROLOGIC AVENGER COMPACT 3 LANSETE 1.37M

a8.pro.72670
Livrare 24-48 ore

333,18Lei

HUSA Sportex LANSETE CARP X 11/12FT 195CM Grey
Exclusiv online!

HUSA Sportex LANSETE CARP X 11/12FT 195CM Grey

s309012
Livrare 48-72 ore

239,00Lei

HUSA JAXON X TEAM 125CM
Exclusiv online!

HUSA JAXON X TEAM 125CM

uj-xad125
Livrare 48-72 ore

95,00Lei

HUSA LANSETA JAXON SPINNING 115CM
Exclusiv online!

HUSA LANSETA JAXON SPINNING 115CM

um-pod115
Livrare 48-72 ore

100,00Lei

HUSA LANSETE JAXON X-TEAM 2 CAMO COMPARTIMENTE 155CM
Exclusiv online!

HUSA LANSETE JAXON X-TEAM 2 CAMO COMPARTIMENTE 155CM

uj-xrs155
Livrare 48-72 ore

180,00Lei

Husa LANSETA FOX Explorer Double Rod Sleeve 2 LANSETE 135 x 26 x 26cm -20%

Husa LANSETA FOX Explorer Double Rod Sleeve 2 LANSETE 135 x 26 x 26cm

clu434
Livrare imediată!

290,71Lei(-20%) 232,56Lei

Afişare 301 - 320 din 658 (33 pagini)
Queries: 6, Total time: 24.341 ms [By time] [By id] [By file]
1 (0.102)
SELECT data
FROM `oc_session`
WHERE session_id = '0ab1f3116537cddb4f31277584'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.122)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (0.130)
SELECT *
FROM oc_url_alias
WHERE keyword = 'search'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (20.776)
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('+huse +mulinete' 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
5 (3.085)
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 300, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
6 (0.126)
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