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

Căutare

Produse ce potrivesc criteriilor de căutare


Varga Garbolino Bullet Speed Whip 329 4.00m, 8seg

Varga Garbolino Bullet Speed Whip 329 4.00m, 8seg

10130gomrg8125400-7
Livrare imediată!

260,44Lei

Varga Garbolino Strike Classic Whip, 5.00m
Exclusiv online!

Varga Garbolino Strike Classic Whip, 5.00m

10130gomrh8156500-5
Livrare 48-72 ore

156,49Lei

Husa Lansete Garbolino 0.95m XXl 6 Compartimente Rigid Ready Rod Competition (12lans+12mul)
Exclusiv online!

Husa Lansete Garbolino 0.95m XXl 6 Compartimente Rigid Ready Rod Competition (12lans+12mul)

90530gomlg38081950-6c
Livrare 48-72 ore

999,98Lei

Husa Rigida Lansete Garbolino Competition Ready Rod XL, 1.95m, 4 compartimente
Exclusiv online!

Husa Rigida Lansete Garbolino Competition Ready Rod XL, 1.95m, 4 compartimente

90530gomlg38081950-4c
Livrare 48-72 ore

749,99Lei

Varf Feeder Garbolino Fibra Plina Carbon Challenger 8oz, 52cm, 2.9mm
Exclusiv online!

Varf Feeder Garbolino Fibra Plina Carbon Challenger 8oz, 52cm, 2.9mm

21130gofre8299-c-8
Livrare 48-72 ore

57,48Lei

Varga Garbolino Bullet Speed Whip 3.00m, 6seg
Exclusiv online!

Varga Garbolino Bullet Speed Whip 3.00m, 6seg

10130gomrg8125300-6
Livrare 48-72 ore

226,96Lei

Varga Garbolino Strike Classic Whip, 6.00m
Exclusiv online!

Varga Garbolino Strike Classic Whip, 6.00m

10130gomrh8156600-6
Livrare 48-72 ore

204,00Lei

Vartej Rolling Simplu + Agrafa Rapida Garbolino Diamant nr.12, 10buc
Exclusiv online!

Vartej Rolling Simplu + Agrafa Rapida Garbolino Diamant nr.12, 10buc

41405gotah0197-000
Livrare 48-72 ore

15,26Lei

Cosulet Feeder Garbolino D50 Nadire Grea, 50x70mm, 50g

Cosulet Feeder Garbolino D50 Nadire Grea, 50x70mm, 50g

40930gofam0306d50-50
Livrare imediată!

17,39Lei

Feeder Arm Garbolino Multigrip Open Suport Fix Articulatie Dubla
Exclusiv online!

Feeder Arm Garbolino Multigrip Open Suport Fix Articulatie Dubla

90830gomeh3921
Livrare 48-72 ore

265,47Lei

Geanta pentru Tavi Garbolino XXL 80cm
Exclusiv online!

Geanta pentru Tavi Garbolino XXL 80cm

90430gomlj3838
Livrare 48-72 ore

588,43Lei

Juvelnic Garbolino Competitie Demi-Lune Latex-Lake 3.00m
Exclusiv online!

Juvelnic Garbolino Competitie Demi-Lune Latex-Lake 3.00m

50505gomnk6258300
Livrare 48-72 ore

390,71Lei

Lanseta Garbolino Lexica Bolo 5.70m, 20g
Exclusiv online!

Lanseta Garbolino Lexica Bolo 5.70m, 20g

20730gofrl8205570-6
Livrare 48-72 ore

472,97Lei

Varf Feeder Garbolino Fibra Plina Carbon Challenger 7oz, 52cm, 2.9mm
Exclusiv online!

Varf Feeder Garbolino Fibra Plina Carbon Challenger 7oz, 52cm, 2.9mm

21130gofre8299-c-7
Livrare 48-72 ore

57,48Lei

Varf Garbolino Oversized Fibra Carbon Plina, 4.00oz, 2.8mm, 0.53m
Exclusiv online!

Varf Garbolino Oversized Fibra Carbon Plina, 4.00oz, 2.8mm, 0.53m

20530gofrj8120-c-4
Livrare 48-72 ore

56,83Lei

Husa Juvelnic Rectangular Garbolino Trooper 55x50x80cm
Exclusiv online!

Husa Juvelnic Rectangular Garbolino Trooper 55x50x80cm

90405gomlh3010
Livrare 48-72 ore

77,23Lei

Varf Feeder Garbolino Fibra Plina Carbon Challenger 1oz, 46cm, 2.2mm
Exclusiv online!

