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


Hanorac Tubertini Giacca Class, Masura Xxxxxl -13%
Exclusiv online!

Hanorac Tubertini Giacca Class, Masura Xxxxxl

713910g
Livrare 7-14 zile

320,50Lei(-13%) 278,00Lei

Hanorac Tubertini Giacca Wind Prof, Marime L -13%
Exclusiv online!

Hanorac Tubertini Giacca Wind Prof, Marime L

713960b
Livrare 7-14 zile

410,00Lei(-13%) 355,36Lei

Hanorac Tubertini Giacca Wind Prof, Marime Xl -13%
Exclusiv online!

Hanorac Tubertini Giacca Wind Prof, Marime Xl

713960c
Livrare 7-14 zile

410,00Lei(-13%) 355,36Lei

Hanorac Tubertini Giacca Wind Prof, Marime Xxxl -13%
Exclusiv online!

Hanorac Tubertini Giacca Wind Prof, Marime Xxxl

713960e
Livrare 7-14 zile

410,00Lei(-13%) 355,36Lei

Hanorac Tubertini Giacca Wind Prof, Marime Xxxxl -13%
Exclusiv online!

Hanorac Tubertini Giacca Wind Prof, Marime Xxxxl

713960f
Livrare 7-14 zile

410,00Lei(-13%) 355,36Lei

Husa Lansete Fox R-series 12ft Quiver And 4 Sleeves -39%

Husa Lansete Fox R-series 12ft Quiver And 4 Sleeves

clu364
Livrare imediată!

697,46Lei(-39%) 427,86Lei

Husa 2 Compartimente Delphin Classa 130 Cm -46%

Husa 2 Compartimente Delphin Classa 130 Cm

101000456
Livrare imediată!

189,99Lei(-46%) 102,58Lei

Husa Cantar Jrc Defender Scales Pouch, Green -51%

Husa Cantar Jrc Defender Scales Pouch, Green

1445883
Livrare imediată!

78,80Lei(-51%) 38,24Lei

Husa Colmic Capac Galeata Pvc 12 L -25%
Exclusiv online!

Husa Colmic Capac Galeata Pvc 12 L

sec04
Livrare 48-72 ore

45,00Lei(-25%) 33,54Lei

Husa Dam Intenze 3 Compartment Padded Rod Bag, 170x33x30cm -45%
Exclusiv online!

Husa Dam Intenze 3 Compartment Padded Rod Bag, 170x33x30cm

svs60368
Livrare 7-14 zile

399,91Lei(-45%) 220,22Lei

Husa Korum Progress Compact Quiver 2 Rods, 130x10x9cm -35%
Exclusiv online!

Husa Korum Progress Compact Quiver 2 Rods, 130x10x9cm

k0290118
Livrare 7-14 zile

189,00Lei(-35%) 122,92Lei

Husa Lansete Cu Mulinete Fox Camolite Double Spod Jackets 13ft, 2 Compartimente -23%

Husa Lansete Cu Mulinete Fox Camolite Double Spod Jackets 13ft, 2 Compartimente

clu456
Livrare imediată!

431,96Lei(-23%) 331,33Lei

Husa Lansete Nash 12ft, 5 Rod Apache, Green -42%

Husa Lansete Nash 12ft, 5 Rod Apache, Green

t3539
Livrare imediată!

829,90Lei(-42%) 477,62Lei

Husa Lansete Shimano Tribal Trench 3 Rod 12 Holdall 200 Cm -29%

Husa Lansete Shimano Tribal Trench 3 Rod 12 Holdall 200 Cm

shttg07
Livrare imediată!

700,00Lei(-29%) 494,15Lei

Husa Lansete Solar Undercover Camo, Rod Holdall 3+2, 13ft, 215x30cm -9%

Husa Lansete Solar Undercover Camo, Rod Holdall 3+2, 13ft, 215x30cm

ca10
Livrare imediată!

499,95Lei(-9%) 455,77Lei

Husa Mulineta Dam O.t.t. Reel Case 10x20x16cm -42%
Exclusiv online!

Husa Mulineta Dam O.t.t. Reel Case 10x20x16cm

svs74982
Livrare 7-14 zile

59,96Lei(-42%) 34,85Lei

Husa Mulinete Carryall Abu Garcia Beast Beast Pro Reel Pouch -36%
Exclusiv online!

Husa Mulinete Carryall Abu Garcia Beast Beast Pro Reel Pouch

1528434
Livrare 7-14 zile

71,28Lei(-36%) 45,64Lei

Husa Mulinete Team Feeder By Dome S 21x16x9cm -17%

Husa Mulinete Team Feeder By Dome S 21x16x9cm

5301-004
Livrare imediată!

51,00Lei(-17%) 42,50Lei

Husa Rhino Rc Bag Universal, 16x8x4cm -36%
Exclusiv online!

Husa Rhino Rc Bag Universal, 16x8x4cm

9944003
Livrare 7-14 zile

39,95Lei(-36%) 25,37Lei

Husa Rigida Fl 1 Compartiment 115cm -43%

Husa Rigida Fl 1 Compartiment 115cm

5752123467530
Livrare imediată!

90,00Lei(-43%) 51,74Lei

Afişare 1101 - 1120 din 9260 (463 pagini)
Queries: 5, Total time: 629.686 ms [By time] [By id] [By file]
1 (0.127)
SELECT data
FROM `oc_session`
WHERE session_id = 'faf87220047b974f628b536b70'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.087)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (277.161)
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 (352.176)
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 1100,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:588
5 (0.135)
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