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


Taparina Mustad Luminous Shrimp Nr.4 4buc/plic -29%

Taparina Mustad Luminous Shrimp Nr.4 4buc/plic

m.cl.rig4.4
Livrare imediată!

9,03Lei(-29%) 6,45Lei

Taparina Mustad Mini Hokkai Nr.4 6buc/plic -29%

Taparina Mustad Mini Hokkai Nr.4 6buc/plic

m.cl.rig19.4
Livrare imediată!

10,67Lei(-29%) 7,62Lei

Taparina Zebco Holografix Nr 10 Transparent -48%

Taparina Zebco Holografix Nr 10 Transparent

4111102
Livrare imediată!

13,28Lei(-48%) 6,90Lei

Taparina Zebco Holografix Nr 8 Transparent -10%

Taparina Zebco Holografix Nr 8 Transparent

4111101
Livrare imediată!

13,28Lei(-10%) 11,95Lei

Taparina Zebco Nr 6 Portocaliu Uv, Verde Luminos -10%

Taparina Zebco Nr 6 Portocaliu Uv, Verde Luminos

4110002
Livrare imediată!

13,28Lei(-10%) 11,95Lei

Target Gardner Fluorocarbon 5ib 2.3kg 25m -36%

Target Gardner Fluorocarbon 5ib 2.3kg 25m

tfc5
Livrare imediată!

27,94Lei(-36%) 17,90Lei

Teaser Black Cat Battle Teaser Silent Glow Dark 100gr -9%

Teaser Black Cat Battle Teaser Silent Glow Dark 100gr

6250121
Livrare imediată!

80,78Lei(-9%) 73,90Lei

Teaser Black Cat Battle Teaser Silent Glow Dark 130gr -39%

Teaser Black Cat Battle Teaser Silent Glow Dark 130gr

6250161
Livrare imediată!

89,79Lei(-39%) 54,89Lei

Teaser Black Cat Battle, Glow-in-the-dark, 120g, 1buc/pac -20%
Exclusiv online!

Teaser Black Cat Battle, Glow-in-the-dark, 120g, 1buc/pac

6077122
Livrare 7-14 zile

95,00Lei(-20%) 75,80Lei

Teaser Zeck Clonk Rattle Teaser 60g, Alb -23%

Teaser Zeck Clonk Rattle Teaser 60g, Alb

1309150034
Livrare imediată!

91,25Lei(-23%) 69,90Lei

Teaser Zeck Clonk Rattle Teaser 60g, Negru -23%

Teaser Zeck Clonk Rattle Teaser 60g, Negru

1309150038
Livrare imediată!

91,25Lei(-23%) 69,90Lei

Tenisi Navitas Lo Down Lace Up, Marime 41 -22%

Tenisi Navitas Lo Down Lace Up, Marime 41

ntxa4949-41
Livrare imediată!

178,90Lei(-22%) 139,90Lei

Tija Interschimbabila Matrix Medium Swivel Feeder Stems X2 -33%

Tija Interschimbabila Matrix Medium Swivel Feeder Stems X2

gfr246
Livrare imediată!

13,46Lei(-33%) 8,98Lei

Tija Interschimbabila Matrix Small Elasticated Stems X2 -33%

Tija Interschimbabila Matrix Small Elasticated Stems X2

gfr247
Livrare imediată!

13,46Lei(-33%) 8,98Lei

Tija Interschimbabila Matrix Small Swivel Feeder Stems X2 -33%

Tija Interschimbabila Matrix Small Swivel Feeder Stems X2

gfr245
Livrare imediată!

13,46Lei(-33%) 8,98Lei

Torpile Cat Spirit 23cm Culoare Pink 1buc -86%

Torpile Cat Spirit 23cm Culoare Pink 1buc

act390069-bucxx
Livrare imediată!

65,00Lei(-86%) 8,90Lei

Trabucco Aero Sp. Flatbed Method Flexi Mould Presa Flexibila -33%

Trabucco Aero Sp. Flatbed Method Flexi Mould Presa Flexibila

140-66-300
Livrare imediată!

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

Tricou Carp Spirit Carbune L -14%
Exclusiv online!

Tricou Carp Spirit Carbune L

acs680067
Livrare 48-72ore

69,00Lei(-14%) 59,00Lei

Tricou Carp Spirit Carbune M -14%
Exclusiv online!

Tricou Carp Spirit Carbune M

acs680066
Livrare 48-72ore

69,00Lei(-14%) 59,00Lei

Tricou Carp Spirit Verde L -25%
Exclusiv online!

Tricou Carp Spirit Verde L

acs680073
Livrare 48-72ore

89,00Lei(-25%) 66,79Lei

Afişare 8281 - 8300 din 9153 (458 pagini)
Queries: 8, Total time: 650.716 ms [By time] [By id] [By file]
1 (0.187)
SELECT data
FROM `oc_session`
WHERE session_id = 'd837bfd5962fff258db09750d5'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.080)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (297.031)
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 (352.882)
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 8280,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:588
5 (0.161)
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.125)
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
7 (0.117)
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
8 (0.133)
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