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 Fl Hangere Pe Lant 4buc Jy-sw-25t -7%
Exclusiv online!

Set Fl Hangere Pe Lant 4buc Jy-sw-25t

fl-jy-sw-25t
Livrare 7-14 zile

142,90Lei(-7%) 133,08Lei

Set Fl Swingere 4buc Jy-sw-26t -7%

Set Fl Swingere 4buc Jy-sw-26t

fl-jy-sw-26t
Livrare imediată!

124,90Lei(-7%) 115,80Lei

Set Jaxon 3 Bacuri Eva 4l 2.5l 1l -21%

Set Jaxon 3 Bacuri Eva 4l 2.5l 1l

re-101
Livrare imediată!

215,00Lei(-21%) 169,69Lei

Set Manere Korum S23 Arm Rest Kit Pentru Scaun S23 Standard Accesory Chair -49%
Exclusiv online!

Set Manere Korum S23 Arm Rest Kit Pentru Scaun S23 Standard Accesory Chair

k0300026
Livrare 7-14 zile

188,97Lei(-49%) 97,07Lei

Set Picheti Shakespeare Standard Bank Stick Selection, 6buc/set -31%

Set Picheti Shakespeare Standard Bank Stick Selection, 6buc/set

1155127
Livrare imediată!

123,17Lei(-31%) 85,29Lei

Set Prologic Farfurie Plus Tacamuri Black Fire -28%

Set Prologic Farfurie Plus Tacamuri Black Fire

svs72739
Livrare imediată!

177,66Lei(-28%) 127,07Lei

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

Set Swinger 4 Buc Fl Mkm-3 Plus Cofret

3243168337176
Livrare 7-14 zile

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

Afişare 2201 - 2220 din 9196 (460 pagini)
Queries: 5, Total time: 648.764 ms [By time] [By id] [By file]
1 (0.130)
SELECT data
FROM `oc_session`
WHERE session_id = 'eb1d6059e0eb1bc67082dd6538'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.127)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (301.609)
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 = '0' 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 (346.777)
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 = '0' 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 2200,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:588
5 (0.121)
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