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 90 zile

Retur simplu in 90 zile.

Vezi mai multe detalii

Oferte speciale


Boilies Carp Zoom Premium Natural Balanced 18mm 100gr Spice Essence -20%
Exclusiv online!

Boilies Carp Zoom Premium Natural Balanced 18mm 100gr Spice Essence

cz9261
Livrare 48-72 ore

21,50Lei(-20%) 17,29Lei

Boilies Carp Zoom Premium Natural Classic 18mm 120gr Spice Essence -19%
Exclusiv online!

Boilies Carp Zoom Premium Natural Classic 18mm 120gr Spice Essence

cz9292
Livrare 48-72 ore

20,00Lei(-19%) 16,17Lei

Bologneza Fl Miracle 5 M -23%
Exclusiv online!

Bologneza Fl Miracle 5 M

10318-500
Livrare 24-48 ore

200,00Lei(-23%) 154,44Lei

Borseta Berkley Urbn Utility Waist Bag -31%

Borseta Berkley Urbn Utility Waist Bag

1530308
Livrare imediată!

131,41Lei(-31%) 90,37Lei

Borseta Black Cat Battle Cat Lure Wallet, 38x25x10cm -18%
Exclusiv online!

Borseta Black Cat Battle Cat Lure Wallet, 38x25x10cm

8575001
Livrare 7-14 zile

300,00Lei(-18%) 244,83Lei

Borseta Colmic Mulineta Eva 20/30 -28%
Exclusiv online!

Borseta Colmic Mulineta Eva 20/30

bo704
Livrare 48-72 ore

45,00Lei(-28%) 32,52Lei

Borseta Daiwa Emeraldas Hip Bag E Green 13x30x23cm -2%
Exclusiv online!

Borseta Daiwa Emeraldas Hip Bag E Green 13x30x23cm

a8.emehipbagegr
Livrare 24-48 ore

414,45Lei(-2%) 404,72Lei

Borseta Fox Aquos Camo Bait 8l -48%
Exclusiv online!

Borseta Fox Aquos Camo Bait 8l

cev018
Livrare 7-14 zile

187,80Lei(-48%) 98,51Lei

Borseta Preston Eva Hooklength Case Large -18%

Borseta Preston Eva Hooklength Case Large

p0130108
Livrare imediată!

121,46Lei(-18%) 99,53Lei

Borseta Preston Eva Hooklength Case Short -17%

Borseta Preston Eva Hooklength Case Short

p0130107
Livrare imediată!

94,46Lei(-17%) 78,18Lei

Borseta Solar Undercover Accessory Pouches Small -27%

Borseta Solar Undercover Accessory Pouches Small

ca23
Livrare imediată!

66,60Lei(-27%) 48,79Lei

Brat Suport Tubertini Accessory Tele Support Arm Long -13%
Exclusiv online!

Brat Suport Tubertini Accessory Tele Support Arm Long

85066xx
Livrare 7-14 zile

260,00Lei(-13%) 225,71Lei

Brat Suport Tubertini Accessory Tele Support Arm Short -13%
Exclusiv online!

Brat Suport Tubertini Accessory Tele Support Arm Short

85065xx
Livrare 7-14 zile

234,99Lei(-13%) 204,11Lei

Broasca Live Target Hollow Body Frog Walking Bait, Albino / White, 6.5cm, 21g -37%
Exclusiv online!

Broasca Live Target Hollow Body Frog Walking Bait, Albino / White, 6.5cm, 21g

lt.fgh65t516
Livrare 24-48 ore

41,94Lei(-37%) 26,58Lei

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

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

lt.fgh55t503
Livrare 24-48 ore

40,23Lei(-37%) 25,54Lei

Broasca Live Target Hollow Body Frog Walking Bait, Emerald / Brown, 6.5cm, 21g -37%
Exclusiv online!

Broasca Live Target Hollow Body Frog Walking Bait, Emerald / Brown, 6.5cm, 21g

lt.fgh65t514
Livrare 24-48 ore

41,94Lei(-37%) 26,58Lei

Broasca Live Target Hollow Body Frog Walking Bait, Tan / Brown, 4.5cm, 7g -36%
Exclusiv online!

Broasca Live Target Hollow Body Frog Walking Bait, Tan / Brown, 4.5cm, 7g

lt.fgh45t502
Livrare 24-48 ore

38,51Lei(-36%) 24,50Lei

Broasca Live Target Freestyle Frog, Albino / White, 7.5cm, 2buc/pac -47%

Broasca Live Target Freestyle Frog, Albino / White, 7.5cm, 2buc/pac

f1.lt.fsf75t516
Livrare imediată!

42,88Lei(-47%) 22,80Lei

Broasca Live Target Freestyle Frog, Albino / White, 9cm, 2buc/pac -26%
Exclusiv online!

Broasca Live Target Freestyle Frog, Albino / White, 9cm, 2buc/pac

f1.lt.fsf90t516
Livrare 24-48 ore

42,88Lei(-26%) 31,52Lei

Broasca Live Target Freestyle Frog, Black / Black, 7.5cm, 2buc/pac -47%

Broasca Live Target Freestyle Frog, Black / Black, 7.5cm, 2buc/pac

f1.lt.fsf75t517
Livrare imediată!

42,88Lei(-47%) 22,80Lei

Afişare 341 - 360 din 9311 (466 pagini)
Queries: 5, Total time: 695.116 ms [By time] [By id] [By file]
1 (0.087)
SELECT data
FROM `oc_session`
WHERE session_id = '050d36a261e59d6c2b7cca988a'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.094)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (328.956)
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 (365.868)
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 340,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:588
5 (0.111)
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