Pentru o livrare cat mai rapida va recomandam sa alegeti produse cu stoc in Magazin fizic si in Depozit Online. Produsele cu Stoc furnizor au termen de livrare mai mare si pot intarzia comanda dvs.
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

Filtreaza

Fir Textil Spiderwire Stealth Smooth 12 Braid Transparent 2000m, 0.05mm, 5.4kg -57%
Exclusiv online!

Fir Textil Spiderwire Stealth Smooth 12 Braid Transparent 2000m, 0.05mm, 5.4kg

1507427
Livrare 7-14 zile

2.749,95Lei(-57%) 1.180,75Lei

Fir Textil Spiderwire Stealth Smooth 12 Braid Galben 2000m, 0.39mm, 46.3kg -56%
Exclusiv online!

Fir Textil Spiderwire Stealth Smooth 12 Braid Galben 2000m, 0.39mm, 46.3kg

1507448
Livrare 7-14 zile

2.749,95Lei(-56%) 1.222,32Lei

Fir Textil Spiderwire Stealth Smooth 12 Braid Galben 2000m, 0.33mm, 38.1kg -64%
Exclusiv online!

Fir Textil Spiderwire Stealth Smooth 12 Braid Galben 2000m, 0.33mm, 38.1kg

1507447
Livrare 7-14 zile

2.749,95Lei(-64%) 982,10Lei

Fir Textil Spiderwire Stealth Smooth 12 Braid Galben 2000m, 0.29mm, 26.4kg -63%
Exclusiv online!

Fir Textil Spiderwire Stealth Smooth 12 Braid Galben 2000m, 0.29mm, 26.4kg

1507446
Livrare 7-14 zile

2.749,95Lei(-63%) 1.020,57Lei

Fir Textil Spiderwire Stealth Smooth 12 Braid Galben 2000m, 0.09mm, 7.5kg -37%
Exclusiv online!

Fir Textil Spiderwire Stealth Smooth 12 Braid Galben 2000m, 0.09mm, 7.5kg

1507440
Livrare 7-14 zile

2.749,95Lei(-37%) 1.735,33Lei

Fir Textil Spiderwire Stealth Smooth 12 Braid Galben 2000m, 0.05mm, 5.4kg -57%
Exclusiv online!

Fir Textil Spiderwire Stealth Smooth 12 Braid Galben 2000m, 0.05mm, 5.4kg

1507438
Livrare 7-14 zile

2.749,95Lei(-57%) 1.184,38Lei

Fir Textil Spiderwire Dura 4 Verde 1800m, 0.10mm, 9.1kg
Exclusiv online!

Fir Textil Spiderwire Dura 4 Verde 1800m, 0.10mm, 9.1kg

1450395
Livrare 7-14 zile

702,60Lei

Fir Textil Spiderwire Dura 4 Galben 1800m, 0.40mm, 45kg
Exclusiv online!

Fir Textil Spiderwire Dura 4 Galben 1800m, 0.40mm, 45kg

1450430
Livrare 7-14 zile

702,60Lei

Fir Textil Owner Kizuna Ex X8 Broad, Super Chartreuse, 0.19mm, 13.10kg, 150m
Exclusiv online!

Fir Textil Owner Kizuna Ex X8 Broad, Super Chartreuse, 0.19mm, 13.10kg, 150m

1106025613219
Livrare 48-72 ore

122,83Lei

Fir Textil Owner Kizuna Ex X8 Broad, Super Chartreuse, 0.17mm, 9.90kg, 150m
Exclusiv online!

Fir Textil Owner Kizuna Ex X8 Broad, Super Chartreuse, 0.17mm, 9.90kg, 150m

1106025613217
Livrare 48-72 ore

122,83Lei

Fir Textil Owner Kizuna Ex X8 Broad, Super Chartreuse, 0.13mm, 7.60kg, 150m

Fir Textil Owner Kizuna Ex X8 Broad, Super Chartreuse, 0.13mm, 7.60kg, 150m

1106025613213
Livrare imediată!

122,83Lei

Fir Textil Owner Kizuna Ex X8 Broad, Super Chartreuse, 0.10mm, 4.50kg, 150m

Fir Textil Owner Kizuna Ex X8 Broad, Super Chartreuse, 0.10mm, 4.50kg, 150m

1106025613210
Livrare imediată!

122,83Lei

Fir Textil Mikado Nihonto Octa Braid, Fluo Yellow, 0.08mm, 5.15kg, 150m
Exclusiv online!

Fir Textil Mikado Nihonto Octa Braid, Fluo Yellow, 0.08mm, 5.15kg, 150m

z24f-008
Livrare 48-72 ore

72,07Lei

Fir Textil Mikado Nihonto Octa Braid Fluo 150m 0.12mm 8.9kg
Exclusiv online!

Fir Textil Mikado Nihonto Octa Braid Fluo 150m 0.12mm 8.9kg

z24f-012
Livrare 48-72 ore

72,07Lei

Fir Textil Mikado Dreamline Ultralight 4x, Fluo Green, 0.058mm, 4.43kg, 150m
Exclusiv online!

Fir Textil Mikado Dreamline Ultralight 4x, Fluo Green, 0.058mm, 4.43kg, 150m

zdl000fg-150-0058
Livrare 48-72 ore

112,75Lei

Fir Textil Mikado Dreamline Ultralight 4x, Fluo Green, 0.047mm, 3.87kg, 150m
Exclusiv online!

