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 300 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


Broasca, Live, Target, Hollow, Body, Frog, Walking, Bait,, Green, /, Yellow,, 5.5cm,, 18g, Lt.fgh55t500, Broaste Artificiale, Broaste Artificiale Live Target, Live Target -20%
Exclusiv online!

Broasca, Live, Target, Hollow, Body, Frog, Walking, Bait,, Green, /, Yellow,, 5.5cm,, 18g, Lt.fgh55t500, Broaste Artificiale, Broaste Artificiale Live Target, Live Target

lt.fgh55t500
Livrare 24-48 ore

40,23Lei(-20%) 32,18Lei

Broasca, Live, Target, Hollow, Body, Frog, Walking, Bait,, Green, /, Yellow,, 6.5cm,, 21g, Lt.fgh65t500, Broaste Artificiale, Broaste Artificiale Live Target, Live Target -20%
Exclusiv online!

Broasca, Live, Target, Hollow, Body, Frog, Walking, Bait,, Green, /, Yellow,, 6.5cm,, 21g, Lt.fgh65t500, Broaste Artificiale, Broaste Artificiale Live Target, Live Target

lt.fgh65t500
Livrare 24-48 ore

41,94Lei(-20%) 33,55Lei

Broasca Live Target Hollow Body Frog Walking Bait, Tan / Brown, 5.5cm, 18g -20%
Exclusiv online!

Broasca Live Target Hollow Body Frog Walking Bait, Tan / Brown, 5.5cm, 18g

lt.fgh55t502
Livrare 24-48 ore

40,23Lei(-20%) 32,18Lei

Broasca, Live, Target, Hollow, Body, Frog, Walking, Bait,, Tan, /, Brown,, 6.5cm,, 21g, Lt.fgh65t502, Broaste Artificiale, Broaste Artificiale Live Target, Live Target -20%
Exclusiv online!

Broasca, Live, Target, Hollow, Body, Frog, Walking, Bait,, Tan, /, Brown,, 6.5cm,, 21g, Lt.fgh65t502, Broaste Artificiale, Broaste Artificiale Live Target, Live Target

lt.fgh65t502
Livrare 24-48 ore

41,94Lei(-20%) 33,55Lei

Broasca Live Target Hollow Body Frog Walking Bait, Yellow / Black, 4.5cm, 7g -20%
Exclusiv online!

Broasca Live Target Hollow Body Frog Walking Bait, Yellow / Black, 4.5cm, 7g

lt.fgh45t501
Livrare 24-48 ore

38,51Lei(-20%) 30,81Lei

Broasca, Live, Target, Hollow, Body, Frog, Walking, Bait,, Yellow, /, Black,, 5.5cm,, 18g, Lt.fgh55t501, Broaste Artificiale, Broaste Artificiale Live Target, Live Target -20%
Exclusiv online!

Broasca, Live, Target, Hollow, Body, Frog, Walking, Bait,, Yellow, /, Black,, 5.5cm,, 18g, Lt.fgh55t501, Broaste Artificiale, Broaste Artificiale Live Target, Live Target

lt.fgh55t501
Livrare 24-48 ore

40,23Lei(-20%) 32,18Lei

Broasca, Live, Target, Hollow, Body, Frog, Walking, Bait,, Yellow, /, Black,, 6.5cm,, 21g, Lt.fgh65t501, Broaste Artificiale, Broaste Artificiale Live Target, Live Target -20%

Broasca, Live, Target, Hollow, Body, Frog, Walking, Bait,, Yellow, /, Black,, 6.5cm,, 21g, Lt.fgh65t501, Broaste Artificiale, Broaste Artificiale Live Target, Live Target

lt.fgh65t501
Livrare imediată!

41,94Lei(-20%) 33,55Lei

Buff Daiwa Aquamarine -20%
Exclusiv online!

Buff Daiwa Aquamarine

d.18206.103
Livrare 24-48 ore

37,08Lei(-20%) 29,67Lei

Buff Daiwa Asphalt -20%
Exclusiv online!

Buff Daiwa Asphalt

d.18206.104
Livrare 24-48 ore

37,08Lei(-20%) 29,67Lei

Buff Daiwa Green Camo -20%
Exclusiv online!

Buff Daiwa Green Camo

d.18206.102
Livrare 24-48 ore

37,08Lei(-20%) 29,67Lei

Buff Daiwa Grey Camo -20%
Exclusiv online!

Buff Daiwa Grey Camo

d.18206.101
Livrare 24-48 ore

37,08Lei(-20%) 29,67Lei

Buzz Bar Fl Aluminiu Negru Conector Rapid 2 Posturi -23%

Buzz Bar Fl Aluminiu Negru Conector Rapid 2 Posturi

64-2135
Livrare imediată!

94,90Lei(-23%) 72,90Lei

Buzz Bar Fl Aluminiu Negru Conector Rapid 3 Posturi -20%

Buzz Bar Fl Aluminiu Negru Conector Rapid 3 Posturi

64-2136
Livrare imediată!

113,00Lei(-20%) 89,90Lei

Buzz Bar Shakespeare Skp Feeder 2 Posturi 22cm 2buc/set -33%

Buzz Bar Shakespeare Skp Feeder 2 Posturi 22cm 2buc/set

1550487
Livrare imediată!

133,45Lei(-33%) 88,99Lei

Buzz Bar Solar P1 3 Rod Adjustable Wide -10%

Buzz Bar Solar P1 3 Rod Adjustable Wide

p1bb3x
Livrare imediată!

411,05Lei(-10%) 369,95Lei

Căciulă Blană Delphin Atak Boyar -19%

Căciulă Blană Delphin Atak Boyar

101002216
Livrare imediată!

81,00Lei(-19%) 65,50Lei

Căciulă De Iarnă Delphin Strip -36%

Căciulă De Iarnă Delphin Strip

101002915
Livrare imediată!

39,00Lei(-36%) 25,00Lei

Căciulă De Iarnă Delphin Winter -32%

Căciulă De Iarnă Delphin Winter

101002916
Livrare imediată!

41,00Lei(-32%) 28,00Lei

Căciulă De Iarnă Din Polar Delphin Flix -27%

Căciulă De Iarnă Din Polar Delphin Flix

101002917
Livrare imediată!

26,00Lei(-27%) 19,00Lei

Caciula De Iarna Ridgemonkey Apearel Dropback Bobble Beanie Hat Camo, Marime Universala -10%

Caciula De Iarna Ridgemonkey Apearel Dropback Bobble Beanie Hat Camo, Marime Universala

rm558
Livrare imediată!

81,63Lei(-10%) 73,46Lei

Afişare 281 - 300 din 9711 (486 pagini)
Queries: 9, Total time: 238.831 ms [By time] [By id] [By file]
1 (0.078)
SELECT data
FROM `oc_session`
WHERE session_id = '67273f37b297f13eab84be52ad'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.080)
SELECT *
FROM oc_platforma_promovari LIMIT 1
/var/www/clients/client1/web1/web/index.php:128
3 (0.080)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:422
4 (103.618)
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:1676
5 (134.548)
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 280,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:586
6 (0.174)
SELECT layout_id
FROM oc_layout_route
WHERE 'product/special' LIKE route AND store_id = '3'
ORDER BY route DESC LIMIT 1
/var/www/clients/client1/web1/web/catalog/model/design/layout.php:8
7 (0.087)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
8 (0.078)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
9 (0.088)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '3' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38