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


LANSETA SPORTEX HYPERION XT 2.40M 26-48G -30%

LANSETA SPORTEX HYPERION XT 2.40M 26-48G

hp2412
Livrare imediată!

1.868,00Lei(-30%) 1.308,00Lei

SUPORT SPRO C-TEC INCARCAT LANSETA

SUPORT SPRO C-TEC INCARCAT LANSETA

003901-00012-00000
Livrare imediată!

11,00Lei

Lanseta Nevis Vanity Carp Picker 3.00m 20-50g -25%

Lanseta Nevis Vanity Carp Picker 3.00m 20-50g

1843-302
Livrare imediată!

249,00Lei(-25%) 186,79Lei

Lanseta Lineaeffe Tele GMX 4.20m, 200g

Lanseta Lineaeffe Tele GMX 4.20m, 200g

l.2283444
Livrare imediată!

281,68Lei

Lanseta Daiwa Emblem XT Carp 3.60m 3.00lbs 2seg
Exclusiv online!

Lanseta Daiwa Emblem XT Carp 3.60m 3.00lbs 2seg

d.11576.365
Livrare 24-48 ore

565,42Lei

Lanseta DAM Sensomax II Light Feeder 3.60m 25-75gr

Lanseta DAM Sensomax II Light Feeder 3.60m 25-75gr

2050966319
Livrare imediată!

296,37Lei

Suport Lanseta Telescopic Energo Team Aluminiu 60/110cm

Suport Lanseta Telescopic Energo Team Aluminiu 60/110cm

72149110
Livrare imediată!

18,00Lei

Lanseta Cormoran BIG CAT LONG RANGE 3.00M/200-600G 2SEG -23%

Lanseta Cormoran BIG CAT LONG RANGE 3.00M/200-600G 2SEG

c.20.1600305
Livrare imediată!

342,42Lei(-23%) 263,89Lei

Lanseta Prologic Tele C1 Alpha 3.60m 3.00lbs
Exclusiv online!

Lanseta Prologic Tele C1 Alpha 3.60m 3.00lbs

o.pro.57192
Livrare 24-48 ore

350,10Lei

Lanseta Feeder Benzar Concourse Method Feeder 3.60m 30-120g
Exclusiv online!

Lanseta Feeder Benzar Concourse Method Feeder 3.60m 30-120g

12345360
Livrare 24-48 ore

1.000,00Lei

Lanseta Mivardi Magion Feeder, 3.90m, 50g-100g, 3PLUS2buc

Lanseta Mivardi Magion Feeder, 3.90m, 50g-100g, 3PLUS2buc

miv-maf390h
Livrare imediată!

299,99Lei

Lanseta Nevis Vanity Carp Feeder H 3.90m 45-130g

Lanseta Nevis Vanity Carp Feeder H 3.90m 45-130g

1843-391
Livrare imediată!

293,00Lei

Lanseta Telescopica Daiwa Black Widow Feeder 3.90m 150g 7+2SEG
Exclusiv online!

Lanseta Telescopica Daiwa Black Widow Feeder 3.90m 150g 7+2SEG

d.11574.395
Livrare 24-48 ore

394,94Lei

Lanseta WIZARD DROP SHOT 2.10M 5-20G

Lanseta WIZARD DROP SHOT 2.10M 5-20G

13188210
Livrare imediată!

157,00Lei

Lanseta Baracuda Evolution Feeder 3903 3.90M 120g 3seg

Lanseta Baracuda Evolution Feeder 3903 3.90M 120g 3seg

evolution feeder 3903
Livrare imediată!

191,90Lei

LANSETA TELESCOPICA COLMIC TARGET BOAT 3.00M 50-250GR

LANSETA TELESCOPICA COLMIC TARGET BOAT 3.00M 50-250GR

cata82e
Livrare imediată!

330,00Lei

SUPORT LANSETA CARP ZOOM CU BLOCAJ

SUPORT LANSETA CARP ZOOM CU BLOCAJ

cz1175
Livrare imediată!

32,00Lei

Lanseta Daiwa Black Widow Exttention Carp 3.00m 3.5lbs 2seg

Lanseta Daiwa Black Widow Exttention Carp 3.00m 3.5lbs 2seg

d.11578.305
Livrare imediată!

254,87Lei

LANSETA CARP EXPERT BLACK SHADOW TELECARP IM10 3.60M 3.5LB
Exclusiv online!

LANSETA CARP EXPERT BLACK SHADOW TELECARP IM10 3.60M 3.5LB

13391360
Livrare 24-48 ore

224,01Lei

Lanseta Mivardi Nuclear Carp 3.90m, 3.50lbs, 2buc
Exclusiv online!

Lanseta Mivardi Nuclear Carp 3.90m, 3.50lbs, 2buc

miv-nucc390sh2
Livrare 48-72 ore

429,99Lei

Afişare 2721 - 2740 din 8583 (430 pagini)
Queries: 5, Total time: 277.018 ms [By time] [By id] [By file]
1 (0.078)
SELECT data
FROM `oc_session`
WHERE session_id = '7e65571497e1ea11356bfcd9b2'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.082)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (234.550)
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('+lanseta' 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 (42.090)
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 2720, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.218)
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