Abu Garcia


Mulineta Abu Garcia Superior 2500S -13%

Mulineta Abu Garcia Superior 2500S

1500956
Livrare imediată!

450,00Lei(-13%) 389,62Lei

Lingurita Rotativa ABU GARCIA Reflex White LF, Silver, 18g, 6.5cm

Lingurita Rotativa ABU GARCIA Reflex White LF, Silver, 18g, 6.5cm

1549922
Livrare 7-14 zile

29,48Lei

Geanta Impermeabila Abu Garcia Waterproof Boat Bag, 38x48x24 cm

Geanta Impermeabila Abu Garcia Waterproof Boat Bag, 38x48x24 cm

1530849
Livrare 7-14 zile

215,55Lei

Vobler Hard Bait Abu Garcia Svartzonker SVZ McMy Tail, Real Hot Pike, 20cm, 83g

Vobler Hard Bait Abu Garcia Svartzonker SVZ McMy Tail, Real Hot Pike, 20cm, 83g

1550144
Livrare 7-14 zile

118,96Lei

Mulineta Abu Garcia Abumatic 276UI Spincast

Mulineta Abu Garcia Abumatic 276UI Spincast

1139307
Livrare imediată!

207,41Lei

Lingurita Oscilanta ABU GARCIA Shaky, Brown Trout, 10g, 1buc/pac

Lingurita Oscilanta ABU GARCIA Shaky, Brown Trout, 10g, 1buc/pac

1572784
Livrare 7-14 zile

25,40Lei

Lingura Rotativa Abu Garcia Droppen Maxi Spinners, Gold Fluo Orange, 9g, 7.5cm

Lingura Rotativa Abu Garcia Droppen Maxi Spinners, Gold Fluo Orange, 9g, 7.5cm

1549801
Livrare 7-14 zile

62,01Lei

Lingurita Rotativa ABU GARCIA Fast Attack Stickle Spinner, 8cm, 12g, Firetiger, 1buc/pac

Lingurita Rotativa ABU GARCIA Fast Attack Stickle Spinner, 8cm, 12g, Firetiger, 1buc/pac

1596287
Livrare 7-14 zile

41,67Lei

Vobler Abu Garcia Svartzokner Mc Snack, Glow Shad, 22g, 9cm

Vobler Abu Garcia Svartzokner Mc Snack, Glow Shad, 22g, 9cm

1550158
Livrare 7-14 zile

62,01Lei

Lanseta Abu Garcia EON 702ML Spinning Rod, 2.13m, 5-21g, 2seg

Lanseta Abu Garcia EON 702ML Spinning Rod, 2.13m, 5-21g, 2seg

1561339
Livrare 7-14 zile

859,18Lei

Pluta Abu Garcia Bombarda Float Stop, Clear, 15g

Pluta Abu Garcia Bombarda Float Stop, Clear, 15g

1110077
Livrare imediată!

19,30Lei

Combo Abu Garcia Revo X Spinning M, 7-28g, 2.44m, 2seg

Combo Abu Garcia Revo X Spinning M, 7-28g, 2.44m, 2seg

1579563
Livrare 7-14 zile

926,29Lei

Lanseta Abu Garcia Beast Casting Rod 862XH, 50-200g, 2.59m, 2seg

Lanseta Abu Garcia Beast Casting Rod 862XH, 50-200g, 2.59m, 2seg

1561313
Livrare 7-14 zile

601,93Lei

Mulineta Abu Garcia Revo 5 X-W LP Casting Reel Left Hand

Mulineta Abu Garcia Revo 5 X-W LP Casting Reel Left Hand

1565151
Livrare 7-14 zile

559,23Lei

Lanseta Abu Garcia Beast Pro Pelagic Casting Rod 6511H, 50-120g, 1.95m, 1+1seg

Lanseta Abu Garcia Beast Pro Pelagic Casting Rod 6511H, 50-120g, 1.95m, 1+1seg

1577392
Livrare 7-14 zile

1.007,60Lei

Vobler Abu Garcia Svartzonker McHybrid, Yellow Fin Perch, 74g, 16.5cm

Vobler Abu Garcia Svartzonker McHybrid, Yellow Fin Perch, 74g, 16.5cm

1531897
Livrare 7-14 zile

98,62Lei

Vobler Abu Garcia Svartzonker McHybrid, Fire Bass, 74g, 16.5cm

Vobler Abu Garcia Svartzonker McHybrid, Fire Bass, 74g, 16.5cm

1550108
Livrare 7-14 zile

98,62Lei

Lingurita Oscilanta Abu Garcia Atom, YP, 35g, 9cm

Lingurita Oscilanta Abu Garcia Atom, YP, 35g, 9cm

p.1312845
Livrare 24-48 ore

42,83Lei

Lanseta ABU GARCIA Tormentor 2 Travel Spinning Rod M, 7-28g, 2.74m, 4seg

Lanseta ABU GARCIA Tormentor 2 Travel Spinning Rod M, 7-28g, 2.74m, 4seg

1612492
Livrare 7-14 zile

258,25Lei

Lanseta Abu Garcia Carabus Exquisite Spinning Rod L, 1.5-4.5g, 1.83m, 2seg

Lanseta Abu Garcia Carabus Exquisite Spinning Rod L, 1.5-4.5g, 1.83m, 2seg

1612455
Livrare 7-14 zile

215,55Lei

Afişare 1 - 20 din 1426 (72 pagini)
💬
WhatsApp Chat
👋 Salut! Cu ce vă pot ajuta?

Pot răspunde la întrebări despre:
✅ Comenzi și status livrare
✅ Informatii produse
✅ Recomandari produse(beta)
✅ Compatibilitate intre produse(beta)
Queries: 7, Total time: 86.196 ms [By time] [By id] [By file]
1 (0.099)
SELECT data
FROM `oc_session`
WHERE session_id = '3d860fbadc32d16cfd6670c0e2'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.079)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.099)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Abu-Garcia'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.137)
SELECT *
FROM oc_manufacturer m
LEFT JOIN oc_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id)
WHERE m.manufacturer_id = '122' AND m2s.store_id = '0'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
5 (36.535)
SELECT COUNT(1) AS total
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '2' AND p.status = '1' AND p.quantity > '0' AND p.price > '0' AND p2s.store_id = '0' AND p.manufacturer_id = '122'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1699
6 (49.158)
SELECT p.product_id, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, ps.price AS special, p.viewed, p.price
FROM oc_product p
LEFT JOIN (SELECT pss.price, pss.product_id
FROM oc_product_special pss GROUP BY pss.product_id) ps ON (ps.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '2' AND p.status = '1' AND p.quantity > '0' AND p.price > '0' AND p2s.store_id = '0' AND p.manufacturer_id = '122' GROUP BY p.product_id
ORDER BY p.sort_order ASC LIMIT 0,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.089)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '0' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:37