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


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

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

clu456
Livrare imediată!

431,96Lei(-25%) 323,97Lei

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

Husa Lansete Nash 12ft, 5 Rod Apache, Green

t3539
Livrare imediată!

829,89Lei(-44%) 468,74Lei

Husa Lansete Solar Undercover Camo, Rod Holdall 3+2, 13ft, 215x30cm -11%

Husa Lansete Solar Undercover Camo, Rod Holdall 3+2, 13ft, 215x30cm

ca10
Livrare imediată!

499,95Lei(-11%) 447,25Lei

Husa Mulineta Dam O.t.t. Reel Case 10x20x16cm -44%
Exclusiv online!

Husa Mulineta Dam O.t.t. Reel Case 10x20x16cm

svs74982
Livrare 7-14 zile

59,95Lei(-44%) 33,28Lei

Husa Mulinete Carryall Abu Garcia Beast Beast Pro Reel Pouch -38%
Exclusiv online!

Husa Mulinete Carryall Abu Garcia Beast Beast Pro Reel Pouch

1528434
Livrare 7-14 zile

71,28Lei(-38%) 43,90Lei

Husa Mulinete Team Feeder By Dome S 21x16x9cm -20%

Husa Mulinete Team Feeder By Dome S 21x16x9cm

5301-004
Livrare imediată!

51,00Lei(-20%) 40,81Lei

Husa Rhino Rc Bag Universal, 16x8x4cm -40%
Exclusiv online!

Husa Rhino Rc Bag Universal, 16x8x4cm

9944003
Livrare 7-14 zile

39,95Lei(-40%) 23,97Lei

Husa Rigida Fl 1 Compartiment 115cm -45%

Husa Rigida Fl 1 Compartiment 115cm

5752123467530
Livrare imediată!

90,00Lei(-45%) 49,90Lei

Husa Tigaie Delphin Pancase 46x30x9cm -43%

Husa Tigaie Delphin Pancase 46x30x9cm

101003321
Livrare imediată!

87,00Lei(-43%) 49,90Lei

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

Husa Ușoară Delphin Light Space C2g

101002386
Livrare imediată!

101,00Lei(-41%) 59,90Lei

Inel Lineaeffe 2 Picioare Sic D 10,0mm -28%

Inel Lineaeffe 2 Picioare Sic D 10,0mm

a9.2999410
Livrare imediată!

2,81Lei(-28%) 2,03Lei

Jacheta Avid Carp Ripstop Camo Jacket Marime S -44%

Jacheta Avid Carp Ripstop Camo Jacket Marime S

a0620180
Livrare imediată!

442,76Lei(-44%) 247,89Lei

Jacheta Browning Xpo Coldkill Pp Verde Marime M -15%
Exclusiv online!

Jacheta Browning Xpo Coldkill Pp Verde Marime M

bo.30469540.m
Livrare 24-48 ore

547,21Lei(-15%) 465,66Lei

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

Jacheta Cu Gluga Fox Rage Wind Blocker Jacket Masura Xl

npr276
Livrare imediată!

424,89Lei(-20%) 339,91Lei

Jacheta Fleece Korda Kore Polar, Olive, Marime 2xl -23%
Exclusiv online!

Jacheta Fleece Korda Kore Polar, Olive, Marime 2xl

kcl326
Livrare 7-14 zile

348,48Lei(-23%) 268,06Lei

Jacheta Fleece Korda Kore Polar, Olive, Marime M -23%
Exclusiv online!

Jacheta Fleece Korda Kore Polar, Olive, Marime M

kcl323
Livrare 7-14 zile

347,33Lei(-23%) 267,17Lei

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

Jacheta Fleece Korda Kore Polar, Olive, Marime S

kcl322
Livrare imediată!

374,95Lei(-7%) 348,48Lei

Jacheta Fleece Korda Kore Polar, Olive, Marime Xl -23%
Exclusiv online!

Jacheta Fleece Korda Kore Polar, Olive, Marime Xl

kcl325
Livrare 7-14 zile

347,33Lei(-23%) 267,17Lei

Jacheta Fox Rage Voyager Lightweight Wind Blocker S -26%

Jacheta Fox Rage Voyager Lightweight Wind Blocker S

npr424
Livrare imediată!

427,46Lei(-26%) 314,90Lei

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

Jacheta Gamakatsu Gama G Quilted Fleece, Marime L

a8.gk.7245.300
Livrare 24-48 ore

359,73Lei(-20%) 287,78Lei

Afişare 1041 - 1060 din 8893 (445 pagini)
Queries: 5, Total time: 621.726 ms [By time] [By id] [By file]
1 (0.074)
SELECT data
FROM `oc_session`
WHERE session_id = 'c20dfe25848ad47694ac602fe9'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.073)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (284.005)
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 (337.427)
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 1040,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:588
5 (0.147)
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