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 DAM Imax Boat Quiver MF 3.00m 250gr

Lanseta DAM Imax Boat Quiver MF 3.00m 250gr

2120970637
Stoc epuizat

327,69Lei

Lanseta Spinning Nevis Motive Spin 2.44m 7-28g

Lanseta Spinning Nevis Motive Spin 2.44m 7-28g

1432-241
Stoc epuizat

220,00Lei

HUSA DAIWA IFS 130X21CM ISERS

HUSA DAIWA IFS 130X21CM ISERS

d.18851.060
Stoc epuizat

128,73Lei

Lanseta Shimano Sedona 610M 2.08m 7-35g 2seg

Lanseta Shimano Sedona 610M 2.08m 7-35g 2seg

sed610mfe
Stoc epuizat

384,00Lei

Lanseta OKUMA Wave Power Spin 6'0" 183cm 5-20g M 2sec

Lanseta OKUMA Wave Power Spin 6'0" 183cm 5-20g M 2sec

wp-s-602m
Stoc epuizat

134,10Lei

LANSETA KORUM OPPORTUNIST 8FT 2.43M 2.00LBS 2SEG

LANSETA KORUM OPPORTUNIST 8FT 2.43M 2.00LBS 2SEG

k0330009
Stoc epuizat

269,96Lei

Cap Suport Shakespeare SKP Feeder Chair Rear Rest EVA 26cm -26%

Cap Suport Shakespeare SKP Feeder Chair Rear Rest EVA 26cm

1550485
Stoc epuizat

48,50Lei(-26%) 36,00Lei

Suport Shakespeare SKP Feeder Chair Rear Rest 30cm -25%

Suport Shakespeare SKP Feeder Chair Rear Rest 30cm

1550486
Stoc epuizat

57,41Lei(-25%) 42,99Lei

Husa FL 2022 Kaki 2 Compartimente 115cm

Husa FL 2022 Kaki 2 Compartimente 115cm

3552208663398
Stoc epuizat

37,90Lei

Lanseta Okuma 8K Feeder 330cm 45g 2sec MLG/LG/LG

Lanseta Okuma 8K Feeder 330cm 45g 2sec MLG/LG/LG

8k-f-1102m
Stoc epuizat

593,10Lei

LANSETA MIKADO FISH HUNTER FEEDER 3.60M 100g 3+3seg

LANSETA MIKADO FISH HUNTER FEEDER 3.60M 100g 3+3seg

waa009-360
Stoc epuizat

159,00Lei

Husa FL 2022 Kaki 2 Compartimente 145cm

Husa FL 2022 Kaki 2 Compartimente 145cm

8552223788255
Stoc epuizat

57,91Lei

HUSA INDIVIDUALA KORDA COMPAC PADDED SLEEVE LANSETA+MULINETA 163X26X5CM

HUSA INDIVIDUALA KORDA COMPAC PADDED SLEEVE LANSETA+MULINETA 163X26X5CM

a8.klug54
Stoc epuizat

185,22Lei

Lanseta Maver IT BOLOGNEZA STEALT BLX 6M

Lanseta Maver IT BOLOGNEZA STEALT BLX 6M

5786600
Stoc epuizat

290,00Lei

Lanseta DAM Madcat White X-TAAZ Far Out 2.85m, 200-500g, 2seg

Lanseta DAM Madcat White X-TAAZ Far Out 2.85m, 200-500g, 2seg

mad.60844
Stoc epuizat

789,01Lei

Lanseta Daiwa Aqualite Float 3.90m 10-35g 3SEG

Lanseta Daiwa Aqualite Float 3.90m 10-35g 3SEG

d.11401.390
Stoc epuizat

453,58Lei

LANSETA KORUM BARBEL ROD 3.60M 2LBS 2SEG

LANSETA KORUM BARBEL ROD 3.60M 2LBS 2SEG

k0330015
Stoc epuizat

359,96Lei

HUSA FL 2022 3 COMPARTIMENTE 165CM

HUSA FL 2022 3 COMPARTIMENTE 165CM

6427559016827
Stoc epuizat

140,00Lei

LANSETA KORUM BARBEL ROD 3.30M 1.75LBS 2SEG

LANSETA KORUM BARBEL ROD 3.30M 1.75LBS 2SEG

k0330013
Stoc epuizat

314,96Lei

LANSETA SPINNING FL SUPAPULL - JACK 2.40M 15-45G

LANSETA SPINNING FL SUPAPULL - JACK 2.40M 15-45G

4552279222813
Stoc epuizat

104,90Lei

Afişare 6261 - 6280 din 8888 (445 pagini)
Queries: 8, Total time: 268.637 ms [By time] [By id] [By file]
1 (0.152)
SELECT data
FROM `oc_session`
WHERE session_id = 'a2ee598c9b82ee228b26339ee6'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.093)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (267.791)
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('+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.150)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"PRODUSE INACTIVE"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
5 (0.111)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"ROM-EUROTRADE SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
6 (0.103)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"RAPALA VMC ROMANIA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
7 (0.107)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"RAPALA VMC ROMANIA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
8 (0.131)
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