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


Cuie Cort Delphin Kl, 10buc -54%
Exclusiv online!

Cuie Cort Delphin Kl, 10buc

436007900
Stoc epuizat

87,00Lei(-54%) 39,90Lei

Cuie Cort Ponton Fox Bivvy Pegs 15buc Set -17%

Cuie Cort Ponton Fox Bivvy Pegs 15buc Set

cum142
Livrare imediată!

102,55Lei(-17%) 84,74Lei

Cuisoare Nash Safety Pinz Diffusion Camo -46%

Cuisoare Nash Safety Pinz Diffusion Camo

t8136
Livrare imediată!

9,00Lei(-46%) 4,90Lei

Cupa Fox Rangemaster Multi Pouch Spare -31%

Cupa Fox Rangemaster Multi Pouch Spare

cpt029
Livrare imediată!

41,60Lei(-31%) 28,91Lei

Curea Pentru Umar Delphin Strap -47%

Curea Pentru Umar Delphin Strap

430410145
Livrare imediată!

28,00Lei(-47%) 14,90Lei

Cutie Jackall 2800d Tackle M Black -39%
Exclusiv online!

Cutie Jackall 2800d Tackle M Black

a4.ja.807196931
Livrare 24-48 ore

107,43Lei(-39%) 65,35Lei

Cutie Accesorii Fbox Deluxe Medium -30%

Cutie Accesorii Fbox Deluxe Medium

cbx004
Livrare imediată!

289,96Lei(-30%) 203,87Lei

Cutie Accesorii Jackall 2300d Double Open Blue M 23.4x19.5x4cm -40%

Cutie Accesorii Jackall 2300d Double Open Blue M 23.4x19.5x4cm

a4.ja.807197044
Livrare imediată!

100,34Lei(-40%) 60,20Lei

Cutie Accesorii Jackall 2800d Blue M 27.5x18.5x3.9cm -40%

Cutie Accesorii Jackall 2800d Blue M 27.5x18.5x3.9cm

a4.ja.807196955
Livrare imediată!

107,43Lei(-40%) 64,46Lei

Cutie Accesorii Plano Marine Plam4520b -45%

Cutie Accesorii Plano Marine Plam4520b

plam4520b
Livrare imediată!

199,50Lei(-45%) 108,90Lei

Cutie Accesorii Trakko 36x24x5cm -19%
Exclusiv online!

Cutie Accesorii Trakko 36x24x5cm

mb9309
Livrare 48-72 ore

42,00Lei(-19%) 33,90Lei

Cutie Carlige Nash Logic, Large, 11x8x2cm -37%

Cutie Carlige Nash Logic, Large, 11x8x2cm

t0281
Livrare imediată!

43,99Lei(-37%) 27,88Lei

Cutie Carlige Nash Logic, Small, 11x8x1.7cm -25%

Cutie Carlige Nash Logic, Small, 11x8x1.7cm

t0280
Livrare imediată!

43,99Lei(-25%) 32,90Lei

Cutie Carp Zoom Accesorii Pochet Bit Box 12x12x3.4cm -21%

Cutie Carp Zoom Accesorii Pochet Bit Box 12x12x3.4cm

cz2552
Livrare imediată!

21,00Lei(-21%) 16,70Lei

Cutie Carp Zoom Momeala Eva 30x18x10cm -24%
Exclusiv online!

Cutie Carp Zoom Momeala Eva 30x18x10cm

cz4274
Livrare 48-72 ore

85,00Lei(-24%) 64,70Lei

Cutie Carp Zoom Rig Bin Rotund Large 10x12.5cm -26%

Cutie Carp Zoom Rig Bin Rotund Large 10x12.5cm

cz5905
Livrare imediată!

27,00Lei(-26%) 19,90Lei

Cutie Carp Zoom Stack-up Tackle Box 36x29x6cm -21%

Cutie Carp Zoom Stack-up Tackle Box 36x29x6cm

cz0695
Livrare imediată!

72,99Lei(-21%) 57,91Lei

Cutie Daiwa Prorex Pentru Naluci Sau Accesorii L 36x22.5x5.5cm -23%

Cutie Daiwa Prorex Pentru Naluci Sau Accesorii L 36x22.5x5.5cm

a4.15809.452
Livrare imediată!

75,51Lei(-23%) 58,08Lei

Cutie Dubla Pentru Naluci Plano Stowaway, 16x10x5.25cm -12%

Cutie Dubla Pentru Naluci Plano Stowaway, 16x10x5.25cm

pmc344922
Livrare imediată!

29,95Lei(-12%) 26,43Lei

Cutie Falcon Pentru Plute, Small, 16x9.5x3cm -20%

Cutie Falcon Pentru Plute, Small, 16x9.5x3cm

ec9142
Livrare imediată!

9,00Lei(-20%) 7,20Lei

Afişare 4361 - 4380 din 9004 (451 pagini)
Queries: 6, Total time: 599.508 ms [By time] [By id] [By file]
1 (0.087)
SELECT data
FROM `oc_session`
WHERE session_id = '3e62895dd89520c85be0b3282c'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.108)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (280.009)
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 (318.999)
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 4360,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:588
5 (0.211)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"MOSS INDISPONIBIL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
6 (0.094)
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