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 bolognesa Maver Easy 4m

Lanseta bolognesa Maver Easy 4m

5764400
Stoc epuizat

249,00Lei

Lanseta bolognesa Maver Superlithium Power MX 6m

Lanseta bolognesa Maver Superlithium Power MX 6m

5796600
Stoc epuizat

2.010,01Lei

Lanseta bolognesa Maver Superlithium Light MX 8m

Lanseta bolognesa Maver Superlithium Light MX 8m

5794800
Stoc epuizat

3.420,00Lei

HUSA LANSETE KORDA COMPAC 3 LANSETE 3.05M

HUSA LANSETE KORDA COMPAC 3 LANSETE 3.05M

a8.klug51
Stoc epuizat

555,58Lei

Lanseta Sportex Black Arrow G-3 240cm 40gr

Lanseta Sportex Black Arrow G-3 240cm 40gr

ba2432
Stoc epuizat

1.060,00Lei

LANSETA FOX RAGE STREET FIGHTER PERCH POKER ROD 200CM 7-28GR

LANSETA FOX RAGE STREET FIGHTER PERCH POKER ROD 200CM 7-28GR

nrd364
Stoc epuizat

404,96Lei

Lanseta Sportex Black Arrow G-3 240cm 20gr

Lanseta Sportex Black Arrow G-3 240cm 20gr

ba2431
Stoc epuizat

1.020,00Lei

Lanseta Bologneza Maver Diamond, 5m

Lanseta Bologneza Maver Diamond, 5m

5761500
Stoc epuizat

710,00Lei

Lanseta Sportex Black Arrow G-3 270cm 40gr

Lanseta Sportex Black Arrow G-3 270cm 40gr

ba2732
Stoc epuizat

1.210,00Lei

Lanseta Delphin REWIR Picker 3.00M 2+3SEG 60g -36%

Lanseta Delphin REWIR Picker 3.00M 2+3SEG 60g

101001285
Stoc epuizat

307,00Lei(-36%) 195,01Lei

Lanseta Okuma Wave Power 702M 2.13 10-30g 2seg

Lanseta Okuma Wave Power 702M 2.13 10-30g 2seg

o.okr.64389
Stoc epuizat

149,00Lei

LANSETA CARPZOOM CORK ACTION CA3 CRAP 3.9m 3.5lb 3 sec

LANSETA CARPZOOM CORK ACTION CA3 CRAP 3.9m 3.5lb 3 sec

cz5850
Stoc epuizat

335,00Lei

Lanseta bolognesa Maver Superlithium Light MX 6m

Lanseta bolognesa Maver Superlithium Light MX 6m

5794600
Stoc epuizat

2.240,00Lei

Lanseta Feeder Mitchell Tanager Feeder 3.60m/60-100g

Lanseta Feeder Mitchell Tanager Feeder 3.60m/60-100g

1378240
Stoc epuizat

264,16Lei

LANSETA FOX RAGE TERMINATOR Versatile Light Casting 210cm 7-28g

LANSETA FOX RAGE TERMINATOR Versatile Light Casting 210cm 7-28g

nrd355
Stoc epuizat

787,46Lei

Lanseta Sportex Black Arrow G-3 240cm 60gr

Lanseta Sportex Black Arrow G-3 240cm 60gr

ba2433
Stoc epuizat

1.120,00Lei

Lanseta DAM Yagi Light Spoon 1.90m 1-4gr

Lanseta DAM Yagi Light Spoon 1.90m 1-4gr

2040970661
Stoc epuizat

222,85Lei

LANSETA CARPZOOM MAXIMAL CRAP 13 3.9m 3.5lbs

LANSETA CARPZOOM MAXIMAL CRAP 13 3.9m 3.5lbs

cz5508
Stoc epuizat

350,00Lei

Suport Delphin feeder Atoma BEND -31%

Suport Delphin feeder Atoma BEND

101001471
Stoc epuizat

58,00Lei(-31%) 40,00Lei

Lanseta bolognesa Maver Superlithium Light MX 5m

Lanseta bolognesa Maver Superlithium Light MX 5m

5794500
Stoc epuizat

1.760,00Lei

Afişare 5121 - 5140 din 8888 (445 pagini)
Queries: 4, Total time: 254.072 ms [By time] [By id] [By file]
1 (0.112)
SELECT data
FROM `oc_session`
WHERE session_id = 'f621b118099371cb9005a6b1d4'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.106)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (253.718)
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('+lansete' 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.136)
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