NOT LISTED FOR SALE

24 Mounds Rd Unit D San Mateo, CA 94402

Baywood-Aragon Neighborhood

Estimated Value: $1,776,886 - $2,109,000

3 Beds
2 Baths
2,506 Sq Ft
$755/Sq Ft Est. Value

Highlights

  • 2 Car Attached Garage
  • Tile Flooring
  • Dining Area
  • Borel Middle School Rated A-
  • Washer and Dryer
  • Heating Available

About This Home

As of December 2023

SPACIOUS, 1-level luxury condo available for rent at 24 Mounds Road, #D San Mateo. Tranquil setting. Quiet, cul-de-sac location. Amazing views overlooking San Francisco Bay. 3 bedrooms, 2 full bathrooms, approx. 2,506 sq ft. Great location, blocks from Downtown San Mateo and Burlingame shopping and amenities. Near Hillsborough border nice quiet streets for evening walks. Easy access to Highway 92/101/280

Last Agent to Rent the Property

Andrew Guglielmi

SC Properties License #01852584 Listed on: 09/06/2023

Last Renter's Agent

Andrew Guglielmi

SC Properties License #01852584 Listed on: 09/06/2023

Property Details

Home Type

  • Apartment

Est. Annual Taxes

  • $12,612

Year Built

  • 1993

Lot Details

  • 0.37

Parking

  • 2 Car Attached Garage
  • Assigned Parking

Interior Spaces

  • 2,506 Sq Ft Home
  • Gas Log Fireplace
  • Living Room with Fireplace
  • Dining Area
  • Washer and Dryer

Kitchen

  • Gas Oven
  • Gas Cooktop
  • Dishwasher

Flooring

  • Carpet
  • Tile

Bedrooms and Bathrooms

  • 3 Bedrooms
  • 2 Full Bathrooms

Utilities

  • Heating Available

Community Details

Listing and Financial Details

  • Security Deposit $3,000
  • Property Available on 10/23/23
  • Rent includes gardener, sewer, trash removal, water
  • 12-Month Minimum Lease Term

Property Details

Home Type

Apartment

Est. Annual Taxes

$12,612

Year Built

1993

Lot Details

0

Parking

2

Rental Info

  • Available: 10/23/2023
  • Lease Terms: Deposit Required
  • Minimum Lease Months: 12
  • Rent Includes: Gardener, Sewer, Trash Removal, Water
  • Security Deposit: 3000

Listing Details

  • Subclass: Apartment/Condo For Rent
  • Age: 30
  • Listing Class: Residential Lease/Rental
  • Structure Sq Ft: 2506
  • Special Features: None
  • Property Sub Type: MultiFamily
  • Year Built: 1993

Interior Features

  • Fireplace: Gas Burning, Gas Log, Gas Starter, Living Room
  • Dining Room: Dining Area
  • Kitchen: Cooktop - Gas, Dishwasher, Oven - Gas, Refrigerator
  • Fireplace: Yes
  • Living Sq Ft: 2506
  • Laundry: Washer / Dryer
  • Flooring: Carpet, Tile
  • Fireplaces Min: 1
  • Maximum Numberof Bedrooms: 3
  • Minimum Numberof Bedrooms: 3
  • Full Bathrooms: 2
  • Total Bedrooms: 3

Garage/Parking

  • Garage Spaces: 2
  • Garage Parking Features: Assigned Spaces, Attached Garage, Covered Parking

Utilities

  • Heating System: Electric

Schools

  • School District: San Mateo Union High

Ownership History

Date Name Owned For Owner Type

Purchase Details

Closed on
Dec 16, 2010
Sold by
Stein Gary F
Bought by
Stein Gary
Current Estimated Value
$1,891,962

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$397,000
Outstanding Balance
$263,887
Interest Rate
4.34%
Mortgage Type
New Conventional
Estimated Equity
$1,628,075

Purchase Details

Closed on
Dec 2, 2008
Sold by
Stein Dr Gary F
Bought by
Stein Gary

Purchase Details

Closed on
Dec 31, 1996
Sold by
Stein Gary F and Stein Catherine C
Bought by
Colcord Stein Gary F and Colcord Stein Catherine

Purchase Details

Closed on
Jun 28, 1994
Sold by
Erpen Gustav
Bought by
Colcord Stein Gary F and Colcord Stein Catherine

Home Financials for this Owner

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

Range of Values:

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
Stein Gary -- Old Republic Title Company
Stein Gary -- Old Republic Title Company
Stein Gary F -- Old Republic Title Company
Stein Gary -- None Available
Colcord Stein Gary F -- --
Colcord Stein Gary F $587,000 First American Title Ins Co
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Stein Gary F $397,000
Closed Colcord Stein Gary F $469,600
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft
12/20/2023 12/20/23 Rented $5,000 -5.6% --
12/19/2023 12/19/23 Under Contract -- -- --
10/23/2023 10/23/23 Price Changed $5,295 -7.0% $2 / Sq Ft
10/05/2023 10/05/23 Price Changed $5,695 -5.0% $2 / Sq Ft
09/19/2023 09/19/23 Price Changed $5,995 -5.6% $2 / Sq Ft
09/06/2023 09/06/23 For Rent $6,350 -- --
Source: MLSListings

Tax History Compared to Growth

Source: Public Records

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 $12,612 $985,965 $295,782 $690,183
2023 $12,612 $947,681 $284,298 $663,383
2022 $12,029 $929,100 $278,724 $650,376
2021 $12,638 $910,883 $273,259 $637,624
2020 $11,537 $901,544 $270,458 $631,086
2019 $11,244 $883,867 $265,155 $618,712
2018 $10,583 $866,537 $259,956 $606,581
2017 $10,011 $849,547 $254,859 $594,688
2016 $9,922 $832,890 $249,862 $583,028
2015 $9,679 $820,380 $246,109 $574,271
2014 $9,569 $804,311 $241,289 $563,022
Source: Public Records

Agents Affiliated with this Home

  • Andrew Guglielmi

    Landlord's Agent in 2023

    Andrew Guglielmi

    SC Properties

    (650) 269-8517

    23 Total Sales

    Andrew Guglielmi
    Section Image
See All Agents

Map

Source: MLSListings

MLS Number: ML81940898

MLSListings

APN: 103-510-040

California San Mateo County San Mateo 94402 Baywood-Aragon

24 Mounds Rd Unit D, San Mateo, CA

This home is located at 24 Mounds Rd Unit D, San Mateo, CA 94402 since 06 September 2023 and is currently priced at $1,891,962. This property was built in 1993. 24 Mounds Rd Unit D is a home located in San Mateo County with nearby schools including San Mateo Park Elementary, Borel Middle School, and San Mateo High School.

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 © 2025 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