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


Shad Savage Lb Cannibal Curltail 10cm/5g/perch 4buc/plic -26%
Exclusiv online!

Shad Savage Lb Cannibal Curltail 10cm/5g/perch 4buc/plic

f1.sg.63807
Livrare 24-48 ore

24,98Lei(-26%) 18,39Lei

Shad Savage Lb Roach Paddle Tail 12.5cm/22.0g Firetiger 3buc/plic -37%
Exclusiv online!

Shad Savage Lb Roach Paddle Tail 12.5cm/22.0g Firetiger 3buc/plic

f1.sg.61886
Livrare 24-48 ore

30,35Lei(-37%) 19,10Lei

Shad Spro Freestyle Urban Prey Slug Goby 7.3cm 4buc Plic -40%

Shad Spro Freestyle Urban Prey Slug Goby 7.3cm 4buc Plic

004695-00537-00000
Livrare imediată!

19,80Lei(-40%) 11,90Lei

Shad Spro Scent Series Insta 9cm Caramel Disco 5buc -24%

Shad Spro Scent Series Insta 9cm Caramel Disco 5buc

004689-00509-00000
Livrare imediată!

25,00Lei(-24%) 18,90Lei

Shad Spro Scent Series Insta 9cm Hot Chili 5buc -24%

Shad Spro Scent Series Insta 9cm Hot Chili 5buc

004689-00501-00000
Livrare imediată!

25,00Lei(-24%) 18,90Lei

Shad Spro Scent Series Insta 9cm Pumpkin Fire 5buc -24%

Shad Spro Scent Series Insta 9cm Pumpkin Fire 5buc

004689-00505-00000
Livrare imediată!

25,00Lei(-24%) 18,90Lei

Shad Spro Scent Series Insta 9cm Lemon Lime 5buc -24%

Shad Spro Scent Series Insta 9cm Lemon Lime 5buc

004689-00503-00000
Livrare imediată!

25,00Lei(-24%) 18,90Lei

Shad Storm Boom Shad Electric Smelt 10cm 8g 4buc/plic -28%

Shad Storm Boom Shad Electric Smelt 10cm 8g 4buc/plic

bmsh04 esml
Livrare imediată!

25,00Lei(-28%) 17,90Lei

Shad Storm Boom Shad Frozen Strawberry 7.6cm 3g 5buc/plic -28%

Shad Storm Boom Shad Frozen Strawberry 7.6cm 3g 5buc/plic

bmsh03 frzs
Livrare imediată!

25,00Lei(-28%) 17,90Lei

Shad Storm Hit Culoare Aland Ayu 8cm 6g 5buc/plic -28%

Shad Storm Hit Culoare Aland Ayu 8cm 6g 5buc/plic

hits03 aa
Livrare imediată!

25,00Lei(-28%) 17,90Lei

Shad Storm Hit Culoare Motor Oil 8cm 6g 5buc/plic -28%

Shad Storm Hit Culoare Motor Oil 8cm 6g 5buc/plic

hits03 mo
Livrare imediată!

25,00Lei(-28%) 17,90Lei

Shad Storm Jointed Minnow 7cm 2g Frozen Strawberry 5buc/plic -28%

Shad Storm Jointed Minnow 7cm 2g Frozen Strawberry 5buc/plic

jmn03 frzs
Livrare imediată!

25,00Lei(-28%) 17,90Lei

Shad Storm Jointed Minnow 7cm 2g Gold Digger 5buc/plic -28%

Shad Storm Jointed Minnow 7cm 2g Gold Digger 5buc/plic

jmn03 gd
Livrare imediată!

25,00Lei(-28%) 17,90Lei

Shad Storm Jointed Minnow 7cm 2g Purple Flow 5buc/plic -28%

Shad Storm Jointed Minnow 7cm 2g Purple Flow 5buc/plic

jmn03 prplf
Livrare imediată!

25,00Lei(-28%) 17,90Lei

Shad Storm Sudak Minnow Esml 8cm 3g 5buc/plic -28%

Shad Storm Sudak Minnow Esml 8cm 3g 5buc/plic

sdmn03 esml
Livrare imediată!

25,00Lei(-28%) 17,90Lei

Shad Storm Sudak Minnow Mrshp 8cm 3g 5buc/plic -28%

Shad Storm Sudak Minnow Mrshp 8cm 3g 5buc/plic

sdmn03 mrshp
Livrare imediată!

25,00Lei(-28%) 17,90Lei

Shad Storm Sudak Minnow Rdtc 8cm 3g 5buc/plic -28%

Shad Storm Sudak Minnow Rdtc 8cm 3g 5buc/plic

sdmn03 rdtc
Livrare imediată!

25,00Lei(-28%) 17,90Lei

Shad Storm Tock Minnow Culoare Baltic Herring 8cm 6g 5buc/plic -29%
Exclusiv online!

Shad Storm Tock Minnow Culoare Baltic Herring 8cm 6g 5buc/plic

tom03 blth
Livrare 48-72ore

25,00Lei(-29%) 17,85Lei

Shad Storm Tock Minnow Culoare Oder Perch 8cm 6g 5buc/plic -28%

Shad Storm Tock Minnow Culoare Oder Perch 8cm 6g 5buc/plic

tom03 ope
Livrare imediată!

25,00Lei(-28%) 17,90Lei

Shad Strike Pro Piglet 10cm 7gr Ice Shad -20%

Shad Strike Pro Piglet 10cm 7gr Ice Shad

sp.sp172e.c014
Livrare imediată!

53,17Lei(-20%) 42,54Lei

Afişare 7981 - 8000 din 9136 (457 pagini)
Queries: 6, Total time: 579.678 ms [By time] [By id] [By file]
1 (0.131)
SELECT data
FROM `oc_session`
WHERE session_id = '89d68ff7bbb6ba64a649d19dcf'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.111)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (278.753)
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 = '3' 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 (300.389)
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 = '3' 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 7980,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:588
5 (0.140)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"RAPALA VMC ROMANIA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
6 (0.154)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '3' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:37