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


Wafter 220baits Supreme Fluo 6 Mm Visiniu Capsuni & N-butyric -18%

Wafter 220baits Supreme Fluo 6 Mm Visiniu Capsuni & N-butyric

2242216798441
Livrare imediată!

32,00Lei(-18%) 26,36Lei

Wafter 220baits Supreme Nano Capsuna 3mm -18%

Wafter 220baits Supreme Nano Capsuna 3mm

0757226060768
Livrare imediată!

32,00Lei(-18%) 26,36Lei

Wafter 220baits Supreme Nano Mango-ciocolata 3mm -18%

Wafter 220baits Supreme Nano Mango-ciocolata 3mm

0757226060782
Livrare imediată!

32,00Lei(-18%) 26,36Lei

Wafter 220baits Supreme Nano Menta 3mm -18%

Wafter 220baits Supreme Nano Menta 3mm

0757226060751
Livrare imediată!

32,00Lei(-18%) 26,36Lei

Wafter 220baits Supreme Nano Pre Washed 3mm -16%

Wafter 220baits Supreme Nano Pre Washed 3mm

0757226060720
Livrare imediată!

30,00Lei(-16%) 25,34Lei

Wafter 220baits Supreme Nano Usturoi 3mm -14%

Wafter 220baits Supreme Nano Usturoi 3mm

0757226060737
Livrare imediată!

32,00Lei(-14%) 27,38Lei

Wafter 220baits Supreme Nano, Capsuna & Usturoi, 3mm, 50g -14%

Wafter 220baits Supreme Nano, Capsuna & Usturoi, 3mm, 50g

0757226060775
Livrare imediată!

32,00Lei(-14%) 27,38Lei

Wafter 220baits Supreme Nano, Menta & Portocala, 3mm, 50g -14%

Wafter 220baits Supreme Nano, Menta & Portocala, 3mm, 50g

0757226060744
Livrare imediată!

32,00Lei(-14%) 27,38Lei

Wafter Carp Zoom Superb, Grass Carp, 15mm, 50g -21%

Wafter Carp Zoom Superb, Grass Carp, 15mm, 50g

cz4556
Livrare imediată!

23,00Lei(-21%) 18,22Lei

Wafters 2.20 Baits Supreme Milky Crab 10mm -18%

Wafters 2.20 Baits Supreme Milky Crab 10mm

0757226060942
Livrare imediată!

32,00Lei(-18%) 26,36Lei

Wafters 2.20 Baits Supreme Pernute, Alb - Roz, Capsuna & Frisca, 10mm, 50ml -17%

Wafters 2.20 Baits Supreme Pernute, Alb - Roz, Capsuna & Frisca, 10mm, 50ml

0655383291004
Livrare imediată!

33,00Lei(-17%) 27,38Lei

Wafters 2.20 Baits Supreme Pernute, Alb, Water Lemon, 10mm, 50ml -17%

Wafters 2.20 Baits Supreme Pernute, Alb, Water Lemon, 10mm, 50ml

0655383290960
Livrare imediată!

33,00Lei(-17%) 27,38Lei

Wafters 2.20 Baits Supreme Pernute, Alb, Water Lemon, 6mm, 50ml -18%

Wafters 2.20 Baits Supreme Pernute, Alb, Water Lemon, 6mm, 50ml

0655383290908
Livrare imediată!

32,00Lei(-18%) 26,36Lei

Wafters 2.20 Baits Supreme Pernute, Galben - Portocaliu, Ciocolata & Pepene Galben, 10mm, 50ml -17%

Wafters 2.20 Baits Supreme Pernute, Galben - Portocaliu, Ciocolata & Pepene Galben, 10mm, 50ml

0655383290991
Livrare imediată!

33,00Lei(-17%) 27,38Lei

Wafters 2.20 Baits Supreme Pernute, Galben, Menta & Portocala, 10mm, 50ml -17%

Wafters 2.20 Baits Supreme Pernute, Galben, Menta & Portocala, 10mm, 50ml

0655383290984
Livrare imediată!

33,00Lei(-17%) 27,38Lei

Wafters 2.20 Baits Supreme Pernute, Portocaliu, Portocala & Frisca, 6mm, 50ml -18%

Wafters 2.20 Baits Supreme Pernute, Portocaliu, Portocala & Frisca, 6mm, 50ml

0655383290892
Livrare imediată!

32,00Lei(-18%) 26,36Lei

Wafters 2.20 Baits Supreme Pernute, Roz, Capsuna & Scopex, 10mm, 50ml -17%

Wafters 2.20 Baits Supreme Pernute, Roz, Capsuna & Scopex, 10mm, 50ml

0655383290977
Livrare imediată!

33,00Lei(-17%) 27,38Lei

Wafters 2.20 Baits Supreme, Alb - Negru, Frisca & N-butyric, 4mm, 50ml -18%

Wafters 2.20 Baits Supreme, Alb - Negru, Frisca & N-butyric, 4mm, 50ml

0655383291011
Livrare imediată!

32,00Lei(-18%) 26,36Lei

Wafters 2.20 Baits Supreme, Galben - Negru, Ciocolata & Lamaie, 10mm, 50ml -17%

Wafters 2.20 Baits Supreme, Galben - Negru, Ciocolata & Lamaie, 10mm, 50ml

0655383291097
Livrare imediată!

33,00Lei(-17%) 27,38Lei

Wafters 2.20 Baits Supreme, Negru, Frisca, 10mm, 50ml -17%

Wafters 2.20 Baits Supreme, Negru, Frisca, 10mm, 50ml

0655383291103
Livrare imediată!

33,00Lei(-17%) 27,38Lei

Afişare 3161 - 3180 din 9193 (460 pagini)
Queries: 5, Total time: 627.194 ms [By time] [By id] [By file]
1 (0.120)
SELECT data
FROM `oc_session`
WHERE session_id = '14f85add8dc09d25781fc4f1ef'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.113)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (305.669)
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 (321.170)
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 3160,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:588
5 (0.122)
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