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

Produse ce potrivesc criteriilor de căutare


Lanseta Colmic Panter Bolentino XT, 2.40m, 150g

Lanseta Colmic Panter Bolentino XT, 2.40m, 150g

capa84c
Stoc epuizat

218,00Lei

Lanseta Colmic Panter Bolentino XT, 2.40m, 200g

Lanseta Colmic Panter Bolentino XT, 2.40m, 200g

capa85c
Stoc epuizat

218,00Lei

Lanseta Delphin YUPIE 2.40m, 40g, 6seg

Lanseta Delphin YUPIE 2.40m, 40g, 6seg

101003244
Stoc epuizat

95,00Lei

Lanseta Konger Grafitex Catfish 2.40m, 200g, 2seg

Lanseta Konger Grafitex Catfish 2.40m, 200g, 2seg

20306143005240
Stoc epuizat

184,66Lei

Lanseta Zeck Finesse ST, 2.40m, 4-28g, 2seg

Lanseta Zeck Finesse ST, 2.40m, 4-28g, 2seg

20405200413
Stoc epuizat

790,90Lei

Lanseta Colmic Herakles Calida Ego HCE2-80H 2.40m 20-60g

Lanseta Colmic Herakles Calida Ego HCE2-80H 2.40m 20-60g

cahkce06
Stoc epuizat

565,00Lei

Lanseta Daiwa Ninja X Stalker Feeder 2.40m, 100g, 2+2seg

Lanseta Daiwa Ninja X Stalker Feeder 2.40m, 100g, 2+2seg

d.11605.240
Stoc epuizat

282,84Lei

Lanseta Delphin GreenCODE 2.40m, 35g, 2seg -25%

Lanseta Delphin GreenCODE 2.40m, 35g, 2seg

101003129
Stoc epuizat

188,00Lei(-25%) 141,21Lei

Lanseta Delphin MURENA 2.40m, 100g, 2seg -25%

Lanseta Delphin MURENA 2.40m, 100g, 2seg

101000311
Stoc epuizat

218,00Lei(-25%) 164,01Lei

Lanseta Sunset Squidea ZXR, 2.40m, 100g, 2seg

Lanseta Sunset Squidea ZXR, 2.40m, 100g, 2seg

20311stsrj8885240-2
Stoc epuizat

134,32Lei

Combo Spinning Berkley Catch More Fish Pike 4000, 5.2:1, 2.40m, 10-40g, 2seg
Lanseta Delphin GreenCODE Hard 2.40m, 50g, 2seg -25%

Lanseta Delphin GreenCODE Hard 2.40m, 50g, 2seg

101003132
Stoc epuizat

203,00Lei(-25%) 152,70Lei

Lanseta FL Power Plus 2.40M 80-150Gr 2Seg

Lanseta FL Power Plus 2.40M 80-150Gr 2Seg

1243165521334
Stoc epuizat

41,41Lei

Lanseta Shimano Nasci BX Spinning 711H 2.40m/15-60g

Lanseta Shimano Nasci BX Spinning 711H 2.40m/15-60g

snasbx711h
Stoc epuizat

395,00Lei

Lanseta Baracuda Catfish Fighter 2402 2.40m 50-150g 2seg

Lanseta Baracuda Catfish Fighter 2402 2.40m 50-150g 2seg

catfish fighter 2402
Stoc epuizat

98,70Lei

LANSETA TRABUCCO PULSE SPECIAL EGI 2.40m 5-20gr 125cm

LANSETA TRABUCCO PULSE SPECIAL EGI 2.40m 5-20gr 125cm

161-73-010
Stoc epuizat

165,01Lei

LANSETA TRABUCCO PULSE SPIN MASTER 2.40m 10-30gr 125cm

LANSETA TRABUCCO PULSE SPIN MASTER 2.40m 10-30gr 125cm

125-40-030
Stoc epuizat

175,00Lei

LANSETA TRABUCCO PULSE SPECIAL EGI 2.40m 10-30gr 125cm

LANSETA TRABUCCO PULSE SPECIAL EGI 2.40m 10-30gr 125cm

161-73-020
Stoc epuizat

179,00Lei

Lanseta Rapture STX Softbait M 2.40m 10-30g 2seg

Lanseta Rapture STX Softbait M 2.40m 10-30g 2seg

126-70-410
Stoc epuizat

345,00Lei

Lanseta Rapture STX Dropshot Finesse L 2.40m 4-21g 2seg

Lanseta Rapture STX Dropshot Finesse L 2.40m 4-21g 2seg

126-70-120
Stoc epuizat

335,00Lei

Afişare 581 - 600 din 607 (31 pagini)
Queries: 8, Total time: 492.747 ms [By time] [By id] [By file]
1 (0.105)
SELECT data
FROM `oc_session`
WHERE session_id = 'ed50d1eb7496e2d0664fac5ee7'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.115)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (489.212)
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 (pd.tag LIKE "%2.40%") 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.819)
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 580, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.153)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"PRODUSE INACTIVE"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
6 (0.118)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"ROM-EUROTRADE SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
7 (0.111)
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
8 (0.114)
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