The real loss in in opportunity cost from what I could have found.Have others had similar experiences with buyer’s agency vs. dual agency?

It allows a substantial portion of the asset's cost to be deducted in the first year of service.In 2023, the bonus depreciation rate is 80%.In 2024, it decreases to 60%.In 2025, the rate further reduces to 40%.COST SEGREGATION:Cost segregation involves dividing a property into its individual components for tax purposes.Some parts age faster, like carpets or paint.Your CPA can use this info to more accurately depreciate elements of your property leading to potential tax savings.BASIS:Your basis is the initial price that you paid for your property, including any expenses or improvements.Knowing your basis is crucial for tax purposes, as it's used to evaluate depreciation & determine the capital gains or losses if/when your property sells.LAND VALUE:This is how much your land is worth without any buildings or improvements.Land doesn't get old like buildings, so you can't depreciate it.

The loss is very big for those family.

W-2, 1099, etc.) with passive income/loss from my rentals (STR, LTR).AnswerThere are a few ways, but the most common for real estate investors is to own a rental that 1.) meets the IRS requirements to be considered an STR and 2.) fulfill the material participation requirements (this doesn't require Real Estate Professional Status or REPS).

I will post my story on here... it resulted in a more than 8000 loss... and water bills which were not paid, and which Northpoint was supposed to assist in transfering to tenant's name. 

Should I just cut my losses.  

A complete loss of value is unlikely, but possible.

Can K1 losses from this LP only deal be also taken to offset W2 income?

I can only offset w-2 income with losses of the current year in which my wife became Real state.   

I would like to insure only for total loss and liability.