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


Husa Tigaie Delphin Pancase 46x30x9cm -41%

Husa Tigaie Delphin Pancase 46x30x9cm

101003321
Livrare imediată!

87,00Lei(-41%) 51,74Lei

Husa Ușoară Delphin Light Space C2g -39%

Husa Ușoară Delphin Light Space C2g

101002386
Livrare imediată!

101,00Lei(-39%) 61,92Lei

Jacheta Avid Carp Ripstop Camo Jacket Marime S -43%

Jacheta Avid Carp Ripstop Camo Jacket Marime S

a0620180
Livrare imediată!

442,76Lei(-43%) 253,06Lei

Jacheta Avid Hydro-force 20k Pullover Jacket, Marimea L -24%

Jacheta Avid Hydro-force 20k Pullover Jacket, Marimea L

a0620334
Livrare imediată!

539,96Lei(-24%) 412,71Lei

Jacheta Avid Hydro-force 20k Pullover Jacket, Marimea M -24%

Jacheta Avid Hydro-force 20k Pullover Jacket, Marimea M

a0620333
Livrare imediată!

539,96Lei(-24%) 412,71Lei

Jacheta Avid Hydro-force 20k Pullover Jacket, Marimea S -24%

Jacheta Avid Hydro-force 20k Pullover Jacket, Marimea S

a0620332
Livrare imediată!

539,96Lei(-24%) 412,71Lei

Jacheta Avid Hydro-force 20k Pullover Jacket, Marimea Xl -24%

Jacheta Avid Hydro-force 20k Pullover Jacket, Marimea Xl

a0620335
Livrare imediată!

539,96Lei(-24%) 412,71Lei

Jacheta Avid Hydro-force 20k Pullover Jacket, Marimea Xxl -24%

Jacheta Avid Hydro-force 20k Pullover Jacket, Marimea Xxl

a0620336
Livrare imediată!

539,96Lei(-24%) 412,71Lei

Jacheta Avid Hydro-force 20k Pullover Jacket, Marimea Xxxl -24%

Jacheta Avid Hydro-force 20k Pullover Jacket, Marimea Xxxl

a0620337
Livrare imediată!

539,96Lei(-24%) 412,71Lei

Jacheta Cu Gluga Fox Rage Wind Blocker Jacket Masura Xl -18%

Jacheta Cu Gluga Fox Rage Wind Blocker Jacket Masura Xl

npr276
Livrare imediată!

424,89Lei(-18%) 347,54Lei

Jacheta Fleece Korda Kore Polar, Olive, Marime S -5%

Jacheta Fleece Korda Kore Polar, Olive, Marime S

kcl322
Livrare imediată!

374,95Lei(-5%) 355,34Lei

Jacheta Fox Rage Voyager Lightweight Wind Blocker S -25%

Jacheta Fox Rage Voyager Lightweight Wind Blocker S

npr424
Livrare imediată!

427,46Lei(-25%) 321,19Lei

Jacheta Gamakatsu Gama G Quilted Fleece, Marime L -18%
Exclusiv online!

Jacheta Gamakatsu Gama G Quilted Fleece, Marime L

a8.gk.7245.300
Livrare 24-48 ore

359,73Lei(-18%) 293,62Lei

Jacheta Gamakatsu Gama G Quilted Fleece, Marime M -18%
Exclusiv online!

Jacheta Gamakatsu Gama G Quilted Fleece, Marime M

a8.gk.7245.200
Livrare 24-48 ore

359,73Lei(-18%) 293,62Lei

Jacheta Imax Arx Thermo Marimea M -29%
Exclusiv online!

Jacheta Imax Arx Thermo Marimea M

a8.imx.57248
Livrare 24-48 ore

315,34Lei(-29%) 225,45Lei

Jacheta Imax Arx Thermo Marimea Xl -29%

Jacheta Imax Arx Thermo Marimea Xl

a8.imx.57250
Livrare imediată!

416,65Lei(-29%) 297,56Lei

Jacheta Imax Arx Thermo Marimea Xxl -29%
Exclusiv online!

Jacheta Imax Arx Thermo Marimea Xxl

a8.imx.57251
Livrare 24-48 ore

416,65Lei(-29%) 297,56Lei

Jacheta Impermeabila Tubertini Giacca Freeport, Marime Xxl -13%
Exclusiv online!

Jacheta Impermeabila Tubertini Giacca Freeport, Marime Xxl

753200d
Livrare 7-14 zile

415,01Lei(-13%) 359,68Lei

Jacheta Jackall Timon Rain Wear, Marime L -29%
Exclusiv online!

Jacheta Jackall Timon Rain Wear, Marime L

ja.807294033
Livrare 24-48 ore

1.881,61Lei(-29%) 1.340,27Lei

Jacheta Nash Waterproof Jacket, Marimea M -30%

Jacheta Nash Waterproof Jacket, Marimea M

c0031
Livrare imediată!

439,99Lei(-30%) 308,47Lei

Afişare 1101 - 1120 din 9210 (461 pagini)
Queries: 5, Total time: 821.415 ms [By time] [By id] [By file]
1 (0.086)
SELECT data
FROM `oc_session`
WHERE session_id = '0706f37d279b9c9b229e837b57'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.119)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (418.453)
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 (402.553)
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 1100,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:588
5 (0.205)
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