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

Produse ce potrivesc criteriilor de căutare


Saltea primire Baracuda HYM001 104x78x2.5cm

Saltea primire Baracuda HYM001 104x78x2.5cm

saltea crap profesionala hym001
Livrare imediată!

148,05Lei

Juvelnic Mikado Profesional Patrat Method Feeder 60/50cm-50/40cm 400cm
Exclusiv online!

Juvelnic Mikado Profesional Patrat Method Feeder 60/50cm-50/40cm 400cm

s15-001-400
Livrare 48-72 ore

374,01Lei

Forfecuta Victorinox Rubis Profesionala Pentru Cuticule, 8.9cm, Otel, Argintiu
Exclusiv online!

Forfecuta Victorinox Rubis Profesionala Pentru Cuticule, 8.9cm, Otel, Argintiu

8.2082.09
Livrare 48-72ore

207,00Lei

Forfecuta Victorinox Rubis Profesionala Pentru Cuticule, 9cm, Otel, Argintiu
Exclusiv online!

Forfecuta Victorinox Rubis Profesionala Pentru Cuticule, 9cm, Otel, Argintiu

8.2081.09
Livrare 48-72ore

207,00Lei

TREPIED CANTARIRE MIVARDI PROFESIONAL

TREPIED CANTARIRE MIVARDI PROFESIONAL

m-wppro
Livrare imediată!

259,00Lei

PAT MIVARDI PROFESIONAL 8 PICIOARE 140KG

PAT MIVARDI PROFESIONAL 8 PICIOARE 140KG

m-bchpro8
Livrare imediată!

969,01Lei

MANER MINCIOG MIVARDI PROFESIONAL TWIN CARBON 1.80MT 2 SEGMENTE

MANER MINCIOG MIVARDI PROFESIONAL TWIN CARBON 1.80MT 2 SEGMENTE

miv-lnhprt
Livrare imediată!

183,00Lei

MASA PENTRU RULAT BOILIE CARP ZOOM PROFESIONAL 14mm 50x25cm
Exclusiv online!

MASA PENTRU RULAT BOILIE CARP ZOOM PROFESIONAL 14mm 50x25cm

cz1234
Livrare 48-72 ore

167,00Lei

MASA PENTRU RULAT BOILIE CARP ZOOM PROFESIONAL 30mm 50x25cm
Exclusiv online!

MASA PENTRU RULAT BOILIE CARP ZOOM PROFESIONAL 30mm 50x25cm

cz1272
Livrare 48-72 ore

167,00Lei

MASA PENTRU RULAT BOILIE CARP ZOOM PROFESIONAL 18mm 50x25cm
Exclusiv online!

MASA PENTRU RULAT BOILIE CARP ZOOM PROFESIONAL 18mm 50x25cm

cz1241
Livrare 48-72 ore

167,00Lei

MASA PENTRU RULAT BOILIE CARP ZOOM PROFESIONAL 24mm 50x25cm
Exclusiv online!

MASA PENTRU RULAT BOILIE CARP ZOOM PROFESIONAL 24mm 50x25cm

cz1265
Livrare 48-72 ore

167,00Lei

MASA PENTRU RULAT BOILIE CARP ZOOM PROFESIONAL 20mm 50x25cm
Exclusiv online!

MASA PENTRU RULAT BOILIE CARP ZOOM PROFESIONAL 20mm 50x25cm

cz1258
Livrare 48-72 ore

167,00Lei

Croseta Lineaeffe Profesionala Boilies

Croseta Lineaeffe Profesionala Boilies

a.4990223
Livrare imediată!

12,40Lei

MASA PENTRU RULAT BOILIE CARP ZOOM PROFESIONAL 8mm 50x25cm

MASA PENTRU RULAT BOILIE CARP ZOOM PROFESIONAL 8mm 50x25cm

cz1227
Livrare imediată!

167,00Lei

SET SOMN ENERGO TEAM LK SPINNING PROFESIONAL
Exclusiv online!

SET SOMN ENERGO TEAM LK SPINNING PROFESIONAL

12045501
Livrare 24-48 ore

765,00Lei

NADA PROFESIONALA ARROW CU AROMA DE VANILIE 1KG

NADA PROFESIONALA ARROW CU AROMA DE VANILIE 1KG

a0.p.nad.pro.van
Stoc epuizat

10,63Lei

Cort Mivardi Profesional 2 pers

Cort Mivardi Profesional 2 pers

m-bivpr
Stoc epuizat

1.920,01Lei

Winterskin Mivardi Profesional

Winterskin Mivardi Profesional

m-bivpro
Stoc epuizat

999,01Lei

PLIOR MIKADO PROFESIONAL 19CM 5buc

PLIOR MIKADO PROFESIONAL 19CM 5buc

am-sig-001-19
Stoc epuizat

18,00Lei

Afişare 1 - 19 din 19 (1 pagini)
Queries: 9, Total time: 212.556 ms [By time] [By id] [By file]
1 (0.170)
SELECT data
FROM `oc_session`
WHERE session_id = '5e2bf25290d6d9424d6c8a13bf'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.147)
SELECT *
FROM oc_platforma_promovari LIMIT 1
/var/www/clients/client1/web1/web/index.php:128
3 (0.083)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:422
4 (211.656)
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 "%profesional%") 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 (0.136)
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
6 (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
7 (0.091)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
8 (0.081)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
9 (0.085)
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