Gama variata de produse

La Claumar Pescar poti alege simplu si rapid dintr-o gama variata de articole de pescuit.

Transport Gratuit

Comenzile peste 300 lei pot beneficia de transport gratuit.

Vezi mai multe detalii

Plata cu cardul

Plata cu cardul in rate fara dobanda.

Vezi mai multe detalii

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 simplu in 14 zile

Retur simplu in 14 zile.

Vezi mai multe detalii

Juvelnice Stationar

Filtreaza

Juvelnic Trabucco Pro Net Carp 50x40 3m
Exclusiv online!

Juvelnic Trabucco Pro Net Carp 50x40 3m

Cod produs: 082-53-300
Livrare 48-72 ore

171,00Lei

Juvelnic Concurs Nevis Rotund 2m

Juvelnic Concurs Nevis Rotund 2m

Cod produs: 4224-200
Livrare imediată!

125,00Lei

Juvelnic Competitie Energo Team Cu Tija 2.00 M
Exclusiv online!

Juvelnic Competitie Energo Team Cu Tija 2.00 M

Cod produs: 72091200
Livrare 24-48 ore

47,50Lei

Juvelnic Carp Zoom Practic 40x150cm

Juvelnic Carp Zoom Practic 40x150cm

Cod produs: cz0329
Livrare imediată!

81,00Lei

Juvelnic Ciorap
Exclusiv online!

Juvelnic Ciorap

Cod produs: 72020080
Livrare 24-48 ore

16,01Lei

Juvelnic Trabucco Rot Carp Pe Mesh 2.5mt

Juvelnic Trabucco Rot Carp Pe Mesh 2.5mt

Cod produs: 086-40-250
Livrare imediată!

111,00Lei

Juvelnic Colmic Iros Carp Patrat 2.5m
Exclusiv online!

Juvelnic Colmic Iros Carp Patrat 2.5m

Cod produs: nacr112a
Livrare 48-72 ore

281,99Lei

Juvelnic Jaxon Eco 3 8mm 35x65cm

Juvelnic Jaxon Eco 3 8mm 35x65cm

Cod produs: ps-jla0653
Livrare imediată!

25,00Lei

Juvelnic Carp Zoom Feeder Competition D 60x45 - 50cm 3m
Exclusiv online!

Juvelnic Carp Zoom Feeder Competition D 60x45 - 50cm 3m

Cod produs: cz1437
Livrare 48-72 ore

198,00Lei

Juvelnic Colmic Iros Carp Rotund 2.5m
Exclusiv online!

Juvelnic Colmic Iros Carp Rotund 2.5m

Cod produs: nacr110a
Livrare 48-72 ore

219,00Lei

Juvelnic Jaxon Promo 4 6mm 40x120cm
Exclusiv online!

Juvelnic Jaxon Promo 4 6mm 40x120cm

Cod produs: ps-al044
Livrare 48-72 ore

65,00Lei

Juvelnic Colmic Steel Carp Rotund 2.5m
Exclusiv online!

Juvelnic Colmic Steel Carp Rotund 2.5m

Cod produs: nacr100a
Livrare 48-72 ore

220,00Lei

Juvelnic Colmic Steel Carp Patrat 4.0m
Exclusiv online!

Juvelnic Colmic Steel Carp Patrat 4.0m

Cod produs: nacr105d
Livrare 48-72 ore

402,01Lei

Juvelnic Colmic Steel Carp Patrat 3.5m
Exclusiv online!

Juvelnic Colmic Steel Carp Patrat 3.5m

Cod produs: nacr105c
Livrare 48-72 ore

361,00Lei

Juvelnic Colmic Steel Carp Rotund 3.0m
Exclusiv online!

Juvelnic Colmic Steel Carp Rotund 3.0m

Cod produs: nacr100b
Livrare 48-72 ore

249,00Lei

Juvelnic Colmic Steel Carp Rotund 4.0m
Exclusiv online!

Juvelnic Colmic Steel Carp Rotund 4.0m

Cod produs: nacr100d
Livrare 48-72 ore

315,00Lei

Juvelnic Colmic Steel Carp Rotund 3.5m
Exclusiv online!

Juvelnic Colmic Steel Carp Rotund 3.5m

Cod produs: nacr100c
Livrare 48-72 ore

281,99Lei

