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 300 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 Ryobi Amazon Feeder 3.00m, 80g, 3+3seg

Lanseta Ryobi Amazon Feeder 3.00m, 80g, 3+3seg

17309300
Stoc epuizat

296,00Lei

Mulineta Colmic Laris FD 5000 8+1BB

Mulineta Colmic Laris FD 5000 8+1BB

mullar50
Stoc epuizat

350,00Lei

Mulineta Delphin SHARX 3T, 3000, 9+1rul

Mulineta Delphin SHARX 3T, 3000, 9+1rul

101003275
Stoc epuizat

249,31Lei

Mulineta Okuma Revenger RV-65

Mulineta Okuma Revenger RV-65

rv-65
Stoc epuizat

139,00Lei

Set Varfuri Trabucco Precision RPL River Feeder 3.60m

Set Varfuri Trabucco Precision RPL River Feeder 3.60m

152-36-360-r01
Stoc epuizat

75,01Lei

Varf Delphin NIRVANA FDR Light Carbon Glass, 1buc

Varf Delphin NIRVANA FDR Light Carbon Glass, 1buc

101001308
Stoc epuizat

41,00Lei

Carlige Legate Guru Bayonets Rig, Carlig Nr.10, 0.19mm, 10cm, 8buc/pac

Carlige Legate Guru Bayonets Rig, Carlig Nr.10, 0.19mm, 10cm, 8buc/pac

a.gu.grr214
Stoc epuizat

22,19Lei

Carlige Legate Mikado Sensual Feeder 9109 BN, 70cm, Nr.12, 0.12mm, 8buc/plic

Carlige Legate Mikado Sensual Feeder 9109 BN, 70cm, Nr.12, 0.12mm, 8buc/plic

hp9109-12b-012
Stoc epuizat

10,00Lei

Clips pentru Rame Zeck Worm Clip Hair-Rig, 17mm, 5buc/pac

Clips pentru Rame Zeck Worm Clip Hair-Rig, 17mm, 5buc/pac

41605110232
Stoc epuizat

20,38Lei

Cosulet Preston Bullet Feeder, Medium, 50g, 1buc/plic

Cosulet Preston Bullet Feeder, Medium, 50g, 1buc/plic

p0050071
Stoc epuizat

11,07Lei

Fir Conic pentru Inaintas Delphin Conic SHOCKER REAXE Clear, 0.20mm-0.35mm, 7lbs-19lbs/3.18-8.62kg, 6x13m, 78m
Fir Monofilament Sunset Amnesia Black, 25lb/11.4kg, 100m

Fir Monofilament Sunset Amnesia Black, 25lb/11.4kg, 100m

ss08425
Stoc epuizat

35,00Lei

Fir Textil Delphin HERO 4 Galben Fluo, 0.12mm, 8.20kg, 15m

Fir Textil Delphin HERO 4 Galben Fluo, 0.12mm, 8.20kg, 15m

101001776
Stoc epuizat

10,00Lei

Lanseta Browning Sphere Feeder Medium Heavy 3.90m 100g -25%

Lanseta Browning Sphere Feeder Medium Heavy 3.90m 100g

1498391
Stoc epuizat

2.249,78Lei(-25%) 1.687,34Lei

Mulineta Colmic Bandit FD 6000

Mulineta Colmic Bandit FD 6000

mulba60
Stoc epuizat

518,99Lei

Mulineta Delphin SHARX 4T, 4000, 9+1rul -30%

Mulineta Delphin SHARX 4T, 4000, 9+1rul

101003276
Stoc epuizat

355,00Lei(-30%) 249,40Lei

Mulineta Mitchell RZT Avocet RD, 2000

Mulineta Mitchell RZT Avocet RD, 2000

1394674
Stoc epuizat

219,96Lei

Set Method Feeder E4 Jaxon cu Matrita si Conector 30g

Set Method Feeder E4 Jaxon cu Matrita si Conector 30g

af-e430x
Stoc epuizat

56,00Lei

Spin Momeala ExtraCarp Bite Spike, 8mm, 10buc/plic

Spin Momeala ExtraCarp Bite Spike, 8mm, 10buc/plic

4162795-1420
Stoc epuizat

6,46Lei

Varf Garbolino Oversized Fibra Sticla Plina, 2.00oz, 2.8mm, 0.53m

Varf Garbolino Oversized Fibra Sticla Plina, 2.00oz, 2.8mm, 0.53m

20530gofrj8119-g-2
Stoc epuizat

39,25Lei

Afişare 12061 - 12080 din 12301 (616 pagini)
Queries: 5, Total time: 420.194 ms [By time] [By id] [By file]
1 (0.086)
SELECT data
FROM `oc_session`
WHERE session_id = '214aa9978857472e57af66933a'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.089)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:427
3 (419.755)
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` GROUP BY tax_class_id) AS tx ON (p.tax_class_id = tx.tax_class_id)
WHERE p2s.store_id = '0' AND (pd.tag LIKE "%feeder%") 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:698
4 (0.152)
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.112)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '0' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38