510 Aragon BLVD, San Mateo, CA 94402
Eduardo Huerta And Lizzeth Flores
Eduardo Huerta And Lizzeth Flores

REALTOR®, Mortgage Loan Originator, Broker-Owner | Lic# Ed: 1391479

+1(408) 272-1031

GET MORE INFORMATION

Full Name
Phone*
Message
We respect your privacy! Your information WILL NOT BE SHARED, SOLD, or RENTED to anyone, for any reason outside the course of normal real estate exchange. By submitting, you agree to our Terms of Use and Privacy Policy.
Listed by Miriam Chirko • Coldwell Banker Realty, DRE#01130688
Bought with William Fox • Berkshire Hathaway HomeServices DrysdaleProperties

$ 2,788,000

Est. payment | /mo

4 Beds

2.5 Baths

2,410 SqFt

Video Tour

$ 2,788,000

Est. payment | /mo
Video Tour

4 Beds

2.5 Baths

2,410 SqFt

Key Details

Property Type Single Family Home

Sub Type Single Family Home

Listing Status Sold

Purchase Type For Sale

Square Footage 2,410 sqft

Price per Sqft $1,286

MLS Listing ID ML82047327

Sold Date 06/03/26

Bedrooms 4

Full Baths 2

Half Baths 1

Year Built 1940

Lot Size 6,599 Sqft

Property Sub-Type Single Family Home

Property 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.

Location

State CA

County San Mateo

Area Aragon

Zoning R10000

Rooms

Family Room No Family Room

Other Rooms Den / Study / Office, Formal Entry

Dining Room Breakfast Nook, Eat in Kitchen, Formal Dining Room

Kitchen Cooktop - Electric, Countertop - Tile, Dishwasher, Exhaust Fan, Refrigerator

Interior

Heating Central Forced Air - Gas, Fireplace , Other

Cooling Other

Flooring Carpet, Hardwood, Vinyl / Linoleum

Fireplaces Type Gas Starter, Living Room, Wood Burning

Laundry Tub / Sink, Washer / Dryer

Exterior

Exterior Feature Fenced, Sprinklers - Auto

Parking Features Attached Garage, Gate / Door Opener

Garage Spaces 2.0

Fence Fenced Back

Utilities Available Public Utilities

Roof Type Composition

Building

Foundation Concrete Perimeter

Sewer Sewer - Public

Water Public

Others

Tax ID 034-213-220

Horse Property No

Special Listing Condition Not Applicable

MLSListings Inc. (MLSListings)
© 2026 MLSListings Inc. All rights reserved.

Nearby Locations

GET MORE INFORMATION

Eduardo Huerta And Lizzeth Flores
Eduardo Huerta And Lizzeth Flores

REALTOR®, Mortgage Loan Originator, Broker-Owner | Lic# Ed: 1391479

+1(408) 272-1031

750 N. Capitol Ave. Suite B2, Jose, CA, 95133

Name
Phone*
Message

By checking this box, I agree by electronic signature to the Electronic Disclosure Consent Agreement; to receive recurring marketing communication from Eduardo Huerta And Lizzeth Flores, including auto-dialed calls, texts, and artificial/prerecorded voice messages (message frequency varies; data rates may apply; reply "STOP" to opt-out of texts or "HELP" for assistance); and to the Terms of Service and Privacy Policy of this website. Consent not required to make a purchase. I understand that I can call to obtain direct assistance.

Go tour this home

510 Aragon BLVD