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


Mulineta Trabucco Xenial Sw Fa 2500 Pg -15%

Mulineta Trabucco Xenial Sw Fa 2500 Pg

034-50-250
Livrare imediată!

520,00Lei(-15%) 442,65Lei

Mulineta Trabucco Xenial Sw Fa 3500 Pg -14%

Mulineta Trabucco Xenial Sw Fa 3500 Pg

034-50-350
Livrare imediată!

530,00Lei(-14%) 454,75Lei

Mulineta Trabucco Xplore Gt 2500 -12%

Mulineta Trabucco Xplore Gt 2500

034-10-200
Livrare imediată!

430,00Lei(-12%) 377,12Lei

Mulineta Trabucco Xplore Gt 3500 -14%

Mulineta Trabucco Xplore Gt 3500

034-10-300
Livrare imediată!

435,00Lei(-14%) 376,10Lei

Mulineta Trabucco Zephyr Fd 3000 -17%

Mulineta Trabucco Zephyr Fd 3000

034-42-300
Livrare imediată!

270,00Lei(-17%) 224,85Lei

Mulinta Tica Cambria Ly, 4000 -18%
Exclusiv online!

Mulinta Tica Cambria Ly, 4000

ly4000
Livrare 48-72 ore

188,00Lei(-18%) 154,84Lei

Multiplicator Savage Gear Sg6 Bc 250 Lh 5+1bb/mxmm/6.6:1 -11%
Exclusiv online!

Multiplicator Savage Gear Sg6 Bc 250 Lh 5+1bb/mxmm/6.6:1

o.sg.74779
Livrare 24-48 ore

630,42Lei(-11%) 561,37Lei

Musca Mustad Int. Artif.pe Cirlig Nr.14 -8%

Musca Mustad Int. Artif.pe Cirlig Nr.14

f3.mus14
Livrare imediată!

7,59Lei(-8%) 7,01Lei

Musca Mustad Int. Artif.pe Cirlig Nr.16 -8%

Musca Mustad Int. Artif.pe Cirlig Nr.16

f3.mus16
Livrare imediată!

7,59Lei(-8%) 7,01Lei

Muste Jmc Ape Rapide 6buc/pac -23%
Exclusiv online!

Muste Jmc Ape Rapide 6buc/pac

130745mo11001
Livrare 48-72 ore

58,96Lei(-23%) 45,60Lei

Muste Jmc Emergentes 6buc/pac -23%

Muste Jmc Emergentes 6buc/pac

130745mo11008
Livrare imediată!

58,96Lei(-23%) 45,60Lei

Muste Jmc Mouche De Mai 6buc/pac -23%

Muste Jmc Mouche De Mai 6buc/pac

130745mo11006
Livrare imediată!

58,96Lei(-23%) 45,60Lei

Muste Jmc Noyees 6buc/pac -23%

Muste Jmc Noyees 6buc/pac

130745mo01102
Livrare imediată!

58,96Lei(-23%) 45,60Lei

Muste Jmc Palmers 6buc/pac -23%

Muste Jmc Palmers 6buc/pac

130745mo11003
Livrare imediată!

58,96Lei(-23%) 45,60Lei

Nada Benzar Mix Rapid Bigfish Mix 1.5kg Mango-butiric -36%
Exclusiv online!

Nada Benzar Mix Rapid Bigfish Mix 1.5kg Mango-butiric

97012174
Livrare 24-48 ore

18,32Lei(-36%) 11,66Lei

Nada Carp Hunter Anason 800gr -42%
Exclusiv online!

Nada Carp Hunter Anason 800gr

98003102
Stoc epuizat

8,64Lei(-42%) 5,00Lei

Nada Colmic Feeder Mix Halibut Hemp 1 Kg -26%
Exclusiv online!

Nada Colmic Feeder Mix Halibut Hemp 1 Kg

pcfed02e
Livrare 48-72 ore

41,00Lei(-26%) 30,23Lei

Nada Colmic Feeder Mix Premium Halibut 1 Kg -26%
Exclusiv online!

Nada Colmic Feeder Mix Premium Halibut 1 Kg

pcfed02c
Livrare 48-72 ore

41,00Lei(-26%) 30,23Lei

Nada Fish Pro, Caras Platica, Caramel Sarat, 1kg -49%
Exclusiv online!

Nada Fish Pro, Caras Platica, Caramel Sarat, 1kg

nfp-cpcs
Stoc epuizat

15,16Lei(-49%) 7,67Lei

Nada Sensas 3000 Lake 1kg -18%

Nada Sensas 3000 Lake 1kg

a0.s71351
Livrare imediată!

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

Afişare 6861 - 6880 din 9198 (460 pagini)
Queries: 5, Total time: 768.968 ms [By time] [By id] [By file]
1 (0.100)
SELECT data
FROM `oc_session`
WHERE session_id = 'ed0d10017d4f8d2b909137688d'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.097)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (302.975)
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 (465.650)
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 6860,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:588
5 (0.146)
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