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


Cosulet Preston Hexmesh Plastic Open End Feeders Large 30g -39%
Exclusiv online!

Cosulet Preston Hexmesh Plastic Open End Feeders Large 30g

p0050166
Livrare 7-14 zile

11,25Lei(-39%) 6,90Lei

Cosulet Preston Hexmesh Plastic Open End Feeders Large 40g -39%
Exclusiv online!

Cosulet Preston Hexmesh Plastic Open End Feeders Large 40g

p0050167
Livrare 7-14 zile

11,25Lei(-39%) 6,90Lei

Cosulet Preston Hexmesh Plastic Open End Feeders Large 50g -39%
Exclusiv online!

Cosulet Preston Hexmesh Plastic Open End Feeders Large 50g

p0050168
Livrare 7-14 zile

11,25Lei(-39%) 6,90Lei

Cosulet Preston Hexmesh Plastic Open End Feeders Medium 20g -39%
Exclusiv online!

Cosulet Preston Hexmesh Plastic Open End Feeders Medium 20g

p0050162
Livrare 7-14 zile

11,25Lei(-39%) 6,90Lei

Cosulet Preston Hexmesh Plastic Open End Feeders Medium 30g -39%
Exclusiv online!

Cosulet Preston Hexmesh Plastic Open End Feeders Medium 30g

p0050163
Livrare 7-14 zile

11,25Lei(-39%) 6,90Lei

Cosulet Preston Hexmesh Plastic Open End Feeders Medium 40g -39%

Cosulet Preston Hexmesh Plastic Open End Feeders Medium 40g

p0050164
Livrare imediată!

11,25Lei(-39%) 6,90Lei

Cosulet Preston Hexmesh Plastic Open End Feeders Small 20g -39%
Exclusiv online!

Cosulet Preston Hexmesh Plastic Open End Feeders Small 20g

p0050159
Livrare 7-14 zile

11,25Lei(-39%) 6,90Lei

Cosulet Preston Hexmesh Plastic Open End Feeders Small 30g -39%
Exclusiv online!

Cosulet Preston Hexmesh Plastic Open End Feeders Small 30g

p0050160
Livrare 7-14 zile

11,25Lei(-39%) 6,90Lei

Cosulet Preston Hexmesh Plastic Open End Feeders Small 40g -39%
Exclusiv online!

Cosulet Preston Hexmesh Plastic Open End Feeders Small 40g

p0050161
Livrare 7-14 zile

11,25Lei(-39%) 6,90Lei

Cosulet Preston Hexmesh Plastic Open End Feeders Xl 20g -39%
Exclusiv online!

Cosulet Preston Hexmesh Plastic Open End Feeders Xl 20g

p0050169
Livrare 7-14 zile

11,25Lei(-39%) 6,90Lei

Cosulet Preston Hexmesh Plastic Open End Feeders Xl 30g -39%
Exclusiv online!

Cosulet Preston Hexmesh Plastic Open End Feeders Xl 30g

p0050170
Livrare 7-14 zile

11,25Lei(-39%) 6,90Lei

Cosulet Preston Hexmesh Plastic Open End Feeders Xl 40g -39%
Exclusiv online!

Cosulet Preston Hexmesh Plastic Open End Feeders Xl 40g

p0050171
Livrare 7-14 zile

11,25Lei(-39%) 6,90Lei

Cosulet Preston Hexmesh Plastic Open End Feeders Xl 50g -39%

Cosulet Preston Hexmesh Plastic Open End Feeders Xl 50g

p0050172
Livrare imediată!

11,25Lei(-39%) 6,90Lei

Covor Delphin Catchme Catch And Release -46%

Covor Delphin Catchme Catch And Release

795000310
Livrare imediată!

39,00Lei(-46%) 20,90Lei

Covor Delphin Crap, 60x40cm -68%

Covor Delphin Crap, 60x40cm

795000001
Livrare imediată!

62,00Lei(-68%) 19,90Lei

Covor Delphin Home, 60x40cm -52%

Covor Delphin Home, 60x40cm

795000302
Livrare imediată!

62,00Lei(-52%) 29,90Lei

Crawbug Carp Zoom Predator Z Oplus 2.5cm Black -17%
Exclusiv online!

Crawbug Carp Zoom Predator Z Oplus 2.5cm Black

cz2915
Livrare 48-72 ore

12,00Lei(-17%) 9,90Lei

Crazy Frog Colmic Natural Frog 13gr 7cm -21%

Crazy Frog Colmic Natural Frog 13gr 7cm

arhkda01
Livrare imediată!

58,00Lei(-21%) 45,90Lei

Creatura Berkley Hollow Craw Dark Cray Uv Claw 7cm, 8buc -23%

Creatura Berkley Hollow Craw Dark Cray Uv Claw 7cm, 8buc

1570938
Livrare imediată!

39,96Lei(-23%) 30,90Lei

Creatura Berkley Pulse Realistic Craw Hollow, Signal Cray Uv Claw, 7cm, 8buc/plic -23%

Creatura Berkley Pulse Realistic Craw Hollow, Signal Cray Uv Claw, 7cm, 8buc/plic

1570941
Livrare imediată!

39,96Lei(-23%) 30,90Lei

Afişare 4281 - 4300 din 9006 (451 pagini)
Queries: 5, Total time: 932.031 ms [By time] [By id] [By file]
1 (0.112)
SELECT data
FROM `oc_session`
WHERE session_id = 'd1d90aa9122c394c46a5996d8c'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.107)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (457.446)
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 (474.222)
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 4280,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:588
5 (0.144)
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