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 - spreader

Produse ce potrivesc criteriilor de căutare


Lanseta Jaxon METHOD FEEDER ACADEMY X 360 20-60GR -25%

Lanseta Jaxon METHOD FEEDER ACADEMY X 360 20-60GR

wj-cbf36060-x
Stoc epuizat

281,99Lei(-25%) 211,00Lei

MANER MINCIOG FL CARBON FEEDER TELESCOPICA 4.00M

MANER MINCIOG FL CARBON FEEDER TELESCOPICA 4.00M

1243167954628
Stoc epuizat

91,90Lei

Bluza UV cu Gluga Carp Zoom Feeder Competition, Marime 2XL

Bluza UV cu Gluga Carp Zoom Feeder Competition, Marime 2XL

cz4380
Stoc epuizat

171,00Lei

Lanseta Jaxon METHOD FEEDER ACADEMY L 360 20-60GR -25%

Lanseta Jaxon METHOD FEEDER ACADEMY L 360 20-60GR

wj-caf36060-l
Stoc epuizat

364,00Lei(-25%) 273,00Lei

Lanseta Jaxon FEEDER ACADEMY X 390 40-90GR -25%

Lanseta Jaxon FEEDER ACADEMY X 390 40-90GR

wj-cbf390090-x
Stoc epuizat

295,00Lei(-25%) 221,99Lei

Lanseta Jaxon FEEDER ACADEMY L 360 30-90GR -25%

Lanseta Jaxon FEEDER ACADEMY L 360 30-90GR

wj-caf360090-l
Stoc epuizat

385,00Lei(-25%) 289,00Lei

Lanseta Jaxon FEEDER ACADEMY L 390 50-120GR -25%

Lanseta Jaxon FEEDER ACADEMY L 390 50-120GR

wj-caf390120-l
Stoc epuizat

433,01Lei(-25%) 324,00Lei

Lanseta Jaxon FEEDER ACADEMY L 390 70-150GR -25%

Lanseta Jaxon FEEDER ACADEMY L 390 70-150GR

wj-caf390150-l
Stoc epuizat

457,00Lei(-25%) 343,01Lei

Lanseta Jaxon FEEDER ACADEMY L 330 50-120GR -25%

Lanseta Jaxon FEEDER ACADEMY L 330 50-120GR

wj-caf330120-l
Stoc epuizat

385,00Lei(-25%) 289,00Lei

Lanseta Jaxon METHOD FEEDER ACADEMY L 300 20-60GR -25%

Lanseta Jaxon METHOD FEEDER ACADEMY L 300 20-60GR

wj-caf30060-l
Stoc epuizat

334,00Lei(-25%) 250,00Lei

Lanseta Jaxon FEEDER ACADEMY L 360 70-150GR -25%

Lanseta Jaxon FEEDER ACADEMY L 360 70-150GR

wj-caf360150-l
Stoc epuizat

426,00Lei(-25%) 320,00Lei

MULINETA BARACUDA YUMOSHI FF7000

MULINETA BARACUDA YUMOSHI FF7000

yumoshi ff7000
Stoc epuizat

60,90Lei

JUVELNIC FL CAUCIUCAT + HUSA 2.3MT DIAMETRU 30CM

JUVELNIC FL CAUCIUCAT + HUSA 2.3MT DIAMETRU 30CM

8511752348132
Stoc epuizat

69,90Lei

Lanseta FL Strong Carp Feeder 3.90m

Lanseta FL Strong Carp Feeder 3.90m

5153172931759
Stoc epuizat

75,90Lei

FIR COLMIC ARWEN MATCH SINNKING 150M 0.22mm 5.8 kg

FIR COLMIC ARWEN MATCH SINNKING 150M 0.22mm 5.8 kg

nying22
Stoc epuizat

30,00Lei

MULINETA DAIWA NINJA LT 4RUL 5000-C 0.37mm/150m

MULINETA DAIWA NINJA LT 4RUL 5000-C 0.37mm/150m

d.10219.500
Stoc epuizat

374,53Lei

MULINETA SHIMANO CATANA FEC3000 -38%

MULINETA SHIMANO CATANA FEC3000

catc3000fe
Stoc epuizat

260,00Lei(-38%) 161,99Lei

MULINETA SHIMANO Nasci FC 4000 -31%

MULINETA SHIMANO Nasci FC 4000

nas4000fc
Stoc epuizat

590,00Lei(-31%) 405,00Lei

Mulineta Browning Black Viper SLC 660

Mulineta Browning Black Viper SLC 660

0403660
Stoc epuizat

629,78Lei

Mulineta Shimano Aero C5000 -31%

Mulineta Shimano Aero C5000

aeroc5000
Stoc epuizat

650,00Lei(-31%) 447,00Lei

Afişare 12481 - 12500 din 12500 (625 pagini)
Queries: 10, Total time: 338.699 ms [By time] [By id] [By file]
1 (0.117)
SELECT data
FROM `oc_session`
WHERE session_id = 'f005ef03a79c53a68ef5d93f59'
/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 (0.130)
SELECT *
FROM oc_url_alias
WHERE keyword = 'search'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (287.961)
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('+feeder' 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
5 (49.707)
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 12480, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
6 (0.169)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"EDCRIS COM SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
7 (0.159)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"ROM-EUROTRADE SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
8 (0.116)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"ROM-EUROTRADE SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
9 (0.123)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"ROM-EUROTRADE SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
10 (0.103)
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