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 - vu.2.5878

Produse ce potrivesc criteriilor de căutare


PICHET INOX CARP SPIRIT BORA POINT 300 - 12 -35%

PICHET INOX CARP SPIRIT BORA POINT 300 - 12

acs370031
Stoc epuizat

199,00Lei(-35%) 129,35Lei

Piket inox K-Karp 75 cm

Piket inox K-Karp 75 cm

192-10-075
Stoc epuizat

65,00Lei

DEGORJOR JAXON INOX 17CM

DEGORJOR JAXON INOX 17CM

ac-3203
Stoc epuizat

10,00Lei

PENSETA JAXON INOX CURBATA 10CM

PENSETA JAXON INOX CURBATA 10CM

ac-3102
Stoc epuizat

29,00Lei

Agrafa VMC Tournament cu Vartej Inox Nr.5 3buc/plic

Agrafa VMC Tournament cu Vartej Inox Nr.5 3buc/plic

sstss#5
Stoc epuizat

7,20Lei

MIXER NADA NuFish INOX WSK

MIXER NADA NuFish INOX WSK

5035305802160
Stoc epuizat

159,00Lei

PENSETA JAXON INOX CURBATA 12.5CM

PENSETA JAXON INOX CURBATA 12.5CM

ac-3104
Stoc epuizat

30,00Lei

Agrafa VMC Tournament cu Vartej Inox Nr.4 3buc/plic

Agrafa VMC Tournament cu Vartej Inox Nr.4 3buc/plic

sstss#4
Stoc epuizat

8,29Lei

PIQUET LANSETA INOX TRAKKO 50 cm

PIQUET LANSETA INOX TRAKKO 50 cm

tr349650
Stoc epuizat

75,01Lei

Buzz Bar Trakko inox 22cm 2 posturi

Buzz Bar Trakko inox 22cm 2 posturi

tr3366-22cm
Stoc epuizat

36,00Lei

Mulineta Delphin INOX 80D 0.30mm/610m -35%

Mulineta Delphin INOX 80D 0.30mm/610m

101000969
Stoc epuizat

507,00Lei(-35%) 328,40Lei

CROSETA INOX DE LUXE MOSTIRO 1 BUC

CROSETA INOX DE LUXE MOSTIRO 1 BUC

4090
Stoc epuizat

6,60Lei

Mulineta Delphin INOX 70D 0.30mm/410m -39%

Mulineta Delphin INOX 70D 0.30mm/410m

101000968
Stoc epuizat

487,00Lei(-39%) 295,00Lei

BURGHIU INOX DE LUXE MOSTIRO 1 BUC

BURGHIU INOX DE LUXE MOSTIRO 1 BUC

4089
Stoc epuizat

8,20Lei

Cleste Carp Zoom Pentru Jupuit Peste, Inox

Cleste Carp Zoom Pentru Jupuit Peste, Inox

cz2339
Stoc epuizat

22,00Lei

Rasnita pentru Cafea Helikon Tex Inox

Rasnita pentru Cafea Helikon Tex Inox

ac-hcg-ss-15
Stoc epuizat

125,00Lei

Snagears JRC Extreme TXS Snag Ears, Inox

Snagears JRC Extreme TXS Snag Ears, Inox

1503035
Stoc epuizat

90,33Lei

Inele Despicate Stonfo Inox 204, 10kg, Marima 1, 10buc

Inele Despicate Stonfo Inox 204, 10kg, Marima 1, 10buc

8028651010775
Stoc epuizat

9,00Lei

Inele Despicate Stonfo Inox 204, 25kg, Marima 2, 10buc

Inele Despicate Stonfo Inox 204, 25kg, Marima 2, 10buc

8028651010782
Stoc epuizat

9,00Lei

Inele Despicate Stonfo Inox, Marima 3, 10buc

Inele Despicate Stonfo Inox, Marima 3, 10buc

8028651010799
Stoc epuizat

9,00Lei

Afişare 121 - 140 din 145 (8 pagini)
Queries: 8, Total time: 5.480 ms [By time] [By id] [By file]
1 (0.112)
SELECT data
FROM `oc_session`
WHERE session_id = '51d6ae8f197b2ff015e48d1992'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.122)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (3.928)
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('+inox' 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.811)
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 120, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.131)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"RAPALA VMC ROMANIA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
6 (0.127)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"RAPALA VMC ROMANIA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
7 (0.120)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"RAPALA VMC ROMANIA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
8 (0.129)
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