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


Lanseta Dam Madcat White Deluxe G2 2.75m, 150-350g, 2seg -28%

Lanseta Dam Madcat White Deluxe G2 2.75m, 150-350g, 2seg

2033151833
Livrare imediată!

702,19Lei(-28%) 507,93Lei

Lanseta Dam Madcat White Deluxe G2 3.20m, 350g, 2seg -28%

Lanseta Dam Madcat White Deluxe G2 3.20m, 350g, 2seg

2033151834
Livrare imediată!

745,02Lei(-28%) 538,86Lei

Lanseta Dam Madcat White Spin 2.10m 175gr -25%

Lanseta Dam Madcat White Spin 2.10m 175gr

2033156873
Livrare imediată!

494,93Lei(-25%) 368,98Lei

Lanseta Dam Madcat White Spin 2.85m 175gr -25%

Lanseta Dam Madcat White Spin 2.85m 175gr

2033156876
Livrare imediată!

657,61Lei(-25%) 489,98Lei

Lanseta Dam Salt-x Sw Spin 2.20m 7-30gr -27%

Lanseta Dam Salt-x Sw Spin 2.20m 7-30gr

2040965742
Livrare imediată!

275,73Lei(-27%) 200,06Lei

Lanseta Dam Sensomax Il Carp Picker 3.00m, 15-55g, 2+3seg -30%
Exclusiv online!

Lanseta Dam Sensomax Il Carp Picker 3.00m, 15-55g, 2+3seg

dam.66316
Livrare 24-48 ore

281,22Lei(-30%) 197,86Lei

Lanseta Dam Yagi Cast Spinning Rod, 7-28g, 1.98m, 2seg -53%

Lanseta Dam Yagi Cast Spinning Rod, 7-28g, 1.98m, 2seg

svs60046
Livrare imediată!

264,91Lei(-53%) 124,55Lei

Lanseta Dam Yagi Spin F, 2.10m, 7-28g, 2seg -18%
Exclusiv online!

Lanseta Dam Yagi Spin F, 2.10m, 7-28g, 2seg

dam.60035
Livrare 24-48 ore

234,36Lei(-18%) 191,64Lei

Lanseta Dam Yagi Spin F, 2.59m, 12-42g, 2seg -18%
Exclusiv online!

Lanseta Dam Yagi Spin F, 2.59m, 12-42g, 2seg

dam.60038
Livrare 24-48 ore

271,85Lei(-18%) 222,13Lei

Lanseta Dam Yagi Spin Ul Jig Mf, 2.25m, 3-15g, 2seg -18%
Exclusiv online!

Lanseta Dam Yagi Spin Ul Jig Mf, 2.25m, 3-15g, 2seg

dam.60306
Livrare 24-48 ore

210,93Lei(-18%) 172,58Lei

Lanseta Feeder Daiwa N Zon S Feeder 3.60m 150g -19%

Lanseta Feeder Daiwa N Zon S Feeder 3.60m 150g

d.11136.366
Livrare imediată!

676,70Lei(-19%) 551,46Lei

Lanseta Feeder Matrix Ethos Xrd 13.1ft 4.0m Feeder 130g 3.4mm 2seg -23%

Lanseta Feeder Matrix Ethos Xrd 13.1ft 4.0m Feeder 130g 3.4mm 2seg

grd210
Livrare imediată!

1.124,96Lei(-23%) 865,17Lei

Lanseta Feeder Matrix Ethos Xrf 11.10ft/3.6m, 55g, 2+2seg -12%

Lanseta Feeder Matrix Ethos Xrf 11.10ft/3.6m, 55g, 2+2seg

grd201-matrix
Livrare imediată!

900,00Lei(-12%) 787,92Lei

Lanseta Feeder Matrix Ethos Xrf 11ft 3.30m Feeder 45g 2.8mm 2+2seg -39%
Exclusiv online!

Lanseta Feeder Matrix Ethos Xrf 11ft 3.30m Feeder 45g 2.8mm 2+2seg

grd200
Livrare 7-14 zile

854,96Lei(-39%) 523,54Lei

Lanseta Feeder Matrix Ethos Xrf 12.6ft 3.8m Feeder 65g 2.8mm 2+2seg -12%

Lanseta Feeder Matrix Ethos Xrf 12.6ft 3.8m Feeder 65g 2.8mm 2+2seg

grd202
Livrare imediată!

967,50Lei(-12%) 846,88Lei

Lanseta Feeder Mitchell Tanager Feeder 3.60m 3 Segmente 60-100g -20%

Lanseta Feeder Mitchell Tanager Feeder 3.60m 3 Segmente 60-100g

1553741
Livrare imediată!

319,96Lei(-20%) 255,10Lei

Lanseta Feeder Shakespeare Skp Concept Feeder 3.60m 2+3buc -20%

Lanseta Feeder Shakespeare Skp Concept Feeder 3.60m 2+3buc

1550398
Livrare imediată!

427,46Lei(-20%) 343,56Lei

Lanseta Fl Strong River Tele Carp 3.30 M 3.50lb -33%

Lanseta Fl Strong River Tele Carp 3.30 M 3.50lb

2153198183982
Livrare imediată!

200,00Lei(-33%) 133,08Lei

Lanseta Fox Explorer Rods 8-10ft Full Shrink, 2.40-3.00m, 3.25lb -12%

Lanseta Fox Explorer Rods 8-10ft Full Shrink, 2.40-3.00m, 3.25lb

crd313
Livrare imediată!

742,46Lei(-12%) 650,75Lei

Lanseta Fox Horizon X4 Barbel Mult Tip Specialist, 2.25lbs, 12ft, 3+2sec -18%

Lanseta Fox Horizon X4 Barbel Mult Tip Specialist, 2.25lbs, 12ft, 3+2sec

ard062
Livrare imediată!

974,95Lei(-18%) 794,98Lei

Afişare 1241 - 1260 din 9291 (465 pagini)
Queries: 5, Total time: 653.566 ms [By time] [By id] [By file]
1 (0.146)
SELECT data
FROM `oc_session`
WHERE session_id = 'b15f816dac4d829c854e7c4016'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.122)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (301.081)
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 (352.105)
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 1240,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:588
5 (0.112)
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