NOT LISTED FOR SALE

24 Mounds Rd Unit B San Mateo, CA 94402

Baywood-Aragon Neighborhood

Estimated Value: $2,749,091 - $2,864,000

3 Beds
2 Baths
2,448 Sq Ft
0.37 Acres Lot

Sale Details

Date Sold: June 9, 2025

Last sale price $2,885,500 $1,179 Per Sq Ft

Est. 3% decrease in value since last sale

Current estimated payment $17,320 / mo

38 Days on Market

Highlights

  • Bay View
  • Subterranean Parking
  • Forced Air Zoned Heating and Cooling System
  • Borel Middle School Rated A-
  • Electric Vehicle Home Charger
  • Combination Dining and Living Room

About This Home

As of June 2025

RARELY AVAILABLE THREE BEDROOM, TWO BATH, APPROXIMATELY 2,448-SQUARE FEET LUXURY CONDO, OVER $700K SPENT TO COMPLETELY REMODEL THIS HOME TO THE HIGHEST STANDARDS. NO OTHER CONDO IN SAN MATEO OR BURLINGAME CAN COMPARE TO THE QUALITY AND DESIGNER TOUCHES OF THIS DISTINGUISHED RESIDENCE. COMPLETELY REBUILT FROM THE STUDS, THIS OPEN-CONCEPT HOME FEATURES PREMIUM MATERIALS SUCH AS QUARTZITE COUNTERTOPS, GAGGENAU AND THERMADORE APPLIANCES, ENGINEERED "HEATED" HARDWOOD FLOORING, DAIKIN A/C AND HEAT MINI-SPLIT SYSTEMS, WHITE OAK CABINETS, LEVEL-FIVE FINISHED WALLS, GENERAC BACKUP GENERATOR, HALO AND NORA LIGHTING, AND A REBUILT EXTERIOR PATIO WITH AMAZING BAY VIEWS. ADDITIONAL UPGRADES INCLUDE HARD-WIRED WINDOWS FOR ELECTRIC POWER SHADES, A RING CAMERA SECURITY SYSTEM, A BUILT-IN OFFICE DESK, CUSTOM CLOSET ORGANIZERS, AND TWO DEDICATED PARKING SPACES WITH EV CHARGER. LOCATED CLOSE TO DOWNTOWN SAN MATEO, THIS REMODELED LUXURY CONDO IS A RARE AND UNIQUE OPPORTUNITY!

Last Agent to Sell the Property

Nick Corcoleotes

Coldwell Banker Realty License #00614270 Listed on: 04/11/2025

Coldwell Banker Realty

Last Buyer's Agent

Geoffrey Nelson

Coldwell Banker Realty License #01313666

Coldwell Banker Realty

Property Details

Home Type

  • Condominium

Year Built

  • Built in 1993

Lot Details

  • 0.37

Parking

  • Subterranean Parking
  • Electric Vehicle Home Charger

Home Design

  • Slab Foundation
  • Concrete Perimeter Foundation

Interior Spaces

  • 2,448 Sq Ft Home
  • 1-Story Property
  • Fireplace With Gas Starter
  • Living Room with Fireplace
  • Combination Dining and Living Room
  • Bay Views

Bedrooms and Bathrooms

  • 3 Bedrooms
  • 2 Full Bathrooms

Utilities

  • Forced Air Zoned Heating and Cooling System
  • Separate Meters

Community Details

  • Property has a Home Owners Association
  • Association fees include maintenance - exterior
  • 5 Units
  • Sumit Association

Listing and Financial Details

  • Assessor Parcel Number 103-510-020

Property Details

Home Type

Condominium

Year Built

Built in 1993

Lot Details

0.37 Acres

Parking

2

Listing Details

  • Subclass: Condominium
  • Listing Class: Residential
  • Min Numberof Unitsin Complex: 5
  • Structure Sq Ft: 2448
  • Year Built: 1993
  • Zoning Description: R30000
  • Special Features: None
  • Property Sub Type: Condos

Interior Features

  • Family Room: No Family Room
  • Fireplace: Gas Starter, Living Room
  • Dining Room: Dining Area in Living Room
  • Living Sq Ft: 2448
  • Stories: 1
  • Fireplaces Min: 1
  • Full Bathrooms: 2
  • Total Bedrooms: 3
  • Fireplace: Yes

Exterior Features

  • Foundation: Concrete Perimeter and Slab, Concrete Slab
  • View: Bay

Garage/Parking

  • Garage Spaces: 2
  • Garage Parking Features: Underground Parking
  • Electric Vehicle Hookup Type: Electric Vehicle Hookup Level 2 (240 volts)

