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


Maner Minciog Telescopic Spro C-Tec S-Fix Handle, 2.00m

Maner Minciog Telescopic Spro C-Tec S-Fix Handle, 2.00m

003884-00530-00000
Stoc epuizat

121,00Lei

Minciog Fox Rage Speed Flow Large, 85x75x85cm

Minciog Fox Rage Speed Flow Large, 85x75x85cm

nln026
Stoc epuizat

404,96Lei

MINCIOG CARP SPIRIT 100X80CM 180CM -50%

MINCIOG CARP SPIRIT 100X80CM 180CM

acc180000
Stoc epuizat

159,00Lei(-50%) 80,00Lei

Cap Minciog EnergoTeam Oval 55x45cm -20%

Cap Minciog EnergoTeam Oval 55x45cm

71027155
Stoc epuizat

42,00Lei(-20%) 33,61Lei

MINCIOG LINEAEFFE 3,00M D100X100CM

MINCIOG LINEAEFFE 3,00M D100X100CM

a2.m6101860
Stoc epuizat

157,59Lei

Cap Minciog cu 2 Flotoare NGT, 107x90cm

Cap Minciog cu 2 Flotoare NGT, 107x90cm

fnh-net-42-bbc-dnf-grn
Stoc epuizat

89,00Lei

MINCIOG ALUMINIU CORMORAN 2.50M 80X70CM

MINCIOG ALUMINIU CORMORAN 2.50M 80X70CM

a2.m62.11874
Stoc epuizat

227,75Lei

MANER MINCIOG K-KARP PIONEER 1.80MT HM CARBON -22%

MANER MINCIOG K-KARP PIONEER 1.80MT HM CARBON

084-40-650
Stoc epuizat

179,00Lei(-22%) 139,90Lei

CAP MINCIOG CRESTA NANO MESH 50X40X30CM

CAP MINCIOG CRESTA NANO MESH 50X40X30CM

003289-00041-00000
Stoc epuizat

72,00Lei

Minciog Carp Zoom Gamma XXL 2 Sec. 100x100x280cm

Minciog Carp Zoom Gamma XXL 2 Sec. 100x100x280cm

cz1406
Stoc epuizat

227,00Lei

CAP MINCIOG MAVER MEDUSA CAUCIUCAT 60X50CM

CAP MINCIOG MAVER MEDUSA CAUCIUCAT 60X50CM

1968000
Stoc epuizat

121,00Lei

MINCIOG JAXON STRONG B1 ALU 300

MINCIOG JAXON STRONG B1 ALU 300

pl-acb1300f
Livrare imediată!

153,00Lei

Cap Minciog Energo Team Mono 45cm

Cap Minciog Energo Team Mono 45cm

71027445
Stoc epuizat

50,00Lei

CAP MINCIOG JAXON NYLON 20MM 45x55CM MODEL 2

CAP MINCIOG JAXON NYLON 20MM 45x55CM MODEL 2

pz-lxf5545
Stoc epuizat

83,00Lei

CAP MINCIOG CARP EXPERT COMPETITIE BLACK SUPER CARP 50X60CM

CAP MINCIOG CARP EXPERT COMPETITIE BLACK SUPER CARP 50X60CM

71024050
Stoc epuizat

49,00Lei

CAP MINCIOG SPRO C-TEC CU PLASA CAUCIUCATA 8MM 65X55X35CM

CAP MINCIOG SPRO C-TEC CU PLASA CAUCIUCATA 8MM 65X55X35CM

003230-00102-00000
Stoc epuizat

95,00Lei

Cap de Minciog NGT Stationar 56x46x50cm

Cap de Minciog NGT Stationar 56x46x50cm

ngt-fnh-net-match-std
Stoc epuizat

42,00Lei

Maner Minciog Delphin ATOMA Feeder 320cm Tele -29%

Maner Minciog Delphin ATOMA Feeder 320cm Tele

941001570
Stoc epuizat

178,00Lei(-29%) 126,00Lei

CAP MINCIOG CRESTA NANO MESH 45X35X25CM

CAP MINCIOG CRESTA NANO MESH 45X35X25CM

003289-00040-00000
Stoc epuizat

66,00Lei

CAP MINCIOG JAXON 10MM 45X55CM

CAP MINCIOG JAXON 10MM 45X55CM

ps-lms779
Stoc epuizat

54,00Lei

Afişare 1121 - 1140 din 1357 (68 pagini)
Queries: 6, Total time: 31.927 ms [By time] [By id] [By file]
1 (0.105)
SELECT data
FROM `oc_session`
WHERE session_id = '66afa1ec5a83edbbf0fc8388af'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.139)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:428
3 (31.114)
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('+minciog' 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.211)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"RAPALA VMC ROMANIA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
5 (0.156)
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.202)
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