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


Lanseta Sportex Rapid Spin 270 20g

Lanseta Sportex Rapid Spin 270 20g

rp2701
Stoc epuizat

650,00Lei

Lanseta Pontoon21 Psychogun PGSS732MSF 2.2m 7-24g Fast

Lanseta Pontoon21 Psychogun PGSS732MSF 2.2m 7-24g Fast

pgss732msf
Stoc epuizat

970,00Lei

Lanseta Spinning Daiwa 2seg Prorex S, 2,40m/10-50g

Lanseta Spinning Daiwa 2seg Prorex S, 2,40m/10-50g

d.11280.242
Stoc epuizat

358,61Lei

Mulineta Colmic Laris FD 6000 8+1BB

Mulineta Colmic Laris FD 6000 8+1BB

mullar60
Stoc epuizat

359,00Lei

Combo Mitchell Tanager SW Dorade Spinning H, 50-150g, 2.10m, 2seg

Combo Mitchell Tanager SW Dorade Spinning H, 50-150g, 2.10m, 2seg

1544376
Stoc epuizat

269,96Lei

Fir Textil Berkley Whiplash 8 Green 0.16mm 20.8kg 150m

Fir Textil Berkley Whiplash 8 Green 0.16mm 20.8kg 150m

1446652
Stoc epuizat

112,10Lei

FIR TEXTIL P-LINE X TCB 8 BRAID TEFLON GREEN 0.18mm 14.5kg 135M -5%

FIR TEXTIL P-LINE X TCB 8 BRAID TEFLON GREEN 0.18mm 14.5kg 135M

750190004
Stoc epuizat

77,00Lei(-5%) 72,99Lei

Lanseta Pastrav Abu Garcia Carabus Distinct CDST Rod 642UL, 1.90m, 0.8-4g, 2seg
Lanseta Pontoon21 GAD Gancho GNH602XULF 1.83m 0.5-4g Fast

Lanseta Pontoon21 GAD Gancho GNH602XULF 1.83m 0.5-4g Fast

gnh602xulf
Stoc epuizat

349,00Lei

Lanseta Pontoon21 Psychogun PGSS682ULSF 2.03m 1.4-7g Fast

Lanseta Pontoon21 Psychogun PGSS682ULSF 2.03m 1.4-7g Fast

pgss682ulsf
Stoc epuizat

725,00Lei

Lanseta Sportex Nobun Spin 235 20g

Lanseta Sportex Nobun Spin 235 20g

nb2301
Stoc epuizat

4.170,00Lei

Kit Penn Combo Wrath Spin, 3.00M, 20-80g, 2seg

Kit Penn Combo Wrath Spin, 3.00M, 20-80g, 2seg

1522076
Stoc epuizat

461,80Lei

Kit Spinning pentru Copii Shakespeare Catch a Monster Spin Yellow

Kit Spinning pentru Copii Shakespeare Catch a Monster Spin Yellow

1506890
Stoc epuizat

112,46Lei

Lanseta Delphin GreenCODE 2.10m, 25g, 2seg -34%

Lanseta Delphin GreenCODE 2.10m, 25g, 2seg

101003128
Stoc epuizat

177,00Lei(-34%) 116,00Lei

Lanseta Sportex Jig-Xpert Zander 250 15-45g

Lanseta Sportex Jig-Xpert Zander 250 15-45g

jx2502
Stoc epuizat

690,00Lei

Mulineta Quantum Escalade EM 3000

Mulineta Quantum Escalade EM 3000

0406830
Stoc epuizat

307,60Lei

Fir Textil Berkley Whiplash 8, Yellow, 150m, 0.14mm, 19.2kg -36%

Fir Textil Berkley Whiplash 8, Yellow, 150m, 0.14mm, 19.2kg

1446684
Stoc epuizat

124,50Lei(-36%) 79,77Lei

Lanseta Graphiteleader Super Finezza GSFS-712ML-T Fast 2.42m 1-15g Medium Light
Lanseta Mitchell Epic MX1 Spinning 182 ML, 1.80m, 2-12g, 2seg

Lanseta Mitchell Epic MX1 Spinning 182 ML, 1.80m, 2-12g, 2seg

1561464
Stoc epuizat

139,96Lei

Lanseta Pontoon21 GAD Fair FAS702MLF 2.13m 3-15g Fast

Lanseta Pontoon21 GAD Fair FAS702MLF 2.13m 3-15g Fast

fas702mlf
Stoc epuizat

205,00Lei

Afişare 7501 - 7520 din 7808 (391 pagini)
Queries: 11, Total time: 241.672 ms [By time] [By id] [By file]
1 (0.110)
SELECT data
FROM `oc_session`
WHERE session_id = '6d3239c4f38d41ddecdb71003d'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.093)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (0.106)
SELECT *
FROM oc_url_alias
WHERE keyword = 'search'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (209.770)
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('+rapitori' 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
5 (31.027)
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 7500, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
6 (0.113)
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
7 (0.095)
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
8 (0.088)
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
9 (0.089)
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
10 (0.087)
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
11 (0.094)
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