My plan is to live on the upper unit and rent a room out to a buddy and turn the lower unit into a midterm rental.

It's a riskier loan given you do not carry a social security, no US credit & no experience.Due to increased risk comes mitigation (Lower LTV & Higher Rates)

There are accountants who say that applies to the opportunity to discount sale and/or basis shift to further lower the tax bill.  

@Tove Fox - Residential Real Estate InvestingPros:Lower Entry Costs: Easier to get started with less capital required.High Demand: People always need homes, making demand relatively stable.Easier Financing: Mortgages are generally easier to secure with favorable terms.Simplicity: Easier to understand and manage, especially for beginners.Flexibility: You can use it as a personal residence or rent it out.Cons:Tenant Turnover: More frequent turnover leads to vacancy and more management.Lower Cash Flow: Income potential can be modest compared to commercial properties.Emotional Buyers: Residential prices can be influenced by emotions, leading to price volatility.Maintenance Burden: Landlords often deal with repairs and maintenance, which can be time-consuming.Commercial Real Estate InvestingPros:Higher Income Potential: Stronger cash flow and higher returns are common.Long-Term Leases: Tenants often sign longer leases (3-10 years), reducing vacancy risk.Professional Tenants: Business tenants tend to take better care of the property.Valuation Based on Income: Prices are based on the income the property generates, not market emotions.Shared Costs: Tenants often cover property expenses like taxes, insurance, and maintenance (via triple-net leases).Cons:High Entry Costs: Requires more capital or partnerships to get started.Complex Management: More expertise is needed; you may need a professional property manager.Economic Sensitivity: Commercial properties are more sensitive to economic conditions.Challenging Financing: Securing financing can be harder, with stricter terms and higher interest rates.Zoning and Legalities: More complex regulations compared to residential properties.Key Differences:Risk: Residential tends to be lower risk, while commercial offers higher rewards but with greater risk.Management: Residential is easier for DIY investors, while commercial properties usually require a team.Scalability: Commercial properties are easier to scale, offering more potential for significant cash flow increases.

I am torn between pricing rent lower with a minimum 3 night stay or just weeding out the less desirable/more work clients with higher pricing.  

Syndicates that used lower leverage points and have far-out maturities (such as 2029 or later) are likely to survive as long as they don't run out of cash to maintain the assets for longer-than-planned hold times. 

Section 8  rates (and lower) will also give you a rough idea of what your market rent will be.Yours is an object lesson in the mistake of buying what you can afford up front rather than what is a good opportunity.People just starting out should only buy local, that they themselves can inspect and get a feel for.

that we’ve learned in our 24 years, managing almost 700 doors across the Metro Detroit area, including almost 100 S8 leases:Class A Properties:Cashflow vs Appreciation: Typically, 3-5 years for positive cashflow, but you get highest relative rent & value appreciation.Vacancy Est: Historically 10%, 5% the more recent norm.Tenant Pool: Majority will have FICO scores of 680+ (roughly 5% probability of default), zero evictions in last 7 years.Class B Properties:Cashflow vs Appreciation: Typically, decent amount of relative rent & value appreciation.Vacancy Est: Historically 10%, 5% should be applied only if proper research done to support.Tenant Pool: Majority will have FICO scores of 620-680 (around 10% probability of default), some blemishes, but should have no evictions in last 5 yearsClass C Properties:Cashflow vs Appreciation: Typically, high cashflow and at the lower end of relative rent & value appreciation.

Now I have two vacancies and lower rents than when we started. 

that we’ve learned in our 24 years, managing almost 700 doors across the Metro Detroit area, including almost 100 S8 leases:Class A Properties:Cashflow vs Appreciation: Typically, 3-5 years for positive cashflow, but you get highest relative rent & value appreciation.Vacancy Est: Historically 10%, 5% the more recent norm.Tenant Pool: Majority will have FICO scores of 680+ (roughly 5% probability of default), zero evictions in last 7 years.Class B Properties:Cashflow vs Appreciation: Typically, decent amount of relative rent & value appreciation.Vacancy Est: Historically 10%, 5% should be applied only if proper research done to support.Tenant Pool: Majority will have FICO scores of 620-680 (around 10% probability of default), some blemishes, but should have no evictions in last 5 yearsClass C Properties:Cashflow vs Appreciation: Typically, high cashflow and at the lower end of relative rent & value appreciation.