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 300 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 - Coast

Produse ce potrivesc criteriilor de căutare


Forceps NGT Large, 24.4cm

Forceps NGT Large, 24.4cm

ngt-fu-fc-10-c
Livrare imediată!

28,00Lei

PATENT COLMIC CRUSH DURALUMINIU XT 300
Exclusiv online!

PATENT COLMIC CRUSH DURALUMINIU XT 300

st99
Livrare 48-72 ore

189,00Lei

PENSETA JAXON INOX 10CM
Exclusiv online!

PENSETA JAXON INOX 10CM

ac-3101
Livrare 48-72 ore

29,00Lei

Pensa Lunga Dreapta EnergoTeam 25cm

Pensa Lunga Dreapta EnergoTeam 25cm

79590025
Livrare imediată!

36,00Lei

Cleste Spro Straight Nose S Cutter 16cm
Exclusiv online!

Cleste Spro Straight Nose S Cutter 16cm

004702-00161-00000
Livrare 48-72 ore

69,31Lei

FOARFECA FIRE JAXON
Exclusiv online!

FOARFECA FIRE JAXON

aj-ns17a
Livrare 48-72 ore

26,00Lei

FOARFECA HEAVY DUTY CARP ZOOM
Exclusiv online!

FOARFECA HEAVY DUTY CARP ZOOM

cz3643
Livrare 48-72 ore

29,00Lei

PENSA CURBATA FOARFECA CORMORAN 19 CM

PENSA CURBATA FOARFECA CORMORAN 19 CM

a.84.10019
Livrare imediată!

32,09Lei

Pensta Cleste Cormoran pentru Inele Despicate 16.5cm

Pensta Cleste Cormoran pentru Inele Despicate 16.5cm

a.84.11001
Livrare imediată!

36,72Lei

PATENT RAPALA CURBAT 16.5CM

PATENT RAPALA CURBAT 16.5CM

rcpc6
Livrare imediată!

49,00Lei

Cleste Jaxon pentru bride -22%

Cleste Jaxon pentru bride

aj-ft106
Livrare imediată!

60,00Lei(-22%) 46,90Lei

Cleste Carp Zoom MFA-1 16.5cm -30%
Exclusiv online!

Cleste Carp Zoom MFA-1 16.5cm

cz8335
Livrare 48-72 ore

141,00Lei(-30%) 98,70Lei

CLESTE, JAXON, CLIMPER, PENTRU, SERTIZAT, BRIDE, 16CM, aj-ft203, Clesti Patenti Pense, Clesti Patenti Pense Jaxon, Jaxon
PENSETA JAXON INOX 12.5CM
Exclusiv online!

PENSETA JAXON INOX 12.5CM

ac-3103
Livrare 48-72 ore

30,00Lei

CLESTE CUDA TITANIUM NITRIDE BONDED PLIER + HUSA, 20CM
Exclusiv online!

CLESTE CUDA TITANIUM NITRIDE BONDED PLIER + HUSA, 20CM

80950837
Livrare 24-48 ore

219,00Lei

Forceps Spro 16cm
Exclusiv online!

Forceps Spro 16cm

004702-00160-00000
Livrare 48-72 ore

67,40Lei

Cleste Savage Gear Pistol Deep Throat Hook Out 22.5cm
Exclusiv online!

Cleste Savage Gear Pistol Deep Throat Hook Out 22.5cm

a.sg.43845
Livrare 24-48 ore

88,21Lei

CLESTE CUDA TITANIUM NITRIDE BONDED RING SPLITTER, 22CM
Exclusiv online!

CLESTE CUDA TITANIUM NITRIDE BONDED RING SPLITTER, 22CM

80950838
Livrare 24-48 ore

119,00Lei

PENSA DREAPTA FOARFECA CORMORAN 18 CM

PENSA DREAPTA FOARFECA CORMORAN 18 CM

a.84.10018
Livrare imediată!

32,09Lei

Rapala, Forfecuta, Retractabila, , rsls, Clesti Patenti Pense, Clesti Patenti Pense Rapala, Rapala -38%

Rapala, Forfecuta, Retractabila, , rsls, Clesti Patenti Pense, Clesti Patenti Pense Rapala, Rapala

rsls
Livrare imediată!

39,00Lei(-38%) 24,00Lei

Afişare 61 - 80 din 292 (15 pagini)
Queries: 6, Total time: 213.608 ms [By time] [By id] [By file]
1 (0.099)
SELECT data
FROM `oc_session`
WHERE session_id = 'd25f0b8c715692a8d16952ee09'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.126)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:427
3 (0.128)
SELECT *
FROM oc_url_alias
WHERE keyword = 'search'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (211.541)
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` GROUP BY tax_class_id) AS tx ON (p.tax_class_id = tx.tax_class_id)
WHERE p2s.store_id = '0' AND ((pd.tag LIKE '%clesti%' AND pd.tag LIKE '%patenti%' AND pd.tag LIKE '%pense%')) 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:698
5 (1.575)
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 60, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
6 (0.139)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '0' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38