Juvelnic Colmic Iros Carp Rotund 3.0m
Exclusiv online!

Juvelnic Colmic Iros Carp Rotund 3.0m

Cod produs: nacr110b
Livrare 48-72 ore

251,99Lei

Juvelnic Colmic Iros Carp Rotund 4.0m
Exclusiv online!

Juvelnic Colmic Iros Carp Rotund 4.0m

Cod produs: nacr110d
Livrare 48-72 ore

321,00Lei

Juvelnic Lineaeffe Plasa D=32cm/l=1,00m

Juvelnic Lineaeffe Plasa D=32cm/l=1,00m

Cod produs: A2.J6202300
Livrare imediată!

28,36Lei

Juvelnic Colmic Iros Carp Rotund 3.5m
Exclusiv online!

Juvelnic Colmic Iros Carp Rotund 3.5m

Cod produs: nacr110c
Livrare 48-72 ore

294,00Lei

Juvelnic Lineaeffe Plasa D=30cm/l=0,80m

Juvelnic Lineaeffe Plasa D=30cm/l=0,80m

Cod produs: A2.J6201430
Livrare imediată!

23,13Lei

Juvelnic Team Feeder By Dome Gabor Competitie Rotund 2.5m

Juvelnic Team Feeder By Dome Gabor Competitie Rotund 2.5m

Cod produs: 4252-250
Livrare imediată!

150,00Lei

Juvelnic Jaxon Medium 6mm 40x200cm

Juvelnic Jaxon Medium 6mm 40x200cm

Cod produs: ps-jlb2006
Livrare imediată!

66,00Lei

Juvelnic Jaxon Promo 7 6mm 40x240cm
Exclusiv online!

Juvelnic Jaxon Promo 7 6mm 40x240cm

Cod produs: ps-al047
Livrare 48-72 ore

88,00Lei

Juvelnic Jaxon Promo 5 6mm 40x160cm
Exclusiv online!

Juvelnic Jaxon Promo 5 6mm 40x160cm

Cod produs: ps-al045
Livrare 48-72 ore

72,00Lei

Juvelnic Jaxon Promo 3 6mm 40x100cm

Juvelnic Jaxon Promo 3 6mm 40x100cm

Cod produs: ps-al043
Livrare imediată!

57,00Lei

Juvelnic Browning Rubber Mesh Setzkescher 3.50m
Exclusiv online!

Juvelnic Browning Rubber Mesh Setzkescher 3.50m

Cod produs: 416157041350
Livrare 48-72 ore

371,67Lei

Juvelnic Jaxon Medium 6mm 40x160cm
Exclusiv online!

Juvelnic Jaxon Medium 6mm 40x160cm

Cod produs: ps-jlb1605
Livrare 48-72 ore

56,00Lei

Juvelnic Jaxon Eco 4 8mm 35x100cm
Exclusiv online!

Juvelnic Jaxon Eco 4 8mm 35x100cm

Cod produs: PS-JLA1004
Livrare 48-72 ore

35,00Lei

Juvelnic Lineaeffe Plasa D=35cm/l=1,20m
Exclusiv online!

Juvelnic Lineaeffe Plasa D=35cm/l=1,20m

Cod produs: A2.J6201435
Livrare 24-48 ore

34,70Lei

Juvelnic Jaxon Eco 6 8mm 35x200cm

Juvelnic Jaxon Eco 6 8mm 35x200cm

Cod produs: ps-jla2006
Livrare imediată!

56,00Lei

Juvelnic Competitie Energoteam Patrat 4.00m
Exclusiv online!

Juvelnic Competitie Energoteam Patrat 4.00m

Cod produs: 72107400
Livrare 24-48 ore

165,01Lei

Juvelnic Jaxon Eco 4 8mm 35x120cm
Exclusiv online!

Juvelnic Jaxon Eco 4 8mm 35x120cm

Cod produs: ps-jla1204
Livrare 48-72 ore

41,00Lei

Juvelnic Spro C-tec Pvc 50x45x300cm

Juvelnic Spro C-tec Pvc 50x45x300cm

Cod produs: 003901-00106-00000
Livrare imediată!

99,81Lei

Juvelnic Mivardi Match Pro Patrat Ii 400 Cm

Juvelnic Mivardi Match Pro Patrat Ii 400 Cm

