transaero

Noutăţi

No valid database connection Got error 28 from storage engine SQL=SELECT DISTINCT cats.title AS cat, users.name AS author, cats.section AS SID, content.title AS title, content.introtext AS text, content.created AS date, content.images AS images, content.id as IID, CASE WHEN CHAR_LENGTH(content.alias) THEN CONCAT_WS(":", content.id, content.alias) ELSE content.id END as ID, CASE WHEN CHAR_LENGTH(cats.alias) THEN CONCAT_WS(":", cats.id, cats.alias) ELSE cats.id END as CID FROM jos_content AS content LEFT JOIN jos_categories AS categories ON categories.id = content.catid LEFT JOIN jos_sections AS sections ON sections.id = content.sectionid LEFT JOIN jos_menu AS menu ON menu.componentid = content.id LEFT JOIN jos_users AS users ON users.id = content.created_by LEFT JOIN jos_content_frontpage AS frontpage ON content.id = frontpage.content_id LEFT JOIN jos_categories AS cats ON content.catid = cats.id WHERE content.state = 1 AND categories.access <= 0 AND content.access <= 0 AND categories.published = 1 AND ( content.publish_up = '0000-00-00 00:00:00' OR content.publish_up <= '2013-07-27�16:38:34' ) AND ( content.publish_down = '0000-00-00 00:00:00' OR content.publish_down >= '2013-07-27�16:38:34' ) AND ( content.id = 1012 OR content.id = 1009 OR content.id = 990 OR content.id = 971 OR content.id = 357 OR content.id = 485 OR content.id = 62 OR content.id = 64 OR content.id = 65 OR content.id = 63 OR content.id = 236 ) ORDER BY content.created DESC LIMIT 0,8;

    Погода

    °F°C
    invalid location provided
    Sanatoriul "Struguras"
    Twitter
    Нравится

    Sanatoriul „Struguras” este situat în parcul pitoresc pe malul rezervuarului Dubasari din satul Malovata Nouă. Territoriul sanatoriului dispune un plaj teraupetic, staţie de barcă, terenuri sportive.

     Descrierea bolilor tratate:

    sistemul locomotiv, sistemul nervos periferic, ficat şi sistemul biliar, ginecologie, organe de respirătoare

     

       Pentru tratament se aplica proceduri cu glod ( glod se procură din  Kualinik) şi cu apa minerală.                

    Tratament practicat: tratament cu parafin; balneoterapie, masaj manual, haloterapie, acupunctura, fitoterapie, fizioterapie, sauna.                                                      

    La dispoziţie - terenuri sportive pentru volei, baschet, billiard, tenis, simulator.

     

    Rezervari la tel 022 54 24 62/ 069141714