First time posting and getting into the investment scene, I currently have a single family home that was my previous primary, and looking into purchasing my 1st true investment property, trying to find some advice on the financial aspect of the purchase, here's my scenario;Currently going through pre-approval with the builder and I do have liquid assets enough to cover the downpayment for the property (40k) but I do have a car note (41k, 800 monthly, extra 500 to principal monthly) and a Patio upgrade (25k no interest till March 2025).

Assuming a current typical interest rate of 7%, principal and interest will run $536 a month.

Though in CA, 5 years delinquency on property taxes, the city can file a lien and auction off the house.If I pay those taxes, what's the process of if I wanted to take possession of the property after the 5 years delinquent taxes?

Thus your asset is appreciating (building equity) every principal payment you make. 

It is common for many auctions to get called off at the last minute because people will file a court paper to get the auction stopped.  

They're refusing to remove the UCC filing.

What do you think about my other strategy of doing seg study and bonus depreciation on all my rentals for the year 2023 (have not filed it yet) to do the following:1- To get a bigger loss carried forward to 2024 to offset the sale of 3 properties instead of 2 in 2024. 2- Or, Since I married a realtor this year 2024 (and we passed the IRS active participation test together), I can activate that loophole, use whatever loss (bigger lost if we can use the seg study) is left over from the sale of the property to offset my high  W-2 wages (way over the $150K threshold) in 2024. 

I have never filed a claim.Of course you're having a stellar experience..

I don't file claims when my trucks are broken into anymore.

I think it's important to start with this - is your 250k debt what you owe in principal on the mortgage on your home or is this separate debt (credit cards, cars, medical, student, etc)?