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


Pantofi Sport Okuma Light, Marime 38
Exclusiv online!

Pantofi Sport Okuma Light, Marime 38

a8.okr.h001k.38
Livrare 24-48 ore

138,39Lei

Pantofi Sport Savage Urban, Marime 43 -22%
Exclusiv online!

Pantofi Sport Savage Urban, Marime 43

a8.sg.64955
Livrare 24-48 ore

236,23Lei(-22%) 184,97Lei

Pantofi Sport Savage Urban, Marime 42 -22%
Exclusiv online!

Pantofi Sport Savage Urban, Marime 42

a8.sg.64954
Livrare 24-48 ore

236,23Lei(-22%) 184,97Lei

Pantofi Sport Savage Urban, Marime 41 -22%
Exclusiv online!

Pantofi Sport Savage Urban, Marime 41

a8.sg.64953
Livrare 24-48 ore

236,23Lei(-22%) 184,97Lei

PANTALONI Maver UK SPORT PERFORMANCE 2 MAVER XXL
Exclusiv online!

PANTALONI Maver UK SPORT PERFORMANCE 2 MAVER XXL

n1314
Livrare 48-72 ore

179,00Lei

Pantofi Nash Water Shoe UK Marime 43

Pantofi Nash Water Shoe UK Marime 43

c5532
Livrare imediată!

169,99Lei

Pantofi Nash Water Shoe UK Marime 41

Pantofi Nash Water Shoe UK Marime 41

c5530
Livrare imediată!

169,99Lei

Pantofi Nash Water Shoe UK Marime 42 -47%

Pantofi Nash Water Shoe UK Marime 42

c5531
Livrare imediată!

169,99Lei(-47%) 90,50Lei

Pantofi Nash Water Shoe UK Marime 44 -47%

Pantofi Nash Water Shoe UK Marime 44

c5533
Livrare imediată!

169,99Lei(-47%) 90,50Lei

INCALTAMINTE SAVAGE URBAN MARIME 45 -22%
Exclusiv online!

INCALTAMINTE SAVAGE URBAN MARIME 45

a8.sg.64957
Livrare 24-48 ore

236,23Lei(-22%) 184,97Lei

Adidasi Fox Olive Trainers, Marime 43

Adidasi Fox Olive Trainers, Marime 43

cfw146
Livrare imediată!

246,00Lei

Adidasi Fox Olive Trainers, Marime 42

Adidasi Fox Olive Trainers, Marime 42

cfw145
Livrare imediată!

247,46Lei

Adidasi Fox Olive Trainers, Marime 45
Exclusiv online!

Adidasi Fox Olive Trainers, Marime 45

cfw148
Livrare 7-14 zile

246,00Lei

Pantofi RidgeMonkey Dropback Aqua Shoes Black Size UK10 Marime 44-45 -10%

Pantofi RidgeMonkey Dropback Aqua Shoes Black Size UK10 Marime 44-45

rm dbas b10
Livrare imediată!

148,45Lei(-10%) 133,61Lei

Ochelari Polarizati Daiwa Sport, Lentila Galbena
Exclusiv online!

Ochelari Polarizati Daiwa Sport, Lentila Galbena

d.df005y
Livrare 24-48 ore

129,22Lei

Ochelari Polarizati Daiwa Sport, Lentila Gri
Exclusiv online!

Ochelari Polarizati Daiwa Sport, Lentila Gri

d.df005b
Livrare 24-48 ore

129,22Lei

Adidasi Savage Gear Freestyle Sneakers, Pearl Grey, Marime 42
Exclusiv online!

Adidasi Savage Gear Freestyle Sneakers, Pearl Grey, Marime 42

a8.sg.1611203
Livrare 24-48 ore

378,96Lei

Barca Cortina 620 Sport Fara Motor, 620x256x130m
Exclusiv online!

Barca Cortina 620 Sport Fara Motor, 620x256x130m

1187243722971
Livrare 30-60 zile

142.500,00Lei

Pantofi SAVAGE GEAR Cool Step, Indian Blue, Marime 42
Exclusiv online!

Pantofi SAVAGE GEAR Cool Step, Indian Blue, Marime 42

a8.sg.1611197
Livrare 24-48 ore

189,41Lei

Pantofi SAVAGE GEAR Cool Step, Indian Blue, Marime 43
Exclusiv online!

Pantofi SAVAGE GEAR Cool Step, Indian Blue, Marime 43

a8.sg.1611198
Livrare 24-48 ore

189,41Lei

Afişare 21 - 40 din 66 (4 pagini)
Queries: 5, Total time: 3.343 ms [By time] [By id] [By file]
1 (0.120)
SELECT data
FROM `oc_session`
WHERE session_id = '8abc4544d909b074abf05c0e03'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.102)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (2.521)
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('+sport' 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.472)
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 20, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.128)
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