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


SITA ATTACK DIAM 38 CM 4mm
Exclusiv online!

SITA ATTACK DIAM 38 CM 4mm

ai-bm10d-38-4
Livrare 48-72 ore

49,00Lei

Umbrela Rive Aqua Parasol Diam. 2.10m
Exclusiv online!

Umbrela Rive Aqua Parasol Diam. 2.10m

90110340520
Livrare 48-72 ore

664,54Lei

ROLE COLMIC EVA MONTURI Diam: 5cm 1Buc/Plic

ROLE COLMIC EVA MONTURI Diam: 5cm 1Buc/Plic

eva02
Livrare imediată!

2,00Lei

Apicale Sensas Ptfe Bush External Diam 2.0mm
Exclusiv online!

Apicale Sensas Ptfe Bush External Diam 2.0mm

se23984
Livrare 24-48 ore

9,50Lei

Juvelnic EnergoTeam 3 inele diam 30cm PT-33

Juvelnic EnergoTeam 3 inele diam 30cm PT-33

72100003
Livrare imediată!

16,01Lei

Apicale Sensas Ptfe Bush External Diam 1.8mm

Apicale Sensas Ptfe Bush External Diam 1.8mm

se23983
Livrare imediată!

9,50Lei

Juvelnic EnergoTeam 5 inele diam 30cm PT-35

Juvelnic EnergoTeam 5 inele diam 30cm PT-35

72100005
Livrare imediată!

21,00Lei

INEL ENERGOTEAM DOUA TALPI TRIUNGHIULARE SIC DIAM 20
Exclusiv online!

INEL ENERGOTEAM DOUA TALPI TRIUNGHIULARE SIC DIAM 20

81017020
Livrare 24-48 ore

8,50Lei

JUVELNIC ENERGO TEAM 6 INELE DIAM 30CM

JUVELNIC ENERGO TEAM 6 INELE DIAM 30CM

72100006
Livrare imediată!

23,00Lei

Juvelnic EnergoTeam 4 inele diam 40cm PT-44
Exclusiv online!

Juvelnic EnergoTeam 4 inele diam 40cm PT-44

72101004
Livrare 24-48 ore

24,00Lei

Juvelnic EnergoTeam 4 inele diam 30cm PT-34
Exclusiv online!

Juvelnic EnergoTeam 4 inele diam 30cm PT-34

72100004
Livrare 24-48 ore

20,00Lei

Juvelnic EnergoTeam 3 inele diam 40cm PT-43
Exclusiv online!

Juvelnic EnergoTeam 3 inele diam 40cm PT-43

72101003
Livrare 24-48 ore

21,00Lei

Juvelnic EnergoTeam 5 inele diam 40cm PT-45

Juvelnic EnergoTeam 5 inele diam 40cm PT-45

72101005
Livrare imediată!

28,00Lei

Juvelnic EnergoTeam 7 inele diam 40cm PT-47
Exclusiv online!

Juvelnic EnergoTeam 7 inele diam 40cm PT-47

72100007
Livrare 24-48 ore

31,00Lei

ROLE COLMIC EVA MONTURI Diam: 4cm 1Buc/Plic
Exclusiv online!

ROLE COLMIC EVA MONTURI Diam: 4cm 1Buc/Plic

eva01
Livrare 48-72 ore

2,00Lei

Umbrela Shimano Aero Pro 50in Nylon Umbrella, Diam=250cm -31%

Umbrela Shimano Aero Pro 50in Nylon Umbrella, Diam=250cm

sharpumb01
Stoc epuizat

700,01Lei(-31%) 485,00Lei

Opritoare Spirala STONFO Molla Di Stop 276-0, Size 0, Diam. 0.20mm, 6buc/pac

Opritoare Spirala STONFO Molla Di Stop 276-0, Size 0, Diam. 0.20mm, 6buc/pac

8028651010638
Stoc epuizat

15,01Lei

Bilute Culisante STONFO Beads Matchplus 453-26, Dimesniune 2, Diam 2.6mm, 24buc/pac
Opritoare Spirala STONFO Molla Di Stop 276-1, Size 1, Diam. 0.30mm, 6buc/pac

Opritoare Spirala STONFO Molla Di Stop 276-1, Size 1, Diam. 0.30mm, 6buc/pac

8028651010645
Stoc epuizat

15,01Lei

Bilute Culisante STONFO Beads Matchplus 453-20, Dimesniune 1, Diam 2.0mm, 24buc/pac
Afişare 1 - 20 din 28 (2 pagini)
Queries: 7, Total time: 2.236 ms [By time] [By id] [By file]
1 (0.122)
SELECT data
FROM `oc_session`
WHERE session_id = '1ac2bef06d62f6df178ad4f739'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.105)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (0.127)
SELECT *
FROM oc_url_alias
WHERE keyword = 'search'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (1.284)
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('+diam' 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
5 (0.341)
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 0, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
6 (0.134)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"ROM-EUROTRADE SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
7 (0.123)
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