SELECT province_id,state_id,h_code,title,city_d,ifnull(street_i,' ') as street_i,stars, type, tel, ifnull(fax,' ') as fax, zip, if(strcmp(url_online,'http://')=0,' ',url) as url, if(strcmp(email,'@')=0,' ',email) as email, singlerooms,doublerooms,appartments,suites,ps_min,ps_max,pd_min,pd_max,pa_min,pa_max,pu_min,pu_max,pricetype,valuta FROM hotel WHERE active_ts=1 and h_code = '1901'
Almhof Hotel Call - Sankt Vigil, Südtirol, Italien
Home > Unterkünfte > Suchergebnis
> Details
