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


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

Hanorac Trakker Cr Logo Hoody, Kaki, Marime 3xl

207159
Livrare imediată!

234,95Lei(-13%) 204,07Lei

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

Hanorac Trakker Cr Logo Hoody, Kaki, Marime L

207156
Livrare imediată!

234,95Lei(-13%) 204,07Lei

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

Hanorac Trakker Cr Logo Hoody, Kaki, Marime M

207155
Livrare imediată!

234,95Lei(-13%) 204,07Lei

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

Hanorac Trakker Cr Logo Hoody, Kaki, Marime S

207154
Livrare imediată!

234,95Lei(-13%) 204,07Lei

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

Hanorac Trakker Cr Logo Hoody, Kaki, Marime Xl

207157
Livrare imediată!

234,95Lei(-13%) 204,07Lei

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

Hanorac Trakker Tempest Fishing Hoody, Marime 2xl

207395
Livrare imediată!

234,95Lei(-13%) 204,07Lei

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

Hanorac Trakker Tempest Fishing Hoody, Marime 3xl

207396
Livrare imediată!

234,95Lei(-13%) 204,07Lei

Hanorac Trakker Tempest Fishing Hoody, Marime L -13%

Hanorac Trakker Tempest Fishing Hoody, Marime L

207393
Livrare imediată!

234,95Lei(-13%) 204,07Lei

Hanorac Trakker Tempest Fishing Hoody, Marime M -13%

Hanorac Trakker Tempest Fishing Hoody, Marime M

207392
Livrare imediată!

234,95Lei(-13%) 204,07Lei

Hanorac Trakker Tempest Fishing Hoody, Marime S -13%

Hanorac Trakker Tempest Fishing Hoody, Marime S

207391
Livrare imediată!

234,95Lei(-13%) 204,07Lei

Hanorac Trakker Tempest Fishing Hoody, Marime Xl -13%

Hanorac Trakker Tempest Fishing Hoody, Marime Xl

207394
Livrare imediată!

234,95Lei(-13%) 204,07Lei

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

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

clu364
Livrare imediată!

697,46Lei(-39%) 427,86Lei

Husa 2 Compartimente Delphin Classa 130 Cm -46%

Husa 2 Compartimente Delphin Classa 130 Cm

101000456
Livrare imediată!

189,99Lei(-46%) 102,58Lei

Husa Cantar Jrc Defender Scales Pouch, Green -51%

Husa Cantar Jrc Defender Scales Pouch, Green

1445883
Livrare imediată!

78,80Lei(-51%) 38,24Lei

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

Husa Colmic Capac Galeata Pvc 12 L

sec04
Livrare 48-72 ore

45,00Lei(-25%) 33,54Lei

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

Husa Dam Intenze 3 Compartment Padded Rod Bag, 170x33x30cm

svs60368
Livrare 7-14 zile

399,91Lei(-45%) 220,22Lei

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

Husa Korum Progress Compact Quiver 2 Rods, 130x10x9cm

k0290118
Livrare 7-14 zile

189,00Lei(-35%) 122,92Lei

Husa Lansete Cu Mulinete Fox Camolite Double Spod Jackets 13ft, 2 Compartimente -23%

Husa Lansete Cu Mulinete Fox Camolite Double Spod Jackets 13ft, 2 Compartimente

clu456
Livrare imediată!

431,96Lei(-23%) 331,33Lei

Husa Lansete Nash 12ft, 5 Rod Apache, Green -42%

Husa Lansete Nash 12ft, 5 Rod Apache, Green

t3539
Livrare imediată!

829,90Lei(-42%) 477,62Lei

Husa Lansete Shimano Tribal Trench 3 Rod 12 Holdall 200 Cm -29%

Husa Lansete Shimano Tribal Trench 3 Rod 12 Holdall 200 Cm

shttg07
Livrare imediată!

700,00Lei(-29%) 494,15Lei

Afişare 1081 - 1100 din 9292 (465 pagini)
Queries: 5, Total time: 701.044 ms [By time] [By id] [By file]
1 (0.158)
SELECT data
FROM `oc_session`
WHERE session_id = '8d26af0af78f4867e5486d57ce'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.087)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (323.288)
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 (377.347)
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 1080,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:588
5 (0.164)
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