A lot of people buy STRs with the same general idea who are not running the numbers first, so the prices are generally inflated by the dumb money factor. Keep that in mind.
I would probably assume you'll break even on the place at best if you hire out cleaning/management. If not, assume it'll be a HUGE pain/second job type situation. If this place was minting money, why is it for sale? Do you have the full tax filings for the last few years, or just the owner's word?
At 85% occupancy (call it 300 nights to make the math easy) and $500 a night (assuming it's a nice enough bungalow to command that rate) you'd be grossing $150k. With those generous assumptions, not bad! But management and cleaning/maintenance are going to whack off 30% or more, and that's before you pay the PITI.
I guess the most helpful thing would be to get an actual breakdown of the nights it was rented over the last couple of years, the rate it was rented for, and all the overhead costs paid by the owners. Without that info, you're just basically taking their word for it (and nobody here can give you any real advice, since the numbers are all hand-waved at this point).
So far, we have:
$1k/mo in property taxes
$300/mo in insurance (!!! Really? For a million dollar STR in Cali? Have you actually gotten a quote for this?)
$5800 or so in principal/interest assuming a 30 year note
So $7100 a month with zero maintenance/management/utility/overhead costs.
Even assuming those costs are zero, at 300 (optimistic) days occupied per year and $500/day (optimistic?) you're already down to $65k in net income. If you use the place during peak times yourself, those numbers are going to drop significantly, too.
I think the chances that you beat the S&P are low to negligible, but I've been saying RE was overpriced for the last 5 years and been consistently wrong, so what do I know.
-W