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


FIR MONOFILAMENT DAIWA TOURNAMENT SF GREEN 300M 0.23mm 4.50kg
Exclusiv online!

FIR MONOFILAMENT DAIWA TOURNAMENT SF GREEN 300M 0.23mm 4.50kg

d.12200.323
Livrare 24-48 ore

33,20Lei

CANTAR ELECTRONIC CU RULETA SI INCARCATOR 50KG WEI HENG

CANTAR ELECTRONIC CU RULETA SI INCARCATOR 50KG WEI HENG

wh-a29
Livrare imediată!

76,90Lei

Cantar Digital Energo Team Wizard, 150kg
Exclusiv online!

Cantar Digital Energo Team Wizard, 150kg

80213322
Livrare 24-48 ore

274,21Lei

Fir, Asso, Ultra, Cast, Orange,, 1000m,, 0.39mm,, 18.50kg, , 110108100039, Fire Monofilament Crap, Fire Monofilament Crap Asso, Asso
Fir Monofilament Extra Carp Magic Yellow, 15.50kg, 0.35mm, 1000m

Fir Monofilament Extra Carp Magic Yellow, 15.50kg, 0.35mm, 1000m

ec3875-35
Livrare imediată!

68,00Lei

Fir Inaintas Konger Kevlar Dread Cat Leader Camou, 10m, 1.24mm, 150kg

Fir Inaintas Konger Kevlar Dread Cat Leader Camou, 10m, 1.24mm, 150kg

110406285010150
Livrare imediată!

42,82Lei

Fir Monofilament Trabucco T-Force Special Feeder, 0.20mm, 5.50kg, 150m

Fir Monofilament Trabucco T-Force Special Feeder, 0.20mm, 5.50kg, 150m

051-40-200
Livrare imediată!

31,00Lei

CANTAR ELECTRONIC CU RULETA SI INCARCATOR 50KG WEI HENG ROSU

CANTAR ELECTRONIC CU RULETA SI INCARCATOR 50KG WEI HENG ROSU

wh-a28
Livrare imediată!

85,89Lei

Fir Territory Purple - 0.26Mm/8.50Kg/300M
Exclusiv online!

Fir Territory Purple - 0.26Mm/8.50Kg/300M

ztpur3-026
Livrare 48-72 ore

54,00Lei

Fir Textil Climax iBraid Neo X8, Fluo Chartreuse, 0.25mm, 20.50kg, 135m

Fir Textil Climax iBraid Neo X8, Fluo Chartreuse, 0.25mm, 20.50kg, 135m

9406-10135-025
Livrare imediată!

98,00Lei

Fir, Textil, Climax, iBraid, Neo, X8,, Fluo, Red,, 0.12mm,, 8.50kg,, 135m, 9405-10135-012, Fire Textile Rapitori, Fire Textile Rapitori Climax, Fire Climax, Textile Climax, Rapitori Climax, Climax
Fir Inaintas Konger Kevlar Dread Cat Leader Negru, 10m, 1.24mm, 150kg

Fir Inaintas Konger Kevlar Dread Cat Leader Negru, 10m, 1.24mm, 150kg

110406285011150
Livrare imediată!

41,55Lei

Fir, Territory, Purple, -, 0.28Mm/9.50Kg/300M, ZTPUR3-028, Fire Monofilament Crap, Fire Monofilament Crap Mikado, Fire Mikado, Monofilament Mikado, Crap Mikado, Mikado
Fir Textil Inaintas Golden Catch Catfish Leader 20m, 1.40mm, 150kg
Exclusiv online!

Fir Textil Inaintas Golden Catch Catfish Leader 20m, 1.40mm, 150kg

gcz-4165203
Livrare 48-72ore

62,50Lei

Fir, Textil, Lazer, Xtreme, Cat, 200m,, 0.60mm,, 54.50kg, fil-952152, Fire Somn, Fire Somn Lazer, Lazer

Fir, Textil, Lazer, Xtreme, Cat, 200m,, 0.60mm,, 54.50kg, fil-952152, Fire Somn, Fire Somn Lazer, Lazer

fil-952152
Livrare imediată!

89,00Lei

Fir Textil Zeck Hulk Line 0.55mm, 50kg, 400m, Verde
Exclusiv online!

Fir Textil Zeck Hulk Line 0.55mm, 50kg, 400m, Verde

110405130057
Livrare 48-72 ore

359,74Lei

Cantar Digital Verney Carron Digital Scale, 250kg
Exclusiv online!

Cantar Digital Verney Carron Digital Scale, 250kg

lvc.phac046
Livrare 24-48 ore

266,60Lei

Fir, Territory, Purple, -, 0.28Mm/9.50Kg/600M, ZTPUR6-028, Fire Monofilament Crap, Fire Monofilament Crap Mikado, Fire Mikado, Monofilament Mikado, Crap Mikado, Mikado
Cantar Electronic cu Termometru Lucky John BBS 50kg
Exclusiv online!

Cantar Electronic cu Termometru Lucky John BBS 50kg

ljbbs050-fs
Livrare 48-72ore

165,01Lei

Fir, Monofilament, Trabucco, T-Force, Special, Feeder,, 0.20mm,, 5.50kg,, 300m, 051-42-200, Fire Textile Monofilament Feeder, Fire Textile Monofilament Feeder Trabucco, Fire Trabucco, Textile Trabucco, Monofilament Trabucco, Feeder Trabucco, Trabucco
Afişare 21 - 40 din 181 (10 pagini)
Queries: 10, Total time: 197.707 ms [By time] [By id] [By file]
1 (0.163)
SELECT data
FROM `oc_session`
WHERE session_id = 'd3f698fd33b03faa43906a28d0'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.126)
SELECT *
FROM oc_platforma_promovari LIMIT 1
/var/www/clients/client1/web1/web/index.php:128
3 (0.107)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:422
4 (195.566)
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 = '2' AND (pd.tag LIKE "%50kg%") 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:698
5 (1.158)
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 20, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
6 (0.118)
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
7 (0.126)
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
8 (0.114)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
9 (0.111)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
10 (0.119)
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