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


Carp Zoom PELETE SOFT 12mm 30gr Spice

Carp Zoom PELETE SOFT 12mm 30gr Spice

cz3900
Livrare imediată!

12,50Lei

Carp Zoom PELETE TURBO 2 IN 1 3mm 500gr Spice-Garlic
Exclusiv online!

Carp Zoom PELETE TURBO 2 IN 1 3mm 500gr Spice-Garlic

cz4860
Livrare 48-72 ore

18,00Lei

Carp Zoom AROMA LICHIDA PLUS 200ml Spice
Exclusiv online!

Carp Zoom AROMA LICHIDA PLUS 200ml Spice

cz4662
Livrare 48-72 ore

13,51Lei

Carp Zoom DIP BOILIE 80ml Spice Mix
Exclusiv online!

Carp Zoom DIP BOILIE 80ml Spice Mix

cz4396
Livrare 48-72 ore

13,00Lei

Carp, Zoom, WAFTERS, GALACTIC, DUO, 8mm, 15gr, Exotic, Spice, cz6888, Critic Echilibrate / Wafters, Critic Echilibrate / Wafters Carp Zoom, Carp Zoom
Carp Zoom WAFTERS GALACTIC DUO 10mm 15gr Exotic Spice
Exclusiv online!

Carp Zoom WAFTERS GALACTIC DUO 10mm 15gr Exotic Spice

cz6949
Livrare 48-72 ore

15,00Lei

BOILIES CARP ZOOM PREMIUM NATURAL CLASSIC 18mm 120gr Spice Essence
Exclusiv online!

BOILIES CARP ZOOM PREMIUM NATURAL CLASSIC 18mm 120gr Spice Essence

cz9292
Livrare 48-72 ore

20,00Lei

POP-UP CARP ZOOM FLAT 15gr Spice Magic
Exclusiv online!

POP-UP CARP ZOOM FLAT 15gr Spice Magic

cz8783
Livrare 48-72 ore

19,50Lei

ADITIV CARP ZOOM METHOD FEEDER ATRACTOR + BETAINE 200ml Hot Spice
Exclusiv online!

ADITIV CARP ZOOM METHOD FEEDER ATRACTOR + BETAINE 200ml Hot Spice

cz9339
Livrare 48-72 ore

17,51Lei

BOILIES CARP ZOOM PREMIUM NATURAL BALANCED 18mm 100gr Spice Essence
Exclusiv online!

BOILIES CARP ZOOM PREMIUM NATURAL BALANCED 18mm 100gr Spice Essence

cz9261
Livrare 48-72 ore

21,49Lei

BOILIE CARP ZOOM AMUR-GRASS CARP 20mm 800gr Spice
Exclusiv online!

BOILIE CARP ZOOM AMUR-GRASS CARP 20mm 800gr Spice

cz9377
Livrare 48-72 ore

40,00Lei

WAFTERS CARP ZOOM FLAT SLOW SINKING 15G Spice Magic
Exclusiv online!

WAFTERS CARP ZOOM FLAT SLOW SINKING 15G Spice Magic

cz8813
Livrare 48-72 ore

19,50Lei

POP UP CARP ZOOM MINI FANATI-X 10mm 25gr Hot Spice
Exclusiv online!

POP UP CARP ZOOM MINI FANATI-X 10mm 25gr Hot Spice

cz8981
Livrare 48-72 ore

16,00Lei

LINGURITA, OSCILANTA, YARIE, 702, PIRICA, MORE, Y80, KARASI, SPICE, 1.8G, y70218y80, Lingurite Oscilante, Lingurite Oscilante Yarie, Yarie
LINGURITA, OSCILANTA, YARIE, 702, PIRICA, MORE, Y80, KARASI, SPICE, 1.5G, y70215y80, Lingurite Oscilante, Lingurite Oscilante Yarie, Yarie
LINGURITA OSCILANTA YARIE 710T T-FRESH EVO Y80 Karasi Spice 1.5G
Exclusiv online!

LINGURITA OSCILANTA YARIE 710T T-FRESH EVO Y80 Karasi Spice 1.5G

y710t15y80
Livrare 48-72 ore

25,00Lei

Atractant Lichid Carp Zoom R2 PVA Green Booster, Spice Krill, 75ml
Exclusiv online!

Atractant Lichid Carp Zoom R2 PVA Green Booster, Spice Krill, 75ml

cz0854
Livrare 48-72 ore

22,00Lei

LINGURITA, OSCILANTA, YARIE, 710T, T-FRESH, EVO, Y80, Karasi, Spice, 2G, y710t20y80, Lingurite Oscilante, Lingurite Oscilante Yarie, Yarie
Wafter Feeder Bait Club Series, Spice Meat, 8mm
Exclusiv online!

Wafter Feeder Bait Club Series, Spice Meat, 8mm

fbcs7
Livrare 48-72 ore

17,85Lei

Wafters Feeder Bait Mikron, Spice, 6mm, 50ml,
Exclusiv online!

Wafters Feeder Bait Mikron, Spice, 6mm, 50ml,

fb27-13
Livrare 48-72 ore

16,00Lei

Afişare 1 - 20 din 72 (4 pagini)
Queries: 7, Total time: 240.825 ms [By time] [By id] [By file]
1 (0.139)
SELECT data
FROM `oc_session`
WHERE session_id = '0a35229c6b446b7a87e29fe678'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.143)
SELECT *
FROM oc_platforma_promovari LIMIT 1
/var/www/clients/client1/web1/web/index.php:128
3 (0.108)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:422
4 (240.066)
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 = '3' AND (pd.tag LIKE "%spice%") 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
5 (0.147)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
6 (0.090)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
7 (0.132)
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