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


Fir Monofilament Maver Dynasty Green 150m 0.20mm -26%
Exclusiv online!

Fir Monofilament Maver Dynasty Green 150m 0.20mm

605020
Livrare 48-72 ore

25,00Lei(-26%) 18,40Lei

Fir Monofilament Maver Dynasty Green 150m 0.22mm -26%
Exclusiv online!

Fir Monofilament Maver Dynasty Green 150m 0.22mm

605022
Livrare 48-72 ore

25,00Lei(-26%) 18,40Lei

Fir Monofilament Maver Dynasty Green 150m 0.24mm -26%
Exclusiv online!

Fir Monofilament Maver Dynasty Green 150m 0.24mm

605024
Livrare 48-72 ore

25,00Lei(-26%) 18,40Lei

Fir Monofilament Maver Dynasty Green 150m 0.27mm -26%
Exclusiv online!

Fir Monofilament Maver Dynasty Green 150m 0.27mm

605027
Livrare 48-72 ore

25,00Lei(-26%) 18,40Lei

Fir Monofilament Maver Dynasty Green 600m 0.30mm -29%
Exclusiv online!

Fir Monofilament Maver Dynasty Green 600m 0.30mm

700030
Livrare 48-72 ore

66,00Lei(-29%) 47,10Lei

Fir Monofilament Maver Dynasty Green 600m 0.33mm -29%
Exclusiv online!

Fir Monofilament Maver Dynasty Green 600m 0.33mm

700033
Livrare 48-72 ore

75,01Lei(-29%) 53,40Lei

Fir Monofilament Maver Elit Luminex 100m 0.180mm -48%
Exclusiv online!

Fir Monofilament Maver Elit Luminex 100m 0.180mm

726180
Livrare 48-72 ore

51,00Lei(-48%) 26,39Lei

Fir Monofilament Maver Elit Luminex 100m 0.225mm -49%
Exclusiv online!

Fir Monofilament Maver Elit Luminex 100m 0.225mm

726225
Livrare 48-72 ore

58,50Lei(-49%) 30,10Lei

Fir Monofilament Maver Elit Luminex 100m 0.290mm -49%
Exclusiv online!

Fir Monofilament Maver Elit Luminex 100m 0.290mm

726290
Livrare 48-72 ore

66,00Lei(-49%) 33,90Lei

Fir Monofilament Maver Elit Luminex 100m 0.310mm -49%
Exclusiv online!

Fir Monofilament Maver Elit Luminex 100m 0.310mm

726310
Livrare 48-72 ore

72,00Lei(-49%) 36,90Lei

Fir Monofilament Maver Elite No Gravity Fluo 300m 0.316mm -49%
Exclusiv online!

Fir Monofilament Maver Elite No Gravity Fluo 300m 0.316mm

727316
Livrare 48-72 ore

85,00Lei(-49%) 43,40Lei

Fir Monofilament Maver Extreme 4x4 500m 0.194mm -47%
Exclusiv online!

Fir Monofilament Maver Extreme 4x4 500m 0.194mm

661194
Livrare 48-72 ore

33,00Lei(-47%) 17,40Lei

Fir Monofilament Maver Extreme 4x4 500m 0.215mm -47%
Exclusiv online!

Fir Monofilament Maver Extreme 4x4 500m 0.215mm

661215
Livrare 48-72 ore

34,00Lei(-47%) 17,90Lei

Fir Monofilament Maver Extreme 4x4 500m 0.246mm -47%
Exclusiv online!

Fir Monofilament Maver Extreme 4x4 500m 0.246mm

661246
Livrare 48-72 ore

34,00Lei(-47%) 17,90Lei

Fir Monofilament Maver Extreme 4x4 500m 0.302mm -48%
Exclusiv online!

Fir Monofilament Maver Extreme 4x4 500m 0.302mm

661302
Livrare 48-72 ore

37,00Lei(-48%) 19,40Lei

Fir Monofilament Maver Extreme 4x4 500m 0.349mm -48%
Exclusiv online!

Fir Monofilament Maver Extreme 4x4 500m 0.349mm

661349
Livrare 48-72 ore

41,00Lei(-48%) 21,40Lei

Fir Monofilament Maver Extreme 4x4 500m 0.427mm -49%
Exclusiv online!

Fir Monofilament Maver Extreme 4x4 500m 0.427mm

661427
Livrare 48-72 ore

86,00Lei(-49%) 43,90Lei

Fir Monofilament Maver Extreme 4x4 500m 0.540mm -49%
Exclusiv online!

Fir Monofilament Maver Extreme 4x4 500m 0.540mm

661540
Livrare 48-72 ore

86,00Lei(-49%) 43,90Lei

Fir Monofilament Maver Genesis Plus 50m 0.18mm -22%
Exclusiv online!

Fir Monofilament Maver Genesis Plus 50m 0.18mm

679018
Livrare 48-72 ore

11,50Lei(-22%) 9,00Lei

Fir Monofilament Maver Genesis Plus 50m 0.22mm -23%

Fir Monofilament Maver Genesis Plus 50m 0.22mm

679022
Livrare imediată!

12,80Lei(-23%) 9,90Lei

Afişare 4801 - 4820 din 9131 (457 pagini)
Queries: 5, Total time: 580.235 ms [By time] [By id] [By file]
1 (0.125)
SELECT data
FROM `oc_session`
WHERE session_id = 'ae795eefd55c9dcf63c7c4e4f5'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.077)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (264.348)
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 (315.585)
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 4800,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:588
5 (0.100)
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