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 FL Eternity Tele Carp 3.30m

Lanseta FL Eternity Tele Carp 3.30m

1133175016459
Stoc epuizat

119,10Lei

MANER MINCIOG TRAKKO LUCHY TELE NET HANDLE 4 TRONSOANE 3.50M

MANER MINCIOG TRAKKO LUCHY TELE NET HANDLE 4 TRONSOANE 3.50M

tr3504
Stoc epuizat

165,01Lei

Lanseta DAM Shadow Tele 2.10m 5-25gr

Lanseta DAM Shadow Tele 2.10m 5-25gr

2040970346
Stoc epuizat

212,22Lei

Lanseta FL Rock Fish Tele Spin 3.00M 40-80G Telescopic

Lanseta FL Rock Fish Tele Spin 3.00M 40-80G Telescopic

8153170637278
Stoc epuizat

103,49Lei

MANER JAXON MINCIOG TELE CARBON LM 3.0M

MANER JAXON MINCIOG TELE CARBON LM 3.0M

pl-afc300
Stoc epuizat

184,00Lei

MANER JAXON MINCIOG TELE CARBON 2.4M

MANER JAXON MINCIOG TELE CARBON 2.4M

pl-afe240
Stoc epuizat

156,00Lei

MANER JAXON MINCIOG TELE JAXON LM 4 M

MANER JAXON MINCIOG TELE JAXON LM 4 M

pl-afb400
Stoc epuizat

240,00Lei

MANER JAXON MINCIOG TELE CARBON LM 4.0M

MANER JAXON MINCIOG TELE CARBON LM 4.0M

pl-afc400
Stoc epuizat

250,00Lei

Lanseta Delphin LYCAN Tele FEEDER 3.60M 100G

Lanseta Delphin LYCAN Tele FEEDER 3.60M 100G

101001301
Stoc epuizat

328,00Lei

MINCIOG SAVAGE GEAR TELE PRO FOLDING DLX XL 70X85X70CM 105CM

MINCIOG SAVAGE GEAR TELE PRO FOLDING DLX XL 70X85X70CM 105CM

a2.sg.71105
Stoc epuizat

321,04Lei

MINCIOG SAVAGE GEAR TELE FULL FRAME ROUND 46X56X50CM 99-150CM

MINCIOG SAVAGE GEAR TELE FULL FRAME ROUND 46X56X50CM 99-150CM

a2.sg.71107
Stoc epuizat

248,42Lei

LANSETA SPINNING OKUMA LIGHT RANGE FISHING TELE 2.28m 8-22g 6seg

LANSETA SPINNING OKUMA LIGHT RANGE FISHING TELE 2.28m 8-22g 6seg

lrf-s-766ml-t
Stoc epuizat

379,00Lei

Lanseta DAM Base-X Tele Pike 3.50m 80-150gr

Lanseta DAM Base-X Tele Pike 3.50m 80-150gr

2020970398
Stoc epuizat

108,14Lei

Varga FL Tele Success 6 M

Varga FL Tele Success 6 M

309-600
Stoc epuizat

185,90Lei

Varga FL Tele Success 7 M

Varga FL Tele Success 7 M

309-700
Stoc epuizat

207,00Lei

Varga FL Tele Amusement 6 M

Varga FL Tele Amusement 6 M

310-600
Stoc epuizat

185,90Lei

Varga FL Tele Success 8 M

Varga FL Tele Success 8 M

309-800
Stoc epuizat

233,30Lei

MANER MINCIOG PRO FL COMPETITION TELE 4.00M

MANER MINCIOG PRO FL COMPETITION TELE 4.00M

64-45780
Stoc epuizat

89,90Lei

Combo Shakespeare Firebird Tele Spinning 3.00m, 15-40g

Combo Shakespeare Firebird Tele Spinning 3.00m, 15-40g

1550302
Stoc epuizat

152,96Lei

MANER MINCIOG PRO FL COMPETITION TELE 3.00M

MANER MINCIOG PRO FL COMPETITION TELE 3.00M

64-45773
Stoc epuizat

85,89Lei

Afişare 321 - 340 din 544 (28 pagini)
Queries: 7, Total time: 14.144 ms [By time] [By id] [By file]
1 (0.137)
SELECT data
FROM `oc_session`
WHERE session_id = '4370ee250addef547ac0be46ea'
/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 (13.557)
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('+tele' 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.116)
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.080)
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.074)
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
7 (0.076)
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