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


Mini Swinger Fox Black Label Orange

csi069
Livrare imediată!

107,94Lei(-22%) 84,16Lei

Mini Swinger Fox Black Label Purple

csi073
Livrare imediată!

107,94Lei(-14%) 92,50Lei

Mini Swinger Fox Black Label Red

csi068
Livrare imediată!

107,94Lei(-14%) 92,50Lei

Mini Swinger Fox Black Label White

csi074
Livrare imediată!

107,94Lei(-22%) 84,16Lei

89,96Lei(-19%) 73,08Lei

89,96Lei(-19%) 73,08Lei

Momitor Carp Zoom Feeder Picatura 10gr

cz9426
Livrare imediată!

5,51Lei(-4%) 5,28Lei

Exclusiv online!

Momitor Carp Zoom Method Feeder Flat 20g

cz9743
Livrare 48-72 ore

11,50Lei(-7%) 10,66Lei

Momitor Carp Zoom Method Feeder Flat 30g

cz9750
Livrare imediată!

12,00Lei(-8%) 11,07Lei

Momitor Carp Zoom Method Feeder Flat 40g

cz9767
Livrare imediată!

12,50Lei(-8%) 11,47Lei

Exclusiv online!

9,00Lei(-18%) 7,41Lei

Exclusiv online!

7,80Lei(-17%) 6,49Lei

Exclusiv online!

Momitor Cormoran Feeder Lestat 55mm D41mm 60g

a.49.63060
Livrare 24-48 ore

16,64Lei(-53%) 7,77Lei

Momitor Cresta Easy Feeder 56 Gr

004722-00135-00000
Livrare imediată!

14,80Lei(-18%) 12,08Lei

Momitor Cresta Pellet Feeder 42gr

004722-00124-00000
Livrare imediată!

17,50Lei(-19%) 14,21Lei

Momitor Cu Antitangle Jaxon 20gr 30cm

aj-054m
Livrare imediată!

13,00Lei(-10%) 11,68Lei

Momitor Cu Antitangle Jaxon 10gr 21cm

aj-063m
Livrare imediată!

12,00Lei(-8%) 11,07Lei

Momitor Cu Antitangle Jaxon 21cm

aj-061m
Livrare imediată!

9,00Lei(-11%) 8,02Lei

Momitor Cu Antitangle Jaxon 30cm

aj-062m
Livrare imediată!

9,00Lei(-11%) 8,02Lei

Momitor Cu Plumb Jaxon Int 15gr 5.5cm

aj-041m
Livrare imediată!

13,00Lei(-11%) 11,57Lei

Afişare 6581 - 6600 din 9198 (460 pagini)
Queries: 5, Total time: 628.223 ms [By time] [By id] [By file]
1 (0.089)
SELECT data
FROM `oc_session`
WHERE session_id = '0453b8fe6cbded898f8bee9cf7'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.123)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (279.186)
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 (348.690)
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 6580,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:588
5 (0.135)
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