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

Produse ce potrivesc criteriilor de căutare


MOMITOR MAVER PRO-FEEDER RACK OPEN END 70GR -30%
Exclusiv online!

MOMITOR MAVER PRO-FEEDER RACK OPEN END 70GR

179370
Livrare 48-72 ore

21,00Lei(-30%) 14,70Lei

VOBLER STRIKE PRO BABY PRO 2,5CM/2G 046
Exclusiv online!

VOBLER STRIKE PRO BABY PRO 2,5CM/2G 046

sp.eg036.046
Livrare 24-48 ore

30,71Lei

MOMITOR PROLOGIC S 6X11MM 15BUC/PLIC

MOMITOR PROLOGIC S 6X11MM 15BUC/PLIC

a.pro.49948
Livrare imediată!

21,50Lei

Vobler Rapture Pro Shiver, Sinking, Ghost Ayu, 7cm, 13g -18%

Vobler Rapture Pro Shiver, Sinking, Ghost Ayu, 7cm, 13g

180-19-604
Livrare imediată!

34,00Lei(-18%) 27,91Lei

LANSETA PROLOGIC 2BUC C1 AVENGER 3,60M/3,25LBS -40%
Exclusiv online!

LANSETA PROLOGIC 2BUC C1 AVENGER 3,60M/3,25LBS

o.pro.64139
Livrare 24-48 ore

460,54Lei(-40%) 276,33Lei

COADA DE SCHIMB STRIKE PRO PT. WOLF TAIL JR. RED
Exclusiv online!

COADA DE SCHIMB STRIKE PRO PT. WOLF TAIL JR. RED

sp.eg175t.reg
Livrare 24-48 ore

23,63Lei

Lanseta Fox EOS Pro Tele 3.60m 3.5lb 6seg -20%

Lanseta Fox EOS Pro Tele 3.60m 3.5lb 6seg

crd332
Livrare imediată!

357,80Lei(-20%) 286,90Lei

ELASTIC MAVER DUAL CORE PRO MATCH 1.50MM 5M
Exclusiv online!

ELASTIC MAVER DUAL CORE PRO MATCH 1.50MM 5M

3017002
Livrare 48-72 ore

113,00Lei

Vobler Strike Pro Cranky SS A142-264 4cm 3.7g
Exclusiv online!

Vobler Strike Pro Cranky SS A142-264 4cm 3.7g

sp.eg164sl.a142.264
Livrare 24-48 ore

31,02Lei

Lanseta EnergoTeam LK Pro Guide 1.98m 2-10g MEDIUM LIGHT
Exclusiv online!

Lanseta EnergoTeam LK Pro Guide 1.98m 2-10g MEDIUM LIGHT

13149398
Livrare 24-48 ore

302,00Lei

VOBLER STRIKE PRO FLOATING, 953S CANDY CRANK, 4CM, 3.1G
Exclusiv online!

VOBLER STRIKE PRO FLOATING, 953S CANDY CRANK, 4CM, 3.1G

sp.eg202.953s
Livrare 24-48 ore

37,96Lei

CANTAR PROLOGIC SPECIMEN DIAL 27KG -20%

CANTAR PROLOGIC SPECIMEN DIAL 27KG

a.pro.64108
Livrare imediată!

131,05Lei(-20%) 104,84Lei

FIR MONOFILAMENT PROLOGIC XLNT HP GREEN 1000M 0.28MM -40%
Exclusiv online!

FIR MONOFILAMENT PROLOGIC XLNT HP GREEN 1000M 0.28MM

a.pro.57100
Livrare 24-48 ore

70,38Lei(-40%) 42,23Lei

LINGURA JAXON HR PRO SPIN DOUBLE HKX 2C 25GR
Exclusiv online!

LINGURA JAXON HR PRO SPIN DOUBLE HKX 2C 25GR

bw-hkx2c
Livrare 48-72 ore

12,50Lei

MOMITOR MAVER PRO-FEEDER PLASTIC GRIP MESH 40GR -30%
Exclusiv online!

MOMITOR MAVER PRO-FEEDER PLASTIC GRIP MESH 40GR

179140
Livrare 48-72 ore

14,70Lei(-30%) 10,31Lei

LANSETA PROLOGIC 2BUC C2 ELEMENT XD 3,60M/3,5LBS -20%
Exclusiv online!

LANSETA PROLOGIC 2BUC C2 ELEMENT XD 3,60M/3,5LBS

o.pro.64128
Livrare 24-48 ore

605,38Lei(-20%) 484,29Lei

Jacheta Prologic Impermeabila Bank Bound Trek L -43%
Exclusiv online!

Jacheta Prologic Impermeabila Bank Bound Trek L

a8.pro.62338
Livrare 24-48 ore

353,12Lei(-43%) 201,26Lei

Carlige Trabucco Pro Sword 120 Numarul 14
Exclusiv online!

Carlige Trabucco Pro Sword 120 Numarul 14

020-12-014
Livrare 48-72 ore

18,00Lei

Lanseta EnergoTeam LK Pro Guide 1.98m 2-10g MEDIUM
Exclusiv online!

Lanseta EnergoTeam LK Pro Guide 1.98m 2-10g MEDIUM

13149498
Livrare 24-48 ore

301,00Lei

VOBLER STRIKE PRO CRANKY DEEP, A47FL, 4CM, 4.6G
Exclusiv online!

VOBLER STRIKE PRO CRANKY DEEP, A47FL, 4CM, 4.6G

sp.eg164l.a47fl
Livrare 24-48 ore

34,70Lei

Afişare 1821 - 1840 din 3887 (195 pagini)
Queries: 10, Total time: 148.100 ms [By time] [By id] [By file]
1 (0.100)
SELECT data
FROM `oc_session`
WHERE session_id = '1fae718d0da43844720c8ca072'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.104)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (96.184)
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('+pro' 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.353)
SELECT COUNT(1) AS total
FROM ( SELECT p.*
FROM `oc_bf_tmp_product` AS p
WHERE match_filters = 1) AS t
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1561
5 (14.844)
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 1820, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
6 (2.614)
SELECT DISTINCT m.manufacturer_id AS id, CONCAT(UCASE(LEFT(m.name, 1)), LCASE(SUBSTRING(m.name, 2))) AS name
FROM `oc_manufacturer` AS m
INNER JOIN `oc_bf_tmp_product` AS p ON (m.manufacturer_id = p.manufacturer_id)
WHERE match_filters = 1
ORDER BY m.sort_order, m.name
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:1248
7 (0.077)
SELECT stock_status_id AS id, name
FROM `oc_stock_status`
WHERE language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:1270
8 (0.645)
SELECT MIN(actual_price) AS min, MAX(actual_price) AS max
FROM `oc_bf_tmp_product` AS p
WHERE match_filters = 1
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:1035
9 (33.007)
SELECT COUNT(1) AS val, filter_group, filter_id
FROM `oc_bf_tmp_product` AS p
INNER JOIN `oc_bf_filter` AS f ON (p.product_id = f.product_id)
WHERE match_filters = 1 AND f.language_id = '2' GROUP BY filter_group, filter_id
/var/www/clients/client1/web1/web/catalog/model/module/brainyfilter.php:949
10 (0.172)
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