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 300 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 - Mivardi

Produse ce potrivesc criteriilor de căutare


CUTIE, VOBLERE, JAXON, , 210MX110X35MM, rh-120, Cutii, Cutii Jaxon, Cutii Jaxon, Jaxon

CUTIE, VOBLERE, JAXON, , 210MX110X35MM, rh-120, Cutii, Cutii Jaxon, Cutii Jaxon, Jaxon

rh-120
Livrare imediată!

16,01Lei

MONTURA SOMN FIR TEXTIL T-RIG CUTIE PB.150G CARLIG 5/0

MONTURA SOMN FIR TEXTIL T-RIG CUTIE PB.150G CARLIG 5/0

a.msc20.150
Livrare imediată!

24,61Lei

Kit, Accesorii, Monturi, Crap, NGT, Carp, Kit, Box, 170, piese/cutie, ngt-ftt-set-carp-lrg, Kituri Monturi, Kituri Monturi NGT, NGT
CARLIGE KORDA KAMAKURA KRANK Nr8 10BUC/CUTIE

CARLIGE KORDA KAMAKURA KRANK Nr8 10BUC/CUTIE

k.kam07
Livrare imediată!

41,78Lei

Cutie, Multifunctionala, Accesorii, Korda, New, Tackle, Box, a4.kbox6, Cutii, Cutii Korda, Korda

Cutie, Multifunctionala, Accesorii, Korda, New, Tackle, Box, a4.kbox6, Cutii, Cutii Korda, Korda

a4.kbox6
Livrare imediată!

255,54Lei

CUTIE, VOBLERE, JAXON, , 295X210MX65MM, rh-100, Cutii, Cutii Jaxon, Jaxon

CUTIE, VOBLERE, JAXON, , 295X210MX65MM, rh-100, Cutii, Cutii Jaxon, Jaxon

rh-100
Livrare imediată!

72,99Lei

CUTIE ACCESORII CARP ZOOM 12.2x10.5x3.4cm

CUTIE ACCESORII CARP ZOOM 12.2x10.5x3.4cm

cz4269
Livrare imediată!

19,00Lei

TAVA LATERALA CARP ZOOM CU CUTIE FEEDER

TAVA LATERALA CARP ZOOM CU CUTIE FEEDER

cz2029
Livrare imediată!

299,00Lei

CUTIE, VOBLERE, JAXON, , 122, 350X210MX50MM, rh-122, Cutii, Cutii Jaxon, Jaxon

CUTIE, VOBLERE, JAXON, , 122, 350X210MX50MM, rh-122, Cutii, Cutii Jaxon, Jaxon

rh-122
Livrare imediată!

69,00Lei

Carlige Korda Kamakura Wide Gape Nr 6 10buc/cutie

Carlige Korda Kamakura Wide Gape Nr 6 10buc/cutie

k.kam02
Livrare imediată!

41,78Lei

CUTIE KORDA PENTRU CARLIGE LEGATE

CUTIE KORDA PENTRU CARLIGE LEGATE

a4.kbox4
Livrare imediată!

139,36Lei

CUTIE, ACCESORII, MIVARDI, 5+1, , XXL, m-caboxmxl, Cutii, Cutii Mivardi, Mivardi

CUTIE, ACCESORII, MIVARDI, 5+1, , XXL, m-caboxmxl, Cutii, Cutii Mivardi, Mivardi

m-caboxmxl
Livrare imediată!

160,00Lei

CUTIE ACCESORII JAXON 100X65X30MM

CUTIE ACCESORII JAXON 100X65X30MM

rh-114
Livrare imediată!

9,00Lei

CUTIE NGT RIGIDA XPR CU INCHIDERE MAGNETICA, 24X13X4CM

CUTIE NGT RIGIDA XPR CU INCHIDERE MAGNETICA, 24X13X4CM

ngt-ftb-boxsystem-xpr
Livrare imediată!

59,00Lei

CUTIE STRATEGY PENTRU CARLIGE LEGATE CRAP 344X95X47

CUTIE STRATEGY PENTRU CARLIGE LEGATE CRAP 344X95X47

006513-00013-00000
Livrare imediată!

89,00Lei

CUTIE, NALUCI, JAXON, 10X5X2cm, rh-151, Cutii, Cutii Jaxon, Jaxon

CUTIE, NALUCI, JAXON, 10X5X2cm, rh-151, Cutii, Cutii Jaxon, Jaxon

rh-151
Livrare imediată!

5,00Lei

CUTIE SPRO PTR ACCESORII 197MMX115MMX50MM -25%

CUTIE SPRO PTR ACCESORII 197MMX115MMX50MM

006518-00200-00000
Livrare imediată!

146,00Lei(-25%) 108,90Lei

CUTIE CARP ZOOM FEEDER 39x27x12cm

CUTIE CARP ZOOM FEEDER 39x27x12cm

cz8427
Livrare imediată!

191,99Lei

CUTIE ACCESORII CARP ZOOM 8 COMPARTIMENTE

CUTIE ACCESORII CARP ZOOM 8 COMPARTIMENTE

cz2585
Livrare imediată!

7,50Lei

CUTIE, PLUMBI, MAVER, ALICE, SUPERCALIBRATI, 0.013GR, , 121013, Plumbi Stationar, Plumbi Stationar Maver, Maver -40%

CUTIE, PLUMBI, MAVER, ALICE, SUPERCALIBRATI, 0.013GR, , 121013, Plumbi Stationar, Plumbi Stationar Maver, Maver

121013
Livrare imediată!

7,00Lei(-40%) 4,20Lei

Afişare 201 - 220 din 1436 (72 pagini)
Queries: 9, Total time: 209.198 ms [By time] [By id] [By file]
1 (0.075)
SELECT data
FROM `oc_session`
WHERE session_id = 'aec6470dee0b22adb7f675a75e'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.077)
SELECT *
FROM oc_platforma_promovari LIMIT 1
/var/www/clients/client1/web1/web/index.php:128
3 (0.112)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:422
4 (0.137)
SELECT *
FROM oc_url_alias
WHERE keyword = 'search'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
5 (202.333)
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` GROUP BY tax_class_id) AS tx ON (p.tax_class_id = tx.tax_class_id)
WHERE p2s.store_id = '0' AND (pd.tag LIKE "%cutie%") 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:698
6 (6.132)
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 200, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
7 (0.111)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
8 (0.108)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
9 (0.113)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '0' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38