Fir Textil Mikado Dreamline Ultralight 4x, Fluo Green, 0.047mm, 3.87kg, 150m

zdl000fg-150-0047
Livrare 48-72 ore

112,75Lei

Fir Textil Mikado Dreamline Ultralight 4x, Fluo Green, 0.035mm, 2.53kg, 150m
Exclusiv online!

Fir Textil Mikado Dreamline Ultralight 4x, Fluo Green, 0.035mm, 2.53kg, 150m

zdl000fg-150-0035
Livrare 48-72 ore

112,75Lei

Fir Textil Mikado Dreamline Competition 8x, Fluo Green, 0.14mm, 12.98kg, 150m
Exclusiv online!

Fir Textil Mikado Dreamline Competition 8x, Fluo Green, 0.14mm, 12.98kg, 150m

zdl000g-150-014
Livrare 48-72 ore

129,02Lei

Fir Textil Mikado Dreamline Competition 8x, Fluo Green, 0.08mm, 6.91kg, 150m
Exclusiv online!

Fir Textil Mikado Dreamline Competition 8x, Fluo Green, 0.08mm, 6.91kg, 150m

zdl000fg-150-008
Livrare 48-72 ore

129,02Lei

Fir Textil Lucky John Vanrex Micro Game X4 Braid Fluo Orange, 125m, 0.10mm, 3.4kg
Exclusiv online!

Fir Textil Lucky John Vanrex Micro Game X4 Braid Fluo Orange, 125m, 0.10mm, 3.4kg

lj4113-010
Livrare 48-72 ore

46,75Lei

Afişare 541 - 560 din 2233 (112 pagini)

Firele textile pentru spinning/rapitori sunt fire impletite in 4 sau opt pentru deveni rezistente la abraziune si nod si pentru a se putea obtine lanseuri cat mai lungi.De obicei culorile firelor textile pentru rapitori sunt cat mai vizibile pentru a ajuta pescarul in observarea trasaturilor fine ale pestilor rapitori.Firele textile pentru rapitori sunt realizate din fibre diferite pentru a putea face fata atat pestilor de apa sarata precum halibutul cat si pestilor de apa dulce ca si salaul.Printre firmele producatoare de fire textile pentru spinning/rapitori putem raminti:

Fire textile pentru spinning de la Daiwa,Fire textile pentru spinning de la Shimano,Fire textile pentru spinning de la Berkley, Fire textile pentru spinning de la Varivas, Fire textile pentru spinning de la Momoi, Fire textile pentru spinning de la Fox,Fire textile pentru spinning de la Bokor,Fire textile pentru spinning de la Favorite, Fire textile pentru spinning de la Power Pro etc

Queries: 16, Total time: 181.625 ms [By time] [By id] [By file]
1 (0.106)
SELECT data
FROM `oc_session`
WHERE session_id = '4a01ed4481dac2d13d966b2a92'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.085)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.112)
SELECT *
FROM oc_url_alias
WHERE keyword = 'fire-textile-rapitori'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.379)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '354' AND cd.language_id = '2' AND c2s.store_id = '3' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:46
5 (59.672)
CREATE TEMPORARY TABLE oc_bf_tmp_product (PRIMARY KEY (`product_id`)) ENGINE=InnoDB 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_to_category` AS p2c ON (p.product_id = p2c.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` GROUP BY tax_class_id) AS tx ON (p.tax_class_id = tx.tax_class_id)
WHERE p2s.store_id = '3' AND p2c.category_id = '354' 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:857
6 (0.823)
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:1593
7 (11.853)
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 DESC LIMIT 540, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
8 (0.127)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"TACKLE SHOP ARENA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
9 (84.379)
SELECT a.attribute_group_id AS group_id, av.attribute_id AS attr_id, av.attribute_value_id AS val_id, ad.name AS attr_name, av.sort_order AS val_sort, av.value
FROM `oc_bf_product_attribute_value` AS af
INNER JOIN `oc_bf_tmp_product` AS p ON (af.product_id = p.product_id)
INNER JOIN `oc_bf_attribute_value` AS av ON (af.attribute_value_id = av.attribute_value_id)
INNER JOIN `oc_attribute` AS a ON (a.attribute_id = av.attribute_id)
INNER JOIN `oc_attribute_description` AS ad ON (ad.attribute_id = a.attribute_id)
WHERE ad.language_id = '2' AND av.language_id = '2' AND match_filters = 1 GROUP BY av.attribute_value_id
ORDER BY a.sort_order, ad.name, av.sort_order, CAST(av.value AS UNSIGNED), av.value
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:1286
10 (1.664)
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:1393
11 (0.152)
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:1415
12 (0.594)
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:1180
13 (21.192)
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:1094
14 (0.192)
SELECT *
FROM `oc_pb_bundles`
WHERE `products` != '' AND `status`= '1' AND type = '1' AND `date_available` <= NOW() AND `customer_type` = 0 AND `categories_show` LIKE '%"354"%' LIMIT 0, 1000
/var/www/clients/client1/web1/web/catalog/model/module/productbundles.php:106
15 (0.172)
SELECT *
FROM `oc_pb_bundles`
WHERE `products` != '' AND `status`= '1' AND type = '0' AND `date_available` <= NOW() AND `customer_type` = 0 AND `categories_show` LIKE '%"354"%' LIMIT 0, 1000
/var/www/clients/client1/web1/web/catalog/model/module/product_recomandate.php:106
16 (0.123)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '3' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:37