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


MINCIOG CORMORAN ALUMINIU PLASA CAUCIUCATA 2.20M 60X60CM -20%

MINCIOG CORMORAN ALUMINIU PLASA CAUCIUCATA 2.20M 60X60CM

a2.m62.45222
Livrare imediată!

174,78Lei(-20%) 139,84Lei

Suport telescopic Energo Aluminiu Si Otel 60-90cm

Suport telescopic Energo Aluminiu Si Otel 60-90cm

72149055
Livrare imediată!

12,99Lei

MINCIOG CORMORAN ALUMINIU PLASA CAUCIUCATA 2.00M 60X60CM
Exclusiv online!

MINCIOG CORMORAN ALUMINIU PLASA CAUCIUCATA 2.00M 60X60CM

a2.m62.48202
Livrare 24-48 ore

158,82Lei

SUPORT ENERGOTEAM TELESCOPIC LANSETA ALUMINIU + OTEL 70-110CM

SUPORT ENERGOTEAM TELESCOPIC LANSETA ALUMINIU + OTEL 70-110CM

72149068
Livrare imediată!

18,00Lei

SUPORT SPRO C-TEC ALUMINIU STORM CU INFILETARE 70-120 CM -28%

SUPORT SPRO C-TEC ALUMINIU STORM CU INFILETARE 70-120 CM

006540-00110-00000
Livrare imediată!

83,00Lei(-28%) 59,90Lei

SUPORT SPRO C-TEC ALUMINIU STORM CU INFILETARE 42-64 CM -27%

SUPORT SPRO C-TEC ALUMINIU STORM CU INFILETARE 42-64 CM

006540-00108-00000
Livrare imediată!

60,00Lei(-27%) 43,90Lei

SUPORT SPRO C-TEC ALUMINIU STORM CU INFILETARE 60-99 CM

SUPORT SPRO C-TEC ALUMINIU STORM CU INFILETARE 60-99 CM

006540-00109-00000
Livrare imediată!

70,00Lei

MANER MINCIOG JAXON ALUMINIU TELE UNIVERSAL 180CM
Exclusiv online!

MANER MINCIOG JAXON ALUMINIU TELE UNIVERSAL 180CM

pl-han01
Livrare 48-72 ore

60,00Lei

SUPORT ENERGO TEAM TELESCOPIC ALUMINIU PLUS OTEL 70/110 cm

SUPORT ENERGO TEAM TELESCOPIC ALUMINIU PLUS OTEL 70/110 cm

72149067
Livrare imediată!

18,00Lei

SUPORT SPRO C-TEC ALUMINIU STORM CU INFILETARE 108-198 CM
Exclusiv online!

SUPORT SPRO C-TEC ALUMINIU STORM CU INFILETARE 108-198 CM

006540-00111-00000
Livrare 48-72 ore

90,00Lei

Prastie Supreme Aluminiu

Prastie Supreme Aluminiu

80252350
Livrare imediată!

24,00Lei

SUPORT ENERGO TEAM TELESCOPIC ALUMINIU PLUS OTEL 60/90 cm

SUPORT ENERGO TEAM TELESCOPIC ALUMINIU PLUS OTEL 60/90 cm

72149056
Livrare imediată!

11,50Lei

Minciog Cormoran Aluminiu Plasa Cauciucata, 80x80cm, 280cm, 3seg
Exclusiv online!

Minciog Cormoran Aluminiu Plasa Cauciucata, 80x80cm, 280cm, 3seg

a2.m62.47293
Livrare 24-48 ore

305,94Lei

Suport Energo Team Lansete Aluminiu 70cm Fluo Orange U

Suport Energo Team Lansete Aluminiu 70cm Fluo Orange U

77030820
Livrare imediată!

12,50Lei

Suport Energo Team Lansete Aluminiu 70cm Fluo Orange Y

Suport Energo Team Lansete Aluminiu 70cm Fluo Orange Y

77030840
Livrare imediată!

12,50Lei

PICIOR ALUMINIU COLMIC TELE 30mm - 65cm
Exclusiv online!

PICIOR ALUMINIU COLMIC TELE 30mm - 65cm

pa2056a
Livrare 48-72 ore

199,00Lei

STICK TRAKKO ALUMINIU 75 CM
Exclusiv online!

STICK TRAKKO ALUMINIU 75 CM

tr015
Livrare 48-72 ore

35,00Lei

MANER MINCIOG LINEAEFFE ALUMINIU TELE. 2M
Exclusiv online!

MANER MINCIOG LINEAEFFE ALUMINIU TELE. 2M

a2.6300820
Livrare 24-48 ore

65,75Lei

STICK TRAKKO ALUMINIU 50 CM
Exclusiv online!

STICK TRAKKO ALUMINIU 50 CM

tr014
Livrare 48-72 ore

29,00Lei

Minciog Baracuda BH-60 aluminiu 2.45M

Minciog Baracuda BH-60 aluminiu 2.45M

minciog bh-60
Livrare imediată!

109,90Lei

Afişare 41 - 60 din 182 (10 pagini)
Queries: 4, Total time: 5.821 ms [By time] [By id] [By file]
1 (0.138)
SELECT data
FROM `oc_session`
WHERE session_id = '0d6beb527c749240c7be77bf86'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.110)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (5.427)
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('+aluminiu' 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.146)
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