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


Manusi Trakker Polar Fleece Gloves, Green -15%
Exclusiv online!

Manusi Trakker Polar Fleece Gloves, Green

207702
Livrare 7-14 zile

99,95Lei(-15%) 84,95Lei

Manusi Trakker Thermal Stretch Glove -15%
Exclusiv online!

Manusi Trakker Thermal Stretch Glove

207704
Livrare 7-14 zile

119,95Lei(-15%) 101,96Lei

Manusi Uv Fhm Mark Light Blue Xl -51%

Manusi Uv Fhm Mark Light Blue Xl

000024-0008-xl
Livrare imediată!

101,60Lei(-51%) 49,90Lei

Manusi Uv Fhm Mark Light Grey Xl -51%

Manusi Uv Fhm Mark Light Grey Xl

000024-0004-xl
Livrare imediată!

101,60Lei(-51%) 49,90Lei

Marker Luminos Prologic Illuminated Eva Margin, Orange, 1buc/pac -63%
Exclusiv online!

Marker Luminos Prologic Illuminated Eva Margin, Orange, 1buc/pac

svs47341
Livrare 7-14 zile

144,95Lei(-63%) 53,91Lei

Marker Ridge Monkey Marka Float, Large -10%

Marker Ridge Monkey Marka Float, Large

rmt373
Livrare imediată!

50,00Lei(-10%) 45,01Lei

Marker Ridge Monkey Marka Float, Small -10%

Marker Ridge Monkey Marka Float, Small

rmt374
Livrare imediată!

43,74Lei(-10%) 39,38Lei

Masa Monturi Extra Carp Roll-up Bivvy Table -28%

Masa Monturi Extra Carp Roll-up Bivvy Table

ec8321
Livrare imediată!

225,01Lei(-28%) 160,90Lei

Masa Plianta Black Cat Neagra, 40x80x32cm -18%

Masa Plianta Black Cat Neagra, 40x80x32cm

9384001
Livrare imediată!

284,70Lei(-18%) 233,80Lei

Matrita Dam Detek Feeder Mold L -55%
Exclusiv online!

Matrita Dam Detek Feeder Mold L

svs66027
Livrare 7-14 zile

26,45Lei(-55%) 11,86Lei

Matrita Dam Detek Feeder Mold M -54%

Matrita Dam Detek Feeder Mold M

svs66026
Livrare imediată!

20,96Lei(-54%) 9,73Lei

Matrita Korum Camo Method Mould Small -40%

Matrita Korum Camo Method Mould Small

k0320048
Livrare imediată!

12,38Lei(-40%) 7,43Lei

Matrita Momitor Vario Team Feeder By Dome Method Feeder, Marime L -20%

Matrita Momitor Vario Team Feeder By Dome Method Feeder, Marime L

7341-001
Livrare imediată!

19,00Lei(-20%) 15,20Lei

Method Feeder Daiwa Nzon Method 25g Mar. M -27%

Method Feeder Daiwa Nzon Method 25g Mar. M

a3.13345.125
Livrare imediată!

18,99Lei(-27%) 13,90Lei

Micro Grub Lucky John 2.5cm 026 15buc/plic -8%
Exclusiv online!

Micro Grub Lucky John 2.5cm 026 15buc/plic

140159-026
Livrare 48-72ore

12,00Lei(-8%) 11,00Lei

Micro Grub Lucky John 2.5cm 085 15buc/plic -8%
Exclusiv online!

Micro Grub Lucky John 2.5cm 085 15buc/plic

140159-085
Livrare 48-72ore

12,00Lei(-8%) 11,00Lei

Micro Grub Lucky John 2.5cm Pa03 15buc/plic -8%

Micro Grub Lucky John 2.5cm Pa03 15buc/plic

140159-pa03
Livrare imediată!

12,00Lei(-8%) 11,00Lei

Micro Grub Lucky John 2.5cm Pa19 15buc/plic -8%

Micro Grub Lucky John 2.5cm Pa19 15buc/plic

140159-pa19
Livrare imediată!

12,00Lei(-8%) 11,00Lei

Micro Grub Lucky John 2.5cm S88 15buc/plic -8%

Micro Grub Lucky John 2.5cm S88 15buc/plic

140159-s88
Livrare imediată!

12,00Lei(-8%) 11,00Lei

Micro Pop-up Cpk 8mm, Apa Rece -32%

Micro Pop-up Cpk 8mm, Apa Rece

1000109
Livrare imediată!

18,99Lei(-32%) 13,00Lei

Afişare 1581 - 1600 din 8899 (445 pagini)
Queries: 7, Total time: 657.467 ms [By time] [By id] [By file]
1 (0.077)
SELECT data
FROM `oc_session`
WHERE session_id = '1a4e562a2d6c4032e47e15ceb6'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.084)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (311.701)
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 (345.337)
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 1580,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:588
5 (0.103)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"TACKLE SHOP ARENA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
6 (0.073)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"TACKLE SHOP ARENA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
7 (0.092)
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