510 Aragon Boulevard San Mateo, CA 94402
MLS LogoListed by MLSlistings Inc. / Listed By: Miriam Chirko, Coldwell Banker Realty - Contact:  650-740-3593

  510 Aragon Boulevard San Mateo, CA 94402

Active (1 Days)
$2,788,000 (USD)
4
BED
3
BATH
2,410
SQFT
OPEN HOUSE TIMES
  • OPEN
    Sat, May 16
    1:00 pm - 4:00 pm
  • OPEN
    Sun, May 17
    1:00 pm - 4:00 pm
  • OPEN
    Tue, May 19
    10:00 am - 1:00 pm
show more

Description

First time on the market in over 60 years! With its timeless curb appeal and lush fern canopy at the inviting gate entry, this 2410 SF sunlit home offers buyers an amazing opportunity. Formal entry welcomes one into a dramatic living room with warm hardwood floors, a striking picture window & a wood-burning fireplace. The home features a spacious kitchen with stainless-steel appliances, a cozy breakfast nook with access to the rear yard, and a lovely formal dining room. Upstairs, there are four generous bedrooms, two full baths, a flexible work-or-play area, and a convenient laundry chute. The lower level includes an ideal private home office, a bath, and a laundry area, with additional access to the rear yard. It also features a two-car attached garage and a large 6,599 SF lot with a fenced backyard. Charming 1940s details include crown molding, high ceilings, beautifully refinished hardwood floors, plus a 200-AMP electrical panel (2024), modern light fixtures & fresh paint throughout. (May/26) This wonderful home offers an excellent opportunity to renovate, expand, or keep the footprint as is. Situated in the highly sought-after Aragon community near award-winning schools, shopping, major commute corridors, and local parks, 510 Aragon will be a special place to call home.

MLS #:
ML82047327
Lot Size
6,599 SQFT
Type
Single-Family Home
Year Built
1940
School District
938
County
San Mateo County

Listed By

Miriam Chirko, DRE #01130688 CA, Coldwell Banker Realty, Contact: 650-740-3593
Source
MLSlistings Inc.
Last checked May 15 2026 at 4:29 PM GMT+0000
Bathroom Details
  • Full Bathrooms: 2
  • Half Bathroom: 1
Interior Features
  • Tub / Sink
  • Washer / Dryer
Kitchen
  • Dishwasher
  • Countertop - Tile
  • Cooktop - Electric
  • Exhaust Fan
  • Refrigerator
Property Features
  • Fenced
  • Sprinklers - Auto
  • Fireplace: Living Room
  • Fireplace: Wood Burning
  • Fireplace: Gas Starter
  • Foundation: Concrete Perimeter
Heating and Cooling
  • Fireplace
  • Central Forced Air - Gas
  • Other
Flooring
  • Hardwood
  • Carpet
  • Vinyl / Linoleum
Exterior Features
  • Roof: Composition
Utility Information
  • Utilities: Water - Public, Public Utilities
  • Sewer: Sewer - Public
School Information
  • Elementary School: Baywood Elementary
  • Middle School: Borel Middle
  • High School: Aragon High
Garage
  • Attached Garage
  • Gate / Door Opener
Living Area
  • 2,410 sqft
Additional Information: Burlingame | 650-740-3593
Location
   
Calculate drive times to this property
 
Powered by INRIX® Drive Time

Powered by Walk Score®

Estimated Monthly Mortgage Payment

*Based on Fixed Interest Rate withe a 30 year term, principal and interest only

Listing price
Down payment
%
Interest rate
%
Mortgage calculator estimates are provided by Coldwell Banker Real Estate LLC and are intended for information use only. Your payments may be higher or lower and all loans are subject to credit approval.
Disclaimer: The data relating to real estate for sale on this website comes in part from the Broker Listing Exchange program of the MLSListings Inc.TM MLS system. Real estate listings held by brokerage firms other than the broker who owns this website are marked with the Internet Data Exchange icon and detailed information about them includes the names of the listing brokers and listing agents. Listing data updated every 30 minutes.

Properties with the icon(s) are courtesy of the MLSListings Inc.

Listing Data Copyright 2026 MLSListings Inc. All rights reserved. Information Deemed Reliable But Not Guaranteed.