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 - vu.2.5878

Produse ce potrivesc criteriilor de căutare


ANCORA CARP ZOOM PREDATOR Z nr.1 -30%

ANCORA CARP ZOOM PREDATOR Z nr.1

cz5449
Stoc epuizat

21,00Lei(-30%) 14,70Lei

Mulineta Carp Zoom Predator Z Oplus Red-Act 3000 FD -30%

Mulineta Carp Zoom Predator Z Oplus Red-Act 3000 FD

cz0580
Stoc epuizat

265,00Lei(-30%) 186,00Lei

Mulineta Carp Zoom Predator Z Oplus Red-Act 4000 FD -30%

Mulineta Carp Zoom Predator Z Oplus Red-Act 4000 FD

cz0597
Stoc epuizat

279,00Lei(-30%) 195,01Lei

Mulineta Carp Zoom Predator-Z Oplus Flash 2000FD -30%

Mulineta Carp Zoom Predator-Z Oplus Flash 2000FD

cz3079
Stoc epuizat

156,00Lei(-30%) 109,00Lei

GRIP CARP ZOOM PREDATOR Z STR-G 21cm -20%

GRIP CARP ZOOM PREDATOR Z STR-G 21cm

cz3224
Stoc epuizat

81,00Lei(-20%) 64,80Lei

FIR TEXTIL CARP ZOOM PREDATOR Z CATFISH 100m 0.40MM 35.0KG Maro

FIR TEXTIL CARP ZOOM PREDATOR Z CATFISH 100m 0.40MM 35.0KG Maro

cz6668
Stoc epuizat

84,00Lei

FIR MONOFILAMENT CARP ZOOM PREDATOR Z OPLUS CATFISH 100m 0.70mm 37.4kg -22%

FIR MONOFILAMENT CARP ZOOM PREDATOR Z OPLUS CATFISH 100m 0.70mm 37.4kg

cz2182
Stoc epuizat

21,00Lei(-22%) 16,30Lei

Aditiv Lichid Van Den Eynde Sirop Betain Predator 250ml -30%

Aditiv Lichid Van Den Eynde Sirop Betain Predator 250ml

v00467
Stoc epuizat

25,00Lei(-30%) 17,50Lei

VOBLER CARP ZOOM PREDATOR -Z M SHAD 7.5cm 6.0gr FLOATING 0740 -20%

VOBLER CARP ZOOM PREDATOR -Z M SHAD 7.5cm 6.0gr FLOATING 0740

cz0740
Stoc epuizat

12,00Lei(-20%) 9,60Lei

Bluza Carp Zoom Predator Z Oplus marime XL

Bluza Carp Zoom Predator Z Oplus marime XL

cz4335
Stoc epuizat

147,00Lei

VOBLER CARP ZOOM PREDATOR -Z BABY SIDER 5.5cm 3.8gr FLOATING 1136 -20%

VOBLER CARP ZOOM PREDATOR -Z BABY SIDER 5.5cm 3.8gr FLOATING 1136

cz1136
Stoc epuizat

12,00Lei(-20%) 9,60Lei

Lanseta Carp Zoom Predator Z Oplus River Jig 2.10m/15-45g

Lanseta Carp Zoom Predator Z Oplus River Jig 2.10m/15-45g

cz0504
Stoc epuizat

238,00Lei

Crawbug Carp Zoom Predator Z Oplus 2.5cm Red -24%

Crawbug Carp Zoom Predator Z Oplus 2.5cm Red

cz2908
Stoc epuizat

12,00Lei(-24%) 9,16Lei

VOBLER CARP ZOOM PREDATOR -Z BABY SIDER 5.5cm 3.8gr FLOATING 1143 -20%

VOBLER CARP ZOOM PREDATOR -Z BABY SIDER 5.5cm 3.8gr FLOATING 1143

cz1143
Stoc epuizat

12,00Lei(-20%) 9,60Lei

VOBLER CARP ZOOM PREDATOR -Z FAT JOINT 8.8cm 13gr FLOATING 1433 -20%

VOBLER CARP ZOOM PREDATOR -Z FAT JOINT 8.8cm 13gr FLOATING 1433

cz1433
Stoc epuizat

15,01Lei(-20%) 12,00Lei

VOBLER CARP ZOOM PREDATOR-Z HARD MINNOW 8.5cm 4.5gr FLOATING 1389 -20%

VOBLER CARP ZOOM PREDATOR-Z HARD MINNOW 8.5cm 4.5gr FLOATING 1389

cz1389
Stoc epuizat

12,00Lei(-20%) 9,60Lei

VOBLER CARP ZOOM PREDATOR -Z FAT JOINT 8.8cm 13gr FLOATING 1419 -23%

VOBLER CARP ZOOM PREDATOR -Z FAT JOINT 8.8cm 13gr FLOATING 1419

cz1419
Stoc epuizat

15,01Lei(-23%) 11,54Lei

CUTIE SPRO PREDATOR 23X33X7-23 COMPARTIMENTE

CUTIE SPRO PREDATOR 23X33X7-23 COMPARTIMENTE

006516-00000-0000014
Stoc epuizat

54,10Lei

VOBLER CARP ZOOM PREDATOR -Z SIDER 6.5cm 6gr FLOATING 1082 -20%

VOBLER CARP ZOOM PREDATOR -Z SIDER 6.5cm 6gr FLOATING 1082

cz1082
Stoc epuizat

12,00Lei(-20%) 9,60Lei

Lanseta Carp Zoom Predator-Z Dropshot Intense DSI 1.95m 3-15g

Lanseta Carp Zoom Predator-Z Dropshot Intense DSI 1.95m 3-15g

cz6438
Stoc epuizat

183,00Lei

Afişare 401 - 420 din 467 (24 pagini)
Queries: 10, Total time: 15.614 ms [By time] [By id] [By file]
1 (0.140)
SELECT data
FROM `oc_session`
WHERE session_id = '7f8cf32445a1b32b84582b2892'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.133)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (14.406)
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 = '3' AND (MATCH(pd.tag) AGAINST('+predator' 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.179)
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.163)
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
6 (0.117)
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.119)
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
8 (0.119)
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
9 (0.120)
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
10 (0.117)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '3' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38