When an animal has the desired trait, that animal is bred and the genes are more likely (not guaranteed) to be passed on.

Dense area with over 200k residents within a 3-mile radiusBusy traffic counts of over 20k cars per day - makes it a desirable location for any tenant and guarantees business for the tenant 6.75% cap rate with 6yrs remaining on lease and 5-5yr optSurrounded by a combined 4 elementary and middle schools - makes it a desirable location for any tenant and guarantees business for the tenant Just note, this is a NNN lease with tenant paying all taxes, insurance and interior maintenance.

If the desire it to leverage your cash you'd be better-served to seek a debt instrument (loan or other) of some sort prior to investing in the syndication and then to invest those dollars instead mindful that this should be a disclosure item to your sponsor. 

Or 3) Does my limited availability hamper my desirability to a broker or mentor, to the point where my legal experience cannot compensate for my current commitments?

During the GR we converted the less desirable unit back to LTR rental during the school year.  

Property values are typically higher in desirable places near shops, offices, and public transportation than in less desirable areas.

ONe thing to consider is flip the tables.. become the bank.. let those that have the stomach and desire to landlord do that work.. you just collect checks each month your still invested in the exact same asset but with none of the liablities and day to day interface with PM and tenant.. 

I’m looking at duplex in a very desirable neighborhood, where I want to live, close to a ton of amenities.

Not the type of return desired by a non-passive investment like residential RE. 

Also, while I desire to do all I possibly can to retain the value and well being of my house, I can't afford to go crazy!