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


Cleste Dam Madcat Splitring Plier -30%

Cleste Dam Madcat Splitring Plier

4250952189
Livrare imediată!

135,46Lei(-30%) 94,82Lei

Cleste Frichy Crimping Pliers -29%

Cleste Frichy Crimping Pliers

414x48
Livrare imediată!

68,79Lei(-29%) 48,90Lei

Cleste Jaxon Multifunctional 17cm -25%
Exclusiv online!

Cleste Jaxon Multifunctional 17cm

aj-ns16a
Livrare 48-72 ore

121,00Lei(-25%) 90,80Lei

Cleste Mustad Alumininium Blue 16cm -40%

Cleste Mustad Alumininium Blue 16cm

m.mt111
Livrare imediată!

202,17Lei(-40%) 122,20Lei

Cleste Mustad Blue 12.7cm -18%

Cleste Mustad Blue 12.7cm

m.mt106
Livrare imediată!

59,52Lei(-18%) 48,52Lei

Cleste Mustad Blue 15.2cm -18%
Exclusiv online!

Cleste Mustad Blue 15.2cm

m.mt108
Livrare 24-48 ore

53,56Lei(-18%) 43,74Lei

Cleste Mustad Blue 17.8cm -29%

Cleste Mustad Blue 17.8cm

m.mt110
Livrare imediată!

112,26Lei(-29%) 79,49Lei

Cleste Mustad Green 17.8cm -29%

Cleste Mustad Green 17.8cm

m.mt114
Livrare imediată!

123,51Lei(-29%) 87,35Lei

Cleste Mustad Green 24.5cm -29%

Cleste Mustad Green 24.5cm

m.mt118
Livrare imediată!

168,46Lei(-29%) 118,82Lei

Cleste Mustad Pentru Inele Blue -28%
Exclusiv online!

Cleste Mustad Pentru Inele Blue

m.mt105
Livrare 24-48 ore

47,43Lei(-28%) 34,11Lei

Cleste Mustad Pentru Inele Despicate 13cm -16%
Exclusiv online!

Cleste Mustad Pentru Inele Despicate 13cm

m.mtb007
Livrare 24-48 ore

20,94Lei(-16%) 17,65Lei

Cleste Pentru Inele Despicate Spro 13.5cm -20%

Cleste Pentru Inele Despicate Spro 13.5cm

4702-135
Livrare imediată!

53,30Lei(-20%) 42,64Lei

Cleste Pentru Taiat Strune Fox Rage Side Cutters, 28cm -33%

Cleste Pentru Taiat Strune Fox Rage Side Cutters, 28cm

ntl039
Livrare imediată!

89,96Lei(-33%) 59,90Lei

Cleste Savage Alu Pro M 17.5cm -20%
Exclusiv online!

Cleste Savage Alu Pro M 17.5cm

a.sg.71887
Livrare 24-48 ore

198,44Lei(-20%) 159,65Lei

Cleste Savage Gear Pro L 20cm -40%
Exclusiv online!

Cleste Savage Gear Pro L 20cm

a.sg.71888
Livrare 24-48 ore

264,56Lei(-40%) 159,64Lei

Cleste Sertizat Black Cat Meag Crimping Pliers, 26cm -20%
Exclusiv online!

Cleste Sertizat Black Cat Meag Crimping Pliers, 26cm

6423001
Livrare 7-14 zile

145,00Lei(-20%) 115,80Lei

Cleste Spro Pentru Inele Despicate Titanium, 12cm -20%

Cleste Spro Pentru Inele Despicate Titanium, 12cm

004702-00120-00000
Livrare imediată!

45,30Lei(-20%) 36,24Lei

Clip Guru Pentru Method Feeder Marimea S 3buc/pac -20%

Clip Guru Pentru Method Feeder Marimea S 3buc/pac

a.gu.gmcs
Livrare imediată!

18,60Lei(-20%) 14,90Lei

Clips Metalic Carp Spirit Pentru Plumb Weed Green 10buc/plic -16%
Exclusiv online!

Clips Metalic Carp Spirit Pentru Plumb Weed Green 10buc/plic

acs010363
Livrare 48-72ore

25,00Lei(-16%) 20,90Lei

Clips One More Cast Magic Twig Lead Clip Light, 2buc/pac -20%
Exclusiv online!

Clips One More Cast Magic Twig Lead Clip Light, 2buc/pac

omcmtll
Livrare 48-72ore

47,23Lei(-20%) 37,90Lei

Afişare 4061 - 4080 din 8973 (449 pagini)
Queries: 7, Total time: 648.761 ms [By time] [By id] [By file]
1 (0.145)
SELECT data
FROM `oc_session`
WHERE session_id = 'd3afa8b06fc5eb5a58e5dca043'
/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 (291.511)
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 (356.579)
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 4060,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:588
5 (0.180)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"RAPALA VMC ROMANIA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
6 (0.121)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"ONE MORE CAST"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
7 (0.111)
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