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 - vu.2.5878

Produse ce potrivesc criteriilor de căutare


Lanseta Mitchell Traxx MX3LE Deadbait Rod 1002H, 3.04m, 2seg

Lanseta Mitchell Traxx MX3LE Deadbait Rod 1002H, 3.04m, 2seg

1542795
Stoc epuizat

420,37Lei

Lanseta Pastrav Abu Garcia Carabus Nano CNA Rod 602XULS, 1.80m, 0.3-2.5g, 2seg
Lanseta Pastrav Palms Egeria Native ETNC-53L, 1.61m, 85g, 2.5-8g, 2seg

Lanseta Pastrav Palms Egeria Native ETNC-53L, 1.61m, 85g, 2.5-8g, 2seg

etns-53l
Stoc epuizat

765,00Lei

Lanseta Rapala Classic Countdown 2.44m, 14-42g, 2seg

Lanseta Rapala Classic Countdown 2.44m, 14-42g, 2seg

rcds802mhf
Stoc epuizat

1.429,00Lei

Lanseta Rapala Shadow Blade Spinning 2.13m, 10-28g, 2seg

Lanseta Rapala Shadow Blade Spinning 2.13m, 10-28g, 2seg

rsb702mf
Stoc epuizat

419,00Lei

Lanseta Rapala Shadow Blade Spinning 2.13m, 14-42g, 2seg

Lanseta Rapala Shadow Blade Spinning 2.13m, 14-42g, 2seg

rsb702mhf
Stoc epuizat

419,00Lei

Lanseta Rapala Shadow Blade Spinning 2.13m, 5-21g, 2seg

Lanseta Rapala Shadow Blade Spinning 2.13m, 5-21g, 2seg

rsb702mlf
Stoc epuizat

419,00Lei

Lanseta Rapala Shadow Blade Spinning 2.44m, 10-28g, 2seg

Lanseta Rapala Shadow Blade Spinning 2.44m, 10-28g, 2seg

rsb802mf
Stoc epuizat

469,00Lei

Monofilament Delphin KYOTO Albastru, 0.148mm, 2.0kg, 5000m

Monofilament Delphin KYOTO Albastru, 0.148mm, 2.0kg, 5000m

101004379
Stoc epuizat

323,00Lei

Mulineta Quantum Drive, DR05

Mulineta Quantum Drive, DR05

0370005
Stoc epuizat

108,77Lei

Mulineta Ryobi Ecusima Vi 3000 5+1rul

Mulineta Ryobi Ecusima Vi 3000 5+1rul

ry-ecs3000vi
Stoc epuizat

245,00Lei

Combo Spinning Berkley Catch More Fish Pike 4000, 5.2:1, 2.40m, 10-40g, 2seg
Fir Monofilament DAIWA Infinity Carp Line, Maro, 0.28mm, 6.30kg, 500m

Fir Monofilament DAIWA Infinity Carp Line, Maro, 0.28mm, 6.30kg, 500m

d.12765.028
Stoc epuizat

57,52Lei

Fir Monofilament DAIWA Infinity Carp Line, Maro, 0.30mm, 6.90kg, 500m

Fir Monofilament DAIWA Infinity Carp Line, Maro, 0.30mm, 6.90kg, 500m

d.12765.030
Stoc epuizat

59,10Lei

Fir Monofilament DAIWA Infinity Carp Line, Maro, 0.34mm, 9.20kg, 500m

Fir Monofilament DAIWA Infinity Carp Line, Maro, 0.34mm, 9.20kg, 500m

d.12765.034
Stoc epuizat

70,53Lei

Fir Monofilament DAIWA Infinity Carp Line, Maro, 0.37mm, 10.10kg, 500m

Fir Monofilament DAIWA Infinity Carp Line, Maro, 0.37mm, 10.10kg, 500m

d.12765.037
Stoc epuizat

73,45Lei

Fir Textil Berkley Fireline Ultra 8 Verde Fluo 0.12mm 7.2 kg 150m -20%

Fir Textil Berkley Fireline Ultra 8 Verde Fluo 0.12mm 7.2 kg 150m

1446594
Stoc epuizat

95,40Lei(-20%) 76,31Lei

Fir Textil Berkley Whiplash 8 Crystal 0.08mm 12.90kg 150m -20%

Fir Textil Berkley Whiplash 8 Crystal 0.08mm 12.90kg 150m

1446618
Stoc epuizat

115,80Lei(-20%) 92,64Lei

Fir Textil Berkley Whiplash 8 Green 150m 0.12mm/17.5kg -36%

Fir Textil Berkley Whiplash 8 Green 150m 0.12mm/17.5kg

1446650
Stoc epuizat

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

Fir Textil Daiwa Tournament 8xBraid EVO+ Verde, 0.20mm, 135m, 18kg

Fir Textil Daiwa Tournament 8xBraid EVO+ Verde, 0.20mm, 135m, 18kg

d.12760.020
Stoc epuizat

118,80Lei

Afişare 7721 - 7740 din 7816 (391 pagini)
Queries: 14, Total time: 248.246 ms [By time] [By id] [By file]
1 (0.135)
SELECT data
FROM `oc_session`
WHERE session_id = 'afb7f93b6a70ff3ba4f76fdbf2'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.104)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (0.127)
SELECT *
FROM oc_url_alias
WHERE keyword = 'search'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (215.160)
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.762)
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 7720, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
6 (0.132)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"TACKLE SHOP ARENA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
7 (0.093)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"RAPALA VMC ROMANIA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
8 (0.080)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"RAPALA VMC ROMANIA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
9 (0.073)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"RAPALA VMC ROMANIA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
10 (0.076)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"RAPALA VMC ROMANIA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
11 (0.127)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"RAPALA VMC ROMANIA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
12 (0.123)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"TACKLE SHOP ARENA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
13 (0.120)
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
14 (0.134)
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