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


MINCIOG JAXON METAL SAFE 210F PLASA 12MM

MINCIOG JAXON METAL SAFE 210F PLASA 12MM

pl-axmb210f
Stoc epuizat

129,00Lei

MINCIOG CARP ZOOM GAMMA-N 2 SECTIUNI 70x70x250cm

MINCIOG CARP ZOOM GAMMA-N 2 SECTIUNI 70x70x250cm

cz3699
Stoc epuizat

179,00Lei

MINCIOG JAXON METAL SAFE T PLASA 30MM 200F

MINCIOG JAXON METAL SAFE T PLASA 30MM 200F

pl-axmt200f
Stoc epuizat

159,00Lei

MINCIOG JAXON SAFE ALU 190F

MINCIOG JAXON SAFE ALU 190F

pl-axb190f
Stoc epuizat

93,00Lei

Minciog Carp Zoom Crap 1 Sec. 107x107x180cm

Minciog Carp Zoom Crap 1 Sec. 107x107x180cm

cz1604
Stoc epuizat

233,00Lei

MINCIOG CARP ZOOM GAMMA-N 2 SECTIUNI 70x70x180cm

MINCIOG CARP ZOOM GAMMA-N 2 SECTIUNI 70x70x180cm

cz3682
Stoc epuizat

156,00Lei

MINCIOG SPRO BASIC 1.50 50X50

MINCIOG SPRO BASIC 1.50 50X50

003220-00151-00000
Stoc epuizat

78,50Lei

MINCIOG CARP ZOOM PLIABIL 2 SECTIUNI 40x60x180cm

MINCIOG CARP ZOOM PLIABIL 2 SECTIUNI 40x60x180cm

cz0438
Stoc epuizat

258,00Lei

MINCIOG CARP ZOOM ALPHA-ECO 2 SECTIUNI 55x55x150cm -32%

MINCIOG CARP ZOOM ALPHA-ECO 2 SECTIUNI 55x55x150cm

cz6643
Stoc epuizat

63,00Lei(-32%) 42,99Lei

MINCIOG JAXON METAL SAFE T PLASA 30MM 300F

MINCIOG JAXON METAL SAFE T PLASA 30MM 300F

pl-axmt300f
Stoc epuizat

179,00Lei

MINCIOG JAXON SAFE ALU 210F

MINCIOG JAXON SAFE ALU 210F

pl-axb210f
Stoc epuizat

100,00Lei

Minciog Carp Zoom Crap 2 Sec. 107x107x180cm

Minciog Carp Zoom Crap 2 Sec. 107x107x180cm

cz1611
Stoc epuizat

225,01Lei

Minciog Delphin mijloc din guma 2 tronsoane 70x70cm 200cm -30%

Minciog Delphin mijloc din guma 2 tronsoane 70x70cm 200cm

942420040
Stoc epuizat

86,00Lei(-30%) 60,00Lei

Minciog Delphin mijloc din metal cu plasa de guma 2 tronsoane 70x70cm 250cm

Minciog Delphin mijloc din metal cu plasa de guma 2 tronsoane 70x70cm 250cm

942415030
Stoc epuizat

115,80Lei

MINCIOG JAXON ECO 150

MINCIOG JAXON ECO 150

pl-axn150f
Stoc epuizat

79,00Lei

MINCIOG JAXON ECO 200

MINCIOG JAXON ECO 200

pl-axn200f
Stoc epuizat

89,00Lei

MINCIOG JAXON SAFE ALU 230F

MINCIOG JAXON SAFE ALU 230F

pl-axb230f
Stoc epuizat

107,00Lei

Minciog Energo Team Telescopic JAF Predator Rubberized 2.8m

Minciog Energo Team Telescopic JAF Predator Rubberized 2.8m

j1704063
Stoc epuizat

248,00Lei

MINCIOG PLIABIL JAXON SPLINE FISHING RUBBERIZED NET 2.40M 59X70CM

MINCIOG PLIABIL JAXON SPLINE FISHING RUBBERIZED NET 2.40M 59X70CM

pl-ab240x
Stoc epuizat

245,00Lei

MINCIOG DAIWA BLACK WIDOW 1.82M 100X100CM 1SEG

MINCIOG DAIWA BLACK WIDOW 1.82M 100X100CM 1SEG

a2.m11579.180
Stoc epuizat

294,64Lei

Afişare 181 - 200 din 231 (12 pagini)
Queries: 4, Total time: 11.201 ms [By time] [By id] [By file]
1 (0.151)
SELECT data
FROM `oc_session`
WHERE session_id = '4bacdb9577f92f1f297b573c5c'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.110)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (10.789)
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('+mincioguri +complete +feeder' 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.151)
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