No valid database connection You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' u.name AS author, u.usertype, cc.title AS category, s.title AS section, CASE WH' at line 1 SQL=SELECT DISTINCT a.id, a.*, jfc.value as jfcvalue, , u.name AS author, u.usertype, cc.title AS category, s.title AS section, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END as slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END as catslug, g.name AS groups, s.published AS sec_pub, cc.published AS cat_pub, s.access AS sec_access, cc.access AS cat_access FROM jos_content AS a LEFT JOIN jos_categories AS cc ON cc.id = a.catid LEFT JOIN jos_sections AS s ON s.id = cc.section AND s.scope = "content" LEFT JOIN jos_users AS u ON u.id = a.created_by LEFT JOIN jos_groups AS g ON a.access = g.id LEFT JOIN jos_jf_content as jfc ON jfc.reference_table='content' AND jfc.reference_id=a.id AND jfc.reference_field='title' AND jfc.language_id =1 WHERE jfc.reference_id IS NOT NULL AND jfc.published=1 AND a.id = 54 AND ( ( a.created_by = 0 ) OR ( a.state = 1 AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2010-09-05 15:10:22' ) AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2010-09-05 15:10:22' ) ) OR ( a.state = -1 ) )
Spa Vacations
The hotel lies 500 meters from Polo Spa, easily reachable with a nice relaxing walk or, by the comfortable hotel's free bicycles provided. Riminiterme is fully equipped for comfort and can offer you a stay from the sea to tap the best of his power and his wealth to the benefit of your health, your well-being in perfect harmony with nature! Thalassotherapy is an integrated method climatotherapy particularly comprehensive because it offers the possibility of exploiting the complex therapeutic synergism between seawater and the marine climate factors. The main therapeutic applications of sea water are carried through the inhalation treatment and care and vascular balneoteapiche.
In the Terme of Rimini everyone can find the path tailored to improve their welfare. All benefits, whether they are assigned to the action of sea water, sludge or to the herbs, have a common characteristic: they are 100% natural. Riminiterme offers a range of therapies such as inhalation, aerosol, a department where you can effectively prevent and treat diseases of the entire respiratory system.
For those who consider natural medicine a possibility to recover from their physical and mental energies can find: in a variety of massage spa pool, sauna, turkish bath, massages, shiatsu, lymphatic drainage and biorilassanti, beauty treatments for face and body, poultices marine sludge slimming teas and many other treatments targeted to run under the careful supervision of our medical team.
For all these reasons, a stay in a hotel near the Terme of Rimini can take advantage of these services. Hotel Villa Irma can directly book all treatments that you think would do .... even before your arrival!
Take care of yourself is the best therapy Spa for a wonderful holiday in our hotel in Rimini.
