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


Shad Westin Kickteez 9cm Dirty Harbor -29%

Shad Westin Kickteez 9cm Dirty Harbor

p015-256-008
Livrare imediată!

27,91Lei(-29%) 19,94Lei

Shrink Tube Climax Trophy Black 50mm 2.40mm -17%

Shrink Tube Climax Trophy Black 50mm 2.40mm

610100161
Livrare imediată!

21,54Lei(-17%) 17,90Lei

Sistem Antitangle Tubertini Match Link, 15cm, 2buc/pac -15%

Sistem Antitangle Tubertini Match Link, 15cm, 2buc/pac

84037xx
Livrare imediată!

15,01Lei(-15%) 12,74Lei

Sistem Atasare Plumb Black Cat Power Boom, 2buc/pac -21%

Sistem Atasare Plumb Black Cat Power Boom, 2buc/pac

6617005
Livrare imediată!

15,01Lei(-21%) 11,80Lei

Sistem Atasare Stonfo Super Booms, 4cm, 2buc/pac -41%

Sistem Atasare Stonfo Super Booms, 4cm, 2buc/pac

83-4cm
Livrare imediată!

11,50Lei(-41%) 6,76Lei

Sistem Plumb Pierdut Helicopter Fox Edges Angled Drop Off Run Ring -20%

Sistem Plumb Pierdut Helicopter Fox Edges Angled Drop Off Run Ring

cac600
Livrare imediată!

33,95Lei(-20%) 27,16Lei

Sistem Toslon All In One Pentru Navomodele Xr 500 -7%

Sistem Toslon All In One Pentru Navomodele Xr 500

xr500
Livrare imediată!

7.499,00Lei(-7%) 6.999,00Lei

Sita Dynamite Baits Pentru Nada, 33cm, 4mm -9%

Sita Dynamite Baits Pentru Nada, 33cm, 4mm

dy510
Livrare imediată!

89,00Lei(-9%) 81,00Lei

Skirt Spinnerbait Spro Jig Buzzbait Freestyle Blue Disco 2buc -39%

Skirt Spinnerbait Spro Jig Buzzbait Freestyle Blue Disco 2buc

004589-00706-00000
Livrare imediată!

8,00Lei(-39%) 4,90Lei

Skirt Spinnerbait Spro Jig Buzzbait Freestyle Cray 2buc -39%

Skirt Spinnerbait Spro Jig Buzzbait Freestyle Cray 2buc

004589-00701-00000
Livrare imediată!

8,00Lei(-39%) 4,90Lei

Skirt Spro Freestyle Jig Slips Roach 2 Buc/plic -39%

Skirt Spro Freestyle Jig Slips Roach 2 Buc/plic

004589-00705-00000
Livrare imediată!

8,00Lei(-39%) 4,90Lei

Slim Shad 4predators Floating 9cm / 5buc / 4.3gr Olive-holoclear -30%

Slim Shad 4predators Floating 9cm / 5buc / 4.3gr Olive-holoclear

4p-ss9-l007
Livrare imediată!

10,00Lei(-30%) 7,04Lei

Snag Bar Wireless Prologic, 1buc -81%
Exclusiv online!

Snag Bar Wireless Prologic, 1buc

svs49122
Livrare 7-14 zile

269,95Lei(-81%) 50,34Lei

Snag Ears Fox Black Label And Hockey Stick L -14%
Exclusiv online!

Snag Ears Fox Black Label And Hockey Stick L

cbb011
Livrare 7-14 zile

98,96Lei(-14%) 85,06Lei

Snag Ears Fox Black Label And Swinger Plate -17%

Snag Ears Fox Black Label And Swinger Plate

cbb016
Livrare imediată!

107,96Lei(-17%) 89,90Lei

Snur Pentru Ochelari Delphin Swim Negru -38%

Snur Pentru Ochelari Delphin Swim Negru

920121700
Livrare imediată!

16,01Lei(-38%) 9,90Lei

Snur Pentru Ochelari Delphin Swim Verde -38%

Snur Pentru Ochelari Delphin Swim Verde

920121701
Livrare imediată!

16,01Lei(-38%) 9,90Lei

Snur Scierra Aerial Pt.musca Wf6f 13g 11.20m -40%

Snur Scierra Aerial Pt.musca Wf6f 13g 11.20m

a.sie.57891
Livrare imediată!

192,42Lei(-40%) 115,45Lei

Soccer Shad Colmic 6cm Silver Pink -27%
Exclusiv online!

Soccer Shad Colmic 6cm Silver Pink

arhkao02
Livrare 48-72 ore

10,40Lei(-27%) 7,60Lei

Soft Bait Colmic Herakles Mr Crab 3cm Chartreuse -28%
Exclusiv online!

Soft Bait Colmic Herakles Mr Crab 3cm Chartreuse

arhkiu02
Livrare 48-72 ore

11,90Lei(-28%) 8,60Lei

Afişare 8001 - 8020 din 9136 (457 pagini)
Queries: 5, Total time: 597.128 ms [By time] [By id] [By file]
1 (0.126)
SELECT data
FROM `oc_session`
WHERE session_id = 'e98771d8637007c20a389a2599'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.109)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (290.240)
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 (306.528)
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 8000,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:588
5 (0.125)
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