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 Trabucco Perfecta GX Competition Feeder, 3.60m, 75g, 3+3seg

Lanseta Trabucco Perfecta GX Competition Feeder, 3.60m, 75g, 3+3seg

150-60-110
Stoc epuizat

650,00Lei

Lanseta Trabucco Perfecta GX Competition Feeder, 3.60m, 90g, 3+3seg

Lanseta Trabucco Perfecta GX Competition Feeder, 3.60m, 90g, 3+3seg

150-60-210
Stoc epuizat

650,00Lei

Lanseta Trabucco Perfecta GX Competition Feeder, 3.60m, 90g, 3+3seg

Lanseta Trabucco Perfecta GX Competition Feeder, 3.60m, 90g, 3+3seg

150-60-010
Stoc epuizat

590,00Lei

Lanseta Trabucco Proxima Master Feeder, 3.60m, 110g, 3+3seg

Lanseta Trabucco Proxima Master Feeder, 3.60m, 110g, 3+3seg

153-75-510
Stoc epuizat

440,00Lei

Lanseta TRABUCCO Trinis GX Competition Feeder, 3.60m, 120g, 3+3seg

Lanseta TRABUCCO Trinis GX Competition Feeder, 3.60m, 120g, 3+3seg

150-76-110
Stoc epuizat

630,00Lei

Lanseta Zfish Logan Feeder, Medium, 3.60m, 80g, 3+3seg

Lanseta Zfish Logan Feeder, Medium, 3.60m, 80g, 3+3seg

ZF-2575
Stoc epuizat

338,51Lei

Maner Minciog Preston Monster Xtreme Handles, 3.60m, 3seg

Maner Minciog Preston Monster Xtreme Handles, 3.60m, 3seg

p0230022
Stoc epuizat

323,97Lei

Tronson 02 Trabucco Precision RPL Carp Feeder 3.60m, 120g

Tronson 02 Trabucco Precision RPL Carp Feeder 3.60m, 120g

152-36-360-r02
Stoc epuizat

54,11Lei

LANSETA CARP EXPERT METHOD FEEDER 3.60M 100-150G

LANSETA CARP EXPERT METHOD FEEDER 3.60M 100-150G

12330360
Stoc epuizat

280,00Lei

Combo Feeder Benzar Classic Method 3.60m, 6000

Combo Feeder Benzar Classic Method 3.60m, 6000

12045896
Stoc epuizat

424,00Lei

LANSETA TELESCOPICA CRAP TRABUCCO INDULGENCE 3.60MT / 4 LBS

LANSETA TELESCOPICA CRAP TRABUCCO INDULGENCE 3.60MT / 4 LBS

156-30-300
Stoc epuizat

225,01Lei

LANSETA ENERGOTEAM BENZAR METHOD FEEDER 3.60M 150G 3 plus 5BUC

LANSETA ENERGOTEAM BENZAR METHOD FEEDER 3.60M 150G 3 plus 5BUC

12343360
Stoc epuizat

333,00Lei

LANSETA OKUMA EPIX V2 3.60M/3.5LB/2Seg

LANSETA OKUMA EPIX V2 3.60M/3.5LB/2Seg

o.okr.ca1202h
Stoc epuizat

376,31Lei

Lanseta Delphin RIVER Trophy Feeder X-TRA Plus 4 varfuri 3.60m 200g -32%

Lanseta Delphin RIVER Trophy Feeder X-TRA Plus 4 varfuri 3.60m 200g

130382310
Stoc epuizat

410,00Lei(-32%) 279,50Lei

LANSETA DAIWA TELE MEGAFORCE 3.60M/70-150G

LANSETA DAIWA TELE MEGAFORCE 3.60M/70-150G

d.11499.365
Stoc epuizat

230,46Lei

LANSETA FEEDER TICA REACTOR LITE 3.60MT 183GR

LANSETA FEEDER TICA REACTOR LITE 3.60MT 183GR

reactorlite360
Stoc epuizat

459,99Lei

LANSETA CARP EXPERT ELITE FEEDER 3.60M 80-120G

LANSETA CARP EXPERT ELITE FEEDER 3.60M 80-120G

12335360
Stoc epuizat

318,00Lei

LANSETA TELESCOPICA NEW DAIWA MEGAFORCE 3.60M 100-300G

LANSETA TELESCOPICA NEW DAIWA MEGAFORCE 3.60M 100-300G

d.11495.365
Stoc epuizat

270,37Lei

LANSETA TRABUCCO ERION XT CARP FEEDER 3.60MH/90gr/3SEG

LANSETA TRABUCCO ERION XT CARP FEEDER 3.60MH/90gr/3SEG

152-71-360
Stoc epuizat

334,79Lei

LANSETA TRABUCCO INSPIRON FEEDER COMPETITION MULTI 3.60M 75G 3 Varfuri 3Seg

LANSETA TRABUCCO INSPIRON FEEDER COMPETITION MULTI 3.60M 75G 3 Varfuri 3Seg

153-03-360
Stoc epuizat

495,00Lei

Afişare 681 - 700 din 804 (41 pagini)
Queries: 6, Total time: 565.233 ms [By time] [By id] [By file]
1 (0.088)
SELECT data
FROM `oc_session`
WHERE session_id = 'fc8531de2c85bfc725b106c252'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.158)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (561.185)
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 "%3.60m%") 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 (3.542)
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 680, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.129)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"ZFISHING SPORT WHOLESALE S.R.O"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
6 (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