Just like any aspect of real estate investing, non-consumer lending at a large scale is a relationship business. 

How does one define design choices, etc?

2) Please define "above market upside in year two and beyond" as not understanding... 

Other places to look are Interior Define, Living Spaces, West Elm, Nathan James and Albany Park.

I imagine there’s a different dynamic with tenants sharing common spaces, so I’d love to get your insights on how to manage this aspect effectively.Thanks for sharing your experience, looking forward to learning more!

Educate yourself with books, podcasts, and market research, define your goals, and build a team of professionals to support your journey.

You may not need "2 years of work history" either depending on the detailsGenerally speaking there are 2 main types of loans for investors: “Conventional” and “Portfolio”Conventional - I'll define these as loans that come from Fannie Mae and Freddie Mac (if you recognize those names).

Tried QuickBooks and didn't like the Customer/Vendor aspect for properties and tenants.

The aspects that would make me look very hard are: 1) how do I ever actually get my $$ back out of the UPREIT?

As I am new to this and looking for cashflow using rentals, one key aspect of this investment is to ensure that the unit rents out quickly and while I do understand that cash flow to begin with might not be attractive, it can be a good investment in the long run if the location is right(as appreciation also kicks in).