Utilities

  • Cooling System: Central AC
  • Heating System: Forced Air, Individual Room Controls
  • Sewer/Septic System: Sewer - Public

Condo/Co-op/Association

  • HOA Fees: 1500
  • Association Fees Include: Maintenance - Exterior
  • H O A Name Text: Sumit
  • H O A Exist: Yes

Lot Info

  • Parcel Number: 103-510-020

Multi Family

  • Utilities: Individual Electric Meters

MLS Schools

  • High School District Text: San Mateo Union High

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Apr 11, 2025
Closed on
Jun 2, 2025
Sold by
Montalbano Family Trust and Montalbano Cynthia A
Bought by
Warren T And Barbara M Lazarow Family Trust and Lazarow
Seller's Agent
Nick Corcoleotes
Coldwell Banker Realty
Buyer's Agent
Geoffrey Nelson
Coldwell Banker Realty
List Price
$3,250,000
Sold Price
$2,885,500
Premium/Discount to List
-$364,500
-11.22%
Views
13
Current Estimated Value
$2,806,030

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
-$79,470
Avg. Annual Appreciation
-3.20%

Purchase Details

Listed on
Feb 7, 2024
Closed on
Apr 16, 2024
Sold by
Byerwalter Family Trust and Byerwalter Mariann
Bought by
Montalbano Family Trust and Montalbano
Seller's Agent
Geoffrey Nelson
Coldwell Banker Realty
Buyer's Agent
Nick Corcoleotes
Coldwell Banker Realty
List Price
$2,698,000
Sold Price
$2,550,000
Premium/Discount to List
-$148,000
-5.49%
Views
53

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
11.56%

Purchase Details

Closed on
Jun 2, 2014
Sold by
Byerwalter Mary R
Bought by
Byerwalter Mary R

Purchase Details

Closed on
Jan 9, 2007
Sold by
Byerwalter Mary R
Bought by
Byerwalter Mary R

Purchase Details

Closed on
Oct 5, 2005
Sold by
Coddington Clinton H and Coddington Martha S
Bought by
Byewalter Joseph R and Byewalter Mary R

Purchase Details

Closed on
Apr 24, 2000
Sold by
Lerman Henry & Meredith Trs
Bought by
Coddington Clinton H and Coddington Martha S

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$350,000
Interest Rate
7.55%
Mortgage Type
Stand Alone First

Purchase Details

Closed on
Nov 20, 1997
Sold by
Lerman Henry and Lerman Meredith
Bought by
Lerman Henry and Lerman Meredith

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$400,000
Interest Rate
7.3%
Mortgage Type
Purchase Money Mortgage

Purchase Details

Closed on
Nov 13, 1997
Sold by
Randick Robert A and Randick Robert A
Bought by
Lerman Henry and Lerman Meredith

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$400,000
Interest Rate
7.3%
Mortgage Type
Purchase Money Mortgage

Purchase Details

Closed on
Apr 27, 1994
Sold by
Erpen Gustav and Erpen Betty Ann
Bought by
Randick Robert A

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$250,000
Interest Rate
7.62%
Mortgage Type
Purchase Money Mortgage

Purchase Details

Closed on
Apr 19, 1994
Sold by
Erpen Betty A
Bought by
Erpen Gustav

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$250,000
Interest Rate
7.62%
Mortgage Type
Purchase Money Mortgage

Purchase Details

Closed on
Apr 5, 1994
Sold by
Randick Georgia Ann
Bought by
Randick Robert A

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$250,000
Interest Rate
7.62%
Mortgage Type
Purchase Money Mortgage
Source: Public Records

Range of Values:

--
Value Increase
--
Percent Increase
--
Adjusted for Inflation
Collateral Analytics

Collateral Analytics Collateral Analytics AVMs (Automated Valuation Model) employ a number of statistical approaches combined with neighborhood-specific comparable selection guarantees the most up-to-date and precise valuations.

Not Available

Collateral Analytics does not have data for the current month. Please view the chart for historical values.

ICE

ICE Mortgage Technology ICE Mortgage Technology’s AVM (Automated Valuation Model) is a state-of-the-art online residential property valuation tool that provides a quick and accurate estimate of the value of almost any home in the U.S.

Not Available

ICE Mortgage Technology does not have data for the current month. Please view the chart for historical values.

First American

First American First American Data & Analytics’ next-generation AVM combines unrivaled data assets with a blended ensemble of valuation models to produce highly accurate, reliable valuations you can trust.

