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


Tambur De Rezerva Team Feeder By Dome Power Fighter Pro 5000 -17%
Exclusiv online!

Tambur De Rezerva Team Feeder By Dome Power Fighter Pro 5000

2533-550-01
Livrare 48-72 ore

70,00Lei(-17%) 57,93Lei

Tambur De Rezerva Team Feeder By Dome Power Fighter Pro 6000 -17%

Tambur De Rezerva Team Feeder By Dome Power Fighter Pro 6000

2533-560-01
Livrare imediată!

78,00Lei(-17%) 64,44Lei

Tambur De Rezerva Universal Daiwa Mulineta Lt 6000d -28%

Tambur De Rezerva Universal Daiwa Mulineta Lt 6000d

d.19115.600
Livrare imediată!

141,18Lei(-28%) 101,49Lei

Tambur Rezerva Penn Spinfisher Spinning Reel Lc, 5500 -58%
Exclusiv online!

Tambur Rezerva Penn Spinfisher Spinning Reel Lc, 5500

1494837
Livrare 7-14 zile

209,95Lei(-58%) 88,08Lei

Tambur Rezerva Penn Spinfisher Spinning Reel, 9500 -65%
Exclusiv online!

Tambur Rezerva Penn Spinfisher Spinning Reel, 9500

1489364
Livrare 7-14 zile

219,95Lei(-65%) 77,10Lei

Tambur Rezerva Tubertini Spool Normal Concept D 2500 -13%
Exclusiv online!

Tambur Rezerva Tubertini Spool Normal Concept D 2500

99962xx
Livrare 7-14 zile

111,50Lei(-13%) 97,37Lei

Tambur Rezerva Tubertini Spool Normal Concept D 3500 -13%
Exclusiv online!

Tambur Rezerva Tubertini Spool Normal Concept D 3500

99963xx
Livrare 7-14 zile

118,00Lei(-13%) 103,00Lei

Tambur Rezerva Tubertini Spool Normal Concept D 4500 -13%
Exclusiv online!

Tambur Rezerva Tubertini Spool Normal Concept D 4500

99964xx
Livrare 7-14 zile

121,50Lei(-13%) 106,01Lei

Tambur Rezerva Tubertini Spool Normal Concept D 5500 -13%
Exclusiv online!

Tambur Rezerva Tubertini Spool Normal Concept D 5500

99965xx
Livrare 7-14 zile

126,00Lei(-13%) 109,90Lei

Tambur Rezerva Tubertini Spool Normal Concept D 6500 -13%
Exclusiv online!

Tambur Rezerva Tubertini Spool Normal Concept D 6500

99966xx
Livrare 7-14 zile

130,00Lei(-13%) 113,36Lei

Tava Laterala Preston Offbox 36 Double Decker Side Tray Pentru Scaun Modular Small -18%

Tava Laterala Preston Offbox 36 Double Decker Side Tray Pentru Scaun Modular Small

p0110059
Livrare imediată!

494,96Lei(-18%) 407,62Lei

Tolba Abu Garcia Carryall Beast Pro Rod Bag -61%
Exclusiv online!

Tolba Abu Garcia Carryall Beast Pro Rod Bag

1528433
Livrare 7-14 zile

218,60Lei(-61%) 85,29Lei

Tricou Daiwa Polo Grey Camo Marime Xl -49%
Exclusiv online!

Tricou Daiwa Polo Grey Camo Marime Xl

d.18293.740
Livrare 24-48 ore

312,59Lei(-49%) 159,93Lei

Tricou Daiwa Polo Grey Camo Marime Xxl -49%
Exclusiv online!

Tricou Daiwa Polo Grey Camo Marime Xxl

d.18293.750
Livrare 24-48 ore

312,59Lei(-49%) 159,93Lei

Tricou Delphin Carp On The Hook, Marime M -23%

Tricou Delphin Carp On The Hook, Marime M

101003629
Livrare imediată!

81,00Lei(-23%) 62,01Lei

Tricou Fox Rage Limited Edition Perch T-shirt Black Mar Xxl -27%

Tricou Fox Rage Limited Edition Perch T-shirt Black Mar Xxl

npr396
Livrare imediată!

139,95Lei(-27%) 101,53Lei

Tricou Fox Rage Limited Edition Pike T-shirt Black Mar L -27%

Tricou Fox Rage Limited Edition Pike T-shirt Black Mar L

npr400
Livrare imediată!

139,95Lei(-27%) 101,53Lei

Tricou Fox Rage Limited Edition Pike T-shirt Black Mar Xxl -27%

Tricou Fox Rage Limited Edition Pike T-shirt Black Mar Xxl

npr402
Livrare imediată!

139,95Lei(-27%) 101,53Lei

Tricou Fox Rage Limited Edition Zander T-shirt Black Mar L -27%

Tricou Fox Rage Limited Edition Zander T-shirt Black Mar L

npr406
Livrare imediată!

139,95Lei(-27%) 101,53Lei

Tricou Fox Rage Limited Edition Zander T-shirt Black Mar S -27%

Tricou Fox Rage Limited Edition Zander T-shirt Black Mar S

npr404
Livrare imediată!

139,95Lei(-27%) 101,53Lei

Afişare 2541 - 2560 din 9198 (460 pagini)
Queries: 5, Total time: 595.188 ms [By time] [By id] [By file]
1 (0.121)
SELECT data
FROM `oc_session`
WHERE session_id = '543194f4124fcb52e96298840e'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.099)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (294.718)
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 (300.077)
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 2540,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:588
5 (0.173)
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