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-long-cast-method-feeder-kosar-l-416'
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='1203' AND MAIN='1' AND CONTENTTYPE='88'
SELECT * FROM cms_1_pictures WHERE CONTENTID='1478' AND MAIN='1' AND CONTENTTYPE='88'
SELECT * FROM cms_1_pictures WHERE CONTENTID='1205' AND MAIN='1' AND CONTENTTYPE='88'
SELECT * FROM cms_1_pictures WHERE CONTENTID='1480' AND MAIN='1' AND CONTENTTYPE='88'
SELECT * FROM cms_1_shop_hu WHERE SEARCHNAME = 'team-feeder-long-cast-method-feeder-kosar-l-416'
SELECT * FROM cms_1_pictures WHERE CONTENTID='416' AND CONTENTTYPE='88' AND MAIN!='1'
SELECT * FROM cms_1_shop_categs_hu WHERE ID='40' AND ACTIVE='1'
SELECT * FROM cms_1_shop_categs_hu WHERE ID='39' AND ACTIVE='1'
SELECT * FROM cms_1_shop_categs_hu WHERE ID='0' AND ACTIVE='1'
SELECT * FROM cms_1_shop_categs_hu WHERE ID='' AND ACTIVE='1'
SELECT * FROM cms_1_pictures WHERE CONTENTID='416' AND MAIN='1' AND CONTENTTYPE='88'
TEAM FEEDER Long Cast Method Feeder kosár L | 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
A folyamatos fejlesztéseknek köszönhetően, egyre jobb eszközöket adhatunk a horgászok kezébe. Az egyszerű használhatóság, precíz kialakítás, modern kivitelezés és maximális hatékonyság ötvözete a Haldorádó feederkosarak legújabb tagja. A By Döme TEAM FEEDER Long Cast Method Feeder kosár, amely kifejezetten távoli methodozáshoz készült, így minden paramétere ennek megfelelően lett kialakítva. A kosár tartalmát becsapódáskor megvédő perem, a félfix kialakítás, a dobást segítő vezetőszár, és a kosár alján lévő oldódást segítő lyukak mind olyan újítások, amelyek a nagy távolságban történő method horgászat során elengedhetetlenek. Az etetőkosár használható kézzel megtöltve, de az áramvonalas gombóc kialakítása érdekében ajánlott a hozzá illő szilikon töltőszerszám használata.
Az L-es méret 25, 35 és 45 grammos méretekben, míg az XL-es méretű kosarak 55 és 65 grammos méretekben kerülnek forgalomba.
