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


Piket inox K-Karp 75 cm

Piket inox K-Karp 75 cm

192-10-075
Stoc epuizat

65,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

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

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

Buzz Bar Carp Expert Master Inox 31cm, 3 Posturi

Buzz Bar Carp Expert Master Inox 31cm, 3 Posturi

77045730
Stoc epuizat

150,73Lei

Pichet Telescopic Carp Expert Master Inox Stick, 50-80cm

Pichet Telescopic Carp Expert Master Inox Stick, 50-80cm

72151860
Stoc epuizat

154,00Lei

Buzz Bar Carp Expert Master Inox 31cm, 2 Posturi

Buzz Bar Carp Expert Master Inox 31cm, 2 Posturi

77045720
Stoc epuizat

137,04Lei

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

Pichet Telescopic Carp Expert Master Inox Stick, 80-140cm

Pichet Telescopic Carp Expert Master Inox Stick, 80-140cm

72151890
Stoc epuizat

191,89Lei

Amnar Victorinox Mini Tool, Fire Ant, Light Blue, 10buc/pac

Amnar Victorinox Mini Tool, Fire Ant, Light Blue, 10buc/pac

4.1331.2.10
Stoc epuizat

294,00Lei

Amnar Victorinox Mini Tool, Fire Ant, Light Green, 10buc/pac

Amnar Victorinox Mini Tool, Fire Ant, Light Green, 10buc/pac

4.1331.8.10
Stoc epuizat

294,00Lei

Amnar Victorinox Mini Tool, Fire Ant, Orange, 10buc/pac

Amnar Victorinox Mini Tool, Fire Ant, Orange, 10buc/pac

4.1331.1.10
Stoc epuizat

294,00Lei

Briceag Copii Victorinox 9.6092.1, 11.5x30.5x3cm

Briceag Copii Victorinox 9.6092.1, 11.5x30.5x3cm

9.6092.1
Stoc epuizat

59,00Lei

Briceag Multifunctional VICTORINOX Hunter, Rosu

Briceag Multifunctional VICTORINOX Hunter, Rosu

h.vx0.8573
Stoc epuizat

255,43Lei

Briceag Multifunctional VICTORINOX Huntsman, Rosu

Briceag Multifunctional VICTORINOX Huntsman, Rosu

h.vx1.3713
Stoc epuizat

204,03Lei

Afişare 1581 - 1600 din 1616 (81 pagini)
Queries: 10, Total time: 723.659 ms [By time] [By id] [By file]
1 (0.109)
SELECT data
FROM `oc_session`
WHERE session_id = '8944c35568833bf4861ca5fb37'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.080)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (722.518)
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 (pd.tag LIKE "%inox%") 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:725
4 (0.196)
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
5 (0.129)
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.132)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"AG COMEXIM SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
7 (0.108)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"AG COMEXIM SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
8 (0.105)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"AG COMEXIM SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
9 (0.107)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"AG COMEXIM SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
10 (0.175)
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