To answer your question, a 1500-1900 sf home of about 50-60 years old on a 5000-9000 sf lot on the peninsula within 15 miles south and west of Brisbane would cost approximately $550K to $850K. It may or may not need cosmetic or other work.
As far as I know, there is no Mello Roos close to there except in Foster City (a VERY congested newer area developed on built-up land on the interior of the bay).
I have not checked Hayward and Union City but would surmise that the same size and age home over there would cost $475K to $750K.
