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


Mulineta FL YF 10000 (Rezerva 9000)

Mulineta FL YF 10000 (Rezerva 9000)

5961650005645
Livrare imediată!

291,60Lei

Mulineta Fl strategist sfl saibe carbon 9000 (tambur rezerva 8000)

Mulineta Fl strategist sfl saibe carbon 9000 (tambur rezerva 8000)

7691745201925
Livrare imediată!

324,91Lei

Mulineta FL ZF 14000

Mulineta FL ZF 14000

2262191364547
Livrare imediată!

308,20Lei

Lanseta Bolognesa Mifine Amazon,10-45g, 6.20m

Lanseta Bolognesa Mifine Amazon,10-45g, 6.20m

8268144712230
Livrare imediată!

183,30Lei

Varga Pokee Prado 7M 10-40Gr

Varga Pokee Prado 7M 10-40Gr

4991454176419
Livrare imediată!

224,90Lei

Lanseta Bolognesa Mifine Gloria 7m 10-50g

Lanseta Bolognesa Mifine Gloria 7m 10-50g

4268144592249
Livrare imediată!

232,89Lei

Husa FL Camuflaj 1.45m 2 Compartimente

Husa FL Camuflaj 1.45m 2 Compartimente

7777035
Livrare imediată!

51,90Lei

PISTOL UMAREX CO2 AIRSOFT HEKLER KOCH USP 6MM 16BB 2J 17L04541
Exclusiv online!

PISTOL UMAREX CO2 AIRSOFT HEKLER KOCH USP 6MM 16BB 2J 17L04541

vu.2.5561
Livrare 24-48 ore

550,26Lei

Varga Mifine Metalica Pole 6.00M

Varga Mifine Metalica Pole 6.00M

8811685505245
Livrare imediată!

172,60Lei

Swinger FL Black Multi Light JY -SW 19

Swinger FL Black Multi Light JY -SW 19

6242182884526
Livrare imediată!

60,40Lei

Minciog FL 3 Tronsoane Aluminiu 60

Minciog FL 3 Tronsoane Aluminiu 60

7777045
Livrare imediată!

50,00Lei

Swinger FL Luminos Cu Bile Verde

Swinger FL Luminos Cu Bile Verde

8262137445563
Livrare imediată!

18,10Lei

Lanseta Bolognesa FL Fight River 4M

Lanseta Bolognesa FL Fight River 4M

4224175045475
Livrare imediată!

103,49Lei

Pistol Umarex CO2 Airsoft Ruger P345 6 MM 15BB 2,8J

Pistol Umarex CO2 Airsoft Ruger P345 6 MM 15BB 2,8J

vu.2.5637
Livrare imediată!

351,42Lei

Lanseta FL Strategist FORCE PLUS 3.00M 3.75LBS 2SEG

Lanseta FL Strategist FORCE PLUS 3.00M 3.75LBS 2SEG

4311205084563
Livrare imediată!

191,60Lei

Sistem de Atasare Plumb Mostiro Lead Boom 15cm, 2buc/pac
Exclusiv online!

Sistem de Atasare Plumb Mostiro Lead Boom 15cm, 2buc/pac

4453ms
Livrare 48-72 ore

5,90Lei

Mulineta Mifine Cheer 1000 -19%

Mulineta Mifine Cheer 1000

6264184583092
Livrare imediată!

209,00Lei(-19%) 169,90Lei

Cutie Carp Academy Inaintas

Cutie Carp Academy Inaintas

4513-001
Livrare imediată!

35,00Lei

AVERTIZOR Carp Zoom ASTRA C-620 CZ3238 Galben

AVERTIZOR Carp Zoom ASTRA C-620 CZ3238 Galben

cz3245
Livrare imediată!

142,00Lei

TAMBUR FOX RAGE REZERVA Prism X 4500
Exclusiv online!

TAMBUR FOX RAGE REZERVA Prism X 4500

nrl036
Livrare 7-14 zile

71,96Lei

Afişare 3441 - 3460 din 5036 (252 pagini)
Queries: 5, Total time: 621.945 ms [By time] [By id] [By file]
1 (0.157)
SELECT data
FROM `oc_session`
WHERE session_id = '19f3a8e29556924581aeba8211'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.150)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (599.959)
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 "%45%") 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 (21.535)
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 3440, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.144)
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