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 Delphin ETNA E3 TRIP 360cm 3.25lbs TeleFI 2seg

Lanseta Delphin ETNA E3 TRIP 360cm 3.25lbs TeleFI 2seg

101001484
Stoc epuizat

374,01Lei

Saltea de primire Delphin Eazy SAFE -16%

Saltea de primire Delphin Eazy SAFE

101001522
Stoc epuizat

304,00Lei(-16%) 255,01Lei

Saltea de Primire Fox Easy Mat 112cm -20%

Saltea de Primire Fox Easy Mat 112cm

ccc055
Stoc epuizat

402,53Lei(-20%) 322,03Lei

Maner Minciog Carbon FL Toreador Telescopic 3M

Maner Minciog Carbon FL Toreador Telescopic 3M

5153210430756
Stoc epuizat

98,40Lei

Maner Minciog Carbon FL Toreador Telescopic 3.5M

Maner Minciog Carbon FL Toreador Telescopic 3.5M

5153211303417
Stoc epuizat

119,90Lei

MANER MINCIOG TELESCOPIC TRABUCCO PRECISION CARP RESPONSE 3.10M

MANER MINCIOG TELESCOPIC TRABUCCO PRECISION CARP RESPONSE 3.10M

081-05-310
Stoc epuizat

185,00Lei

Lanseta Delphin LYCAN Tele FEEDER 3.60M 100G

Lanseta Delphin LYCAN Tele FEEDER 3.60M 100G

101001301
Stoc epuizat

328,00Lei

MANER MINCIOG KORUM POWER TELESCOPIC NET HANDLE 3M

MANER MINCIOG KORUM POWER TELESCOPIC NET HANDLE 3M

k0380002
Stoc epuizat

177,08Lei

Saltea de primire Delphin Eko -27%

Saltea de primire Delphin Eko

955001028
Stoc epuizat

41,00Lei(-27%) 30,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

Saltea de cantarire Sonik Sk Tek Standard

Saltea de cantarire Sonik Sk Tek Standard

sn714401
Stoc epuizat

328,00Lei

Saltea de primire Delphin Lux CarpPOOL NXT

Saltea de primire Delphin Lux CarpPOOL NXT

101001622
Stoc epuizat

489,49Lei

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

Saltea de cantarire Sonik Sk Tek Large

Saltea de cantarire Sonik Sk Tek Large

sn714418
Stoc epuizat

354,00Lei

Brat Feeder Shakespeare SKP Telescopic Feeder Arm -8%

Brat Feeder Shakespeare SKP Telescopic Feeder Arm

1550484
Stoc epuizat

90,00Lei(-8%) 83,00Lei

SALTEA DE PRIMIRE KORUM SUPA LITE FAST MAT 80X40X26CM

SALTEA DE PRIMIRE KORUM SUPA LITE FAST MAT 80X40X26CM

k0290067
Stoc epuizat

269,96Lei

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

Saltea Cantarire Korum Packa Weigh Sling

Saltea Cantarire Korum Packa Weigh Sling

k0290033
Stoc epuizat

112,46Lei

PICHET TELESCOPIC KORUM LEVERAGE BANKSTICKS 100CM XT Screw Point

PICHET TELESCOPIC KORUM LEVERAGE BANKSTICKS 100CM XT Screw Point

k0360016
Stoc epuizat

107,96Lei

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

Afişare 1121 - 1140 din 1568 (79 pagini)
Queries: 7, Total time: 789.975 ms [By time] [By id] [By file]
1 (0.097)
SELECT data
FROM `oc_session`
WHERE session_id = 'a66dc6ad3af39b58776a84e098'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.118)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (782.009)
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 (pd.tag LIKE "%tele%") 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:724
4 (7.344)
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 1120, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
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.125)
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.156)
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