Hey @Lionel Quiambao
So, off the bat, it sounds like a potential great opportunity for you. As long as everything checks out. And you'd have lots of options. I have a few thoughts and info.
First, do not list it in the mls. There is no benefit and it may actually be negative later on. I started my Appraisal career as a deputy Tax Assessor for LA County, so I know a little about this, even though that was many years ago. I am still a practicing Appraiser as well as a Realtor/Broker for many years. Property taxes in CA are very simple, they are a flat 1% of the Assessed Value. And the Assessed Value is based on the Market Value when the property transfers (sells). Technically, it is not based on the Purchase Price (PP) of the property, although, most of the time the PP is the same or close to the market value, and therefore, ends up being the assigned Assessed Value. That's probably why many people assume the Assessed Value is based on PP. Otherwise, you could get a $100 Assessed Value on a house, if you got an extreme discount.
Now, your actual tax bill includes additional voter indebtedness, bonds and other assessments, which are technically not property taxes, but are included on the tax bill, in addition to the 1% property tax rate. This is why taxes are more than 1% of the assessed value. Typically, I see the total rate to be around 1.12-1.15%, although, when I was a mortgage broker, we would use 1.25% for qualifying.
Ok, that may've been more than you wanted to know, but it is good education for the start of your journey. Remember, this is only for CA though, every state's property taxes are different. Now, no matter if you have it listed in the mls or not, it will get flagged by the Assessor as being significantly below market value, and it will be separately assessed closer to market value, based on comparables. Something you can do to help is to make sure you describe the unit in poor condition, etc, on the Preliminary Change of Ownership Form, which you be required to fill out when you purchase it. That way, when the Assessor looks at the transaction, they may understand that your unit is not worth $365k since it isn't remodeled, and hopefully, they will assess it significantly lower. And if you disagree with their assessment, then you can file an appeal. But, if you do, don't go in there saying it should be assessed at the purchase price, instead try and explain how the poor condition, etc, supported the lower purchase price. But, this transaction is what's called a non-arms length transaction, since you have an existing relationship with the seller (i.e. family friend). What that means is that the transaction had some atypical motivation, which contributed to the lower sale price.
Ok, enough of that. Anyway, the potential issue with listing it in the mls is, if you go to sell it shortly, even a year or so after, the Appraiser for the Buyer's lender has to explain significant rise in sale price, as compared to the $150k when you purchased it. And it is easier to explain that it sold under market value due to it being sold off-market in a non-arms length transaction. And since listing it in the mls really won't help the assessment issue, you really don't have anything to gain listing it.
Re: Insurance - typically the HOA has insurance on the building and the unit up until the interior. No additional insurance is needed, although, you are always able to get additional insurance if you want. But, it should be a lot less than your estimate of $1,277/yr. But, you would check with the HOA to see what their insurance covers, when it comes to your individual unit. I have never had an additional policy for my rental condo, except when I had it as an str.
Re: Renting it - I found FHA loans down just under 6% when I searched, so I will use 6%, with 3.5% down. I get mtg pmt of $934 + HOA $410 + property taxes $312 (Estimated from $325k @ 1.15% rounded) and tenant pays utilities and water is usually paid for by the HOA and sometimes gas and/or electricity, etc.. So your costs would be $1,655 before any other costs (maintenance, etc). So, you could actually rent the whole unit out and possibly not be negative until you sell it ( 1 year or 2), or you could live there and rent out the additional rooms and cover your costs, except for potential maintenance issues, etc. Basically you have options! I personally would not buy any longterm investment in the current CA market, unless it was significantly discounted or had some other value added potential. And this deal definitely checks the discounted box! But, it really comes down to what your goals are and what your situation is, etc. It's hard to speculate what to do with this deal, without knowing more. Feel free to reach out if you want to discuss it more specifically.