• Facebook
  • Twitter
  • Instagram
  • LinkedIn
  • Blog
Phone714-745-2708
Login or sign up for new accountLogin / Register
Email Our TeamEmail Us
  • Search Listings
    • Residential
    • Lease
    • Commercial
  • Previous Sales
  •   Local
    • Fullerton
    • Tustin
    • Yorba Linda
    • Santa Ana
    • Orange Park Acres
    • North Tustin
    • Orange
    • Anaheim
  •   Buyers
    • Ways To Take Title In California
    • Vesting
    • Renting vs. buying
    • How much can I afford?
    • Why work with a real estate agent
    • Finding your home
    • What do you want in a home?
    • Submitting an offer
    • After the offer is accepted
    • Moving
  •     Sellers
    • Anaheim FAQ
    • New Sellers and Buyers Guide
    • Why work with a real estate agent
    • Getting your home ready for sale
    • Pricing your home to sell
    • Negotiating the sale
    • Transaction management
    • Moving
  •     Services
    • Onepoint
    • Home Financing
    • Insurance
    • Escrow
    • Title
    • Home Warranty
    • PRESALE/STAGING
    • Relocation
  •     About
    • Why Choose The Keaty Team
    • Leadership Team
    • About Us
    • Globally Respected
    • The Charitable Foundation
    • Diversity & Inclusion
    • Doyle
    • Agents Only
  • Our Team
  • Blog
Menu
Berkshire Hathaway HomeServices California Properties Berkshire Hathaway HomeServices California Properties
Any Price
-
  • 0
  • $100,000+
  • $250,000+
  • $500,000+
  • $750,000+
  • $1,000,000+
0+ Beds
  • 0+
  • 1+
  • 2+
  • 3+
  • 4+
  • 5+
0+ Baths
  • 0+
  • 1+
  • 2+
  • 3+
  • 4+
  • 5+
Property Type
Other
  • Home
  • 515 S Fremont Street

515 S Fremont Street, San Mateo, CA 94402

$1,799,000 Approx. USD 0 beds, 0 baths
2,220 sqft

  VIRTUAL TOUR New Listing
Save My Notes
Share
  • Copy Link
  • Facebook
  • Twitter
  • Pinterest
Source MLS Verified
MORE INFO
BrochureBrochure Virtual Tour
The Keaty Team

View Team Members

Photo of Kevin Keaty

The Keaty Team REALTOR® - Sales Associate 714-608-3298 m
714-745-2708 o
Lic#: 01276603
NRDS ID: 187514104
thekeatyteam@bhhscal.com
Text Me
Call My Cell
Call My Office
Lic#: 01276603
NRDS ID: 187514104
thekeatyteam@bhhscal.com
Tustin Office
18302 Irvine Blvd, Suite 240
Tustin, CA 92780
Phone: 714-832-8800
Fax: 949-565-7700
Tustin 18302 Irvine Blvd, Suite 240
Tustin, CA 92780
Call Branch Office
Fax: 949-565-7700
Mortgage Calculator
GET PRE-APPROVED
Interested in This Property? Your message will be sent to Kevin.
By submitting your information, you consent to be contacted by email, SMS message, and/or phone call. You may opt out at any time per our Privacy Policy.
  • Save
  • My Notes

Listing Agent


Bret Evans | bretevans480@gmail.com
Lic#: 01223530
Broker: Courtesy of RE/MAX Gold Redwood Shores
Phone: 650-722-6555

Agent Remarks

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 Details

Property type: Duplex (Multi-Family)
Status: Active
MLS# ML82062905
Price: $1,799,000
Beds: 0
Baths: 0
Built in 1920
2,220 sqft
0.14 acres
Lot size: 0.1383
County: San Mateo
Zoning: RM0000
Appliances: Dishwasher,Electric Cooktop,Electric Oven,Disposal,Microwave,Refrigerator
Heating/cooling: None
MLS area: 699 - Not Defined

Last Updated: 9/29/2026

 Days On Market (DOM): 1

 Find more San Mateo homes and real estate

 Find more homes in 94402 zip code

This listing belongs to the 699 - Not Defined MLS area

Lat/Long: 37.566702, -122.316018.
Find nearby listings

DISCLAIMER: There is NO WARRANTY, expressed or implied, for the accuracy of this information or its applicability to your financial situation. Please consult your financial and/or tax advisor. GET PRE-APPROVED The loan's interest rate will depend upon the specific characteristics of the loan transaction and credit profile up to the time of closing.