Varf Feeder Garbolino Fibra Plina Carbon Challenger 1oz, 46cm, 2.2mm

21130gofre8298-c-1
Livrare 48-72 ore

56,97Lei

Cosulet Feeder Garbolino D50 Nadire Grea, 50x70mm, 0g
Exclusiv online!

Cosulet Feeder Garbolino D50 Nadire Grea, 50x70mm, 0g

40930gofam0306d50-00
Livrare 48-72 ore

17,39Lei

Cutie Garbolino Riguri Monturi, 15x11.5x7.2cm
Exclusiv online!

Cutie Garbolino Riguri Monturi, 15x11.5x7.2cm

90930gofag0031-10
Livrare 48-72 ore

71,65Lei

Geanta Garbolino Trooper 55x40x40cm -24%

Geanta Garbolino Trooper 55x40x40cm

90405gomlh3011
Livrare imediată!

158,92Lei(-24%) 120,90Lei

Afişare 341 - 360 din 460 (23 pagini)
Queries: 10, Total time: 16.536 ms [By time] [By id] [By file]
1 (0.105)
SELECT data
FROM `oc_session`
WHERE session_id = '1cf5c0ec982a11d4b55802e30d'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.114)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (9.876)
CREATE TEMPORARY TABLE oc_bf_tmp_product (PRIMARY KEY (`product_id`), INDEX my_index (match_filters, sort_order, manufacturer_id)) ENGINE=MEMORY SELECT p.product_id, p.sort_order, p.quantity, p.manufacturer_id, "1" AS match_filters, (IF(MIN(ps.price) IS NOT NULL, MIN(ps.price), p.price) * (1 + IFNULL(percent_tax, 0)/100) + IFNULL(fixed_tax, 0)) AS actual_price
FROM `oc_product` AS p
INNER JOIN `oc_product_to_store` AS p2s ON (p2s.product_id = p.product_id)
INNER JOIN `oc_bf_filter` AS f ON (p.product_id = f.product_id)
INNER JOIN `oc_product_description` AS pd ON (pd.product_id = p.product_id)
LEFT JOIN `oc_product_special` AS ps ON (ps.product_id = p.product_id AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()) AND (ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND ps.customer_group_id = '1')
LEFT JOIN ( SELECT SUM(fixed_rate) AS fixed_tax, SUM(percent_rate) AS percent_tax, tax_class_id
FROM `oc_bf_tax_rate`) AS tx ON (p.tax_class_id = tx.tax_class_id)
WHERE p2s.store_id = '2' AND (MATCH(pd.tag) AGAINST('+garbolino' IN BOOLEAN MODE)) AND p.status_filtru > 0 AND p.price > 0 GROUP BY p.product_id
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:737
4 (0.133)
SELECT COUNT(1) AS total
FROM ( SELECT p.*
FROM `oc_bf_tmp_product` AS p
WHERE match_filters = 1) AS t
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1561
5 (1.801)
SELECT p.*, pp.sort_order, pp.viewed, IF ((pp.quantity) > 0, 1, 0) AS array_quantity
FROM `oc_bf_tmp_product` AS p
INNER JOIN `oc_product_description` AS pd ON (pd.product_id = p.product_id)
INNER JOIN `oc_product` AS pp ON (pp.product_id = p.product_id)
WHERE match_filters = 1 AND pd.language_id = '2'
ORDER BY array_quantity DESC, pp.sort_order ASC, pp.viewed DESC, pd.name ASC LIMIT 340, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
6 (0.386)
SELECT DISTINCT m.manufacturer_id AS id, CONCAT(UCASE(LEFT(m.name, 1)), LCASE(SUBSTRING(m.name, 2))) AS name
FROM `oc_manufacturer` AS m
INNER JOIN `oc_bf_tmp_product` AS p ON (m.manufacturer_id = p.manufacturer_id)
WHERE match_filters = 1
ORDER BY m.sort_order, m.name
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:1248
7 (0.074)
SELECT stock_status_id AS id, name
FROM `oc_stock_status`
WHERE language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:1270
8 (0.169)
SELECT MIN(actual_price) AS min, MAX(actual_price) AS max
FROM `oc_bf_tmp_product` AS p
WHERE match_filters = 1
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:1035
9 (3.755)
SELECT COUNT(1) AS val, filter_group, filter_id
FROM `oc_bf_tmp_product` AS p
INNER JOIN `oc_bf_filter` AS f ON (p.product_id = f.product_id)
WHERE match_filters = 1 AND f.language_id = '2' GROUP BY filter_group, filter_id
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:949
10 (0.123)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '2' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38