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


Fir Jaxon Xt-pro Premium 25m 0.16mm -6%
Exclusiv online!

Fir Jaxon Xt-pro Premium 25m 0.16mm

zj-xtp016c
Livrare 48-72 ore

4,50Lei(-6%) 4,25Lei

Fir Jaxon Xt-pro Premium 25m 0.18mm -6%

Fir Jaxon Xt-pro Premium 25m 0.18mm

zj-xtp018c
Livrare imediată!

4,50Lei(-6%) 4,25Lei

Fir Kryston Quicksilver Gold Coated Shock Leader 20m 25lb Gravel Brown -17%

Fir Kryston Quicksilver Gold Coated Shock Leader 20m 25lb Gravel Brown

krqs4
Livrare imediată!

68,99Lei(-17%) 57,12Lei

Fir Leader Carp Zoom Fluorocarbon Feeder 25m 0.20mm 3.54kg -15%

Fir Leader Carp Zoom Fluorocarbon Feeder 25m 0.20mm 3.54kg

cz2591
Livrare imediată!

21,50Lei(-15%) 18,17Lei

Fir Leader Carp Zoom Fluorocarbon Feeder 25m 0.22mm 4.36kg -17%

Fir Leader Carp Zoom Fluorocarbon Feeder 25m 0.22mm 4.36kg

cz2607
Livrare imediată!

23,00Lei(-17%) 19,20Lei

Fir Maver Smart M1 300m 0.150mm -42%

Fir Maver Smart M1 300m 0.150mm

692015
Livrare imediată!

28,00Lei(-42%) 16,15Lei

Fir Maver Smart M1 300m 0.170mm -42%

Fir Maver Smart M1 300m 0.170mm

692017
Livrare imediată!

29,50Lei(-42%) 17,17Lei

Fir Maver Smart M1 300m 0.190mm -43%
Exclusiv online!

Fir Maver Smart M1 300m 0.190mm

692019
Livrare 48-72 ore

31,00Lei(-43%) 17,68Lei

Fir Maver Smart M1 300m 0.230mm -16%

Fir Maver Smart M1 300m 0.230mm

692023
Livrare imediată!

33,00Lei(-16%) 27,84Lei

Fir Maver Smart M1 300m 0.260mm -16%

Fir Maver Smart M1 300m 0.260mm

692026
Livrare imediată!

35,50Lei(-16%) 29,87Lei

Fir Metalic Cormoran Pentru Struna 7x7 5mt 6kg -6%

Fir Metalic Cormoran Pentru Struna 7x7 5mt 6kg

a7.75.40060
Livrare imediată!

73,56Lei(-6%) 69,45Lei

Fir Metalic Cormoran Pentru Struna 7x7 5mt 9kg -5%

Fir Metalic Cormoran Pentru Struna 7x7 5mt 9kg

a7.75.40090
Livrare imediată!

58,00Lei(-5%) 54,98Lei

Fir Mono Carp Zoom Marshal Origo Carp Line 1000m 0.23mm 4.80kg Fluo Pink -22%

Fir Mono Carp Zoom Marshal Origo Carp Line 1000m 0.23mm 4.80kg Fluo Pink

cz6988
Livrare imediată!

65,00Lei(-22%) 50,61Lei

Fir Monofilament Avid Carp Outline Zig & Floater Line, 4.5kg-10lbs, 0.26mm, 100m -46%

Fir Monofilament Avid Carp Outline Zig & Floater Line, 4.5kg-10lbs, 0.26mm, 100m

a0630007
Livrare imediată!

37,45Lei(-46%) 20,04Lei

Fir Monofilament Berkley Flex Mono Transparent, 150m, 0.14mm, 1.7kg -14%

Fir Monofilament Berkley Flex Mono Transparent, 150m, 0.14mm, 1.7kg

1550686
Livrare imediată!

19,97Lei(-14%) 17,17Lei

Fir Monofilament Berkley Flex Mono Transparent, 150m, 0.16mm, 2.1kg -14%

Fir Monofilament Berkley Flex Mono Transparent, 150m, 0.16mm, 2.1kg

1550687
Livrare imediată!

19,97Lei(-14%) 17,17Lei

Fir Monofilament Berkley Flex Mono Transparent, 150m, 0.25mm, 4.8kg -14%

Fir Monofilament Berkley Flex Mono Transparent, 150m, 0.25mm, 4.8kg

1550690
Livrare imediată!

19,97Lei(-14%) 17,17Lei

Fir Monofilament Berkley Flex Mono Transparent, 150m, 0.30mm, 6.8kg -14%

Fir Monofilament Berkley Flex Mono Transparent, 150m, 0.30mm, 6.8kg

1550691
Livrare imediată!

19,97Lei(-14%) 17,17Lei

Fir Monofilament Berkley Flex Mono Transparent, 150m, 0.35mm, 8.7kg -14%

Fir Monofilament Berkley Flex Mono Transparent, 150m, 0.35mm, 8.7kg

1550692
Livrare imediată!

19,97Lei(-14%) 17,17Lei

Fir Monofilament Carbotex 016mm/3,65kg/100m -19%

Fir Monofilament Carbotex 016mm/3,65kg/100m

e.4800.016
Livrare imediată!

11,85Lei(-19%) 9,57Lei

Afişare 4841 - 4860 din 9190 (460 pagini)
Queries: 5, Total time: 612.519 ms [By time] [By id] [By file]
1 (0.114)
SELECT data
FROM `oc_session`
WHERE session_id = 'a044553fbdf874378ff77f206f'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.103)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (287.776)
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 (324.370)
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 4840,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:588
5 (0.156)
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