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


Grub Fox Rage Pro Green Pumpkin Uv 10cm 1buc/pac -5%

Grub Fox Rage Pro Green Pumpkin Uv 10cm 1buc/pac

npg067-bucxxx
Livrare imediată!

7,38Lei(-5%) 7,01Lei

Grub Fox Rage Pro Green Pumpkin Uv 12cm 1buc/pac -8%

Grub Fox Rage Pro Green Pumpkin Uv 12cm 1buc/pac

npg070-bucxxx
Livrare imediată!

9,35Lei(-8%) 8,62Lei

Grub Fox Rage Pro Green Pumpkin Uv 8cm 1buc/pac -13%

Grub Fox Rage Pro Green Pumpkin Uv 8cm 1buc/pac

npg064-bucxxx
Livrare imediată!

5,14Lei(-13%) 4,48Lei

Grub Fox Rage Uv Micro Grub 4cm 8buc/plic -22%

Grub Fox Rage Uv Micro Grub 4cm 8buc/plic

nmc010
Livrare imediată!

31,30Lei(-22%) 24,28Lei

Grub Relax Turbo Twister Laminat Tl047, 11cm, 4buc/pac -8%
Exclusiv online!

Grub Relax Turbo Twister Laminat Tl047, 11cm, 4buc/pac

trt5-tl047-b
Livrare 24-48 ore

9,00Lei(-8%) 8,32Lei

Grub Relax Turbo Twister Standard Blister, Ts127, 11cm, 8g, 4buc/plic -8%
Exclusiv online!

Grub Relax Turbo Twister Standard Blister, Ts127, 11cm, 8g, 4buc/plic

trt5-ts127-b
Livrare 24-48 ore

9,00Lei(-8%) 8,32Lei

Grub Viber Colmic Herakles 11.4cm Black Red Flk 6buc/plic -35%
Exclusiv online!

Grub Viber Colmic Herakles 11.4cm Black Red Flk 6buc/plic

arhkcz07
Livrare 48-72 ore

31,90Lei(-35%) 20,82Lei

Hanger Prologic Senzor Hanger, Blue, 1buc/pac -37%
Exclusiv online!

Hanger Prologic Senzor Hanger, Blue, 1buc/pac

svs77675
Livrare 7-14 zile

124,94Lei(-37%) 79,10Lei

Hanger Prologic Senzor Hanger, Red, 1buc/pac -37%
Exclusiv online!

Hanger Prologic Senzor Hanger, Red, 1buc/pac

svs77676
Livrare 7-14 zile

124,94Lei(-37%) 79,10Lei

Hangere Prologic K1 Midi Indicator, Alb, 1buc/pac -74%
Exclusiv online!

Hangere Prologic K1 Midi Indicator, Alb, 1buc/pac

svs72839
Livrare 7-14 zile

49,95Lei(-74%) 12,84Lei

Hanorac Cu Fermoar Black Cat Zipper, Marime S -18%
Exclusiv online!

Hanorac Cu Fermoar Black Cat Zipper, Marime S

8778301
Livrare 7-14 zile

270,00Lei(-18%) 220,22Lei

Hanorac Cu Fermoar Black Cat Zipper, Marime Xl -18%
Exclusiv online!

Hanorac Cu Fermoar Black Cat Zipper, Marime Xl

8778304
Livrare 7-14 zile

270,00Lei(-18%) 220,22Lei

Hanorac Cu Fermoar Black Cat Zipper, Marime Xxl -18%
Exclusiv online!

Hanorac Cu Fermoar Black Cat Zipper, Marime Xxl

8778305
Livrare 7-14 zile

270,00Lei(-18%) 220,22Lei

Hanorac Impermeabil Nash Scope Waterproof Smock, Marime 2xl -33%

Hanorac Impermeabil Nash Scope Waterproof Smock, Marime 2xl

c0504
Livrare imediată!

909,99Lei(-33%) 613,02Lei

Hanorac Jackall Zip Up Black Marime L -18%
Exclusiv online!

Hanorac Jackall Zip Up Black Marime L

ja.807176520
Livrare 24-48 ore

539,45Lei(-18%) 439,81Lei

Hanorac Jackall Zip Up Black Marime L -18%
Exclusiv online!

Hanorac Jackall Zip Up Black Marime L

ja.807249767
Livrare 24-48 ore

484,29Lei(-18%) 394,94Lei

Hanorac Jackall Zip Up Black Marime Xl -18%
Exclusiv online!

Hanorac Jackall Zip Up Black Marime Xl

ja.807249774
Livrare 24-48 ore

484,29Lei(-18%) 394,94Lei

Hanorac Korda Le Lightweight, Light Kamo, Marime M -27%

Hanorac Korda Le Lightweight, Light Kamo, Marime M

kcl371
Livrare imediată!

324,75Lei(-27%) 237,81Lei

Hanorac Korda Le Lightweight, Light Kamo, Marime S -22%

Hanorac Korda Le Lightweight, Light Kamo, Marime S

kcl370
Livrare imediată!

324,75Lei(-22%) 254,18Lei

Hanorac Madcat Mega Logo Black Caviar L -28%

Hanorac Madcat Mega Logo Black Caviar L

8053173801
Livrare imediată!

211,02Lei(-28%) 151,20Lei

Afişare 1021 - 1040 din 9211 (461 pagini)
Queries: 5, Total time: 780.865 ms [By time] [By id] [By file]
1 (0.135)
SELECT data
FROM `oc_session`
WHERE session_id = '11077560768b36b37608e26610'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.114)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (378.719)
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 (401.731)
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 1020,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:588
5 (0.166)
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