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


PUFARINE CARP ZOOM NPF FLOTANTE PELETE MINI 30GR USTUROI
Exclusiv online!

PUFARINE CARP ZOOM NPF FLOTANTE PELETE MINI 30GR USTUROI

cz2258
Livrare 48-72ore

10,00Lei

LOOP TYER CARP ZOOM

LOOP TYER CARP ZOOM

cz4221
Livrare imediată!

23,00Lei

Agrafa Cu Blocaj Carp Zoom + Vartej nr.4 negru 10/set

Agrafa Cu Blocaj Carp Zoom + Vartej nr.4 negru 10/set

cz2042
Livrare imediată!

28,00Lei

FIR TEXTIL CARP ZOOM ALLROUND FISHING 110m 0.14mm 9.43kg Verde

FIR TEXTIL CARP ZOOM ALLROUND FISHING 110m 0.14mm 9.43kg Verde

cz0252
Livrare imediată!

30,00Lei

Mulineta Carp Zoom Multifish Carp 5000RD

Mulineta Carp Zoom Multifish Carp 5000RD

cz3109
Livrare imediată!

85,00Lei

JUVELNIC CARP ZOOM ECO 5 SECTIUNI 40X160CM

JUVELNIC CARP ZOOM ECO 5 SECTIUNI 40X160CM

cz0030
Livrare imediată!

48,00Lei

Pelete Carp Zoom Big Carp - Catfish 28mm/800g

Pelete Carp Zoom Big Carp - Catfish 28mm/800g

cz2119
Livrare imediată!

35,00Lei

AGRAFA CU VARTEJ CARP ZOOM HELI NR.4 NEGRU MAT 10/SET -28%

AGRAFA CU VARTEJ CARP ZOOM HELI NR.4 NEGRU MAT 10/SET

cz2035
Livrare imediată!

18,00Lei(-28%) 12,90Lei

Saltea Cantarire Carp Zoom, 100 x 65cm

Saltea Cantarire Carp Zoom, 100 x 65cm

cz0956
Livrare imediată!

97,00Lei

MOMITOR CARP ZOOM SPIRALA 6cm

MOMITOR CARP ZOOM SPIRALA 6cm

cz9198
Livrare imediată!

4,00Lei

UMBRELA CU PARASOLAR CARP ZOOM 250cm

UMBRELA CU PARASOLAR CARP ZOOM 250cm

cz7634
Livrare imediată!

389,00Lei

CANTAR DIGITAL CARP ZOOM CU MANER RABATABIL 50kg

CANTAR DIGITAL CARP ZOOM CU MANER RABATABIL 50kg

cz7970
Livrare imediată!

184,00Lei

BAIT BAND SILICON MIC CARP ZOOM

BAIT BAND SILICON MIC CARP ZOOM

cz8801
Livrare imediată!

8,00Lei

AVERTIZOR CARP ZOOM CLIP-ON

AVERTIZOR CARP ZOOM CLIP-ON

cz3635
Livrare imediată!

42,00Lei

FIR CARP ZOOM FLUOROCARBON LEADER PREDATOR-Z 25m, 0.30mm, 6.62kg -20%

FIR CARP ZOOM FLUOROCARBON LEADER PREDATOR-Z 25m, 0.30mm, 6.62kg

cz2638
Livrare imediată!

35,00Lei(-20%) 27,91Lei

COBRA DE NADIT CARP ZOOM 20MM

COBRA DE NADIT CARP ZOOM 20MM

cz8038
Livrare imediată!

57,00Lei

FIR TEXTIL CARP ZOOM ALLROUND FISHING 110m 0.12mm 6.30kg Verde

FIR TEXTIL CARP ZOOM ALLROUND FISHING 110m 0.12mm 6.30kg Verde

cz0245
Livrare imediată!

30,00Lei

TRIPOD CARP ZOOM ALUMINIU

TRIPOD CARP ZOOM ALUMINIU

cz0568
Livrare imediată!

165,01Lei

SWINGER CARP ZOOM 2 in 1 S5 LUMINO ALBASTRU

SWINGER CARP ZOOM 2 in 1 S5 LUMINO ALBASTRU

cz1116
Livrare imediată!

33,00Lei

AVERTIZOR CARP ZOOM FSI

AVERTIZOR CARP ZOOM FSI

cz7826
Livrare imediată!

58,00Lei

Afişare 141 - 160 din 2138 (107 pagini)
Queries: 6, Total time: 67.965 ms [By time] [By id] [By file]
1 (0.099)
SELECT data
FROM `oc_session`
WHERE session_id = 'f669b363a245d1a469d977befd'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.095)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (59.633)
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('+zoom' 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 (7.852)
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 140, 20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:184
5 (0.141)
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.145)
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