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


Geanta Berkley Urbn Utility Accessory Pouch 10x5x14cm -71%
Exclusiv online!

Geanta Berkley Urbn Utility Accessory Pouch 10x5x14cm

1530311
Livrare 48-72ore

81,99Lei(-71%) 23,76Lei

Geanta Black Cat Accessory Keeper Pro, 22x14x20cm -20%
Exclusiv online!

Geanta Black Cat Accessory Keeper Pro, 22x14x20cm

8515020
Livrare 7-14 zile

315,00Lei(-20%) 251,80Lei

Geanta Black Cat Battle Cat Carryall, Black, 68x41x35cm -20%
Exclusiv online!

Geanta Black Cat Battle Cat Carryall, Black, 68x41x35cm

8574001
Livrare 7-14 zile

600,00Lei(-20%) 479,80Lei

Geanta Daiwa Pliabila Impermeabila Eva 36x25x23cm -20%
Exclusiv online!

Geanta Daiwa Pliabila Impermeabila Eva 36x25x23cm

d.15809.125
Livrare 24-48 ore

166,96Lei(-20%) 133,57Lei

Geanta Daiwa Prorex Tackle 38x18x24cm -20%

Geanta Daiwa Prorex Tackle 38x18x24cm

d.15810.500
Livrare imediată!

307,67Lei(-20%) 246,14Lei

Geanta De Igiena Delphin Nice Space C2g -55%

Geanta De Igiena Delphin Nice Space C2g

101002364
Livrare imediată!

111,00Lei(-55%) 49,90Lei

Geanta Fox Rage Voyager Camo Large Caryall 44x34x28cm -10%

Geanta Fox Rage Voyager Camo Large Caryall 44x34x28cm

nlu090
Livrare imediată!

559,10Lei(-10%) 503,91Lei

Geanta Impermeabila Abu Garcia Beast Pro Eva Accesory Bag M, 22x18x12cm -49%

Geanta Impermeabila Abu Garcia Beast Pro Eva Accesory Bag M, 22x18x12cm

1532343
Livrare imediată!

138,00Lei(-49%) 69,90Lei

Geanta Inaintas Team Feeder By Dome -20%
Exclusiv online!

Geanta Inaintas Team Feeder By Dome

5301-015
Livrare 48-72 ore

87,00Lei(-20%) 69,60Lei

Geanta Jrc Defender Low Carryall 42x31x21cm -39%
Exclusiv online!

Geanta Jrc Defender Low Carryall 42x31x21cm

1548376
Livrare 7-14 zile

247,46Lei(-39%) 149,90Lei

Geanta Korum Progress Bait & Bits Bag, 55x24x40cm, 25ltr -30%
Exclusiv online!

Geanta Korum Progress Bait & Bits Bag, 55x24x40cm, 25ltr

k0290105
Livrare 7-14 zile

249,95Lei(-30%) 174,97Lei

Geanta Nash Hi-protect Tube, 32x15x10cm -43%

Geanta Nash Hi-protect Tube, 32x15x10cm

t3551
Livrare imediată!

119,99Lei(-43%) 68,90Lei

Geanta Pentru Naluci Fox Rage Voyager Camo Large Stacker 48cmx30cmx24cm -10%

Geanta Pentru Naluci Fox Rage Voyager Camo Large Stacker 48cmx30cmx24cm

nlu091
Livrare imediată!

559,10Lei(-10%) 503,91Lei

Geanta Plano Weekend Series 3700 Case + 2 Cutii 47.5x25x24cm -21%

Geanta Plano Weekend Series 3700 Case + 2 Cutii 47.5x25x24cm

plabw370
Livrare imediată!

269,96Lei(-21%) 212,90Lei

Geanta Plano Weekend Series Softsider 3600 -25%

Geanta Plano Weekend Series Softsider 3600

plabw260
Livrare imediată!

225,01Lei(-25%) 168,00Lei

Geanta Plano Weekend Series Softsider 3700 -21%

Geanta Plano Weekend Series Softsider 3700

plabw270
Livrare imediată!

225,01Lei(-21%) 176,91Lei

Geanta Preston Supera X Roller And Roost Xl, 122x32x23cm -25%
Exclusiv online!

Geanta Preston Supera X Roller And Roost Xl, 122x32x23cm

p0130130
Livrare 7-14 zile

427,46Lei(-25%) 319,90Lei

Geanta Ridge Monkey Ruggage Compact Accesssory Case 165 -28%

Geanta Ridge Monkey Ruggage Compact Accesssory Case 165

rm680
Livrare imediată!

118,75Lei(-28%) 85,89Lei

Geanta Termica Penn Cool Bag, 27x15x12cm -59%
Exclusiv online!

Geanta Termica Penn Cool Bag, 27x15x12cm

1545372
Livrare 7-14 zile

149,95Lei(-59%) 61,15Lei

Geanta Termoizolanta Abu Garcia Beast Pro Rucksack Cooler Pouch, 40x20x10cm -68%
Exclusiv online!

Geanta Termoizolanta Abu Garcia Beast Pro Rucksack Cooler Pouch, 40x20x10cm

1528426
Livrare 7-14 zile

158,87Lei(-68%) 50,90Lei

Afişare 941 - 960 din 8894 (445 pagini)
Queries: 6, Total time: 787.244 ms [By time] [By id] [By file]
1 (0.092)
SELECT data
FROM `oc_session`
WHERE session_id = '138038bef86e56ecf5a103cbe7'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.116)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (373.370)
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 (413.381)
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 940,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:588
5 (0.146)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"PRODUSE INACTIVE"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
6 (0.139)
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