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


FIR ENERGO TEAM ULTRA POWER 0.12 MM 150M
Exclusiv online!

FIR ENERGO TEAM ULTRA POWER 0.12 MM 150M

33540012
Livrare 24-48 ore

9,00Lei

STRUNA Climax ULTRA PREDATOR FLEXSTEEL 1x19 60cm 10kg
Exclusiv online!

STRUNA Climax ULTRA PREDATOR FLEXSTEEL 1x19 60cm 10kg

8610-20004-010
Livrare 48-72 ore

12,00Lei

Fir ASSO Ultra Carp Brown 0.30 mm 1000 m

Fir ASSO Ultra Carp Brown 0.30 mm 1000 m

607080065
Livrare imediată!

73,84Lei

Fir Asso Ultra Cast Orange 0.28mm 300m

Fir Asso Ultra Cast Orange 0.28mm 300m

11010830028
Livrare imediată!

34,55Lei

VOBLER RAPALA ULTRA LIGHT POP 4CM / 3GR GPTU
Exclusiv online!

VOBLER RAPALA ULTRA LIGHT POP 4CM / 3GR GPTU

ulp04 gptu
Livrare 48-72ore

42,00Lei

Shad Biwaa Ultra Hog 10cm, 04 Watermelon Red 8/plic
Exclusiv online!

Shad Biwaa Ultra Hog 10cm, 04 Watermelon Red 8/plic

b001122
Livrare 48-72 ore

26,00Lei

FIR ENERGO TEAM ULTRA POWER 0.20 MM 150M

FIR ENERGO TEAM ULTRA POWER 0.20 MM 150M

33540020
Livrare imediată!

9,00Lei

VOBLER RAPALA ULTRA LIGHT RIPPIN' RAP 4CM / 5GR FT
Exclusiv online!

VOBLER RAPALA ULTRA LIGHT RIPPIN' RAP 4CM / 5GR FT

ulrpr04 ft
Livrare 48-72ore

42,00Lei

Fir Asso Ultra Cast Orange 0.22mm 300m
Exclusiv online!

Fir Asso Ultra Cast Orange 0.22mm 300m

11010830022
Livrare 48-72 ore

30,40Lei

Shad Biwaa Ultra Hog 10 cm culoare Orange Green -23%

Shad Biwaa Ultra Hog 10 cm culoare Orange Green

b001302
Livrare imediată!

26,00Lei(-23%) 19,90Lei

STRUNA Climax ULTRA PREDATOR FLEXSTEEL 7x7 30cm 5kg
Exclusiv online!

STRUNA Climax ULTRA PREDATOR FLEXSTEEL 7x7 30cm 5kg

8610-20001-005
Livrare 48-72 ore

12,00Lei

FIR ENERGO TEAM ULTRA POWER 0.14 MM 150M
Exclusiv online!

FIR ENERGO TEAM ULTRA POWER 0.14 MM 150M

33540014
Livrare 24-48 ore

9,00Lei

Shad Biwaa Ultra Hog 10cm culoare 102 Cinnamon 8/plic
Exclusiv online!

Shad Biwaa Ultra Hog 10cm culoare 102 Cinnamon 8/plic

b001120
Livrare 48-72 ore

26,00Lei

Shad Biwaa Ultra Hog 10cm, 103 Nightcrawler 8/PLIC
Exclusiv online!

Shad Biwaa Ultra Hog 10cm, 103 Nightcrawler 8/PLIC

b001121
Livrare 48-72 ore

26,00Lei

Shad Biwaa Ultra Hog 7.5cm culoare Watermelon Red -20%

Shad Biwaa Ultra Hog 7.5cm culoare Watermelon Red

b001112
Livrare imediată!

26,00Lei(-20%) 20,80Lei

STRUNA Climax ULTRA PREDATOR TITANIUM 1x7 50cm 10kg

STRUNA Climax ULTRA PREDATOR TITANIUM 1x7 50cm 10kg

8610-20005-010
Livrare imediată!

72,99Lei

Fir Monofilament Mivardi Ultra Sinking Feeder, Dark, 150m 0.185mm 3.95kg
Exclusiv online!

Fir Monofilament Mivardi Ultra Sinking Feeder, Dark, 150m 0.185mm 3.95kg

miv-lusf1518
Livrare 48-72 ore

29,99Lei

VOBLER RAPALA ULTRA LIGHT POP 4CM / 3GR GLTU
Exclusiv online!

VOBLER RAPALA ULTRA LIGHT POP 4CM / 3GR GLTU

ulp04 gltu
Livrare 48-72ore

42,00Lei

FIR ENERGO TEAM ULTRA POWER 0.25 MM 150M
Exclusiv online!

FIR ENERGO TEAM ULTRA POWER 0.25 MM 150M

33540025
Livrare 24-48 ore

9,00Lei

Fir ASSO Ultra Carp Brown 0.36 mm 1000 m
Exclusiv online!

Fir ASSO Ultra Carp Brown 0.36 mm 1000 m

607080067
Livrare 48-72 ore

89,10Lei

Afişare 361 - 380 din 784 (40 pagini)
Queries: 7, Total time: 18.080 ms [By time] [By id] [By file]
1 (0.145)
SELECT data
FROM `oc_session`
WHERE session_id = '86345617d5f4dfb2f9db15b793'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.114)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (17.226)
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('+ultra' 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.221)
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
5 (0.126)
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
6 (0.129)
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.119)
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