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


Hanorac Trakker Cr Logo Camo Hoody Black, Marime S -15%

Hanorac Trakker Cr Logo Camo Hoody Black, Marime S

207859
Livrare imediată!

234,95Lei(-15%) 199,71Lei

Hanorac Trakker Cr Logo Camo Hoody Black, Marime Xl -15%

Hanorac Trakker Cr Logo Camo Hoody Black, Marime Xl

207862
Livrare imediată!

234,95Lei(-15%) 199,71Lei

Hanorac Trakker Cr Logo Hoody, Kaki, Marime 2xl -15%

Hanorac Trakker Cr Logo Hoody, Kaki, Marime 2xl

207158
Livrare imediată!

234,95Lei(-15%) 199,71Lei

Hanorac Trakker Cr Logo Hoody, Kaki, Marime 3xl -15%

Hanorac Trakker Cr Logo Hoody, Kaki, Marime 3xl

207159
Livrare imediată!

234,95Lei(-15%) 199,71Lei

Hanorac Trakker Cr Logo Hoody, Kaki, Marime L -15%

Hanorac Trakker Cr Logo Hoody, Kaki, Marime L

207156
Livrare imediată!

234,95Lei(-15%) 199,71Lei

Hanorac Trakker Cr Logo Hoody, Kaki, Marime M -15%

Hanorac Trakker Cr Logo Hoody, Kaki, Marime M

207155
Livrare imediată!

234,95Lei(-15%) 199,71Lei

Hanorac Trakker Cr Logo Hoody, Kaki, Marime S -15%

Hanorac Trakker Cr Logo Hoody, Kaki, Marime S

207154
Livrare imediată!

234,95Lei(-15%) 199,71Lei

Hanorac Trakker Cr Logo Hoody, Kaki, Marime Xl -15%

Hanorac Trakker Cr Logo Hoody, Kaki, Marime Xl

207157
Livrare imediată!

234,95Lei(-15%) 199,71Lei

Hanorac Trakker Tempest Fishing Hoody, Marime 2xl -15%

Hanorac Trakker Tempest Fishing Hoody, Marime 2xl

207395
Livrare imediată!

234,95Lei(-15%) 199,71Lei

Hanorac Trakker Tempest Fishing Hoody, Marime 3xl -15%

Hanorac Trakker Tempest Fishing Hoody, Marime 3xl

207396
Livrare imediată!

234,95Lei(-15%) 199,71Lei

Hanorac Trakker Tempest Fishing Hoody, Marime L -15%

Hanorac Trakker Tempest Fishing Hoody, Marime L

207393
Livrare imediată!

234,95Lei(-15%) 199,71Lei

Hanorac Trakker Tempest Fishing Hoody, Marime M -15%

Hanorac Trakker Tempest Fishing Hoody, Marime M

207392
Livrare imediată!

234,95Lei(-15%) 199,71Lei

Hanorac Trakker Tempest Fishing Hoody, Marime S -15%

Hanorac Trakker Tempest Fishing Hoody, Marime S

207391
Livrare imediată!

234,95Lei(-15%) 199,71Lei

Hanorac Trakker Tempest Fishing Hoody, Marime Xl -15%

Hanorac Trakker Tempest Fishing Hoody, Marime Xl

207394
Livrare imediată!

234,95Lei(-15%) 199,71Lei

Husa Lansete Fox R-series 12ft Quiver And 4 Sleeves -40%

Husa Lansete Fox R-series 12ft Quiver And 4 Sleeves

clu364
Livrare imediată!

697,46Lei(-40%) 418,90Lei

Husa 2 Compartimente Delphin Classa 130 Cm -47%

Husa 2 Compartimente Delphin Classa 130 Cm

101000456
Livrare imediată!

190,00Lei(-47%) 99,90Lei

Husa Cantar Jrc Defender Scales Pouch, Green -54%

Husa Cantar Jrc Defender Scales Pouch, Green

1445883
Livrare imediată!

78,80Lei(-54%) 36,60Lei

Husa Colmic Capac Galeata Pvc 12 L -29%
Exclusiv online!

Husa Colmic Capac Galeata Pvc 12 L

sec04
Livrare 48-72 ore

45,01Lei(-29%) 32,00Lei

Husa Dam Intenze 3 Compartment Padded Rod Bag, 170x33x30cm -46%
Exclusiv online!

Husa Dam Intenze 3 Compartment Padded Rod Bag, 170x33x30cm

svs60368
Livrare 7-14 zile

399,90Lei(-46%) 215,60Lei

Husa Korum Progress Compact Quiver 2 Rods, 130x10x9cm -37%
Exclusiv online!

Husa Korum Progress Compact Quiver 2 Rods, 130x10x9cm

k0290118
Livrare 7-14 zile

189,00Lei(-37%) 119,90Lei

Afişare 1021 - 1040 din 8893 (445 pagini)
Queries: 5, Total time: 633.552 ms [By time] [By id] [By file]
1 (0.070)
SELECT data
FROM `oc_session`
WHERE session_id = '2566d0583425e46b9a5d41d140'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.108)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (279.659)
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 (353.606)
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 1020,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:588
5 (0.109)
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