SELECT * FROM cms_1_shop_categs_hu WHERE SUB='0' AND ACTIVE='1' ORDER BY NAME ASC
SELECT * FROM cms_1_shop_categs_hu WHERE SUB='114' AND ACTIVE='1' ORDER BY NAME ASC
SELECT * FROM cms_1_shop_categs_hu WHERE SUB='71' AND ACTIVE='1' ORDER BY NAME ASC
SELECT * FROM cms_1_shop_categs_hu WHERE SUB='107' AND ACTIVE='1' ORDER BY NAME ASC
SELECT * FROM cms_1_shop_categs_hu WHERE SUB='93' AND ACTIVE='1' ORDER BY NAME ASC
SELECT * FROM cms_1_shop_categs_hu WHERE SUB='60' AND ACTIVE='1' ORDER BY NAME ASC
SELECT * FROM cms_1_shop_categs_hu WHERE SUB='137' AND ACTIVE='1' ORDER BY NAME ASC
SELECT * FROM cms_1_shop_categs_hu WHERE SUB='136' AND ACTIVE='1' ORDER BY NAME ASC
SELECT * FROM cms_1_shop_categs_hu WHERE SUB='49' AND ACTIVE='1' ORDER BY NAME ASC
SELECT * FROM cms_1_shop_categs_hu WHERE SUB='39' AND ACTIVE='1' ORDER BY NAME ASC
SELECT * FROM cms_1_shop_categs_hu WHERE SUB='77' AND ACTIVE='1' ORDER BY NAME ASC
SELECT * FROM cms_1_shop_categs_hu WHERE SUB='22' AND ACTIVE='1' ORDER BY NAME ASC
SELECT * FROM cms_1_shop_categs_hu WHERE SUB='34' AND ACTIVE='1' ORDER BY NAME ASC
SELECT * FROM cms_1_shop_categs_hu WHERE SUB='92' AND ACTIVE='1' ORDER BY NAME ASC
SELECT * FROM cms_1_shop_categs_hu WHERE SUB='102' AND ACTIVE='1' ORDER BY NAME ASC
SELECT * FROM cms_1_shop_categs_hu WHERE SUB='29' AND ACTIVE='1' ORDER BY NAME ASC
SELECT * FROM cms_1_contents_hu WHERE SUB='0' AND ACTIVE='1' AND (MODULE="home" OR MODULE="menu" OR MODULE="menu_fullwidth" OR MODULE="contact" OR MODULE="news" OR MODULE="faq") ORDER BY NO ASC
SELECT * FROM cms_1_contents_hu WHERE SUB='1' AND ACTIVE='1' AND (MODULE="home" OR MODULE="menu" OR MODULE="menu_fullwidth" OR MODULE="contact" OR MODULE="news" OR MODULE="faq") ORDER BY NO ASC
SELECT * FROM cms_1_contents_hu WHERE SUB='83' AND ACTIVE='1' AND (MODULE="home" OR MODULE="menu" OR MODULE="menu_fullwidth" OR MODULE="contact" OR MODULE="news" OR MODULE="faq") ORDER BY NO ASC
SELECT * FROM cms_1_contents_hu WHERE SUB='78' AND ACTIVE='1' AND (MODULE="home" OR MODULE="menu" OR MODULE="menu_fullwidth" OR MODULE="contact" OR MODULE="news" OR MODULE="faq") ORDER BY NO ASC
SELECT * FROM cms_1_contents_hu WHERE SUB='60' AND ACTIVE='1' AND (MODULE="home" OR MODULE="menu" OR MODULE="menu_fullwidth" OR MODULE="contact" OR MODULE="news" OR MODULE="faq") ORDER BY NO ASC
SELECT * FROM cms_1_contents_hu WHERE SUB='79' AND ACTIVE='1' AND (MODULE="home" OR MODULE="menu" OR MODULE="menu_fullwidth" OR MODULE="contact" OR MODULE="news" OR MODULE="faq") ORDER BY NO ASC
SELECT * FROM cms_1_contents_hu WHERE SUB='61' AND ACTIVE='1' AND (MODULE="home" OR MODULE="menu" OR MODULE="menu_fullwidth" OR MODULE="contact" OR MODULE="news" OR MODULE="faq") ORDER BY NO ASC
SELECT * FROM cms_1_contents_hu WHERE SUB='63' AND ACTIVE='1' AND (MODULE="home" OR MODULE="menu" OR MODULE="menu_fullwidth" OR MODULE="contact" OR MODULE="news" OR MODULE="faq") ORDER BY NO ASC
SELECT * FROM cms_1_contents_hu WHERE SUB='80' AND ACTIVE='1' AND (MODULE="home" OR MODULE="menu" OR MODULE="menu_fullwidth" OR MODULE="contact" OR MODULE="news" OR MODULE="faq") ORDER BY NO ASC
SELECT * FROM cms_1_contents_hu WHERE SUB='84' AND ACTIVE='1' AND (MODULE="home" OR MODULE="menu" OR MODULE="menu_fullwidth" OR MODULE="contact" OR MODULE="news" OR MODULE="faq") ORDER BY NO ASC
SELECT * FROM cms_1_sidebar WHERE CONTENTID="29" ORDER BY POSITION ASC
SELECT * FROM cms_1_pictures WHERE CONTENTID='' AND CONTENTTYPE='1' AND MAIN!='1'
SELECT * FROM cms_1_pictures WHERE CONTENTID='' AND MAIN='1' AND CONTENTTYPE='1'
SELECT * FROM cms_1_pictures WHERE CONTENTID='' AND MAIN='1' AND CONTENTTYPE='1'
SELECT * FROM cms_1_shop_hu WHERE SEARCHNAME = 'team-feeder-royal-method-carp-390mh-859'
SELECT * FROM cms_1_shop_categs_hu WHERE ACTIVE='1'
SELECT * FROM cms_1_shop_hu WHERE ACTIVE='1' AND ID!='' ORDER BY RAND(),VIEW DESC LIMIT 4
SELECT * FROM cms_1_pictures WHERE CONTENTID='1489' AND MAIN='1' AND CONTENTTYPE='88'
SELECT * FROM cms_1_pictures WHERE CONTENTID='1476' AND MAIN='1' AND CONTENTTYPE='88'
SELECT * FROM cms_1_pictures WHERE CONTENTID='1479' AND MAIN='1' AND CONTENTTYPE='88'
SELECT * FROM cms_1_pictures WHERE CONTENTID='1203' AND MAIN='1' AND CONTENTTYPE='88'
SELECT * FROM cms_1_shop_hu WHERE SEARCHNAME = 'team-feeder-royal-method-carp-390mh-859'
SELECT * FROM cms_1_pictures WHERE CONTENTID='859' AND CONTENTTYPE='88' AND MAIN!='1'
SELECT * FROM cms_1_shop_categs_hu WHERE ID='23' AND ACTIVE='1'
SELECT * FROM cms_1_shop_categs_hu WHERE ID='' AND ACTIVE='1'
SELECT * FROM cms_1_shop_categs_hu WHERE ID='' AND ACTIVE='1'
SELECT * FROM cms_1_shop_categs_hu WHERE ID='' AND ACTIVE='1'
SELECT * FROM cms_1_pictures WHERE CONTENTID='859' AND MAIN='1' AND CONTENTTYPE='88'
TEAM FEEDER Royal Method Carp 390MH | Horgaszni.hu
SELECT * FROM cms_1_news_hu WHERE ACTIVE='1' AND CATEG='1' ORDER BY PUBDATE DESC LIMIT 2
SELECT * FROM cms_1_contents_hu WHERE ACTIVE='1' AND SUB='0' AND (MODULE="home" OR MODULE="menu" OR MODULE="menu_fullwidth" OR MODULE="contact" OR MODULE="news" OR MODULE="faq") ORDER BY NO DESC LIMIT 1
SELECT * FROM cms_1_contents_hu WHERE ACTIVE='1' AND SUB='84' ORDER BY NO ASC
Az új Royal Method Carp botcsalád a legtökéletesebb, pontyhorgászathoz fejlesztett method feederbot a By Döme TEAM FEEDER botok között. Légies könnyedség, elképesztően vékony bottest és soha nem látott rugalmasság jellemzi. Mindehhez egy olyan tökéletes görbületi ív és karakterisztika párosul, amely a gyakorlott feederezőket is ámulatba ejti. Hogyan lehet ezt elérni? Az IMT-12 Power Carbon alapanyag kevlárhálós erősítéssel kellő alapot ad, gyakorlatilag törhetetlenné téve így a botot. De az igazi különlegessége nem ez! A vak is látja, hogy ezen nem hétköznapi gyűrűk kaptak helyet! Hol van ezekből a betét, miért ilyen vékonyak? Az új titán-króm gyűrűk fele olyan súlyúak és dupla élettartamúak, mint a legjobb, legkeményebb SiC gyűrűk. A finom, mégis rendkívül masszív gyűrűsor nem butítja el a botot, létrehozva azt az egyedi felépítményt, amely erre a pálcára jellemző. Régi vágya volt a termékeinket kedvelő horgászoknak, hogy legyen egy igazán érzékeny, de nagytávolságú horgászatot biztosító, 4,2 méter hosszú változat is a szortimentben. Örömmel jelentjük, hogy a 3,3; 3,6 és 3,9 méteres modellek mellett ez a bot immár 4,2 méteres változatban is elérhető. Aki unja már a hagyományos feedereket és egy igazán elegáns és extravagáns, végletekig terhelhető „gumislag” botra vágyik, az garantáltan megtalálja ebben a családban a neki valót!
