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

Produse ce potrivesc criteriilor de căutare


Minciog Nash Scope Black Ops Landing Net 1.8 M

Minciog Nash Scope Black Ops Landing Net 1.8 M

t1762
Stoc epuizat

1.269,99Lei

Minciog Delphin mijloc din metal 2 tronsoane 80x80cm 250cm

Minciog Delphin mijloc din metal 2 tronsoane 80x80cm 250cm

942410050
Stoc epuizat

95,00Lei

Minciog telescopic Baracuda XXL 3.17M

Minciog telescopic Baracuda XXL 3.17M

minciog xxl
Stoc epuizat

130,55Lei

Minciog Delphin mijloc din metal cu plasa de guma 2 tronsoane 60x60cm 200cm

Minciog Delphin mijloc din metal cu plasa de guma 2 tronsoane 60x60cm 200cm

942415020
Stoc epuizat

71,60Lei

Minciog Sert Epuisette Carnassier Rubber Net 1.80m

Minciog Sert Epuisette Carnassier Rubber Net 1.80m

50101sepnh6679cf-1802
Stoc epuizat

142,70Lei

Minciog Delphin mijloc din metal 2 tronsoane 60x60cm 170cm

Minciog Delphin mijloc din metal 2 tronsoane 60x60cm 170cm

942410010
Stoc epuizat

90,00Lei

Minciog Nevis Standard 1.80m 60x60cm

Minciog Nevis Standard 1.80m 60x60cm

4250-180
Stoc epuizat

64,00Lei

Minciog Crap Delphin Armada 90x90cm

Minciog Crap Delphin Armada 90x90cm

946006143
Stoc epuizat

302,00Lei

Minciog Telescopic Carp Expert Original Strong 2.40m

Minciog Telescopic Carp Expert Original Strong 2.40m

71048241
Stoc epuizat

86,00Lei

MINCIOG Carp Zoom ZETA CAUCIUCAT 70x70x250cm 2 sectiun

MINCIOG Carp Zoom ZETA CAUCIUCAT 70x70x250cm 2 sectiun

cz3450
Stoc epuizat

180,00Lei

MINCIOG LINEAEFFE TELESCOPIC 2,60M -30%

MINCIOG LINEAEFFE TELESCOPIC 2,60M

a2.m6101600
Stoc epuizat

122,53Lei(-30%) 85,78Lei

Minciog crap Delphin Symbol 1100x110cm 1.8m -44%

Minciog crap Delphin Symbol 1100x110cm 1.8m

101001502
Stoc epuizat

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

Minciog crap Delphin Symbol 100x100cm 1.8m -44%

Minciog crap Delphin Symbol 100x100cm 1.8m

101001501
Stoc epuizat

314,01Lei(-44%) 177,00Lei

MINCIOG LINEAEFFE TELESCOPIC SPEEDY 2.25M -30%

MINCIOG LINEAEFFE TELESCOPIC SPEEDY 2.25M

a2.m6102422
Stoc epuizat

119,40Lei(-30%) 83,59Lei

MINCIOG PROLOGIC COMMANDER 180M 2seg -20%

MINCIOG PROLOGIC COMMANDER 180M 2seg

a2.pro.70845
Stoc epuizat

215,74Lei(-20%) 172,59Lei

Minciog Nash Air Force F40 Landing Net 2.75m, 117x95cm

Minciog Nash Air Force F40 Landing Net 2.75m, 117x95cm

t1794
Stoc epuizat

1.469,95Lei

Minciog Nash Dwarf Sawn Off Landing Net 134-183m

Minciog Nash Dwarf Sawn Off Landing Net 134-183m

t1483
Stoc epuizat

569,99Lei

Minciog Fox Horizon X4, 1.80m, 117x117cm

Minciog Fox Horizon X4, 1.80m, 117x117cm

cln042
Stoc epuizat

674,94Lei

Minciog JRC Cocoon 2G LongReach Landing Net, 384cm, 3seg

Minciog JRC Cocoon 2G LongReach Landing Net, 384cm, 3seg

1485793
Stoc epuizat

498,98Lei

Minciog JRC Defender X-lite Pro Landing Net, 180cm

Minciog JRC Defender X-lite Pro Landing Net, 180cm

1377141
Stoc epuizat

498,98Lei

Afişare 281 - 300 din 304 (16 pagini)
Queries: 6, Total time: 22.291 ms [By time] [By id] [By file]
1 (0.094)
SELECT data
FROM `oc_session`
WHERE session_id = 'ba77def215083b0297c1d5a838'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.089)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (19.666)
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('+mincioguri +complete +crap' 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 (2.236)
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 280, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.110)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"EDCRIS COM SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
6 (0.096)
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