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

Oferte speciale


Opritor Fish Pro Indicator Ata Pt. Match 6buc/plic -20%

Opritor Fish Pro Indicator Ata Pt. Match 6buc/plic

ci3500 - 47
Livrare imediată!

3,00Lei(-20%) 2,40Lei

Opritor Lineaeffe Din Cauciuc 10buc/plic D=8mm -29%

Opritor Lineaeffe Din Cauciuc 10buc/plic D=8mm

a.4960700
Livrare imediată!

6,21Lei(-29%) 4,44Lei

Opritor Maver Bile Solubile Argint Perlat -18%
Exclusiv online!

Opritor Maver Bile Solubile Argint Perlat

1300000
Livrare 48-72 ore

7,60Lei(-18%) 6,20Lei

Opritor Tungsten Mikado Brown, 15buc/plic -20%

Opritor Tungsten Mikado Brown, 15buc/plic

amc-11683
Livrare imediată!

21,00Lei(-20%) 16,80Lei

Opritore Nash Tungsten Helicopter Top Beads, 8buc/pac -24%

Opritore Nash Tungsten Helicopter Top Beads, 8buc/pac

t8435
Livrare imediată!

33,99Lei(-24%) 25,89Lei

Original Buff Savage Tec Tube Black Captusita Fleece -38%
Exclusiv online!

Original Buff Savage Tec Tube Black Captusita Fleece

a8.sg.50838
Livrare 24-48 ore

56,77Lei(-38%) 34,96Lei

Oscilanta Cormoran Cora-z 35mm/6g Gold/gold -31%
Exclusiv online!

Oscilanta Cormoran Cora-z 35mm/6g Gold/gold

f.50.860406
Livrare 24-48 ore

9,69Lei(-31%) 6,71Lei

Oscilanta Dam Effzett Perch Spoon Blood Perch 17gr 70mm -49%

Oscilanta Dam Effzett Perch Spoon Blood Perch 17gr 70mm

13042966665
Livrare imediată!

30,44Lei(-49%) 15,67Lei

Oscilanta Dam Effzett Perch Spoon Blood Perch 36gr 90mm -39%

Oscilanta Dam Effzett Perch Spoon Blood Perch 36gr 90mm

13042966669
Livrare imediată!

31,76Lei(-39%) 19,37Lei

Oscilanta Dam Effzett Perch Spoon Fire Perch Uv 36gr 90mm -39%

Oscilanta Dam Effzett Perch Spoon Fire Perch Uv 36gr 90mm

13042966667
Livrare imediată!

31,76Lei(-39%) 19,37Lei

Oscilanta Dam Effzett Perch Spoon Orange Perch Uv 36gr 90mm -39%

Oscilanta Dam Effzett Perch Spoon Orange Perch Uv 36gr 90mm

13042966668
Livrare imediată!

31,76Lei(-39%) 19,37Lei

Oscilanta Dam Effzett Roach Spoon Pink Roach Uv 32gr 90mm -39%

Oscilanta Dam Effzett Roach Spoon Pink Roach Uv 32gr 90mm

13042966656
Livrare imediată!

31,76Lei(-39%) 19,37Lei

Oscilanta Dam Effzett Standard Holo Black 6gr 32mm -25%

Oscilanta Dam Effzett Standard Holo Black 6gr 32mm

13042969588
Livrare imediată!

15,09Lei(-25%) 11,34Lei

Oscilanta Madcat A-static Rattlin Inline Spoons 125g Glow-in-the-dark -30%

Oscilanta Madcat A-static Rattlin Inline Spoons 125g Glow-in-the-dark

13083156832
Livrare imediată!

75,23Lei(-30%) 52,66Lei

Oscilanta Madcat A-static Rattlin Inline Spoons 125g Green -30%

Oscilanta Madcat A-static Rattlin Inline Spoons 125g Green

13083156831
Livrare imediată!

75,23Lei(-30%) 52,66Lei

Oscilanta Madcat A-static Rattlin Inline Spoons 125gr Fluo Yellow Uv -30%

Oscilanta Madcat A-static Rattlin Inline Spoons 125gr Fluo Yellow Uv

13083166120
Livrare imediată!

73,74Lei(-30%) 51,63Lei

Overwrap Pt Mivardi New Dynasty -29%

Overwrap Pt Mivardi New Dynasty

m-bivndo
Livrare imediată!

1.150,00Lei(-29%) 821,90Lei

Palarie Delphin Cu Plasa Anti Tantari C2g Shield -24%

Palarie Delphin Cu Plasa Anti Tantari C2g Shield

101002778
Livrare imediată!

34,00Lei(-24%) 25,89Lei

Paleta Nadire Delphin Dumper Full 30cm -47%

Paleta Nadire Delphin Dumper Full 30cm

101001477
Livrare imediată!

41,00Lei(-47%) 21,90Lei

Paleta Rotativa Rapture Flash Willow Golden Pentru Momeli Siliconice 3.0cm, 2 Buc/plic -22%

Paleta Rotativa Rapture Flash Willow Golden Pentru Momeli Siliconice 3.0cm, 2 Buc/plic

188-22-310
Livrare imediată!

19,00Lei(-22%) 14,90Lei

Afişare 6761 - 6780 din 9093 (455 pagini)
Queries: 5, Total time: 616.061 ms [By time] [By id] [By file]
1 (0.106)
SELECT data
FROM `oc_session`
WHERE session_id = 'e53dadc866c42af699a5cc7c2d'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.062)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (289.702)
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 (326.046)
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 6760,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:588
5 (0.145)
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