Listed by Jon Ahern of Coldwell Banker Realty
Fantastic Fairview location with views of the bay and privacy. Once in a lifetime opportunity to own 3 detached homes in a top location. SB-9 could possibly allow a future owner to split the lot into three lots and sell each home individually, buyer to verify. - Unit #1 - 3 bedrooms and 2.5 baths. 2017 Construction. Charming home with lots of parking. Room for a boat or RV. Huge backyard. Extra special home for a landscaper or someone in construction. - Unit 2 - 2 bedrooms and 1.5 baths - Great floor plan, 2 car garage. Huge basement area with a bathroom that could be converted. Lots of storage. Tons of parking. - Unit #3 - 2 bedrooms, 1.5 baths. Once car garage. Fantastic floor plan, large back yard. Lots of room for parking. Separately metered for water & PG&E. Great fit for an investor, or a multi generational living situation which offers 3 detached homes.

Listing Tools (detailViewNewGen)

Property Details of 24728 Fairview Avenue

Property Details

Exterior Features

Community

Map Location

Based on information submitted to CRMLS as of May 16, 2026 4:51 PM EDT . All data is deemed reliable but is not guaranteed accurate by the MLS. All information should be independently reviewed and verified for accuracy. IDX information is provided exclusively for consumers’ personal, noncommercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing.

Hi there! How can we help you?

Contact us using the form below or give us a call.

Send Us A Message:

I agree to receive marketing and customer service calls and text messages from Seven Gables Real Estate. To opt out, you can reply 'stop' at any time or click the unsubscribe link in the emails. Consent is not a condition of purchase. Msg/data rates may apply. Msg frequency varies. Privacy Policy.

Do not fill in this field:

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.