Cod produs: m-knmps4
Livrare imediată!

225,01Lei

Juvelnic Concurs Nevis Rotund 1,5m

Juvelnic Concurs Nevis Rotund 1,5m

Cod produs: 4224-150
Livrare imediată!

115,00Lei

Juvelnic Jaxon Super Eco 5 6mm 40x160cm
Exclusiv online!

Juvelnic Jaxon Super Eco 5 6mm 40x160cm

Cod produs: ps-al055
Livrare 48-72 ore

79,00Lei

Juvelnic Jaxon Eco 5 8mm 35x150cm
Exclusiv online!

Juvelnic Jaxon Eco 5 8mm 35x150cm

Cod produs: ps-jla1505
Livrare 48-72 ore

46,01Lei

Juvelnic Jaxon Profi 6mm 50x300cm
Exclusiv online!

Juvelnic Jaxon Profi 6mm 50x300cm

Cod produs: ps-al107
Livrare 48-72 ore

165,01Lei

Afişare 1 - 40 din 176 (5 pagini)


Queries: 14, Total time: 15.630 ms [By time] [By id] [By file]
1 (0.295)
SELECT `data`
FROM `oc_session`
WHERE session_id = '792eb1c8b9b3c20351ccc1ff31'
/home/ffbro/public_html/magazindepescuitro.ro/system/library/session/db.php:23
2 (0.206)
SELECT *
FROM oc_platforma_promovari
/home/ffbro/public_html/magazindepescuitro.ro/index.php:74
3 (11.651)
SELECT *
FROM `oc_setting`
WHERE store_id = '0' OR store_id = '0'
ORDER BY store_id ASC
/home/ffbro/public_html/magazindepescuitro.ro/index.php:159
4 (0.276)
SELECT *
FROM `oc_language`
WHERE status = '1'
/home/ffbro/public_html/magazindepescuitro.ro/index.php:237
5 (0.159)
SELECT *
FROM oc_currency
/home/ffbro/public_html/magazindepescuitro.ro/system/library/currency.php:13
6 (0.501)
SELECT tr1.tax_class_id, tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM oc_tax_rule tr1
LEFT JOIN oc_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN oc_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN oc_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN oc_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.based = 'shipping' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '175' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '0')
ORDER BY tr1.priority ASC
/home/ffbro/public_html/magazindepescuitro.ro/system/library/tax.php:27
7 (0.400)
SELECT tr1.tax_class_id, tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM oc_tax_rule tr1
LEFT JOIN oc_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN oc_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN oc_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN oc_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.based = 'store' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '175' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '0')
ORDER BY tr1.priority ASC
/home/ffbro/public_html/magazindepescuitro.ro/system/library/tax.php:55
8 (0.185)
SELECT *
FROM oc_weight_class wc
LEFT JOIN oc_weight_class_description wcd ON (wc.weight_class_id = wcd.weight_class_id)
WHERE wcd.language_id = '2'
/home/ffbro/public_html/magazindepescuitro.ro/system/library/weight.php:9
9 (0.187)
SELECT *
FROM oc_length_class mc
LEFT JOIN oc_length_class_description mcd ON (mc.length_class_id = mcd.length_class_id)
WHERE mcd.language_id = '2'
/home/ffbro/public_html/magazindepescuitro.ro/system/library/length.php:9
10 (0.169)
SELECT *
FROM oc_extension
WHERE `type` = 'openbay'
/home/ffbro/public_html/magazindepescuitro.ro/system/library/openbay.php:116
11 (0.193)
SELECT *
FROM oc_event
/home/ffbro/public_html/magazindepescuitro.ro/index.php:338
12 (0.284)
SELECT *
FROM oc_url_alias
WHERE keyword = 'pescuit-la-stationar'
/home/ffbro/public_html/magazindepescuitro.ro/catalog/controller/common/seo_url.php:71
13 (0.154)
SELECT *
FROM oc_url_alias
WHERE keyword = 'juvelnice-stationar'
/home/ffbro/public_html/magazindepescuitro.ro/catalog/controller/common/seo_url.php:71
14 (0.969)
SELECT *
FROM oc_setting
WHERE `code` = 'facebook'
/home/ffbro/public_html/magazindepescuitro.ro/system/library/model/extension/facebooksetting.php:30