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


Agrafa Rapida NR 2 MAVER
Exclusiv online!

Agrafa Rapida NR 2 MAVER

1495002
Livrare 48-72 ore

9,50Lei

MONTURA TRAKKO PENTRU SOMN 30GR
Exclusiv online!

MONTURA TRAKKO PENTRU SOMN 30GR

tr9995-40
Livrare 48-72ore

35,00Lei

Tub Silicon DAM Madcat Power Elastic 5.0m 0.80mm

Tub Silicon DAM Madcat Power Elastic 5.0m 0.80mm

4053156545
Livrare imediată!

12,78Lei

FIR CARP ZOOM TEXTIL LEADER ALLROUND 20m 0.10mm Gri

FIR CARP ZOOM TEXTIL LEADER ALLROUND 20m 0.10mm Gri

cz7473
Livrare imediată!

11,00Lei

MONTURA PROLOGIC STIFF 15CM/22LBS CU CARLIG XC7 NR.6
Exclusiv online!

MONTURA PROLOGIC STIFF 15CM/22LBS CU CARLIG XC7 NR.6

a.pro.50140
Livrare 24-48 ore

25,64Lei

CARLIGE SPRO C-TEC LEGATE STOPPER VARTEJ WEEDY CARLIG NR6 2 BUC/PLIC

CARLIGE SPRO C-TEC LEGATE STOPPER VARTEJ WEEDY CARLIG NR6 2 BUC/PLIC

008620-00108-00000
Livrare imediată!

7,50Lei

Tub Siliconic Select Baits Silicone Tube 1.0mm

Tub Siliconic Select Baits Silicone Tube 1.0mm

sel-217992
Livrare imediată!

6,00Lei

Masa Prologic Monturi Bivvy 60x30x5cm
Exclusiv online!

Masa Prologic Monturi Bivvy 60x30x5cm

a8.pro.54351
Livrare 24-48 ore

273,80Lei

Montura Carp Spirit Sit Up and Beg Rig Barbed nr.4 25lb

Montura Carp Spirit Sit Up and Beg Rig Barbed nr.4 25lb

acs340041
Livrare imediată!

18,00Lei

Forfac Feeder Cu Fir Textil Nevis cu Carlig nr.6 10LBS

Forfac Feeder Cu Fir Textil Nevis cu Carlig nr.6 10LBS

8103-206
Livrare imediată!

12,60Lei

FIR LEADCORE FOX CAMO WOVEN LEADER 7M 50LB
Exclusiv online!

FIR LEADCORE FOX CAMO WOVEN LEADER 7M 50LB

cac747
Livrare 7-14 zile

35,70Lei

PROTECTIE MONTURA KORDA CHODD RIG 8BUC/PL
Exclusiv online!

PROTECTIE MONTURA KORDA CHODD RIG 8BUC/PL

a.klsb
Livrare 24-48 ore

25,51Lei

Fir Multifilament Nevis S Braid 15m 0.10mm

Fir Multifilament Nevis S Braid 15m 0.10mm

3227-010
Livrare imediată!

13,99Lei

Fir Monofilament Sunset Amnesia Clear, 8lb/3.6kg, 100m

Fir Monofilament Sunset Amnesia Clear, 8lb/3.6kg, 100m

755180999
Livrare imediată!

35,00Lei

STRIPPER CARP SPIRIT STRIP EAZE

STRIPPER CARP SPIRIT STRIP EAZE

acs010220
Livrare imediată!

19,00Lei

Fir Multifilament Nevis S Braid 15m 0.12mm

Fir Multifilament Nevis S Braid 15m 0.12mm

3227-012
Livrare imediată!

13,99Lei

Fir leadcore CPK Heavy Leadcore Camo Green 45lb/10m

Fir leadcore CPK Heavy Leadcore Camo Green 45lb/10m

999968
Livrare imediată!

32,00Lei

Bait Bander ENERGOTEAM KAMASAKI APLICARE INEL SILICONIC

Bait Bander ENERGOTEAM KAMASAKI APLICARE INEL SILICONIC

79015500
Livrare imediată!

13,40Lei

FIR TEXTIL CRALUSSO FEEDER&CARP 10M 20lbs
Exclusiv online!

FIR TEXTIL CRALUSSO FEEDER&CARP 10M 20lbs

33909220
Livrare 24-48 ore

35,00Lei

KIT MONTURA PLUMB PIERDUT CARP EXPERT LEAD CLIP CLASSIC 6 BUC/PLIC

KIT MONTURA PLUMB PIERDUT CARP EXPERT LEAD CLIP CLASSIC 6 BUC/PLIC

79032030
Livrare imediată!

7,20Lei

Afişare 1841 - 1860 din 4580 (229 pagini)
Queries: 5, Total time: 92.321 ms [By time] [By id] [By file]
1 (0.103)
SELECT data
FROM `oc_session`
WHERE session_id = 'e717434ab7318d47282013f61c'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.123)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (91.836)
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 = '2' AND (MATCH(pd.tag) AGAINST('+monturi' 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 (0.138)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"PRODUSE INACTIVE"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
5 (0.121)
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