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


VARTEJ BARREL JAXON CU AGRAFA POWER NR 18 -31%
Exclusiv online!

VARTEJ BARREL JAXON CU AGRAFA POWER NR 18

aj-ka10518c
Livrare 48-72 ore

5,50Lei(-31%) 3,80Lei

CARLIGE GAMAKATSU POWER CARP RING EYE NR 10 / 10BUC/PL

CARLIGE GAMAKATSU POWER CARP RING EYE NR 10 / 10BUC/PL

185092-01000-00000
Livrare imediată!

13,99Lei

MANER MINCIOG MIVARDI POWER 3m TELESCOPIC
Exclusiv online!

MANER MINCIOG MIVARDI POWER 3m TELESCOPIC

miv-pn300
Livrare 48-72 ore

79,00Lei

VARTEJ BARREL JAXON CU AGRAFA POWER NR 12 -31%

VARTEJ BARREL JAXON CU AGRAFA POWER NR 12

aj-ka10512c
Livrare imediată!

5,50Lei(-31%) 3,80Lei

Fir Titan Power 0.45mm 100m

Fir Titan Power 0.45mm 100m

30005045
Livrare imediată!

8,00Lei

FIR MONOFILAMENT JAXON URAN POWER 125m 0.45mm

FIR MONOFILAMENT JAXON URAN POWER 125m 0.45mm

zj-urp045g
Livrare imediată!

19,00Lei

Fir Monofilament Ultima Power Carp 1000m, 0.33mm -21%

Fir Monofilament Ultima Power Carp 1000m, 0.33mm

d2333
Livrare imediată!

95,00Lei(-21%) 74,90Lei

Mulineta Carp Expert Pro Power Method Feeder 6000

Mulineta Carp Expert Pro Power Method Feeder 6000

20112355
Livrare imediată!

191,99Lei

Fir Monofilament Ultima Power Carp 1000m, 0.31mm -21%

Fir Monofilament Ultima Power Carp 1000m, 0.31mm

d2331
Livrare imediată!

95,00Lei(-21%) 74,90Lei

Lanseta Maver BOLOGNEZA SUPERLITIUM EVO GREEN POWER MX 5M Inele Fuji Torzite
Exclusiv online!

Lanseta Maver BOLOGNEZA SUPERLITIUM EVO GREEN POWER MX 5M Inele Fuji Torzite

5744500
Livrare 48-72 ore

1.470,00Lei

FIR MONOFILAMENT JAXON URAN POWER 125m 0.22mm -19%

FIR MONOFILAMENT JAXON URAN POWER 125m 0.22mm

zj-urp022g
Livrare imediată!

11,00Lei(-19%) 8,90Lei

FIR TEXTIL GAMAKATSU G-POWER PREMIUM YELLOW 012MM/7,2KG/135M
Exclusiv online!

FIR TEXTIL GAMAKATSU G-POWER PREMIUM YELLOW 012MM/7,2KG/135M

gk.5140.112
Livrare 24-48 ore

96,49Lei

POWER GUM CARP ZOOM FEEDER 10m 0.80mm 6kg transparent

POWER GUM CARP ZOOM FEEDER 10m 0.80mm 6kg transparent

cz3901
Livrare imediată!

20,00Lei

FIR TEXTIL POWER PRO 135MT 0,32MM 24kg M. Green -5%

FIR TEXTIL POWER PRO 135MT 0,32MM 24kg M. Green

ppbi13532mg
Livrare imediată!

70,00Lei(-5%) 66,50Lei

POWER GUM CARP ZOOM FEEDER 10m 1.00mm 8kg transparent

POWER GUM CARP ZOOM FEEDER 10m 1.00mm 8kg transparent

cz3918
Livrare imediată!

23,00Lei

FIR TEXTIL TRABUCCO DYNA TEX X4 POWER UV LIME YELLOW 150M 0.165MM 18LB -21%

FIR TEXTIL TRABUCCO DYNA TEX X4 POWER UV LIME YELLOW 150M 0.165MM 18LB

054-31-160
Livrare imediată!

59,00Lei(-21%) 46,90Lei

Fir Titan Power 0.25mm 100m

Fir Titan Power 0.25mm 100m

30005025
Livrare imediată!

6,00Lei

FIR MONOFILAMENT JAXON URAN POWER 125m 0.14mm

FIR MONOFILAMENT JAXON URAN POWER 125m 0.14mm

zj-urp014g
Livrare imediată!

10,00Lei

Fir Titan Power 0.35mm 100m

Fir Titan Power 0.35mm 100m

30005035
Livrare imediată!

6,00Lei

FIR MONOFILAMENT JAXON URAN POWER 125m 0.30mm

FIR MONOFILAMENT JAXON URAN POWER 125m 0.30mm

zj-urp030g
Livrare imediată!

13,99Lei

Afişare 421 - 440 din 1231 (62 pagini)
Queries: 4, Total time: 27.743 ms [By time] [By id] [By file]
1 (0.110)
SELECT data
FROM `oc_session`
WHERE session_id = 'a51e3220d87a90607e8d812a6e'
/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 (27.381)
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('+power' 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.143)
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