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


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

Cutie Momeala Eva Team Feeder By Dome Cu Capac 24x19x8cm

5305-009
Livrare 48-72 ore

82,00Lei(-20%) 65,60Lei

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

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

t0282
Livrare imediată!

87,99Lei(-20%) 70,40Lei

Cutie Nash Shallow Box T0283 -38%

Cutie Nash Shallow Box T0283

t0283
Livrare imediată!

34,99Lei(-38%) 21,75Lei

Cutie Nash Slim Box 3 T0287 -40%

Cutie Nash Slim Box 3 T0287

t0287
Livrare imediată!

34,99Lei(-40%) 21,00Lei

Cutie Nash Slim Box 8 T0288 -6%

Cutie Nash Slim Box 8 T0288

t0288
Livrare imediată!

35,00Lei(-6%) 32,80Lei

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

Cutie Pentru Accesorii Fox F-box Medium Double

cbx006
Livrare imediată!

215,95Lei(-47%) 113,69Lei

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

Cutie Pentru Momeala Cresta Baitbox Holed, 0.25l

006403-00301-00000
Livrare imediată!

11,80Lei(-25%) 8,90Lei

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

Cutie Plano 3 Sertare Rabatabile 22-34 Compartimente

pmc620306
Livrare imediată!

179,96Lei(-21%) 141,90Lei

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

Cutie Plano Deep Stow Clear W/black Latches 705001

pmc705001
Livrare imediată!

119,50Lei(-44%) 66,90Lei

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

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

pla1313
Livrare imediată!

104,95Lei(-67%) 34,97Lei

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

Cutie Plano Platch Deep Open Stow Yell Latch 2373101

pmc2373101
Livrare imediată!

89,50Lei(-44%) 49,90Lei

Cutie Plano Prolatch Deep Stow Yellow Latch 2373005 -44%

Cutie Plano Prolatch Deep Stow Yellow Latch 2373005

pmc2373005
Livrare imediată!

114,50Lei(-44%) 63,90Lei

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

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

pmc708001
Livrare imediată!

249,50Lei(-44%) 138,90Lei

Cutie Plano Six-compartment Stowaway 3600 -12%

Cutie Plano Six-compartment Stowaway 3600

pmc2360600
Livrare imediată!

37,45Lei(-12%) 33,03Lei

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

Cutie Plumbi Maver Alice Refill - Aaa

k356
Livrare 48-72 ore

13,99Lei(-19%) 11,40Lei

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

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

a4.pro.54995
Livrare imediată!

111,21Lei(-40%) 66,72Lei

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

Cutie Prologic Pt.momeli M 17x17x6cm

a4.pro.57141
Livrare 24-48 ore

27,93Lei(-40%) 16,81Lei

Cutie Ridgemonkey Armoury Lite Tackle Box 330x190x50mm -23%

Cutie Ridgemonkey Armoury Lite Tackle Box 330x190x50mm

rm497
Livrare imediată!

195,98Lei(-23%) 150,90Lei

Cutit Cormoran Pentru Filetat Model 007 L=16cm -30%

Cutit Cormoran Pentru Filetat Model 007 L=16cm

h.c.82.13007
Livrare imediată!

25,85Lei(-30%) 18,10Lei

Cutit Rapala Ceramic 10cm -15%
Exclusiv online!

Cutit Rapala Ceramic 10cm

rcdcukb4
Livrare 48-72ore

59,00Lei(-15%) 49,90Lei

Afişare 4521 - 4540 din 9097 (455 pagini)
Queries: 6, Total time: 624.513 ms [By time] [By id] [By file]
1 (0.113)
SELECT data
FROM `oc_session`
WHERE session_id = '54a37a9adfb431bc9bd4a1db4c'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.077)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (284.005)
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 = '3' 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 (340.029)
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 = '3' 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 4520,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:588
5 (0.163)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"RAPALA VMC ROMANIA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
6 (0.126)
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