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


PAT MIVARDI PROFESIONAL 8 PICIOARE 140KG
Exclusiv online!

PAT MIVARDI PROFESIONAL 8 PICIOARE 140KG

m-bchpro8
Livrare 48-72 ore

969,01Lei

Cort Mivardi Profesional 2 pers
Exclusiv online!

Cort Mivardi Profesional 2 pers

m-bivpr
Livrare 48-72 ore

1.920,01Lei

Lanseta feeder Spro Petri Boatfeeder H 2.70m/120g
Exclusiv online!

Lanseta feeder Spro Petri Boatfeeder H 2.70m/120g

002470-00270-00000
Livrare 48-72 ore

345,00Lei

Lanseta Colmic Herakles Calida Pro Evolution Spin 2.13m/3-14g
Exclusiv online!

Lanseta Colmic Herakles Calida Pro Evolution Spin 2.13m/3-14g

cahkcp02
Livrare 48-72 ore

286,00Lei

FIR PB SILK RAY SILT 45LB-LEADCORE FARA PLUMB 45LB 10M NAMOL

FIR PB SILK RAY SILT 45LB-LEADCORE FARA PLUMB 45LB 10M NAMOL

pb10432
Livrare imediată!

72,00Lei

Lanseta telescopica Lineaeffe Drago/Pro Lord 3.00m/20-50g
Exclusiv online!

Lanseta telescopica Lineaeffe Drago/Pro Lord 3.00m/20-50g

l.2024300
Livrare 24-48 ore

67,84Lei

SET 3 AVERTIZOARE PLUS STATIE PROLOGIC BAT MULTICOLOR -10%

SET 3 AVERTIZOARE PLUS STATIE PROLOGIC BAT MULTICOLOR

a.pro.57081
Livrare imediată!

676,32Lei(-10%) 608,70Lei

MULINETA SPRO CANYON FEEDER 4000
Exclusiv online!

MULINETA SPRO CANYON FEEDER 4000

001184-00640-00000
Livrare 48-72ore

281,99Lei

Cort Prologic Bivy 2 Persoane + Overwrap -40%
Exclusiv online!

Cort Prologic Bivy 2 Persoane + Overwrap

a8.pro.55776
Livrare 24-48 ore

3.220,63Lei(-40%) 1.932,38Lei

LANSETA CRAP PROLOGIC 2BUC C3 RAS 3.00MT 3LBS

LANSETA CRAP PROLOGIC 2BUC C3 RAS 3.00MT 3LBS

o.pro.49821
Livrare imediată!

375,50Lei

ROD POD PROLOGIC SPIDER 3 POSTURI -23%

ROD POD PROLOGIC SPIDER 3 POSTURI

a6.pro.54369
Livrare imediată!

510,97Lei(-23%) 393,90Lei

APARATOARE INELE LANSETE JAXON 7C
Exclusiv online!

APARATOARE INELE LANSETE JAXON 7C

ak-kt007c
Livrare 48-72 ore

54,00Lei

Antirasucitor Spro Metalic 10cm 2 buc

Antirasucitor Spro Metalic 10cm 2 buc

004607-00012-00000
Livrare imediată!

10,60Lei

Lanseta feeder Spro Petri Boatfeeder H 3m/130g

Lanseta feeder Spro Petri Boatfeeder H 3m/130g

002470-00300-00000
Livrare imediată!

369,99Lei

SUPORT PTR STARLETI SPRO DE PRINS PE LANSETA 2 BUC/PLIC 3.6-4.3 MM

SUPORT PTR STARLETI SPRO DE PRINS PE LANSETA 2 BUC/PLIC 3.6-4.3 MM

004759-00400-00000
Livrare imediată!

4,00Lei

BANDA FIXARE LANSETE JAXON NEGRU 20-15CM
Exclusiv online!

BANDA FIXARE LANSETE JAXON NEGRU 20-15CM

uy-rb03a
Livrare 48-72 ore

28,00Lei

BANDA FIXARE LANSETE JAXON ALBASTRU 20-15CM
Exclusiv online!

BANDA FIXARE LANSETE JAXON ALBASTRU 20-15CM

uy-rb03c
Livrare 48-72 ore

28,00Lei

HUSA SPRO C-TEC 3 LANSETE PLUS 3 MULINETE  195X30 CM

HUSA SPRO C-TEC 3 LANSETE PLUS 3 MULINETE  195X30 CM

006405-00005-00000
Livrare imediată!

216,70Lei

ANCORA NR 8 GAMAKATSU LEGATA CU FIR TEXTIL 5CM 12KG

ANCORA NR 8 GAMAKATSU LEGATA CU FIR TEXTIL 5CM 12KG

004624-02500-00000
Livrare imediată!

13,30Lei

Degetar EnergoTeam

Degetar EnergoTeam

74300901
Livrare imediată!

22,50Lei

Afişare 1681 - 1700 din 7177 (359 pagini)
Queries: 6, Total time: 683.023 ms [By time] [By id] [By file]
1 (0.150)
SELECT data
FROM `oc_session`
WHERE session_id = 'd336f48f152bb3bf3436474a36'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.109)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (654.804)
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 (pd.tag LIKE "%pro%") 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 (27.662)
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 1680, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.148)
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
6 (0.150)
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