Not Available

First American does not have data for the current month. Please view the chart for historical values.

Quantarium

Quantarium Quantarium’s valuation service, repeatedly proven the industry’s most accurate and comprehensive, is supercharged with a self-learning and auto-tuning AI engine that continually becomes smarter and more accurate as it processes daily inputs from the industry’s leading RE data lake.

Not Available

Quantarium does not have data for the current month. Please view the chart for historical values.

Average Value
Not Available
List Price
Sold Price
Create a Home Valuation Report for This Property
The Home Valuation Report is an in-depth analysis detailing your home's value as well as a comparison with similar homes in the area

Home Values in the Area

Source: Public Records

Average Home Value in this Area

Source: Public Records

Purchase History

Date Buyer Sale Price Title Company
Warren T And Barbara M Lazarow Family Trust $2,885,500 First American Title
Montalbano Family Trust $2,550,000 Wfg National Title
Byerwalter Mary R $665,000 None Available
Byerwalter Mary R -- None Available
Byewalter Joseph R $1,989,000 First American Title Co
Coddington Clinton H -- North American Title Co
Lerman Henry -- --
Lerman Henry $750,000 First American Title Co
Randick Robert A $530,000 North American Title Co Inc
Erpen Gustav -- Old Republic Title Company
Randick Robert A -- North American Title Company
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Previous Owner Coddington Clinton H $350,000
Previous Owner Lerman Henry $400,000
Previous Owner Randick Robert A $250,000
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft Prior Sale
06/09/2025 06/09/25 Sold $2,885,500 -11.2% $1,179 / Sq Ft
05/20/2025 05/20/25 Pending -- -- --
04/11/2025 04/11/25 For Sale $3,250,000 +27.5% $1,328 / Sq Ft
04/22/2024 04/22/24 Sold $2,550,000 -5.5% $1,042 / Sq Ft View Prior Sale
04/10/2024 04/10/24 Pending -- -- --
02/07/2024 02/07/24 For Sale $2,698,000 -- $1,102 / Sq Ft
Source: MLSListings

Tax History

Year Tax Paid Tax Assessment Tax Assessment Total Assessment is a certain percentage of the fair market value that is determined by local assessors to be the total taxable value of land and additions on the property. Land Improvement
2025 $30,535 $2,601,000 $780,300 $1,820,700
2023 $30,535 $2,612,577 $783,770 $1,828,807
2022 $30,136 $2,561,351 $768,402 $1,792,949
2021 $30,518 $2,511,130 $753,336 $1,757,794
2020 $26,091 $2,240,000 $670,000 $1,570,000
2019 $23,285 $2,000,000 $599,500 $1,400,500
2018 $23,154 $2,000,000 $599,500 $1,400,500
2017 $22,896 $2,000,000 $599,500 $1,400,500
2016 $22,794 $2,000,000 $599,500 $1,400,500
2015 $19,804 $1,750,000 $524,500 $1,225,500
2014 $17,035 $1,500,000 $449,500 $1,050,500
Source: Public Records

Agents Affiliated with this Home

  • Nick Corcoleotes

    Seller's Agent in 2025

    Nick Corcoleotes

    Coldwell Banker Realty

    (650) 207-2758

    2 in this area

    27 Total Sales

    Nick Corcoleotes
    Section Image
  • Geoffrey Nelson

    Buyer's Agent in 2025

    Geoffrey Nelson

    Coldwell Banker Realty

    (650) 455-3735

    2 in this area

    71 Total Sales

    Geoffrey Nelson
    Section Image
See All Agents

Map

Source: MLSListings

MLS Number: ML82002085

MLSListings

APN: 103-510-020

California San Mateo County San Mateo 94402 Baywood-Aragon

24 Mounds Rd Unit B, San Mateo, CA

Disclaimer: Certain information contained herein is derived from information provided by parties other than Homes.com. All information provided is deemed reliable, but is not guaranteed to be accurate and should be independently verified.

MLSListings Property Information © 2026 MLSListings Inc. All rights reserved. Listing information is deemed reliable but not guaranteed. Certain information contained herein is derived from information which is the licensed property of, and copyrighted by, MLSListings Inc. The viewer acknowledges ownership and validity of its copyright. Information provided is for personal, non-commercial use by a viewer with a bona fide interest in the purchase or sale of real estate of the type being offered via this website or other electronic means. The viewer is prohibited from copying, redistributing or retransmitting any of the data or information provided by MLSListing, Inc.

Nearby Homes
Your Personal Tour Guide

Ask me questions while you tour the home.