Abu Garcia


Lanseta Abu Garcia ORRA Predator Spinning Rod 702 MH, 10-40g, 2.13m, 2seg

Lanseta Abu Garcia ORRA Predator Spinning Rod 702 MH, 10-40g, 2.13m, 2seg

1580845
Livrare 7-14 zile

318,24Lei

Lanseta Abu Garcia Diplomat V2 Travel 804ML, 2.44m, 5-21g, 5seg

Lanseta Abu Garcia Diplomat V2 Travel 804ML, 2.44m, 5-21g, 5seg

1561329
Livrare 7-14 zile

323,32Lei

Combo Abu Garcia Max X Black Ops Spinning 802M, 10-30g, 2.44m, 2seg

Combo Abu Garcia Max X Black Ops Spinning 802M, 10-30g, 2.44m, 2seg

1551688
Livrare 7-14 zile

463,65Lei

Combo Abu Garcia Cardinal Classic Allround M, 10-40g, 2.40m, 3seg

Combo Abu Garcia Cardinal Classic Allround M, 10-40g, 2.40m, 3seg

1344998
Livrare imediată!

342,65Lei

Pluta Abu Garcia Bombarda Sink Float Stop, Black, 15g

Pluta Abu Garcia Bombarda Sink Float Stop, Black, 15g

1110089
Livrare imediată!

10,66Lei

Vobler Abu Garcia Svartzonker Mc My Tail, Real Hot Pike, 50g, 17cm

Vobler Abu Garcia Svartzonker Mc My Tail, Real Hot Pike, 50g, 17cm

1550136
Livrare 7-14 zile

106,75Lei

Lanseta ABU GARCIA Tormentor 2 Spinning Rod M, 10-30g, 1.83m, 2seg

Lanseta ABU GARCIA Tormentor 2 Spinning Rod M, 10-30g, 1.83m, 2seg

1612473
Livrare imediată!

143,35Lei

Lanseta Abu Garica Fantasista Nano Spinning Rod L, 2-14g, 2.03m, 2seg

Lanseta Abu Garica Fantasista Nano Spinning Rod L, 2-14g, 2.03m, 2seg

1612461
Livrare 7-14 zile

955,78Lei

Combo Abu Garcia Max SX Spinning ML, 5-21g, 2.13m, 2seg

Combo Abu Garcia Max SX Spinning ML, 5-21g, 2.13m, 2seg

1622849
Livrare 7-14 zile

403,66Lei

Mulineta ABU GARCIA Max X Spinning Reel 3000

Mulineta ABU GARCIA Max X Spinning Reel 3000

1609803
Livrare 7-14 zile

194,19Lei

Shad ABU GARCIA Beast Slim Paddletail, Bream, 21cm, 94g, 4buc/pac

Shad ABU GARCIA Beast Slim Paddletail, Bream, 21cm, 94g, 4buc/pac

1621274
Livrare 7-14 zile

163,69Lei

Vobler ABU GARCIA Beast Hi-Lo Jointed Sinking, Blue Herring, 9cm, 12g

Vobler ABU GARCIA Beast Hi-Lo Jointed Sinking, Blue Herring, 9cm, 12g

1621224
Livrare 7-14 zile

53,87Lei

Lingurita Oscilanta ABU GARCIA Toby Jointed, Red Hot Tiger, 14g, 1buc/pac

Lingurita Oscilanta ABU GARCIA Toby Jointed, Red Hot Tiger, 14g, 1buc/pac

1609460
Livrare 7-14 zile

37,61Lei

Agrafa ABU GARCIA Snap Swivels Gold, Nr.6, 10buc/pac

Agrafa ABU GARCIA Snap Swivels Gold, Nr.6, 10buc/pac

1376741
Livrare 7-14 zile

15,25Lei

Lingura Oscilanata ABU GARCIA Toby Spoon LF, White Flash, 28g, 9cm, 1buc/pac

Lingura Oscilanata ABU GARCIA Toby Spoon LF, White Flash, 28g, 9cm, 1buc/pac

1550233
Livrare 7-14 zile

27,44Lei

Lingura Oscilanata ABU GARCIA Toby Spoon LF, Goldfish, 15g, 7.5cm, 1buc/pac

Lingura Oscilanata ABU GARCIA Toby Spoon LF, Goldfish, 15g, 7.5cm, 1buc/pac

1546293
Livrare 7-14 zile

21,34Lei

Combo ABU GARCIA Fast Attack Pro Spinning Combo Pike 2.10m, 20-70g H, 2seg

Combo ABU GARCIA Fast Attack Pro Spinning Combo Pike 2.10m, 20-70g H, 2seg

1587178
Livrare imediată!

764,62Lei

Lingurita Oscilanta ABU GARCIA Atom, Culoare YP, 9cm, 35g, 1buc/pac

Lingurita Oscilanta ABU GARCIA Atom, Culoare YP, 9cm, 35g, 1buc/pac

1312845
Livrare 7-14 zile

33,54Lei

Vobler SAVAGE GEAR 4Play V2 Liplure Slow Floating, Fire Tiger, 16.5cm, 32g, 1buc/pac

Vobler SAVAGE GEAR 4Play V2 Liplure Slow Floating, Fire Tiger, 16.5cm, 32g, 1buc/pac

svs61747
Livrare imediată!

78,27Lei

Lingurita Oscilanta ABU GARCIA Jazz Spoon, KS Red Silver, 10g, 4.5cm, 1buc/pac

Lingurita Oscilanta ABU GARCIA Jazz Spoon, KS Red Silver, 10g, 4.5cm, 1buc/pac

1248366
Livrare 7-14 zile

23,37Lei

Afişare 1 - 20 din 1431 (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: 107.727 ms [By time] [By id] [By file]
1 (0.078)
SELECT data
FROM `oc_session`
WHERE session_id = '31cedf11446702d5e32221b8ed'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.072)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.096)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Abu-Garcia'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.134)
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 = '3'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
5 (43.714)
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 = '3' AND p.manufacturer_id = '122'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1699
6 (63.490)
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 = '3' 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.143)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '3' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:37