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 300 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


Mulineta, Prologic, Avenger, 6000, BF, SST, Graph, Sare, Spool,, 0.35mm-340m,, 5.2:1,, 3+1BB, o.pro.76025, Mulinete Crap, Mulinete Crap Prologic, Mulinete Prologic, Crap Prologic, Mulinete Feeder, Mulinete Feeder Prologic, Mulinete Prologic, Feeder Prologic, Prologic
Mulineta, Shakespeare, Salt, Spin, 60, Pre-Spooled, 1548352, Mulinete Rapitori, Mulinete Rapitori Shakespeare, Mulinete Shakespeare, Rapitori Shakespeare, Shakespeare -21%
Tambur Rezerva Grey Fin Spare Spool 9/10
Exclusiv online!

Tambur Rezerva Grey Fin Spare Spool 9/10

1546676
Livrare 7-14 zile

191,21Lei

Tambur Rezerva Nash Scope Spare Spool Gold Edition, 6000
Exclusiv online!

Tambur Rezerva Nash Scope Spare Spool Gold Edition, 6000

t2034
Livrare 7-14 zile

176,35Lei

Tambur Rezerva Nash Scope Spare Spool Gold Edition, 4000
Exclusiv online!

Tambur Rezerva Nash Scope Spare Spool Gold Edition, 4000

t2033
Livrare 7-14 zile

146,95Lei

Fir Textil Spiderwire Stealth Smooth Duo Spool SS8 Braid Moss Green, 150m, 0.13mm, 11.2kg + Berkley Vanish Fluoro 40m, 0.35mm, 7kg
Tambur Rezerva Zfish Spool Hulk BT, 10000
Exclusiv online!

Tambur Rezerva Zfish Spool Hulk BT, 10000

ZF-9002
Livrare 48-72ore

53,60Lei

Tambur Rezerva Zfish Spool Hulk BT, 9000
Exclusiv online!

Tambur Rezerva Zfish Spool Hulk BT, 9000

ZF-9001
Livrare 48-72ore

53,60Lei

D-SPOOL LINE STRIPPER CARP SPIRIT
Exclusiv online!

D-SPOOL LINE STRIPPER CARP SPIRIT

acs010222
Livrare 48-72ore

45,01Lei

Kit plasa solubila PVA Spro Meshsystem Hydraspool Wide 35mm/7m

Kit plasa solubila PVA Spro Meshsystem Hydraspool Wide 35mm/7m

2pva01pms736
Livrare imediată!

42,00Lei

Kit plasa solubila PVA Spro Meshsystem Hydraspool Wide 25mm/7m

Kit plasa solubila PVA Spro Meshsystem Hydraspool Wide 25mm/7m

2pva01pms725
Livrare imediată!

37,50Lei

Husa Protectie Tamburi Fox Camolite Spool Case Large 35x9.5cm

Husa Protectie Tamburi Fox Camolite Spool Case Large 35x9.5cm

clu308
Livrare imediată!

103,46Lei

TAMABUR REZERVA TICA TF8007R
Exclusiv online!

TAMABUR REZERVA TICA TF8007R

spool al.tf8007
Livrare 48-72 ore

73,99Lei

0,00Lei

MULINETA RYOBI SLAM PRO 4000 SPOOL SUPPORTER SLAR
Exclusiv online!

MULINETA RYOBI SLAM PRO 4000 SPOOL SUPPORTER SLAR

20115401
Livrare 24-48 ore

648,00Lei

Cutie Guru Rigida Spool Insert 18x8.5x7cm

Cutie Guru Rigida Spool Insert 18x8.5x7cm

a4.gu.gfb05
Livrare imediată!

27,83Lei

STRUNA DAIWA PROREX 7X7 WIRE SPOOL 5M 18KG -20%
Exclusiv online!

STRUNA DAIWA PROREX 7X7 WIRE SPOOL 5M 18KG

a7.17925.518
Livrare 24-48 ore

35,02Lei(-20%) 28,11Lei

MULINETA SAVAGE GEAR SG2 4000 FD 5+1BB/150M/020MM/5,2:1/ GRAPH SPARE SPOOL
Exclusiv online!

MULINETA SAVAGE GEAR SG2 4000 FD 5+1BB/150M/020MM/5,2:1/ GRAPH SPARE SPOOL

o.sg.74721
Livrare 24-48 ore

202,09Lei

MULINETA NASH DWARF FREESPOOL REEL 4000
Exclusiv online!

MULINETA NASH DWARF FREESPOOL REEL 4000

t4670
Livrare 7-14 zile

325,99Lei

MULINETA SAVAGE GEAR 2500 FD 5+1BB/150M/020MM/5,2:1/ GRAPH SPARE SPOOL
Exclusiv online!

MULINETA SAVAGE GEAR 2500 FD 5+1BB/150M/020MM/5,2:1/ GRAPH SPARE SPOOL

o.sg.74719
Livrare 24-48 ore

184,90Lei

Afişare 41 - 60 din 113 (6 pagini)
Queries: 14, Total time: 181.618 ms [By time] [By id] [By file]
1 (0.497)
SELECT data
FROM `oc_session`
WHERE session_id = 'd6f35f1cf71861bf3b666c1299'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.508)
SELECT *
FROM oc_platforma_promovari LIMIT 1
/var/www/clients/client1/web1/web/index.php:128
3 (0.234)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:422
4 (178.514)
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` GROUP BY tax_class_id) AS tx ON (p.tax_class_id = tx.tax_class_id)
WHERE p2s.store_id = '0' AND (pd.tag LIKE "%spool%") 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:697
5 (0.101)
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:1547
6 (0.629)
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 40, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:181
7 (0.549)
SELECT DISTINCT *, p.product_id, pd.name AS name, p.image, m.name AS manufacturer, (SELECT p2sb.product_id
FROM oc_product_to_store p2sb
WHERE p2sb.product_id = p.product_id AND p2sb.store_id = '1') AS blackfriday, (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, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (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 COUNT(1) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
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)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
LEFT JOIN (SELECT os.product_id, os.magazin AS comenzi_magazin, os.online AS comenzi_online
FROM oc_order_stoc os GROUP BY os.product_id) opp ON (opp.product_id = p.product_id)
WHERE p.product_id = '9063' AND pd.language_id = '2' AND p.status = '1' AND p.price > '0' AND p2s.store_id = '0'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:51
8 (0.094)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"ZFISHING SPORT WHOLESALE S.R.O"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
9 (0.087)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"ZFISHING SPORT WHOLESALE S.R.O"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
10 (0.087)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"RAPALA VMC ROMANIA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
11 (0.086)
SELECT *
FROM oc_url_alias
WHERE `query` = 'product_id=0'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:169
12 (0.076)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
13 (0.074)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
14 (0.082)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '0' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38