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


Mulineta Trabucco Helium Fa 1000

034-29-100
Livrare imediată!

690,00Lei(-15%) 589,89Lei

Mulineta Trabucco Kronos Sfx Fd 2000

034-38-200
Livrare imediată!

210,00Lei(-18%) 172,90Lei

Mulineta Trabucco Sharp Fa 4000

034-18-400
Livrare imediată!

690,00Lei(-15%) 583,10Lei

Exclusiv online!

Mulineta Trabucco Venger Fa 2000

034-44-200
Livrare 48-72 ore

250,00Lei(-16%) 209,80Lei

Mulineta Trabucco Vidar 1000

034-45-100
Livrare imediată!

220,00Lei(-14%) 189,90Lei

Mulineta Trabucco Xenial Sw Fa 2500 Pg

034-50-250
Livrare imediată!

519,99Lei(-16%) 434,35Lei

Mulineta Trabucco Xenial Sw Fa 3500 Pg

034-50-350
Livrare imediată!

530,00Lei(-16%) 446,25Lei

Mulineta Trabucco Xplore Gt 2500

034-10-200
Livrare imediată!

429,99Lei(-14%) 369,90Lei

Mulineta Trabucco Xplore Gt 3500

034-10-300
Livrare imediată!

435,00Lei(-15%) 368,90Lei

Mulineta Trabucco Zephyr Fd 3000

034-42-300
Livrare imediată!

270,00Lei(-18%) 220,15Lei

Exclusiv online!

Mulinta Tica Cambria Ly, 4000

ly4000
Livrare 48-72 ore

188,00Lei(-20%) 151,30Lei

Musca Mustad Int. Artif.pe Cirlig Nr.14

f3.mus14
Livrare imediată!

7,59Lei(-22%) 5,90Lei

Musca Mustad Int. Artif.pe Cirlig Nr.16

f3.mus16
Livrare imediată!

7,59Lei(-22%) 5,90Lei

Exclusiv online!

Muste Jmc Ape Rapide 6buc/pac

130745mo11001
Livrare 48-72 ore

58,96Lei(-26%) 43,86Lei

Muste Jmc Emergentes 6buc/pac

130745mo11008
Livrare imediată!

58,96Lei(-26%) 43,86Lei

Muste Jmc Mouche De Mai 6buc/pac

130745mo11006
Livrare imediată!

58,96Lei(-26%) 43,86Lei

Muste Jmc Noyees 6buc/pac

130745mo01102
Livrare imediată!

58,96Lei(-26%) 43,86Lei

Muste Jmc Palmers 6buc/pac

130745mo11003
Livrare imediată!

58,96Lei(-26%) 43,86Lei

Nada Bait Tech Special G F1 2kg

5035305711127
Livrare imediată!

52,00Lei(-6%) 48,90Lei

Exclusiv online!

17,51Lei(-25%) 13,20Lei

Afişare 6661 - 6680 din 9057 (453 pagini)
Queries: 5, Total time: 580.445 ms [By time] [By id] [By file]
1 (0.094)
SELECT data
FROM `oc_session`
WHERE session_id = 'd8dcad9249fbe35ec6a0225705'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.081)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (264.873)
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.235)
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 6660,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:588
5 (0.162)
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