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 90 zile

Retur simplu in 90 zile.

Vezi mai multe detalii

Oferte speciale


Set Swinger 4 Buc Fl Mkm-3 Plus Cofret -8%
Exclusiv online!

Set Swinger 4 Buc Fl Mkm-3 Plus Cofret

3243168337176
Livrare 24-48 ore

223,90Lei(-8%) 205,28Lei

Shad Jackall Rhythm Wave 2,8inch Neon Pearl Walasagi 8buc/pl -37%
Exclusiv online!

Shad Jackall Rhythm Wave 2,8inch Neon Pearl Walasagi 8buc/pl

f1.ja.807199567
Livrare 24-48 ore

50,93Lei(-37%) 32,07Lei

Shad Jackall Rhythm Wave 3,8inch Dark Thunder/cs 7buc/pl -37%
Exclusiv online!

Shad Jackall Rhythm Wave 3,8inch Dark Thunder/cs 7buc/pl

f1.ja.807128611
Livrare 24-48 ore

50,93Lei(-37%) 32,07Lei

Shad Jackall Rhythm Wave 3,8inch Bluegill/pearl White 7buc/pl -37%
Exclusiv online!

Shad Jackall Rhythm Wave 3,8inch Bluegill/pearl White 7buc/pl

f1.ja.807128635
Livrare 24-48 ore

50,93Lei(-37%) 32,07Lei

Shad Bass Assassin Die Dapper, Houdini, 8.9cm, 10buc/pac -15%

Shad Bass Assassin Die Dapper, Houdini, 8.9cm, 10buc/pac

bsadda78466
Livrare imediată!

29,50Lei(-15%) 25,20Lei

Shad Colmic Herakles Vobbler 10cm Pumpkin Chartreuse 7buc/plic -25%
Exclusiv online!

Shad Colmic Herakles Vobbler 10cm Pumpkin Chartreuse 7buc/plic

arhkfv04
Livrare 48-72 ore

29,90Lei(-25%) 22,55Lei

Shad Fox Rage Pro Shad 14cm Sn Roach -8%

Shad Fox Rage Pro Shad 14cm Sn Roach

nsl1170
Livrare imediată!

17,85Lei(-8%) 16,44Lei

Shad Fox Rage Zander Pro Ultra Uv - Dark Oil, 10cm -11%

Shad Fox Rage Zander Pro Ultra Uv - Dark Oil, 10cm

nsl1267
Livrare imediată!

5,51Lei(-11%) 4,91Lei

Shad Fox Rage Zander Pro Ultra Uv - Raspberry, 12cm -15%

Shad Fox Rage Zander Pro Ultra Uv - Raspberry, 12cm

nsl1270
Livrare imediată!

7,30Lei(-15%) 6,20Lei

Shad Jackall Rhythm Wave 7.11cm Blue Gill/pearl White 8buc/pl -37%
Exclusiv online!

Shad Jackall Rhythm Wave 7.11cm Blue Gill/pearl White 8buc/pl

f1.ja.807141689
Livrare 24-48 ore

50,93Lei(-37%) 32,07Lei

Shad Jackall Rhythm Wave 7.11cm Chartreuse Back Shad 8buc/pl -37%
Exclusiv online!

Shad Jackall Rhythm Wave 7.11cm Chartreuse Back Shad 8buc/pl

f1.ja.807141726
Livrare 24-48 ore

50,93Lei(-37%) 32,07Lei

Shad Jackall Rhythm Wave 7.11cm Dark Thunder/cs 8buc/pl -37%
Exclusiv online!

Shad Jackall Rhythm Wave 7.11cm Dark Thunder/cs 8buc/pl

f1.ja.807141665
Livrare 24-48 ore

50,93Lei(-37%) 32,07Lei

Shad Lake Fork Sickle Tail Baby Shad 5.6cm Inch.magic Shad 15buc/plic -20%

Shad Lake Fork Sickle Tail Baby Shad 5.6cm Inch.magic Shad 15buc/plic

01-2600-113
Livrare imediată!

21,50Lei(-20%) 17,17Lei

Shad Live Target Ghost Tail Minnow Dropshot, 201 Silver Blue, 9.5cm, 4buc/plic -26%
Exclusiv online!

Shad Live Target Ghost Tail Minnow Dropshot, 201 Silver Blue, 9.5cm, 4buc/plic

f1.lt.gtm95sk201
Livrare 24-48 ore

42,88Lei(-26%) 31,52Lei

Shad Live Target Ghost Tail Minnow Dropshot, Silver / Blue, 11.5cm, 4buc/pac -26%
Exclusiv online!

Shad Live Target Ghost Tail Minnow Dropshot, Silver / Blue, 11.5cm, 4buc/pac

f1.lt.gtm115sk201
Livrare 24-48 ore

42,88Lei(-26%) 31,52Lei

Shad Live Target Ghost Tail Minnow Dropshot, Silver / Brown, 11.5cm, 4buc/pac -47%
Exclusiv online!

Shad Live Target Ghost Tail Minnow Dropshot, Silver / Brown, 11.5cm, 4buc/pac

f1.lt.gtm115sk934
Livrare 24-48 ore

42,88Lei(-47%) 22,80Lei

Shad Live Target Ghost Tail Minnow Dropshot, Silver / Brown, 9.5cm, 4buc/pac -47%
Exclusiv online!

Shad Live Target Ghost Tail Minnow Dropshot, Silver / Brown, 9.5cm, 4buc/pac

f1.lt.gtm95sk934
Livrare 24-48 ore

42,88Lei(-47%) 22,80Lei

Shad Live Target Ghost Tail Minnow Dropshot, Silver / Green, 11.5cm, 4buc/pac -26%
Exclusiv online!

Shad Live Target Ghost Tail Minnow Dropshot, Silver / Green, 11.5cm, 4buc/pac

f1.lt.gtm115sk952
Livrare 24-48 ore

42,88Lei(-26%) 31,52Lei

Shad Live Target Ghost Tail Minnow Dropshot, Silver / Green, 9.5cm, 4buc/pac -26%
Exclusiv online!

Shad Live Target Ghost Tail Minnow Dropshot, Silver / Green, 9.5cm, 4buc/pac

f1.lt.gtm95sk952
Livrare 24-48 ore

42,88Lei(-26%) 31,52Lei

Shad Live Target Ghost Tail Minnow Dropshot, Silver / Pearl, 11.5cm, 4buc/pac -26%
Exclusiv online!

Shad Live Target Ghost Tail Minnow Dropshot, Silver / Pearl, 11.5cm, 4buc/pac

f1.lt.gtm115sk134
Livrare 24-48 ore

42,88Lei(-26%) 31,52Lei

Afişare 2221 - 2240 din 9304 (466 pagini)
Queries: 5, Total time: 868.888 ms [By time] [By id] [By file]
1 (0.085)
SELECT data
FROM `oc_session`
WHERE session_id = '565b62297414bf3c264ad77e26'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.081)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (368.673)
SELECT COUNT(1) AS total
FROM oc_product_special ps
LEFT JOIN oc_product p ON (ps.product_id = p.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE p.status = '1' AND p2s.store_id = '2' AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) AND p.quantity > '0'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1714
4 (499.906)
SELECT DISTINCT ps.product_id
FROM oc_product_special ps
LEFT JOIN oc_product p 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 p.status = '1' AND p.quantity > '0' AND p2s.store_id = '2' AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) GROUP BY ps.product_id
ORDER BY p.sort_order ASC, LCASE(pd.name) ASC LIMIT 2220,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:588
5 (0.143)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '2' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:37