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

Vergi 8 Metri

Filtreaza

Varga Fl Aqua Pole 8 Mt

Cod produs: 86513545
Livrare imediată!

172,55Lei

Varga Fl Super Game 8mt

Cod produs: 8645614
Livrare imediată!

299,88Lei

Varga Fl Happy 8m

Cod produs: 3313155090015
Livrare imediată!

316,54Lei

Varga Maver Grizzly 23 Trt 8m

Cod produs: 4613b800
Livrare imediată!

1.397,39Lei

Exclusiv online!

Varga Maver Freccia Sl 8m

Cod produs: 4612b800
Livrare 48-72 ore

1.650,70Lei

Exclusiv online!

Varga Sensas Carbon Rafale 8,00m

Cod produs: s.05538
Livrare 24-48 ore

530,20Lei

Exclusiv online!

Varga Colmic Gighen X5 8m

Cod produs: cagi51e
Livrare 48-72 ore

652,00Lei

Exclusiv online!

Varga Maver Cometa Tls 8m

Cod produs: 4743b800
Livrare 48-72 ore

699,15Lei

Varga Fl Strategist 8.00m

Cod produs: 2129194390747
Livrare imediată!

416,50Lei

Exclusiv online!

Varga Maver Ambra Sl 8m

Cod produs: 4780b800
Livrare 48-72 ore

1.760,66Lei

Exclusiv online!

Varga Jaxon Antris Basic Hti Tx 8.00 M

Cod produs: wj-axp800
Livrare 48-72 ore

432,01Lei

Exclusiv online!

Varga Energo Team Blade Pole 8.00m

Cod produs: 11011800
Livrare 24-48 ore

848,01Lei

Afişare 1 - 12 din 19 (2 pagini)

Vergile de 8 metri ca si vergile de 9 metri sunt utilizate de obicei pentru pestii de dimensiuni medii si mari ele find confectionate din diferite tipuri de carbon ce le fac rezistente dar usoare in acelasi timp.In aceasta categorie veti gasi vergi de la diferiti producatori precum:Colmic, Maver , Fl ,Daiwa Etc

Queries: 14, Total time: 47.401 ms [By time] [By id] [By file]
1 (0.396)
SELECT `data`
FROM `oc_session`
WHERE session_id = '5322fd7d5b40bad0dc88375cd8'
/home/ffbro/public_html/magazindepescuitro.ro/system/library/session/db.php:23
2 (1.899)
SELECT *
FROM oc_platforma_promovari
/home/ffbro/public_html/magazindepescuitro.ro/index.php:74
3 (18.046)
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 (2.727)
SELECT *
FROM `oc_language`
WHERE status = '1'
/home/ffbro/public_html/magazindepescuitro.ro/index.php:237
5 (0.148)
SELECT *
FROM oc_currency
/home/ffbro/public_html/magazindepescuitro.ro/system/library/currency.php:13
6 (1.474)
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.430)
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.405)
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.868)
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.208)
SELECT *
FROM oc_extension
WHERE `type` = 'openbay'
/home/ffbro/public_html/magazindepescuitro.ro/system/library/openbay.php:116
11 (0.200)
SELECT *
FROM oc_event
/home/ffbro/public_html/magazindepescuitro.ro/index.php:338
12 (6.332)
SELECT *
FROM oc_url_alias
WHERE keyword = 'vergi-pescuit-8-metrii'
/home/ffbro/public_html/magazindepescuitro.ro/catalog/controller/common/seo_url.php:71
13 (1.033)
SELECT *
FROM oc_setting
WHERE `code` = 'facebook'
/home/ffbro/public_html/magazindepescuitro.ro/system/library/model/extension/facebooksetting.php:30
14 (13.234)
SELECT p.product_id, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id 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()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, p.viewed, p.price
FROM oc_product_to_category p2c
LEFT JOIN oc_product p ON (p2c.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 pd.language_id = '2' AND p.status = '1' AND p.quantity > '0' AND p.price > '0' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '361' GROUP BY p.product_id
ORDER BY p.sort_order ASC LIMIT 0,40
/home/ffbro/public_html/magazindepescuitro.ro/catalog/model/catalog/product.php:385