94402 Area Map

Demographics

Schools

CLICK TO VIEW MAP

Similar Listings

Next Listing
201 S Idaho Street VIRTUAL TOUR
201 S Idaho Street ,
$1,699,000 Approx. USD

List Date: 8/21/2026
Status: Pending
MLS #: ML82056461

My Notes Save
Listing courtesy of
414 E 16Th Avenue VIRTUAL TOUR
414 E 16th Avenue ,
$1,900,000 Approx. USD

List Date: 9/16/2026
Status: Active
MLS #: ML82061457

My Notes Save
Listing courtesy of
315 Grand Boulevard VIRTUAL TOUR
315 Grand Boulevard ,
$1,950,000 Approx. USD

List Date: 7/12/2025
Status: Active
MLS #: ML82014445

My Notes Save
Listing courtesy of
869 Woodside Way VIRTUAL TOUR
869 Woodside Way ,
$1,648,000 Approx. USD

List Date: 7/22/2026
Status: Active
MLS #: 41142446

My Notes Save
Listing courtesy of
824 El Camino Real VIRTUAL TOUR
824 El Camino Real ,
$1,899,999 Approx. USD

List Date: 5/4/2025
Status: Active
MLS #: ML82005442

My Notes Save
Listing courtesy of
1120 Elmer Street VIRTUAL TOUR
1120 Elmer Street ,
$1,680,000 Approx. USD

List Date: 6/18/2026
Status: Active
MLS #: ML82051468

My Notes Save
Listing courtesy of
917 Mills Ave VIRTUAL TOUR
917 Mills Ave ,
$1,729,880 Approx. USD

List Date: 5/5/2026
Status: Active
MLS #: 41133556

My Notes Save
Listing courtesy of
349 Spring Street VIRTUAL TOUR
349 Spring Street ,
$1,798,000 Approx. USD

List Date: 9/11/2026
Status: Active
MLS #: ML82061035

My Notes Save
Listing courtesy of
217 Madison Avenue VIRTUAL TOUR
217 Madison Avenue ,
$1,699,000 Approx. USD

List Date: 3/10/2026
Status: Pending
MLS #: ML82037979

My Notes Save
Listing courtesy of
922 Valota Road VIRTUAL TOUR
922 Valota Road ,
$1,748,000 Approx. USD

List Date: 4/5/2022
Status: Pending
MLS #: ML81885439

My Notes Save
Listing courtesy of
Previous Listing
  • Search
    • My Previous Sales
    • Residential
    • Lease
    • Open Houses
    • Commercial
    • New Homes
    • Luxury
  • Buyers
    • Ways To Take Title In California
    • Vesting
    • Renting vs. buying
    • How much can I afford?
    • Why work with a real estate agent
    • Finding your home
    • What do you want in a home?
    • Submitting an offer
    • After the offer is accepted
    • Moving
  • Sellers
    • Anaheim FAQ
    • New Sellers and Buyers Guide
    • Why work with a real estate agent
    • Getting your home ready for sale
    • Pricing your home to sell
    • Negotiating the sale
    • Transaction management
    • Moving
  • Services
    • Prosperity Home Mortgage
    • HomeServices Relocation
    • HomeServices Insurance Agency
    • Pickford Escrow
    • California Title Company
    • American Home Shield
    • PINNACLE
    • myNHD
  • About
    • Why Choose The Keaty Team
  • Blog
  • Our Team
The Keaty Team
Lic#: 01276603

View Team Members


Tustin Office
18302 Irvine Blvd, Suite 240
Tustin, CA 92780
hsoa-logo
  • Facebook
  • Twitter
  • Instagram
  • LinkedIn
  • Blog

© 2026 BHH Affiliates, LLC. An independently operated subsidiary of HomeServices of America, Inc., a Berkshire Hathaway affiliate, and a franchisee of BHH Affiliates, LLC. Berkshire Hathaway HomeServices and the Berkshire Hathaway HomeServices symbol are registered service marks of Columbia Insurance Company, a Berkshire Hathaway affiliate. Equal Housing Opportunity.
Lic#: 01317331

Photo of Equal Housing Opportunity Privacy Policy - California Privacy Notice - Terms of Use - Accessibility
Do Not Sell My Personal Information DMCA.com Protection Status