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


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

Wafters 2.20 Baits Supreme, Roz - Negru, Capsuna & Ciocolata, 10mm, 50ml -17%

Wafters 2.20 Baits Supreme, Roz - Negru, Capsuna & Ciocolata, 10mm, 50ml

0655383291073
Livrare imediată!

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

Wafters Dumbells Da-i Cu Apa, Ananas Banana, 6mm, 20g -19%

Wafters Dumbells Da-i Cu Apa, Ananas Banana, 6mm, 20g

1872413873958
Livrare imediată!

25,00Lei(-19%) 20,25Lei

Wafters Ibaits Magic Bands, Banana, 5-7mm, 40ml -10%

Wafters Ibaits Magic Bands, Banana, 5-7mm, 40ml

0634474068862
Livrare imediată!

35,00Lei(-10%) 31,55Lei

Wafters Ibaits Magic Bands, Cioco Caramel, 5-7mm, 40ml -10%

Wafters Ibaits Magic Bands, Cioco Caramel, 5-7mm, 40ml

0634474068893
Livrare imediată!

35,00Lei(-10%) 31,55Lei

Wafters Ibaits Magic Bands, Cioco Porto, 5-7mm, 40ml -10%

Wafters Ibaits Magic Bands, Cioco Porto, 5-7mm, 40ml

0634474068855
Livrare imediată!

35,00Lei(-10%) 31,55Lei

Afişare 3001 - 3020 din 8977 (449 pagini)
Queries: 5, Total time: 576.798 ms [By time] [By id] [By file]
1 (0.072)
SELECT data
FROM `oc_session`
WHERE session_id = '7e201e9d0649aa1cd50e9ad662'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.072)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (254.948)
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 = '3' 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.558)
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 = '3' 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 3000,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:588
5 (0.148)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '3' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:37