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


MANER MINCIOG COLMIC JAVIK NET 4.0M

MANER MINCIOG COLMIC JAVIK NET 4.0M

gxja01b
Stoc epuizat

210,00Lei

MANER MINCIOG JAXON ALUMINIU TELE UNIVERSAL 180CM

MANER MINCIOG JAXON ALUMINIU TELE UNIVERSAL 180CM

pl-han01
Stoc epuizat

62,00Lei

MANER MINCIOG MAVER MV-R COMERCIAL CARP 2.6M

MANER MINCIOG MAVER MV-R COMERCIAL CARP 2.6M

d360
Stoc epuizat

323,00Lei

MANER MINCIOG TELE 230cm

MANER MINCIOG TELE 230cm

tel2305
Stoc epuizat

270,00Lei

Maner Delphin ATOMA Feeder 400cm -34%

Maner Delphin ATOMA Feeder 400cm

941001575
Stoc epuizat

228,00Lei(-34%) 150,00Lei

MANER MINCIOG COLMIC EPIC 5.0M

MANER MINCIOG COLMIC EPIC 5.0M

gxep01b
Stoc epuizat

420,00Lei

Maner minciog Sportex Morion 1.80m 2 tronsoane

Maner minciog Sportex Morion 1.80m 2 tronsoane

ln145360
Stoc epuizat

610,01Lei

MANER MINCIOG COLMIC ERON PRO TELE 2.0M

MANER MINCIOG COLMIC ERON PRO TELE 2.0M

gxer50a
Stoc epuizat

92,00Lei

MANER MANCIOG JAXON HARMONY 2.3M

MANER MANCIOG JAXON HARMONY 2.3M

pl-af230
Stoc epuizat

91,00Lei

Maner Browning Minciog Black Magic T/A Power Handle 3.30m -24%

Maner Browning Minciog Black Magic T/A Power Handle 3.30m

7110330
Stoc epuizat

224,78Lei(-24%) 169,90Lei

Maner Delphin CHEREN 350cm 3 tronsoane

Maner Delphin CHEREN 350cm 3 tronsoane

941001400
Stoc epuizat

117,00Lei

Maner Minciog Benzar Carbon Neo Method 4m 3Seg

Maner Minciog Benzar Carbon Neo Method 4m 3Seg

71732400
Stoc epuizat

311,99Lei

Maner Minciog Delphin HACKER 210cm -25%

Maner Minciog Delphin HACKER 210cm

941100580
Stoc epuizat

127,00Lei(-25%) 95,50Lei

Galeata Benzar Nada 12L Maner Metalic Interior Gradat Rosie

Galeata Benzar Nada 12L Maner Metalic Interior Gradat Rosie

75097122
Stoc epuizat

21,00Lei

Maner Minciog Colmic Premium Net NX 5.70m

Maner Minciog Colmic Premium Net NX 5.70m

gxpr50b
Stoc epuizat

1.200,00Lei

Maner Minciog Colmic Ernest Tele 5.00m

Maner Minciog Colmic Ernest Tele 5.00m

gxer60c
Stoc epuizat

300,00Lei

MANER MINCIOG COLMIC HERAKLES TROUT AREA 65-123CM

MANER MINCIOG COLMIC HERAKLES TROUT AREA 65-123CM

guhan09
Stoc epuizat

103,99Lei

Maner Minciog DAM Sensomax II Tele 3.00m Landing Net Handle

Maner Minciog DAM Sensomax II Tele 3.00m Landing Net Handle

5010960839
Stoc epuizat

90,57Lei

MANER MINCIOG TRABUCCO WIZARD MINI NET TELE 2.00 M

MANER MINCIOG TRABUCCO WIZARD MINI NET TELE 2.00 M

080-71-200
Stoc epuizat

140,00Lei

Maner Minciog Carp Zoom FD Affect 3.30m

Maner Minciog Carp Zoom FD Affect 3.30m

cz5912
Stoc epuizat

189,00Lei

Afişare 281 - 300 din 352 (18 pagini)
Queries: 5, Total time: 10.774 ms [By time] [By id] [By file]
1 (0.074)
SELECT data
FROM `oc_session`
WHERE session_id = '108d15b832aa5aa935470d297e'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.115)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (8.737)
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('+maner' 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 (1.718)
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 280, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.130)
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