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


Geanta pentru Juvelnic Rive EVA Size 3XL, 60x58x36cm
Exclusiv online!

Geanta pentru Juvelnic Rive EVA Size 3XL, 60x58x36cm

90410370305
Livrare 48-72 ore

448,65Lei

Hanger Carp Academy Wiron, Albastru
Exclusiv online!

Hanger Carp Academy Wiron, Albastru

6353-203
Livrare 48-72 ore

27,91Lei

Husa Lansete Shakespeare Superteam Rod Holdall
Exclusiv online!

Husa Lansete Shakespeare Superteam Rod Holdall

1550342
Livrare 7-14 zile

449,96Lei

Husa Picheti Korda Compac Dark Camo

Husa Picheti Korda Compac Dark Camo

a8.klug120
Livrare imediată!

101,85Lei

Jacheta FOX Sherpa-Tec Smock Jacket XXL

Jacheta FOX Sherpa-Tec Smock Jacket XXL

cfx198
Livrare imediată!

539,96Lei

Jacheta Gamakatsu Gama G Quilted Fleece, Marime L -20%

Jacheta Gamakatsu Gama G Quilted Fleece, Marime L

a8.gk.7245.300
Livrare imediată!

359,73Lei(-20%) 287,78Lei

Jacheta Garbolino Squadra 3 Straturi, Marime L
Exclusiv online!

Jacheta Garbolino Squadra 3 Straturi, Marime L

80330gomcm2850-l
Livrare 48-72 ore

859,82Lei

Jacheta Trakker CR Downpour Jacket, Kaki, Marimea XXL

Jacheta Trakker CR Downpour Jacket, Kaki, Marimea XXL

206448
Livrare imediată!

474,95Lei

Lampa Pliabilă Technik Camping Lamp C25 (3xAA/nu sunt incluse) COB IP44 (180 de lumeni)

Lampa Pliabilă Technik Camping Lamp C25 (3xAA/nu sunt incluse) COB IP44 (180 de lumeni)

mt-c25
Livrare imediată!

16,70Lei

Lanseta Spinning Daiwa Silver Creek L Spin 2.20m, 5-21g, 2seg -23%

Lanseta Spinning Daiwa Silver Creek L Spin 2.20m, 5-21g, 2seg

d.11441.221
Livrare imediată!

376,84Lei(-23%) 289,90Lei

Lanseta Spinning Daiwa Silver Creek UL F Spoon 1.90m, 0.5-5g, 2seg
Exclusiv online!

Lanseta Spinning Daiwa Silver Creek UL F Spoon 1.90m, 0.5-5g, 2seg

d.11440.190
Livrare 24-48 ore

237,00Lei

Lanseta Sportex Xclusive Feeder RS-2 Medium Heavy 3.65m, 93-192g, 3+3seg

Lanseta Sportex Xclusive Feeder RS-2 Medium Heavy 3.65m, 93-192g, 3+3seg

mh3619
Livrare imediată!

1.379,00Lei

Lanseta Sportex Xclusive Float XT 3.90m, 20-40g, 3seg
Exclusiv online!

Lanseta Sportex Xclusive Float XT 3.90m, 20-40g, 3seg

pf3933
Livrare 48-72 ore

1.190,00Lei

Lingura Oscilanta - Shallow Killer 21G-8.3Cm - Silver
Exclusiv online!

Lingura Oscilanta - Shallow Killer 21G-8.3Cm - Silver

pmb-wshk-21-s
Livrare 48-72 ore

18,00Lei

LINGURITA OSCILANTA YARIE 704 RINGO MIDI HAMMERED BS-10 BLUE/SILVER 2G
Exclusiv online!

LINGURITA OSCILANTA YARIE 704 RINGO MIDI HAMMERED BS-10 BLUE/SILVER 2G

y70420bs10
Livrare 48-72 ore

25,00Lei

LINGURITA OSCILANTA YARIE 710T T-FRESH EVO AD22 Saber Silver 2G
Exclusiv online!

LINGURITA OSCILANTA YARIE 710T T-FRESH EVO AD22 Saber Silver 2G

y710t20ad22
Livrare 48-72 ore

25,00Lei

LINGURITA OSCILANTA YARIE 710T T-FRESH EVO Y80 Karasi Spice 2G
Exclusiv online!

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

y710t20y80
Livrare 48-72 ore

25,00Lei

Masa Nash Bank Life Bedside Station Camo, Small -33%

Masa Nash Bank Life Bedside Station Camo, Small

t1232
Livrare imediată!

450,00Lei(-33%) 300,90Lei

Nada SENZOR Top Method Feeder Amix Editie Limitata Grey, Larve Libelule & Viermusi, 1kg

Nada SENZOR Top Method Feeder Amix Editie Limitata Grey, Larve Libelule & Viermusi, 1kg

snz99320
Livrare imediată!

29,00Lei

Pantaloni Daiwa Joggers Camo, Marime L

Pantaloni Daiwa Joggers Camo, Marime L

d.18865.530
Livrare imediată!

262,48Lei

Afişare 1801 - 1820 din 17573 (879 pagini)
Queries: 5, Total time: 907.685 ms [By time] [By id] [By file]
1 (0.114)
SELECT data
FROM `oc_session`
WHERE session_id = '9552d4c2675c1270bf73683e44'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.082)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (820.358)
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 (pd.tag LIKE "%și%") 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 (87.014)
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 1800, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (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