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


Vobler Jackall Pikupiku 7.8cm 4.9g Dead White -39%
Exclusiv online!

Vobler Jackall Pikupiku 7.8cm 4.9g Dead White

ja.807210095
Livrare 24-48 ore

121,06Lei(-39%) 73,54Lei

Vobler Jackall Pikupiku 7.8cm 4.9g Livery Shad -39%

Vobler Jackall Pikupiku 7.8cm 4.9g Livery Shad

ja.807210125
Livrare imediată!

121,06Lei(-39%) 73,54Lei

Vobler Jackall Pikupiku 7.8cm 4.9g Pinky Chart Crown -39%
Exclusiv online!

Vobler Jackall Pikupiku 7.8cm 4.9g Pinky Chart Crown

ja.807210088
Livrare 24-48 ore

121,06Lei(-39%) 73,54Lei

Vobler Jackall Pikupiku 7.8cm 4.9g Sight Clear Pink -39%
Exclusiv online!

Vobler Jackall Pikupiku 7.8cm 4.9g Sight Clear Pink

ja.807210132
Livrare 24-48 ore

121,06Lei(-39%) 73,54Lei

Vobler Jackall Prikkey, Daigo Ghost Red Glow, 3.0cm, 1.6g -29%
Exclusiv online!

Vobler Jackall Prikkey, Daigo Ghost Red Glow, 3.0cm, 1.6g

ja.807225884
Livrare 24-48 ore

77,21Lei(-29%) 54,95Lei

Vobler Jackall Prikkey, Rum Raisin, 3.0cm, 1.6g -29%
Exclusiv online!

Vobler Jackall Prikkey, Rum Raisin, 3.0cm, 1.6g

ja.807225877
Livrare 24-48 ore

77,21Lei(-29%) 54,95Lei

Vobler Jackall Prikkey, Shobo Kure Glow, 3.0cm, 1.6g -29%
Exclusiv online!

Vobler Jackall Prikkey, Shobo Kure Glow, 3.0cm, 1.6g

ja.807225839
Livrare 24-48 ore

77,21Lei(-29%) 54,95Lei

Vobler Jackall Prikkey, Tackey Sherbet, 3.0cm, 1.6g -29%
Exclusiv online!

Vobler Jackall Prikkey, Tackey Sherbet, 3.0cm, 1.6g

ja.807225907
Livrare 24-48 ore

77,21Lei(-29%) 54,95Lei

Vobler Jackall Prikkey, Tackey Tropical Glow, 3.0cm, 1.6g -29%
Exclusiv online!

Vobler Jackall Prikkey, Tackey Tropical Glow, 3.0cm, 1.6g

ja.807225914
Livrare 24-48 ore

87,85Lei(-29%) 62,39Lei

Vobler Jackall Prikkey, Tk Glow, 3.0cm, 1.6g -29%
Exclusiv online!

Vobler Jackall Prikkey, Tk Glow, 3.0cm, 1.6g

ja.807225853
Livrare 24-48 ore

77,21Lei(-29%) 54,95Lei

Vobler Jackall Soul Flat 58sf Sp, Double Clucth Gold & Black, 5.8cm, 6.8g -29%
Exclusiv online!

Vobler Jackall Soul Flat 58sf Sp, Double Clucth Gold & Black, 5.8cm, 6.8g

ja.807205480
Livrare 24-48 ore

107,98Lei(-29%) 76,49Lei

Vobler Jackall Soul Shad 58sp 5.8cm/5.25g Bml -29%
Exclusiv online!

Vobler Jackall Soul Shad 58sp 5.8cm/5.25g Bml

ja.807162769
Livrare 24-48 ore

107,98Lei(-29%) 76,49Lei

Vobler Jackall Soul Shad 58sp 5.8cm/5.25g Flash Clown -29%
Exclusiv online!

Vobler Jackall Soul Shad 58sp 5.8cm/5.25g Flash Clown

ja.807099959
Livrare 24-48 ore

107,98Lei(-29%) 76,49Lei

Vobler Jackall Soul Shad 58sp 5.8cm/5.25g Gold Black -29%
Exclusiv online!

Vobler Jackall Soul Shad 58sp 5.8cm/5.25g Gold Black

ja.807063202
Livrare 24-48 ore

107,98Lei(-29%) 76,49Lei

Vobler Jackall Soul Shad 58sp 5.8cm/5.25g Muddy Chart. Fish -29%
Exclusiv online!

Vobler Jackall Soul Shad 58sp 5.8cm/5.25g Muddy Chart. Fish

ja.807192568
Livrare 24-48 ore

107,98Lei(-29%) 76,49Lei

Vobler Jackall Tn50 Full Tungsten 5.2cm 9.5g Akatora -30%

Vobler Jackall Tn50 Full Tungsten 5.2cm 9.5g Akatora

ja.807126228
Livrare imediată!

102,90Lei(-30%) 72,03Lei

Vobler Jackall Tn50 Full Tungsten 5.2cm 9.5g Black King Gill -29%
Exclusiv online!

Vobler Jackall Tn50 Full Tungsten 5.2cm 9.5g Black King Gill

ja.807126266
Livrare 24-48 ore

102,90Lei(-29%) 72,94Lei

Vobler Jackall Tn50 Full Tungsten 5.2cm 9.5g Uhsr -29%

Vobler Jackall Tn50 Full Tungsten 5.2cm 9.5g Uhsr

ja.807112207
Livrare imediată!

102,90Lei(-29%) 72,64Lei

Vobler Jackall Tn50 Trigon Hs Impact Black 5.2cm 11.2g -29%
Exclusiv online!

Vobler Jackall Tn50 Trigon Hs Impact Black 5.2cm 11.2g

ja.807166231
Livrare 24-48 ore

104,92Lei(-29%) 74,34Lei

Vobler Jackall Tn50 Trigon Kawashima Sihouette Gold&black 5.2cm 11.2g -29%
Exclusiv online!

Vobler Jackall Tn50 Trigon Kawashima Sihouette Gold&black 5.2cm 11.2g

ja.807143072
Livrare 24-48 ore

104,92Lei(-29%) 74,34Lei

Afişare 2641 - 2660 din 9028 (452 pagini)
Queries: 5, Total time: 553.690 ms [By time] [By id] [By file]
1 (0.113)
SELECT data
FROM `oc_session`
WHERE session_id = '10f58fecfab767929b3a2992e9'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.076)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (266.544)
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 (286.812)
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 2640,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:588
5 (0.145)
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