Listed by Bret Evans of RE/MAX Gold Redwood Shores
Great location close to everything! You will love this charming duplex located on a wide, tree-lined street in the highly desirable Sunnybrae neighborhood of San Mateo. Exterior repainted. New roof on the rear unit. The front residence features 2 bedrooms and 2 bathrooms, two cozy fireplaces, original oak hardwood floors, and a large welcoming entryway, all thoughtfully updated while maintaining classic character. The separate dining room flows into a spacious kitchen with pantry space and an in-unit washer and dryer, creating a functional layout ideal for everyday living and entertaining. A detached 2-car garage and additional parking at the end of the driveway provide excellent convenience. Sunnybrae is known for its unique, solidly built homes and excellent access to transportation, shopping, and diningall within minutes. The property is also located in a strong local school district, adding to its long-term appeal. The rear unit offers a private 2-bedroom, 1-bath layout with its own kitchen and laundry room, making it perfect for extended family, guests, or rental income potential. This versatile duplex presents a rare opportunity for both owner-occupants and investors in one of the Peninsulas most sought-after neighborhoods.

Listing Tools

Property Details of 515 S Fremont Street

Property Details

Exterior Features

Map Location

Based on information submitted to CRMLS as of June 4, 2026 5:21 AM 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 W 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.

Hi there! How can we help you?

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

Send Us A Message:

Do not fill in this field:

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

Hi there! How can we help you?

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

Send Us A Message:

Do not fill in this field:

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

Do not fill in this field:

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

Do not fill in this field:

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

Do not fill in this field:

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

$

Do not fill in this field:

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