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


BOCANCI SCIERRA X-FORCE WADING MARIMEA 40
Exclusiv online!

BOCANCI SCIERRA X-FORCE WADING MARIMEA 40

a8.sie.54599
Livrare 24-48 ore

596,90Lei

JACHETA SAVAGE HIGH LOFT FLEECE GRI MARIMEA XXL -40%
Exclusiv online!

JACHETA SAVAGE HIGH LOFT FLEECE GRI MARIMEA XXL

a8.sg.59124
Livrare 24-48 ore

334,25Lei(-40%) 200,55Lei

SALOPETA SAVAGE HEATLITE THERMO B AND B MARIMEA XL -23%

SALOPETA SAVAGE HEATLITE THERMO B AND B MARIMEA XL

a8.sg.59131
Livrare imediată!

414,10Lei(-23%) 318,90Lei

SET SPRO INELE DE VARF MODEL 2 MARIMEA L 30 BUC

SET SPRO INELE DE VARF MODEL 2 MARIMEA L 30 BUC

002998-00002-00000
Livrare imediată!

246,00Lei

COSTUM GAMAKATSU THERMAL INNER MARIMEA L -20%
Exclusiv online!

COSTUM GAMAKATSU THERMAL INNER MARIMEA L

a8.gk.7184.200
Livrare 24-48 ore

288,16Lei(-20%) 230,53Lei

GEACA DELPHIN CRUISER WIND MARIMEA L

GEACA DELPHIN CRUISER WIND MARIMEA L

750007020
Livrare imediată!

333,00Lei

SALOPETA SAVAGE HEATLITE THERMO B AND B MARIMEA L
Exclusiv online!

SALOPETA SAVAGE HEATLITE THERMO B AND B MARIMEA L

a8.sg.59130
Livrare 24-48 ore

378,96Lei

TRICOU PROLOGIC BANK BOUND RETRO MARIMEA XXL -40%
Exclusiv online!

TRICOU PROLOGIC BANK BOUND RETRO MARIMEA XXL

a8.pro.54649
Livrare 24-48 ore

77,00Lei(-40%) 46,21Lei

SALOPETA IMAX PROTECH B B GREY MARIMEA L
Exclusiv online!

SALOPETA IMAX PROTECH B B GREY MARIMEA L

a8.imx.49455
Livrare 24-48 ore

173,70Lei

HANORAC KORDA KORE BLACK ZIP MARIMEA XL
Exclusiv online!

HANORAC KORDA KORE BLACK ZIP MARIMEA XL

a8.kcl232
Livrare 24-48 ore

232,11Lei

Manusi Mustad Half Finger Marimea L
Exclusiv online!

Manusi Mustad Half Finger Marimea L

a8.gl004.l
Livrare 24-48 ore

105,99Lei

HANORAC KORDA KORE OLIVE ZIP MARIMEA M

HANORAC KORDA KORE OLIVE ZIP MARIMEA M

a8.kcl224
Livrare imediată!

278,59Lei

HANORAC KORDA KORE OLIVE ZIP MARIMEA XL

HANORAC KORDA KORE OLIVE ZIP MARIMEA XL

a8.kcl226
Livrare imediată!

278,59Lei

HANORAC KORDA KORE OLIVE ZIP MARIMEA S -21%

HANORAC KORDA KORE OLIVE ZIP MARIMEA S

a8.kcl223
Livrare imediată!

278,60Lei(-21%) 219,90Lei

JACHETA VERNEY CARRON FLEECE PRESLY KAKI MARIMEA L
Exclusiv online!

JACHETA VERNEY CARRON FLEECE PRESLY KAKI MARIMEA L

lvc.lvpo049.l
Livrare 24-48 ore

354,88Lei

Geaca Fox Camo Aquos Tri Layer Marimea S -59%

Geaca Fox Camo Aquos Tri Layer Marimea S

cfx146
Livrare imediată!

805,09Lei(-59%) 331,00Lei

HANORAC RIDGE MONKEY APEAREL DROPBACK MICROFLEX HOODY GREY MARIMEA S -10%

HANORAC RIDGE MONKEY APEAREL DROPBACK MICROFLEX HOODY GREY MARIMEA S

rm247
Livrare imediată!

296,95Lei(-10%) 267,26Lei

HANORAC RIDGE MONKEY APEAREL DROPBACK MICROFLEX HOODY GREY MARIMEA XL -10%

HANORAC RIDGE MONKEY APEAREL DROPBACK MICROFLEX HOODY GREY MARIMEA XL

rm250
Livrare imediată!

296,95Lei(-10%) 267,26Lei

HANORAC RIDGE MONKEY APEAREL DROPBACK MICROFLEX HOODY GREY MARIMEA M -10%

HANORAC RIDGE MONKEY APEAREL DROPBACK MICROFLEX HOODY GREY MARIMEA M

rm248
Livrare imediată!

296,95Lei(-10%) 267,26Lei

Cizme Piept Preston Heavy Duty Chest Waders, Marimea 42
Exclusiv online!

Cizme Piept Preston Heavy Duty Chest Waders, Marimea 42

p0200399
Livrare 7-14 zile

427,46Lei

Afişare 261 - 280 din 568 (29 pagini)
Queries: 6, Total time: 27.867 ms [By time] [By id] [By file]
1 (0.171)
SELECT data
FROM `oc_session`
WHERE session_id = 'e7dee3e01cc37f8e6dcf8a9d75'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.125)
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 (23.005)
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('+marimea' 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 (4.270)
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 260, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
6 (0.166)
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