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


Combo Abu Garcia Max X Red Spinning 802H, 20-60g, 2.44m, 2seg

Combo Abu Garcia Max X Red Spinning 802H, 20-60g, 2.44m, 2seg

1531495
Stoc epuizat

472,47Lei

Combo Spinning Abu Garcia Tormentor Spinning H, 25-65g, 3.00m, 4seg

Combo Spinning Abu Garcia Tormentor Spinning H, 25-65g, 3.00m, 4seg

1530841
Stoc epuizat

652,47Lei

Kit de Intretinere Mulinete Abu Garcia Maintenance Kit -18%

Kit de Intretinere Mulinete Abu Garcia Maintenance Kit

1368791
Stoc epuizat

242,20Lei(-18%) 199,00Lei

Lanseta Abu Garcia Beast X Casting Rod 842EH, 50-220g, 2.54m, 2seg

Lanseta Abu Garcia Beast X Casting Rod 842EH, 50-220g, 2.54m, 2seg

1528379
Stoc epuizat

629,96Lei

Lanseta Abu Garcia Iaconelli Signatura Rod 702M, 10-30g, 2.13m, 2seg -50%

Lanseta Abu Garcia Iaconelli Signatura Rod 702M, 10-30g, 2.13m, 2seg

1531517
Stoc epuizat

948,58Lei(-50%) 471,39Lei

Lanseta Abu Garcia Rod Tormentor Travel Spin 8, 2.44m, 20-60g, 4seg

Lanseta Abu Garcia Rod Tormentor Travel Spin 8, 2.44m, 20-60g, 4seg

1520990
Stoc epuizat

250,71Lei

Lanseta Abu Garcia Svartzonker X 7112H, 30-100g, 2.40m, 2seg

Lanseta Abu Garcia Svartzonker X 7112H, 30-100g, 2.40m, 2seg

1579821
Stoc epuizat

382,45Lei

Lanseta Abu Garcia Venerate Spinning Cork Rod ML, 5-20g, 2.44m, 2seg

Lanseta Abu Garcia Venerate Spinning Cork Rod ML, 5-20g, 2.44m, 2seg

1539841
Stoc epuizat

267,71Lei

Montura Abu Garcia Svartzonker Stinger L, 2buc/plic

Montura Abu Garcia Svartzonker Stinger L, 2buc/plic

1517201
Stoc epuizat

55,20Lei

Mulineta Abu Garcia Ambassadeur C3-5501 Round Reel Left Hand Classic

Mulineta Abu Garcia Ambassadeur C3-5501 Round Reel Left Hand Classic

1292721
Stoc epuizat

944,96Lei

Mulineta Abu Garcia Revo MGXSP30 Spinning L 3000

Mulineta Abu Garcia Revo MGXSP30 Spinning L 3000

1501215
Stoc epuizat

1.401,61Lei

Mulineta Baitcast Abu Garcia Revo Beast Low Profile Right Hand, 40

Mulineta Baitcast Abu Garcia Revo Beast Low Profile Right Hand, 40

1479946
Stoc epuizat

1.349,96Lei

Vobler Abu Garcia Svartzonker McCelly, Blue Sunrise, 9g, 7cm

Vobler Abu Garcia Svartzonker McCelly, Blue Sunrise, 9g, 7cm

1531916
Stoc epuizat

59,96Lei

Vobler Abu Garcia Svartzonker McCelly, Real Hot Pike, 9g, 7cm

Vobler Abu Garcia Svartzonker McCelly, Real Hot Pike, 9g, 7cm

1531912
Stoc epuizat

59,96Lei

Vobler Abu Garcia Svartzonker McHybrid Baby, T SVZ, 8cm, 11g -56%

Vobler Abu Garcia Svartzonker McHybrid Baby, T SVZ, 8cm, 11g

1446045
Stoc epuizat

54,50Lei(-56%) 24,05Lei

Combo Abu Garcia Iaconelli 802M, 15-40g, 2.44m, 2seg

Combo Abu Garcia Iaconelli 802M, 15-40g, 2.44m, 2seg

1525562
Stoc epuizat

596,90Lei

Lanseta Abu Garcia Venturi V2 Spinning Rod 902M, 10-40g, 2.74m, 2seg

Lanseta Abu Garcia Venturi V2 Spinning Rod 902M, 10-40g, 2.74m, 2seg

1561358
Stoc epuizat

278,34Lei

Lanseta Baitcast Abu Garcia Beast Pro Casting Power Pike Rod 862EH, 50-150g, 2.59m, 2seg
Lingura Oscilanata Abu Garcia Hard Bait Toby Spoon, Sunset, 60g, 11.5cm

Lingura Oscilanata Abu Garcia Hard Bait Toby Spoon, Sunset, 60g, 11.5cm

1546322
Stoc epuizat

44,96Lei

VOBLER ABU GARCIA SVARTZONKER MCCELLY, YELLOW FIN PERCH, 14CM, 64G

VOBLER ABU GARCIA SVARTZONKER MCCELLY, YELLOW FIN PERCH, 14CM, 64G

1531921
Stoc epuizat

83,95Lei

Afişare 801 - 820 din 1109 (56 pagini)
Queries: 5, Total time: 25.651 ms [By time] [By id] [By file]
1 (0.097)
SELECT data
FROM `oc_session`
WHERE session_id = '5adc783392acb8e08eb0c65089'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.108)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (25.041)
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('+abu' 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 (0.222)
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
5 (0.183)
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