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


Shad Biwaa Kapsiz 7.5cm 205 Vairon 7buc/plic -21%
Exclusiv online!

Shad Biwaa Kapsiz 7.5cm 205 Vairon 7buc/plic

b001635
Livrare 48-72 ore

26,00Lei(-21%) 20,42Lei

Shad Biwaa Kapsiz 7.5cm 206 Golden Shiner 7buc/plic -21%
Exclusiv online!

Shad Biwaa Kapsiz 7.5cm 206 Golden Shiner 7buc/plic

b001639
Livrare 48-72 ore

26,00Lei(-21%) 20,42Lei

Shad Biwaa Kapsiz 7.5cm 307 Blue Back Chart 7buc/plic -21%
Exclusiv online!

Shad Biwaa Kapsiz 7.5cm 307 Blue Back Chart 7buc/plic

b001637
Livrare 48-72 ore

26,00Lei(-21%) 20,42Lei

Shad Biwaa Scorpitail 10cm Culoare Cola -18%

Shad Biwaa Scorpitail 10cm Culoare Cola

b001296
Livrare imediată!

26,00Lei(-18%) 21,24Lei

Shad Biwaa Submission 10cm Culoare Red Tiger 4buc -17%

Shad Biwaa Submission 10cm Culoare Red Tiger 4buc

b000970
Livrare imediată!

50,00Lei(-17%) 41,58Lei

Shad Biwaa Submission 10cm Culoare Roach 4buc -35%

Shad Biwaa Submission 10cm Culoare Roach 4buc

b000971
Livrare imediată!

45,00Lei(-35%) 29,37Lei

Shad Biwaa Submission Blue Chrome, 13cm, 14g, 3buc/pac -17%

Shad Biwaa Submission Blue Chrome, 13cm, 14g, 3buc/pac

b000840
Livrare imediată!

50,00Lei(-17%) 41,58Lei

Shad Biwaa Tailgunr Swimbait 2.5 6.5cm 310 Kaleido Star 10/plic -18%

Shad Biwaa Tailgunr Swimbait 2.5 6.5cm 310 Kaleido Star 10/plic

b001418
Livrare imediată!

26,00Lei(-18%) 21,24Lei

Shad Biwaa Tailgunr Swimbait 2.5 6.5cm 008 Pearl White 10/plic -18%

Shad Biwaa Tailgunr Swimbait 2.5 6.5cm 008 Pearl White 10/plic

b001404
Livrare imediată!

26,00Lei(-18%) 21,24Lei

Shad Biwaa Tailgunr Swimbait 3.5 9cm 013 Lemon 7/plic -18%

Shad Biwaa Tailgunr Swimbait 3.5 9cm 013 Lemon 7/plic

b001423
Livrare imediată!

26,00Lei(-18%) 21,24Lei

Shad Biwaa Tailgunr Swimbait 3.5 9cm 308 Atomic 7/plic -13%

Shad Biwaa Tailgunr Swimbait 3.5 9cm 308 Atomic 7/plic

b001434
Livrare imediată!

29,00Lei(-13%) 25,30Lei

Shad Biwaa Tailgunr Swimbait 4.5", 301 Applet Min, 11.50cm, 5buc/pac -13%

Shad Biwaa Tailgunr Swimbait 4.5", 301 Applet Min, 11.50cm, 5buc/pac

b001446
Livrare imediată!

29,00Lei(-13%) 25,30Lei

Shad Biwaa Tailgunr Swimbait 4.5", 313 Smallie Party, 11.50cm, 5buc/pac -13%

Shad Biwaa Tailgunr Swimbait 4.5", 313 Smallie Party, 11.50cm, 5buc/pac

b002007
Livrare imediată!

29,00Lei(-13%) 25,30Lei

Shad Biwaa Tailgunr Swimbait 4.5", 315 Neon Scale Minnow, 11.50cm, 5buc/pac -13%

Shad Biwaa Tailgunr Swimbait 4.5", 315 Neon Scale Minnow, 11.50cm, 5buc/pac

b001453
Livrare imediată!

29,00Lei(-13%) 25,30Lei

Shad Biwaa Tailgunr Swimbait 6.5 Cm Apple Mint -18%

Shad Biwaa Tailgunr Swimbait 6.5 Cm Apple Mint

b001412
Livrare imediată!

26,00Lei(-18%) 21,24Lei

Shad Biwaa Tailgunr Swimbait 6.5 Cm Pro Blue -18%

Shad Biwaa Tailgunr Swimbait 6.5 Cm Pro Blue

b001414
Livrare imediată!

26,00Lei(-18%) 21,24Lei

Shad Biwaa Tailgunr Swimbait 6.5 Cm Wakasagi -18%

Shad Biwaa Tailgunr Swimbait 6.5 Cm Wakasagi

b001410
Livrare imediată!

26,00Lei(-18%) 21,24Lei

Shad Biwaa Tailgunr Swimbait 6.5cm, 206 Golden Shiner, 10buc/pac -13%

Shad Biwaa Tailgunr Swimbait 6.5cm, 206 Golden Shiner, 10buc/pac

b002000
Livrare imediată!

29,00Lei(-13%) 25,30Lei

Shad Biwaa Tailgunr Swimbait 6.5cm, 302 Alburno, 10buc/pac -18%

Shad Biwaa Tailgunr Swimbait 6.5cm, 302 Alburno, 10buc/pac

b001413
Livrare imediată!

26,00Lei(-18%) 21,24Lei

Shad Biwaa Tailgunr Swimbait 9.0cm, 206 Golden Shiner, 7buc/pac -13%

Shad Biwaa Tailgunr Swimbait 9.0cm, 206 Golden Shiner, 7buc/pac

b002003
Livrare imediată!

29,00Lei(-13%) 25,30Lei

Afişare 7741 - 7760 din 9304 (466 pagini)
Queries: 5, Total time: 641.084 ms [By time] [By id] [By file]
1 (0.081)
SELECT data
FROM `oc_session`
WHERE session_id = 'c65bfbe1c2f4c2072d564041dd'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.079)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (306.992)
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 (333.794)
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 7740,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:588
5 (0.138)
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