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


ROD-POD LINEAEFFE CRAP ALUMINIU 3 POSTURI
Exclusiv online!

ROD-POD LINEAEFFE CRAP ALUMINIU 3 POSTURI

a6.6313056
Livrare 24-48 ore

155,13Lei

ROD POD NGT ALUMINIU QUICKFISH CU 3 POSTURI + HUSA DE TRANSPORT
Exclusiv online!

ROD POD NGT ALUMINIU QUICKFISH CU 3 POSTURI + HUSA DE TRANSPORT

ngt-fp-quickfish
Livrare 48-72 ore

255,01Lei

Rod Pod Prologic Tri Sky Aluminiu 4 posturi -10%

Rod Pod Prologic Tri Sky Aluminiu 4 posturi

a6.pro.54368
Livrare imediată!

754,36Lei(-10%) 678,93Lei

ADAPTOR MOSTIRO RAPID QUICK RELEASE ALUMINIU BLACK EDITION

ADAPTOR MOSTIRO RAPID QUICK RELEASE ALUMINIU BLACK EDITION

ai-0949j-alu
Livrare imediată!

13,80Lei

TRIPOD CARP ZOOM ALUMINIU

TRIPOD CARP ZOOM ALUMINIU

cz0568
Livrare imediată!

165,01Lei

Degorjor Energoteam Din Aluminiu Subtire

Degorjor Energoteam Din Aluminiu Subtire

80016055
Livrare imediată!

5,00Lei

LIP GRIP SPRO 24 CM ALUMINIU -25%

LIP GRIP SPRO 24 CM ALUMINIU

004702-00241-00000
Livrare imediată!

166,01Lei(-25%) 124,90Lei

MINCIOG CORMORAN ALUMINIU PLASA CAUCIUCATA 1.90M 50X50CM

MINCIOG CORMORAN ALUMINIU PLASA CAUCIUCATA 1.90M 50X50CM

a2.m62.45192
Livrare imediată!

153,22Lei

Rod Pod Prologic Tri-Sky Aluminiu 3 Posturi

Rod Pod Prologic Tri-Sky Aluminiu 3 Posturi

a6.pro.54367
Livrare imediată!

728,33Lei

MINCIOG CORMORAN ALUMINIU PLASA CAUCIUCATA 2.40M 70X70CM 6247 -20%

MINCIOG CORMORAN ALUMINIU PLASA CAUCIUCATA 2.40M 70X70CM 6247

a2.m62.47242
Livrare imediată!

237,54Lei(-20%) 190,03Lei

MINCIOG CORMORAN ALUMINIU PLASA CAUCIUCATA 2.40M 70X70CM

MINCIOG CORMORAN ALUMINIU PLASA CAUCIUCATA 2.40M 70X70CM

a2.m62.45242
Livrare imediată!

187,02Lei

SCAUN JAXON PLIANT ALUMINIU CU TAVA 57x47x45 79cm 2.7kg 22mm

SCAUN JAXON PLIANT ALUMINIU CU TAVA 57x47x45 79cm 2.7kg 22mm

ak-kzy111b
Livrare imediată!

299,00Lei

Suport Lanseta Telescopic Energo Team Aluminiu 45/90cm

Suport Lanseta Telescopic Energo Team Aluminiu 45/90cm

72149090
Livrare imediată!

15,01Lei

SUPORT CORMORAN TELESCOPIC ALUMINIU CU VARF OTEL L=60-105CM

SUPORT CORMORAN TELESCOPIC ALUMINIU CU VARF OTEL L=60-105CM

a6.63.30360
Livrare imediată!

25,06Lei

Suport Lanseta Telescopic Energo Team Aluminiu 60/110cm

Suport Lanseta Telescopic Energo Team Aluminiu 60/110cm

72149110
Livrare imediată!

18,00Lei

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

Afişare 41 - 60 din 176 (9 pagini)
Queries: 4, Total time: 9.097 ms [By time] [By id] [By file]
1 (0.121)
SELECT data
FROM `oc_session`
WHERE session_id = '6c048aad6dac890ad6df0026b5'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.130)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (8.712)
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 = '2' 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.134)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '2' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38