I only listen to 2 x car podcasts, 2 money podcasts and 6 real estate podcasts.

I only have 4 SFR with sec 8 but I’d highly recommend it.

If you are too busy to go see a whole bunch of properties in person, meet PMs, and help with getting your first property stabilized... you may want to wait until you have more time.Not trying to be negative, just realistic. 

So eventually this negative cash flow property becomes cash flow positive and pays for itself including property taxes, hoa, mortgage etc.Trying to calculate how bad is my investment here or should i sell out if there is appreciation 

There is no such absolute rule or mandate for REI - it is up to you on your comfort level with your cash flow versus total investment versus appreciation potential.If I followed that rule, I would have missed out on a LOT of great opportunities over the years.We bought a house in Jones Valley in 2017 with negative cash flow - why? 

Also, focus on 2 years of job/income stability.Class D Properties:Cashflow vs Appreciation: Typically, all cashflow with little, maybe even negative, relative rent & value appreciationVacancy Est: 20%+ should be used to cover nonpayment, evictions & damages.Tenant Pool: majority will have FICO scores under 560 (almost 30% probability of default), little to no good tradelines, lots of collections & chargeoffs, recent evictions.

Also, focus on 2 years of job/income stability.Class D Properties:Cashflow vs Appreciation: Typically, all cashflow with little, maybe even negative, relative rent & value appreciationVacancy Est: 20%+ should be used to cover nonpayment, evictions & damages.Tenant Pool: majority will have FICO scores under 560 (almost 30% probability of default), little to no good tradelines, lots of collections & chargeoffs, recent evictions.

Also, focus on 2 years of job/income stability.Class D Properties:Cashflow vs Appreciation: Typically, all cashflow with little, maybe even negative, relative rent & value appreciationVacancy Est: 20%+ should be used to cover nonpayment, evictions & damages.Tenant Pool: majority will have FICO scores under 560 (almost 30% probability of default), little to no good tradelines, lots of collections & chargeoffs, recent evictions.

For this deal to work under those conditions, the purchase price would need to be closer to $179k.With your original assumptions 249k, the deal is marginally acceptable but not great, given the negative cash flow in the early years.

I only have enough funds for a 20-25% downpayment and was looking to do a DSCR loan to cover the rest.