$2,788,000
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 | |
| Subdivision | - |
| County | San Mateo County |
| Elementary School | - |
| Middle School | - |
| High School | - |
Find out more
Tell us who you are, and we will have someone reach out to you.
MLS number: ML82047327
Listing agent:
Miriam Chirko
Listing broker:
Coldwell Banker Realty
(650) 558-4200
Last update: Monday, June 1 2026 at 7:52 a.m. EDT
realogy mercurynews
Other listings you might be interested in
$2,798,000
4 Bed •
3 Bath •
2,300 ft²
516 St Vincent Ln
Foster City, CA 94404
$2,680,000
4 Bed •
3 Bath •
2,266 ft²
351 Rolling Hills Avenue
San Mateo, CA 94403
$2,680,000
4 Bed •
3 Bath •
2,239 ft²
550 Helen Dr
Millbrae, CA 94030
$2,950,000
4 Bed •
3 Bath •
2,540 ft²
604 Waterbury
Foster City, CA 94404
$2,750,000
4 Bed •
3 Bath •
3,490 ft²
181 Turnberry Rd
Half Moon Bay, CA 94019
$2,798,000
4 Bed •
3 Bath •
2,355 ft²
40684 Mission Boulevard
Fremont, CA 94539
$2,615,000
4 Bed •
3 Bath •
2,540 ft²
2769 Bromley Drive
San Carlos, CA 94070
$2,798,000
4 Bed •
3 Bath •
2,407 ft²
1467 Kiner Ave
San Jose, CA 95125
$2,799,888
4 Bed •
3 Bath •
2,544 ft²
2465 Fenian Dr
Campbell, CA 95008
$2,998,000
4 Bed •
3 Bath •
2,675 ft²
355 Avenue Alhambra
El Granada, CA 94018
$2,599,000
4 Bed •
3 Bath •
2,280 ft²
1 Ora Way
San Francisco, CA 94131
$2,950,000
4 Bed •
3 Bath •
3,370 ft²
107 Carnoustie Dr
Half Moon Bay, CA 94019