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 - K-Karp

Produse ce potrivesc criteriilor de căutare


LANSETA KORUM OPPORTUNIST X 8FT 2LBS 2.45M 30-120G 2seg -17%

LANSETA KORUM OPPORTUNIST X 8FT 2LBS 2.45M 30-120G 2seg

k0330028
Livrare imediată!

354,20Lei(-17%) 295,69Lei

GEANTA PROLOGIC AVENGER CARRYALL MAR.2XL

GEANTA PROLOGIC AVENGER CARRYALL MAR.2XL

a8.pro.65064
Livrare imediată!

430,23Lei

Wafter 220Baits 6 mm Capsuni Krill 35 ml Alb & Portocaliu

Wafter 220Baits 6 mm Capsuni Krill 35 ml Alb & Portocaliu

5152226497470
Livrare imediată!

25,00Lei

Geanta Spro FreeStyle Shoulder Bag V2

Geanta Spro FreeStyle Shoulder Bag V2

006205-00310-00000
Livrare imediată!

291,00Lei

LANSETA KORUM BIG WATER 3.65M 2.25LBS 2seg

LANSETA KORUM BIG WATER 3.65M 2.25LBS 2seg

k0330040
Livrare imediată!

674,96Lei

LANSETA KORUM OPPORTUNIST 10FT 3.05M 2.25LBS 2SEG

LANSETA KORUM OPPORTUNIST 10FT 3.05M 2.25LBS 2SEG

k0330010
Livrare imediată!

328,46Lei

Lanseta DAM Base-X Allround 3.00m 30-60g
Exclusiv online!

Lanseta DAM Base-X Allround 3.00m 30-60g

2040970373
Livrare 48-72 ore

132,09Lei

Geanta JRC Defender Low XL Carryall 63x31x21cm

Geanta JRC Defender Low XL Carryall 63x31x21cm

1552896
Livrare imediată!

269,96Lei

Geanta JRC Defender Carryall X-Large 66x34x38cm -27%

Geanta JRC Defender Carryall X-Large 66x34x38cm

1445868
Livrare imediată!

270,00Lei(-27%) 196,00Lei

Lanseta DAM Base-X Allround 2.70m 30-60g

Lanseta DAM Base-X Allround 2.70m 30-60g

2040970372
Livrare imediată!

121,21Lei

Kit Plumb Pierdut RidgeMonkey Connexion Uni Lead Clip Negru -10%

Kit Plumb Pierdut RidgeMonkey Connexion Uni Lead Clip Negru

rmt103
Livrare imediată!

42,03Lei(-10%) 37,82Lei

Geanta JRC Rova Compact Carryall Large 57x32x33cm -21%

Geanta JRC Rova Compact Carryall Large 57x32x33cm

1537839
Livrare imediată!

292,45Lei(-21%) 230,90Lei

TAMBUR DAIWA UNIVERSAL MULINETA LT 5000D

TAMBUR DAIWA UNIVERSAL MULINETA LT 5000D

d.19115.500
Livrare imediată!

127,19Lei

Lanseta DAM Base-X Allround 2.40m 30-60g
Exclusiv online!

Lanseta DAM Base-X Allround 2.40m 30-60g

2040970371
Livrare 48-72 ore

112,50Lei

HUSA LANSETE KORUM TRANSITION OPPORTUNIST FOLDALL 130X28CM

HUSA LANSETE KORUM TRANSITION OPPORTUNIST FOLDALL 130X28CM

k0290059
Livrare imediată!

642,02Lei

Tambur de Rezerva Universal Daiwa Mulineta LT 6000D -23%

Tambur de Rezerva Universal Daiwa Mulineta LT 6000D

d.19115.600
Livrare imediată!

138,61Lei(-23%) 106,90Lei

LANSETA KORUM OPPORTUNIST XTND 10FT 2.75LBS 3.04M 60-200G 2SEG

LANSETA KORUM OPPORTUNIST XTND 10FT 2.75LBS 3.04M 60-200G 2SEG

k0330032
Livrare imediată!

404,96Lei

LANSETA KORUM OPPORTUNIST X 8FT 2LBS 2.45M 60-180G 2seg

LANSETA KORUM OPPORTUNIST X 8FT 2LBS 2.45M 60-180G 2seg

k0330029
Livrare imediată!

354,20Lei

Geanta JRC Defender Tackle Bag 28x15x15cm -21%

Geanta JRC Defender Tackle Bag 28x15x15cm

1548377
Livrare imediată!

157,46Lei(-21%) 123,90Lei

LANSETA KORUM OPPORTUNIST X QUIVER 8FT 2.45M 15-90G 2+2seg

LANSETA KORUM OPPORTUNIST X QUIVER 8FT 2.45M 15-90G 2+2seg

k0330027
Livrare imediată!

354,00Lei

Afişare 101 - 120 din 1075 (54 pagini)
Queries: 5, Total time: 246.692 ms [By time] [By id] [By file]
1 (0.104)
SELECT data
FROM `oc_session`
WHERE session_id = '800706a0097187353d5c746b8a'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.116)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:427
3 (241.053)
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 "%uni%") 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
4 (5.321)
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 100, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.098)
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