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


Fir Textil Spro Pc Vi'braid Grey 0.20mm 11kg 125m -22%

Fir Textil Spro Pc Vi'braid Grey 0.20mm 11kg 125m

005305-00120-00000
Livrare imediată!

39,00Lei(-22%) 30,40Lei

Fir Textil Stroft Gtp Chartreuse S06 4.5kg/100m 10buc -28%
Exclusiv online!

Fir Textil Stroft Gtp Chartreuse S06 4.5kg/100m 10buc

st.79113g
Livrare 24-48 ore

268,83Lei(-28%) 192,33Lei

Fir Textil Stroft Gtp Chartreuse S1 5.0kg/100m -28%
Exclusiv online!

Fir Textil Stroft Gtp Chartreuse S1 5.0kg/100m

st.79115g
Livrare 24-48 ore

262,85Lei(-28%) 188,09Lei

Fir Textil Stroft Gtp Gri E2 5.75kg/100m -28%
Exclusiv online!

Fir Textil Stroft Gtp Gri E2 5.75kg/100m

st.77118
Livrare 24-48 ore

105,71Lei(-28%) 76,23Lei

Fir Textil Sufix 832 Neon Lime, 120m, 0.13mm, 8.20kg/18lbs -18%

Fir Textil Sufix 832 Neon Lime, 120m, 0.13mm, 8.20kg/18lbs

ds1cf016bvws71
Livrare imediată!

149,00Lei(-18%) 122,92Lei

Fir Textil Sufix 832 Neon Lime, 120m, 0.15mm, 9.20kg/20lbs -18%

Fir Textil Sufix 832 Neon Lime, 120m, 0.15mm, 9.20kg/20lbs

ds1cf019bvws71
Livrare imediată!

149,00Lei(-18%) 122,00Lei

Fir Textil Sufix 832 Neon Lime, 120m, 0.18mm, 12.00kg/26lbs -18%
Exclusiv online!

Fir Textil Sufix 832 Neon Lime, 120m, 0.18mm, 12.00kg/26lbs

ds1cf025hvws71
Livrare 48-72 ore

149,00Lei(-18%) 122,92Lei

Fir Textil Sufix Matrix Pro 135m 0.20mm 40lb 18.0kg Mid.green -26%

Fir Textil Sufix Matrix Pro 135m 0.20mm 40lb 18.0kg Mid.green

ds1wt03041tb1p
Livrare imediată!

99,00Lei(-26%) 73,08Lei

Fir Textil Trabucco Dyna Tex X4 Power Uv Lime Yellow 150m 0.165mm 18lb -17%

Fir Textil Trabucco Dyna Tex X4 Power Uv Lime Yellow 150m 0.165mm 18lb

054-31-160
Livrare imediată!

59,00Lei(-17%) 48,69Lei

Fir Textil Trabucco Dyna-tex Power Silk Feeder 100m 0.13mm 12lb/5.40kg -23%

Fir Textil Trabucco Dyna-tex Power Silk Feeder 100m 0.13mm 12lb/5.40kg

054-39-013
Livrare imediată!

79,00Lei(-23%) 60,89Lei

Fir Textil Trabucco Dyna-tex Pro Slk X8 Lime Green 150m 0.08mm 4.99kg -27%

Fir Textil Trabucco Dyna-tex Pro Slk X8 Lime Green 150m 0.08mm 4.99kg

055-00-080
Livrare imediată!

125,01Lei(-27%) 91,39Lei

Fir Textil Trakko Dyneema Performance Spinning Verde Fluo 100m 0.10mm -24%

Fir Textil Trakko Dyneema Performance Spinning Verde Fluo 100m 0.10mm

mxt010
Livrare imediată!

69,20Lei(-24%) 52,91Lei

Fir Textil Tubertini Viral Sk X8 Grey, 10.80kg, 0.14mm, 150m -13%
Exclusiv online!

Fir Textil Tubertini Viral Sk X8 Grey, 10.80kg, 0.14mm, 150m

29983xx
Livrare 7-14 zile

106,00Lei(-13%) 92,61Lei

Fir Textil Tubertini Viral Sk X8 Grey, 11.70kg, 0.16mm, 150m -13%
Exclusiv online!

Fir Textil Tubertini Viral Sk X8 Grey, 11.70kg, 0.16mm, 150m

29984xx
Livrare 7-14 zile

106,00Lei(-13%) 92,61Lei

Fir Textil Tubertini Viral Sk X8 Grey, 13kg, 0.18mm, 150m -13%
Exclusiv online!

Fir Textil Tubertini Viral Sk X8 Grey, 13kg, 0.18mm, 150m

29985xx
Livrare 7-14 zile

106,00Lei(-13%) 92,61Lei

Fir Textil Tubertini Viral Sk X8 Grey, 16kg, 0.20mm, 150m -13%
Exclusiv online!

Fir Textil Tubertini Viral Sk X8 Grey, 16kg, 0.20mm, 150m

29986xx
Livrare 7-14 zile

106,00Lei(-13%) 92,61Lei

Fir Textil Tubertini Viral Sk X8 Grey, 6.40kg, 0.08mm, 150m -13%
Exclusiv online!

Fir Textil Tubertini Viral Sk X8 Grey, 6.40kg, 0.08mm, 150m

29980xx
Livrare 7-14 zile

106,00Lei(-13%) 92,61Lei

Fir Textil Tubertini Viral Sk X8 Grey, 7.70kg, 0.10mm, 150m -13%
Exclusiv online!

Fir Textil Tubertini Viral Sk X8 Grey, 7.70kg, 0.10mm, 150m

29981xx
Livrare 7-14 zile

106,00Lei(-13%) 92,61Lei

Fir Textil Tubertini Viral Sk X8 Grey, 9.50kg, 0.12mm, 150m -13%
Exclusiv online!

Fir Textil Tubertini Viral Sk X8 Grey, 9.50kg, 0.12mm, 150m

29982xx
Livrare 7-14 zile

106,00Lei(-13%) 92,61Lei

Fir Textil Varivas Avani Rock Beat Pe 150m 20.9lb -27%

Fir Textil Varivas Avani Rock Beat Pe 150m 20.9lb

v2115012
Livrare imediată!

125,01Lei(-27%) 90,90Lei

Afişare 5181 - 5200 din 9190 (460 pagini)
Queries: 5, Total time: 758.428 ms [By time] [By id] [By file]
1 (0.158)
SELECT data
FROM `oc_session`
WHERE session_id = '76911a3e4f18cc0cf0dd4ed8ba'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.079)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (318.533)
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 (439.496)
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 5180,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:588
5 (0.162)
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