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


Momitor Cresta Pellet Feeder 42gr

004722-00124-00000
Livrare imediată!

17,50Lei(-26%) 12,99Lei

Momitor Cu Antitangle Jaxon 20gr 30cm

aj-054m
Livrare imediată!

12,99Lei(-19%) 10,50Lei

Momitor Cu Antitangle Jaxon 10gr 21cm

aj-063m
Livrare imediată!

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

Momitor Cu Antitangle Jaxon 21cm

aj-061m
Livrare imediată!

9,00Lei(-23%) 6,90Lei

Momitor Cu Antitangle Jaxon 30cm

aj-062m
Livrare imediată!

9,00Lei(-23%) 6,90Lei

Momitor Cu Plumb Jaxon Int 15gr 5.5cm

aj-041m
Livrare imediată!

12,99Lei(-20%) 10,40Lei

Momitor Cu Plumb Jaxon Int 40gr 6.5cm

aj-045m
Livrare imediată!

16,51Lei(-20%) 13,20Lei

187,00Lei(-20%) 149,59Lei

Momitor Delphin Plumb Cu Tub 20g

925001020
Livrare imediată!

4,00Lei(-27%) 2,90Lei

Momitor Delphin Striat Cu Tub 50g

925001250
Livrare imediată!

7,00Lei(-30%) 4,90Lei

Momitor Dragon Method Feeder Large 25g

chj5910025l
Livrare imediată!

9,90Lei(-6%) 9,32Lei

15,01Lei(-14%) 12,90Lei

15,01Lei(-20%) 12,00Lei

Exclusiv online!

Momitor Ecologic Extra Carp Top Feeder 25g

f75-8231
Livrare 48-72ore

5,00Lei(-16%) 4,21Lei

Momitor Feeder Dreptunghiular 20gr

58085020
Livrare imediată!

9,00Lei(-23%) 6,90Lei

Momitor Feeder Jaxon Copca

mp-ka002
Livrare imediată!

33,00Lei(-21%) 26,18Lei

40,00Lei(-2%) 39,00Lei

Momitor Fox Compact Carp Feeder, 28gr

cac242
Livrare imediată!

20,02Lei(-25%) 14,99Lei

Momitor Genlog Force Method Elasticed 20 Gr

mm-fme-20
Livrare imediată!

8,29Lei(-23%) 6,40Lei

Momitor Genlog Force Method Elasticed 40 Gr

mm-fme-40
Livrare imediată!

9,40Lei(-23%) 7,25Lei

Afişare 6421 - 6440 din 9150 (458 pagini)
Queries: 6, Total time: 731.769 ms [By time] [By id] [By file]
1 (0.126)
SELECT data
FROM `oc_session`
WHERE session_id = '63d48e153c40efd0e18fdad79f'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.114)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (332.429)
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 (398.792)
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 6420,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:588
5 (0.141)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"PRODUSE INACTIVE"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
6 (0.167)
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