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


Monofilament Nevis Sensor Fluo 1000m 0.35mm
Exclusiv online!

Monofilament Nevis Sensor Fluo 1000m 0.35mm

3201-835
Livrare 48-72 ore

81,00Lei

FIR KRYSTON SNYDE PREMIUM GRADE COPOLYMER 1000M 11LB 0.30MM GREEN

FIR KRYSTON SNYDE PREMIUM GRADE COPOLYMER 1000M 11LB 0.30MM GREEN

krsny2
Livrare imediată!

89,00Lei

Fir ASSO Hard Skin Siliconed Green 0.20mm 300m
Exclusiv online!

Fir ASSO Hard Skin Siliconed Green 0.20mm 300m

607080020
Livrare 48-72 ore

36,96Lei

Fir Asso Invisilk Yellow 0.22mm 150m
Exclusiv online!

Fir Asso Invisilk Yellow 0.22mm 150m

603080085
Livrare 48-72 ore

19,88Lei

Fir ASSO Ultra Carp Brown 0.26 mm 1000 m

Fir ASSO Ultra Carp Brown 0.26 mm 1000 m

607080063
Livrare imediată!

58,88Lei

FIR LINEAEFFE BASS TOP GALBEN 0.36MM/11KG 550M
Exclusiv online!

FIR LINEAEFFE BASS TOP GALBEN 0.36MM/11KG 550M

l.3001215
Livrare 24-48 ore

18,35Lei

FIR ENERGO TEAM SPECIALIST CARP 0.40 MM 300M

FIR ENERGO TEAM SPECIALIST CARP 0.40 MM 300M

33200040
Livrare imediată!

13,99Lei

Fir Delphin FIN Carp ARMADA 800m Camuflaj 0.40mm 25.3lbs

Fir Delphin FIN Carp ARMADA 800m Camuflaj 0.40mm 25.3lbs

500623440
Livrare imediată!

93,00Lei

FIR LINEAEFFE MONOFILAMENT SPECIMEN SILICONE 0.50MM/29.60KG 300M
Exclusiv online!

FIR LINEAEFFE MONOFILAMENT SPECIMEN SILICONE 0.50MM/29.60KG 300M

l.3600550
Livrare 24-48 ore

34,71Lei

Fir Monofilament Carp Spirit Velocity XS Clear 1200m 0.27mm 5.90kg
Exclusiv online!

Fir Monofilament Carp Spirit Velocity XS Clear 1200m 0.27mm 5.90kg

acs470071
Livrare 48-72ore

131,00Lei

Fir Cralusso Prestige Fluo Galben 0.20mm 350m

Fir Cralusso Prestige Fluo Galben 0.20mm 350m

33907020
Livrare imediată!

42,99Lei

Fir Monofilament Kryston Oblivion Super Grade Copolymer Matt Camou 1000m 0.28mm 8lbs

Fir Monofilament Kryston Oblivion Super Grade Copolymer Matt Camou 1000m 0.28mm 8lbs

krobl11
Livrare imediată!

63,00Lei

FIR MONOFILAMENT PROLOGIC XLNT HP GREEN 1000M 0.28MM -40%
Exclusiv online!

FIR MONOFILAMENT PROLOGIC XLNT HP GREEN 1000M 0.28MM

a.pro.57100
Livrare 24-48 ore

70,38Lei(-40%) 42,23Lei

FIR KRYSTON KRYSTONITE SUPER MONO 1000M 8LB 0.25MM
Exclusiv online!

FIR KRYSTON KRYSTONITE SUPER MONO 1000M 8LB 0.25MM

krkry1
Livrare 48-72 ore

99,00Lei

Fir Monofilament Cralusso Feeder & Crap Fast Sinking, Negru, 0.18mm, 300m

Fir Monofilament Cralusso Feeder & Crap Fast Sinking, Negru, 0.18mm, 300m

33905318
Livrare imediată!

28,00Lei

Fir Monofilament EnergoTeam Kamasaki Super XXL 07 0.80mm 200m -20%

Fir Monofilament EnergoTeam Kamasaki Super XXL 07 0.80mm 200m

30009780
Livrare imediată!

35,00Lei(-20%) 28,00Lei

Monofilament Nevis Sensor Fluo 600m 0.20mm

Monofilament Nevis Sensor Fluo 600m 0.20mm

3201-620
Livrare imediată!

35,00Lei

Fir Monofilament Cralusso Feeder & Crap Fast Sinking, Negru, 0.30mm, 300m

Fir Monofilament Cralusso Feeder & Crap Fast Sinking, Negru, 0.30mm, 300m

33905330
Livrare imediată!

29,00Lei

Fir monofilament Kryston Snyde Premium Green 0.40mm 1000m
Exclusiv online!

Fir monofilament Kryston Snyde Premium Green 0.40mm 1000m

krsny4
Livrare 48-72 ore

105,01Lei

Fir Trabucco Super Iso 0.35mm/500m

Fir Trabucco Super Iso 0.35mm/500m

052-53-350
Livrare imediată!

78,00Lei

Afişare 1041 - 1060 din 1889 (95 pagini)
Queries: 6, Total time: 64.565 ms [By time] [By id] [By file]
1 (0.132)
SELECT data
FROM `oc_session`
WHERE session_id = 'b37b7c0497cef9a6db41a185db'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.104)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (55.968)
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 = '3' AND (MATCH(pd.tag) AGAINST('+fire +monofilament +crap' 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 (8.042)
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 1040, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.196)
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
6 (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:38