If you have $100k to invest and put as a down payment, would you get 1-2 places that have a Cash on Cash (COC) of $500+ a month but no appreciation, or 1 place with a 5-8% appreciation each year but you break even or lose $200-300 per month on the mortgage by renting out? 

Even if the units aren't completed you will get folks that will want to sign a lease due to location or price.

- Motion trigger activation, and I’d prefer if it would record longer than 30 seconds when triggered - The ability to download and store videos - Real time notification on my phone when camera is triggered - similar to my Ring doorbell I use at my home- Cameras record both video and AUDIO- My ability to talk to people through the cameras would be a bonus - Night vision for outside cameras a bonus- Ability to remotely swivel horizontally - and vertically?

I'm loathe to pay for courses or sign up with guru-esque trainers, but also realize that botched DD can cost even more. 

Hi Carlos, since best option is off table and now you need to look for a new buyer maybe try relisting it with an agent who has good network and understanding of what the goals in this transaction are. you never going to get the dollar-to-dollar value that you put into the property, and we are not even considering the time and headache.

If you’re even considering this look around for something with a $10-$20k deductible and see if you can cut it in half.

I am looking to make some connections near me and perhaps even some partnerships.

Jimmy Klein  Evan,A flagged property is a "branded" hotel like one in the Marriott, Hilton, Hyatt, or even "lesser" brands.

A two-family where you live in one side and rent your other rooms to friends and then rent the other side (maybe even do mid-term rental or short-term) with a much lower downpayment is potentially a better producer.

At $300/door you would need 17 or so doors to  do that… and even then you won’t clear all that with reserves you will want to set aside.