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


Vobler Jaxon Holo Select Scamp F Op 7cm 7gr -26%
Exclusiv online!

Vobler Jaxon Holo Select Scamp F Op 7cm 7gr

vj-sa07fop
Livrare 48-72 ore

33,00Lei(-26%) 24,49Lei

Vobler Jaxon Holo Select Scamp F Op 9cm 14gr -26%
Exclusiv online!

Vobler Jaxon Holo Select Scamp F Op 9cm 14gr

vj-sa09fop
Livrare 48-72 ore

35,01Lei(-26%) 25,91Lei

Vobler Jaxon Holo Select Scamp F R 7cm 7gr -26%
Exclusiv online!

Vobler Jaxon Holo Select Scamp F R 7cm 7gr

vj-sa07fr
Livrare 48-72 ore

33,00Lei(-26%) 24,49Lei

Vobler Jaxon Hs Carabus F Bt 3cm 1.5gr -16%

Vobler Jaxon Hs Carabus F Bt 3cm 1.5gr

vj-sh03fbt
Livrare imediată!

35,01Lei(-16%) 29,37Lei

Vobler Jaxon Hs Carabus F Dt 3cm 1.5gr -16%

Vobler Jaxon Hs Carabus F Dt 3cm 1.5gr

vj-sh03fdt
Livrare imediată!

35,01Lei(-16%) 29,37Lei

Vobler Jaxon Hs Fat Pike 2-sec F Fpl 16cm 45gr -19%

Vobler Jaxon Hs Fat Pike 2-sec F Fpl 16cm 45gr

vj-ph16fpl
Livrare imediată!

61,00Lei(-19%) 49,71Lei

Vobler Jaxon Hs Lil Bug F Gv 2cm 1.8gr -16%

Vobler Jaxon Hs Lil Bug F Gv 2cm 1.8gr

vj-sp02sgv
Livrare imediată!

35,01Lei(-16%) 29,37Lei

Vobler Jaxon Pike F Pl 12cm-15gr -16%

Vobler Jaxon Pike F Pl 12cm-15gr

vj-pi12fpl
Livrare imediată!

42,00Lei(-16%) 35,47Lei

Vobler Jaxon Senso F Oc 6cm 6.5gr -25%
Exclusiv online!

Vobler Jaxon Senso F Oc 6cm 6.5gr

vj-se06foc
Livrare 48-72 ore

30,00Lei(-25%) 22,35Lei

Vobler Lineaeffe Nomura Floater Minn Culoare Green Yellow Red 5cm 3.3g -26%
Exclusiv online!

Vobler Lineaeffe Nomura Floater Minn Culoare Green Yellow Red 5cm 3.3g

nm.60116805
Livrare 24-48 ore

35,53Lei(-26%) 26,29Lei

Vobler Lucky John Pro Series Haira Tiny Plus One 33lbf 3.3cm 4gr 505 1 Buc/pac -3%

Vobler Lucky John Pro Series Haira Tiny Plus One 33lbf 3.3cm 4gr 505 1 Buc/pac

lj-hat33lbf-505
Livrare imediată!

40,00Lei(-3%) 38,62Lei

Vobler Lucky John Pro Series Vikara Sinking 6.2cm 13gr 704 1 Buc/pac -20%

Vobler Lucky John Pro Series Vikara Sinking 6.2cm 13gr 704 1 Buc/pac

lj-v62-704
Livrare imediată!

33,00Lei(-20%) 26,32Lei

Vobler Manns Baby 8-minus 13g 55mm Real Shiner -48%

Vobler Manns Baby 8-minus 13g 55mm Real Shiner

804283287005
Livrare imediată!

41,12Lei(-48%) 21,24Lei

Vobler Owner Mira Vibe Sinking 5268 Mv-60s, 59 Perch, 9.5g, 6cm -26%

Vobler Owner Mira Vibe Sinking 5268 Mv-60s, 59 Perch, 9.5g, 6cm

804020064
Livrare imediată!

46,29Lei(-26%) 34,45Lei

Vobler Owner Mira Vibe Sinking, 02 Black Pearl, 19g, 8.3cm -26%

Vobler Owner Mira Vibe Sinking, 02 Black Pearl, 19g, 8.3cm

804020050
Livrare imediată!

49,17Lei(-26%) 36,49Lei

Vobler Palms Alexandra Sinking Mg327 7cm 8g -41%
Exclusiv online!

Vobler Palms Alexandra Sinking Mg327 7cm 8g

ax-70hw/mg327
Stoc epuizat

84,39Lei(-41%) 49,61Lei

Vobler Rapala Mini Fat Rap Gfr 3cm 4g -18%

Vobler Rapala Mini Fat Rap Gfr 3cm 4g

mfr03 gfr
Livrare imediată!

43,00Lei(-18%) 35,47Lei

Vobler Rapture Crank Sqr Dr 5cm 8gr Gsf -11%

Vobler Rapture Crank Sqr Dr 5cm 8gr Gsf

180-17-955
Livrare imediată!

25,00Lei(-11%) 22,25Lei

Vobler Rapture Crank Sqr Dr 5cm 8gr Gts -30%

Vobler Rapture Crank Sqr Dr 5cm 8gr Gts

180-17-951
Livrare imediată!

25,00Lei(-30%) 17,45Lei

Vobler Rapture Crank Sqr Dr 5cm 8gr Rhc -11%

Vobler Rapture Crank Sqr Dr 5cm 8gr Rhc

180-17-925
Livrare imediată!

25,00Lei(-11%) 22,25Lei

Afişare 8821 - 8840 din 9213 (461 pagini)
Queries: 5, Total time: 707.199 ms [By time] [By id] [By file]
1 (0.117)
SELECT data
FROM `oc_session`
WHERE session_id = 'dbc0e2ed17893a8517c285820d'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.106)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (345.359)
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 (361.423)
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 8820,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:588
5 (0.194)
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