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


Cutie Meiho Versus Vs-820ndm Black -15%

Cutie Meiho Versus Vs-820ndm Black

4963189143837
Livrare imediată!

30,00Lei(-15%) 25,39Lei

Cutie Meiho Vs-3010nd Black -18%

Cutie Meiho Vs-3010nd Black

4963189126588
Livrare imediată!

42,00Lei(-18%) 34,55Lei

Cutie Meiho Vs-708 Black -11%

Cutie Meiho Vs-708 Black

4963189126359
Livrare imediată!

23,99Lei(-11%) 21,33Lei

Cutie Momeala Eva Team Feeder By Dome Cu Capac 24x19x8cm -17%
Exclusiv online!

Cutie Momeala Eva Team Feeder By Dome Cu Capac 24x19x8cm

5305-009
Livrare 48-72 ore

82,00Lei(-17%) 67,70Lei

Cutie Nash Needle Box 0.2x3.2x2.4cm -18%

Cutie Nash Needle Box 0.2x3.2x2.4cm

t0282
Livrare imediată!

87,99Lei(-18%) 72,58Lei

Cutie Nash Shallow Box T0283 -34%

Cutie Nash Shallow Box T0283

t0283
Livrare imediată!

34,99Lei(-34%) 23,12Lei

Cutie Nash Slim Box 3 T0287 -36%

Cutie Nash Slim Box 3 T0287

t0287
Livrare imediată!

34,99Lei(-36%) 22,35Lei

Cutie Nash Slim Box 8 T0288 -2%

Cutie Nash Slim Box 8 T0288

t0288
Livrare imediată!

35,01Lei(-2%) 34,35Lei

Cutie Pentru Accesorii Fox F-box Medium Double -46%

Cutie Pentru Accesorii Fox F-box Medium Double

cbx006
Livrare imediată!

215,95Lei(-46%) 116,60Lei

Cutie Pentru Momeala Cresta Baitbox Holed, 0.25l -15%

Cutie Pentru Momeala Cresta Baitbox Holed, 0.25l

006403-00301-00000
Livrare imediată!

11,80Lei(-15%) 10,06Lei

Cutie Plano 3 Sertare Rabatabile 22-34 Compartimente -19%

Cutie Plano 3 Sertare Rabatabile 22-34 Compartimente

pmc620306
Livrare imediată!

179,96Lei(-19%) 145,28Lei

Cutie Plano Deep Stow Clear W/black Latches 705001 -42%

Cutie Plano Deep Stow Clear W/black Latches 705001

pmc705001
Livrare imediată!

119,50Lei(-42%) 69,02Lei

Cutie Plano Pla1313 Storage Box Clr P Wht Latch 35.6cm X 30.5cm X 33cm -65%

Cutie Plano Pla1313 Storage Box Clr P Wht Latch 35.6cm X 30.5cm X 33cm

pla1313
Livrare imediată!

104,96Lei(-65%) 36,55Lei

Cutie Plano Platch Deep Open Stow Yell Latch 2373101 -42%

Cutie Plano Platch Deep Open Stow Yell Latch 2373101

pmc2373101
Livrare imediată!

89,50Lei(-42%) 51,74Lei

Cutie Plano Prolatch Xxl Stowaway Storage Box 708001 44.4x 40.6x 12.7cm -43%

Cutie Plano Prolatch Xxl Stowaway Storage Box 708001 44.4x 40.6x 12.7cm

pmc708001
Livrare imediată!

249,50Lei(-43%) 142,24Lei

Cutie Plano Six-compartment Stowaway 3600 -8%

Cutie Plano Six-compartment Stowaway 3600

pmc2360600
Livrare imediată!

37,45Lei(-8%) 34,59Lei

Cutie Plumbi Maver Alice Refill - Aaa -10%
Exclusiv online!

Cutie Plumbi Maver Alice Refill - Aaa

k356
Livrare 48-72 ore

14,00Lei(-10%) 12,58Lei

Cutie Prologic Cruzade Pt Accesorii 34.5x19.5x6.5cm -38%

Cutie Prologic Cruzade Pt Accesorii 34.5x19.5x6.5cm

a4.pro.54995
Livrare imediată!

111,20Lei(-38%) 68,84Lei

Cutie Prologic Pt.momeli M 17x17x6cm -48%
Exclusiv online!

Cutie Prologic Pt.momeli M 17x17x6cm

a4.pro.57141
Livrare 24-48 ore

27,93Lei(-48%) 14,50Lei

Cutit Cormoran Pentru Filetat Model 003 L=20cm -17%
Exclusiv online!

Cutit Cormoran Pentru Filetat Model 003 L=20cm

h.c.82.13003
Livrare 24-48 ore

33,96Lei(-17%) 28,17Lei

Afişare 4701 - 4720 din 9190 (460 pagini)
Queries: 5, Total time: 609.662 ms [By time] [By id] [By file]
1 (0.118)
SELECT data
FROM `oc_session`
WHERE session_id = '7c4cf98469ef58945745435af8'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.071)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (298.388)
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 (310.951)
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 4700,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:588
5 (0.134)
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