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 FL Strategist 180 Coada 1 Segment Carbon 1.80M Deschidere 1M

Minciog FL Strategist 180 Coada 1 Segment Carbon 1.80M Deschidere 1M

4153212542182
Stoc epuizat

199,90Lei

Minciog FL Strategist 180K Coada 1 Segment Carbon 3K 1.80M Deschidere 1M

Minciog FL Strategist 180K Coada 1 Segment Carbon 3K 1.80M Deschidere 1M

2153218229492
Stoc epuizat

249,90Lei

Maner Minciog Preston Response Carp Handle 4 M

Maner Minciog Preston Response Carp Handle 4 M

p0230006
Stoc epuizat

404,96Lei

CAP TRABUCCO MINCIOG GNT BLACK EDITION MATCH FLUO 55X45

CAP TRABUCCO MINCIOG GNT BLACK EDITION MATCH FLUO 55X45

083-67-620
Stoc epuizat

96,00Lei

Maner Minciog FL Strategist 180K 1 Segment 1.80M

Maner Minciog FL Strategist 180K 1 Segment 1.80M

3153211821333
Stoc epuizat

132,90Lei

MANER JAXON MINCIOG TELE JAXON LM 4 M

MANER JAXON MINCIOG TELE JAXON LM 4 M

pl-afb400
Stoc epuizat

240,00Lei

CAP DELPHIN MINCIOG PLUTITOR ATOMA FLOATY 50X40 -26%

CAP DELPHIN MINCIOG PLUTITOR ATOMA FLOATY 50X40

101000430
Stoc epuizat

88,00Lei(-26%) 65,00Lei

CAP DELPHIN MINCIOG PLUTITOR ATOMA FLOATY 60X50 -26%

CAP DELPHIN MINCIOG PLUTITOR ATOMA FLOATY 60X50

101000431
Stoc epuizat

103,99Lei(-26%) 77,00Lei

CAP MINCIOG TRABUCCO GNT MATCH DUBLU CAUCIUCAT 38X45X30

CAP MINCIOG TRABUCCO GNT MATCH DUBLU CAUCIUCAT 38X45X30

083-69-110
Stoc epuizat

68,00Lei

Cap Minciog Trabucco Cauciucat XDS Power 40x30cm

Cap Minciog Trabucco Cauciucat XDS Power 40x30cm

083-69-710
Stoc epuizat

95,00Lei

Maner Minciog Carbon FL Toreador Telescopic 3M

Maner Minciog Carbon FL Toreador Telescopic 3M

5153210430756
Stoc epuizat

98,40Lei

Conector Magnetic DAM Minciog Cablu Siguranta

Conector Magnetic DAM Minciog Cablu Siguranta

601098420222
Stoc epuizat

41,53Lei

MINCIOG CARPZOOM ENTRANT CRAP 100x90x90 275cm

MINCIOG CARPZOOM ENTRANT CRAP 100x90x90 275cm

cz6055
Stoc epuizat

149,00Lei

MINCIOG CARPZOOM BIG CATCH CAUCIUCAT 65x80x100/240cm

MINCIOG CARPZOOM BIG CATCH CAUCIUCAT 65x80x100/240cm

cz5935
Stoc epuizat

241,00Lei

Maner Minciog Carbon FL Toreador Telescopic 3.5M

Maner Minciog Carbon FL Toreador Telescopic 3.5M

5153211303417
Stoc epuizat

119,90Lei

MANER MINCIOG TELESCOPIC TRABUCCO PRECISION CARP RESPONSE 3.10M

MANER MINCIOG TELESCOPIC TRABUCCO PRECISION CARP RESPONSE 3.10M

081-05-310
Stoc epuizat

185,00Lei

MANER MINCIOG KORUM POWER TELESCOPIC NET HANDLE 3M

MANER MINCIOG KORUM POWER TELESCOPIC NET HANDLE 3M

k0380002
Stoc epuizat

177,08Lei

Y Minciog Avid Spreader Block Carp CNC

Y Minciog Avid Spreader Block Carp CNC

a0610008
Stoc epuizat

94,46Lei

Maner Minciog Garbolino Express Put Over Net 2m

Maner Minciog Garbolino Express Put Over Net 2m

50230gomnj6053200-2
Stoc epuizat

89,23Lei

MINCIOG SAVAGE GEAR TELE PRO FOLDING DLX XL 70X85X70CM 105CM

MINCIOG SAVAGE GEAR TELE PRO FOLDING DLX XL 70X85X70CM 105CM

a2.sg.71105
Stoc epuizat

321,04Lei

Afişare 1021 - 1040 din 1362 (69 pagini)
Queries: 5, Total time: 39.411 ms [By time] [By id] [By file]
1 (0.134)
SELECT data
FROM `oc_session`
WHERE session_id = 'f7c54c20963be25b26b75c4a73'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.090)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (32.027)
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('+minciog' 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 (7.019)
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 1020, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.141)
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