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 - Savage

Produse ce potrivesc criteriilor de căutare


Minciog Rapture Wading Master Plasa Cauciucata 40x30cm MAGNET/CAUCIUC

Minciog Rapture Wading Master Plasa Cauciucata 40x30cm MAGNET/CAUCIUC

084-51-700
Stoc epuizat

120,00Lei

MANER MINCIOG LINEAEFFE DOUBLE TELE 3M

MANER MINCIOG LINEAEFFE DOUBLE TELE 3M

a2.6300730
Stoc epuizat

105,21Lei

Minciog Crap Delphin Armada 90x90cm

Minciog Crap Delphin Armada 90x90cm

946006143
Stoc epuizat

302,00Lei

Plasa Minciog Delphin SYMBOL 90x90

Plasa Minciog Delphin SYMBOL 90x90

101001627
Stoc epuizat

70,00Lei

MINCIOG JAXON CLASSIC LEMN 28X38CM

MINCIOG JAXON CLASSIC LEMN 28X38CM

pl-tru101
Stoc epuizat

151,00Lei

Cap minciog pliabil Delphin ATM Floaty RN HALF 60x50cm -20%

Cap minciog pliabil Delphin ATM Floaty RN HALF 60x50cm

101001591
Stoc epuizat

135,01Lei(-20%) 107,60Lei

Cap minciog Delphin ATM Floaty RN CUBE 60x50cm -14%

Cap minciog Delphin ATM Floaty RN CUBE 60x50cm

101001541
Stoc epuizat

103,99Lei(-14%) 89,20Lei

Maner Maver Minciog Flame Telescopic 3m

Maner Maver Minciog Flame Telescopic 3m

2030300
Stoc epuizat

130,00Lei

Cap minciog Delphin ATM Floaty NYLO 60x50cm

Cap minciog Delphin ATM Floaty NYLO 60x50cm

101001546
Stoc epuizat

102,99Lei

Cap minciog Delphin ATM Floaty NYLO 70x60cm

Cap minciog Delphin ATM Floaty NYLO 70x60cm

101001547
Stoc epuizat

123,00Lei

FLOTOR PRO LINE MINCIOG

FLOTOR PRO LINE MINCIOG

pl13171
Stoc epuizat

46,01Lei

CAP MINCIOG SHAKESPEARE SIGMA 105 CM -56%

CAP MINCIOG SHAKESPEARE SIGMA 105 CM

1315267
Stoc epuizat

112,50Lei(-56%) 49,00Lei

Cap minciog Delphin ATM Floaty RN CUBE 50x40cm -45%

Cap minciog Delphin ATM Floaty RN CUBE 50x40cm

101001539
Stoc epuizat

87,00Lei(-45%) 48,00Lei

Maner minciog Maver Sigma Strong Tele 4.00m

Maner minciog Maver Sigma Strong Tele 4.00m

2036400
Stoc epuizat

589,00Lei

SPREADER BLOCK PROLOGIC HD PLASTIC

SPREADER BLOCK PROLOGIC HD PLASTIC

a2.pro.65038
Stoc epuizat

32,71Lei

Cap Minciog Preston Quick Dry 50cm

Cap Minciog Preston Quick Dry 50cm

p0140041
Stoc epuizat

89,96Lei

COADA MINCIOG PRESTON MONSTER X TELE HANDLE 3M

COADA MINCIOG PRESTON MONSTER X TELE HANDLE 3M

p0230010
Stoc epuizat

215,96Lei

Minciog crap Delphin Symbol 1100x110cm 1.8m -44%

Minciog crap Delphin Symbol 1100x110cm 1.8m

101001502
Stoc epuizat

319,00Lei(-44%) 180,00Lei

Minciog Barca Energo Team JAF Boat Landing Net 35x45cm

Minciog Barca Energo Team JAF Boat Landing Net 35x45cm

j1704039
Stoc epuizat

42,00Lei

Minciog Avid Carp Safeguard Landing Net 107cm 1.80m 1 seg -44%

Minciog Avid Carp Safeguard Landing Net 107cm 1.80m 1 seg

a0610011
Stoc epuizat

642,02Lei(-44%) 359,45Lei

Afişare 1261 - 1280 din 1354 (68 pagini)
Queries: 9, Total time: 211.184 ms [By time] [By id] [By file]
1 (0.147)
SELECT data
FROM `oc_session`
WHERE session_id = 'ef0259e19e4a63a30a3a632685'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.142)
SELECT *
FROM oc_platforma_promovari LIMIT 1
/var/www/clients/client1/web1/web/index.php:128
3 (0.072)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:422
4 (0.099)
SELECT *
FROM oc_url_alias
WHERE keyword = 'search'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
5 (204.529)
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 "%minciog%") 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 (5.906)
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 1260, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
7 (0.123)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
8 (0.085)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
9 (0.081)
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