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, Textil, Varivas, Super, Trout, Area, PE, X4,, Neo, Yellow,, 0.30mm,, 6.7lbs,, 75m, V47075030, Fire Textile Rapitori, Fire Textile Rapitori Varivas, Fire Varivas, Textile Varivas, Rapitori Varivas, Varivas
Minciog Zebco Metal Power Landing Net 1.75m
Exclusiv online!

Minciog Zebco Metal Power Landing Net 1.75m

7081175
Livrare 14-21 zile

116,06Lei

Agrafe Spro Freestyle Fluorocarbon Snaps Stainless Steel, 3mm/6.75mm, 10buc/plic

Agrafe Spro Freestyle Fluorocarbon Snaps Stainless Steel, 3mm/6.75mm, 10buc/plic

004590-00026-00000
Livrare imediată!

12,60Lei

Atractant, Lichid, Carp, Zoom, R2, PVA, Green, Booster,, Tigernut,, 75ml, , cz0885, Aditivi Lichizi / Arome / Dip-uri, Aditivi Lichizi / Arome / Dip-uri Carp Zoom, Carp Zoom
FIR, CLIMAX, TEXTIL, IBRAID, DIVE, FLUO, YELLOW,, 0.15mm,, 275m, 7.50, kg, 9432-10275-015, Fire Textile Inaintas, Fire Textile Inaintas Climax, Fire Climax, Textile Climax, Inaintas Climax, Climax
FIR, CLIMAX, TEXTIL, IBRAID, DIVE, OLIVE, GREEN,, 0.08mm,, 275m, 9431-10275-008, Fire Textile Inaintas, Fire Textile Inaintas Climax, Climax
Fir Textil Spiderwire Durabraid Verde 275m, 0.15mm, 13kg
Exclusiv online!

Fir Textil Spiderwire Durabraid Verde 275m, 0.15mm, 13kg

1580499
Livrare 7-14 zile

172,12Lei

Fir, Textil, Spiderwire, Durabraid, Verde, 275m,, 0.36mm,, 31kg, 1580503, Fire Textile Rapitori, Fire Textile Rapitori SpiderWire, SpiderWire
FIR, CLIMAX, TEXTIL, IBRAID, DIVE, FLUO, YELLOW,, 0.18mm,, 275m, 9.50, kg, 9432-10275-018, Fire Textile Inaintas, Fire Textile Inaintas Climax, Climax
Fir, Monofilament, Sonik, Ultrasonik,, Clear,, 8.16kg,, 0.35mm,, 975m, rs0002, Fire Monofilament Crap, Fire Monofilament Crap Sonik, Fire Sonik, Monofilament Sonik, Crap Sonik, Sonik
STARLET MIKADO 7.5x75mm 2buc/plic 50plicuri
Exclusiv online!

STARLET MIKADO 7.5x75mm 2buc/plic 50plicuri

iaip02-7.5
Livrare 48-72 ore

175,00Lei

Fir Textil Spiderwire Durabraid Verde 275m, 0.23mm, 19.5kg
Exclusiv online!

Fir Textil Spiderwire Durabraid Verde 275m, 0.23mm, 19.5kg

1580501
Livrare 7-14 zile

172,12Lei

Fir Textil Spiderwire Durabraid Verde 275m, 0.28mm, 22.5kg
Exclusiv online!

Fir Textil Spiderwire Durabraid Verde 275m, 0.28mm, 22.5kg

1580502
Livrare 7-14 zile

172,12Lei

Fir, Textil, Spiderwire, Durabraid, Verde, 275m,, 0.41mm,, 42kg, 1580504, Fire Textile Rapitori, Fire Textile Rapitori SpiderWire, SpiderWire
Fir, Textil, Spiderwire, Durabraid, Verde, 275m,, 0.43mm,, 45kg, 1580505, Fire Textile Rapitori, Fire Textile Rapitori SpiderWire, SpiderWire
Lanseta Hardy Ultralite NSX DH Fly Rod 10/11 Line, 4.75m, 6seg
Exclusiv online!

Lanseta Hardy Ultralite NSX DH Fly Rod 10/11 Line, 4.75m, 6seg

1542500
Livrare 7-14 zile

6.119,96Lei

Tambure de Rezerva TICA Titan 3000, 0.25mm/175m

Tambure de Rezerva TICA Titan 3000, 0.25mm/175m

2yt-802-01
Livrare imediată!

125,00Lei

Lanseta Spinning Jackall T-Connection Comfy TCC-S58UL 1,75m/0,4-3g, 2seg
Exclusiv online!

Lanseta Spinning Jackall T-Connection Comfy TCC-S58UL 1,75m/0,4-3g, 2seg

ja.807217964
Livrare 24-48 ore

952,10Lei

Mulineta RAPTURE LMF Fly Reel ADR 75mm, 2+1rul
Exclusiv online!

Mulineta RAPTURE LMF Fly Reel ADR 75mm, 2+1rul

032-92-140
Livrare 48-72 ore

190,00Lei

KIT PUNGI PVA FOX FAST MELT PLUS INCARCATOR FOX EDGES RAPIDE SYSTEM 75 ORI 175MM

KIT PUNGI PVA FOX FAST MELT PLUS INCARCATOR FOX EDGES RAPIDE SYSTEM 75 ORI 175MM

cpv051
Livrare imediată!

49,46Lei

Afişare 41 - 60 din 228 (12 pagini)
Queries: 5, Total time: 216.271 ms [By time] [By id] [By file]
1 (0.082)
SELECT data
FROM `oc_session`
WHERE session_id = '43351e48ef742bcd84ccb871a4'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.087)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:427
3 (214.715)
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 "%75m%") 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
4 (1.283)
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:184
5 (0.104)
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