Carmen Miranda
Compass
(650) 780-3416
68 Total Sales
8 in Hillsdale
$1.8M - $2.5M Price Range
604 E 40th Ave San Mateo, CA 94403
Hillsdale NeighborhoodEstimated Value: $2,065,872
5
Beds
3
Baths
2,030
Sq Ft
$1,018/Sq Ft
Est. Value
Highlights
- Bonus Room
- Formal Dining Room
- Double Pane Windows
- Ralston Intermediate School Rated A
- Eat-In Kitchen
- 2-minute walk to Casanova Park
About This Home
Beautiful San Mateo Village home for someone who needs lots of space. 5 bedrooms, 3 bathrooms, plus a den, plus a formal dining area, plus an unwarranted game room, plus 2 car garage. Large expansion and remodeling done in 2000. Everyone can have their own room and still find a quite place to work or relax. Just around the corner from Casanova and Laurie Meadows Parks.
Last Agent to Sell the Property
John Gieseker
Prudential California Realty License #00768503 Listed on: 07/19/2013
Last Buyer's Agent
Kirsten Hagen
Jaeb Real Estate License #01490617
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 Details
Home Type
- Single Family
Year Built
- Built in 1951
Lot Details
- Fenced
- Zoning described as R1
Parking
- 2 Car Garage
Home Design
- Composition Roof
- Concrete Perimeter Foundation
Interior Spaces
- 2,030 Sq Ft Home
- 2-Story Property
- Ceiling Fan
- Double Pane Windows
- Separate Family Room
- Living Room with Fireplace
- Formal Dining Room
- Bonus Room
- Laminate Flooring
- Gas Dryer Hookup
Kitchen
- Eat-In Kitchen
- Oven or Range
- Microwave
Bedrooms and Bathrooms
- 5 Bedrooms
- 3 Full Bathrooms
Utilities
- Forced Air Zoned Heating System
- Wood Insert Heater
- Sewer Within 50 Feet
Listing and Financial Details
- Assessor Parcel Number 040-227-010
Ownership History
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
Date
Name
Owned For
Owner Type
Purchase Details
Closed on
Oct 19, 2024
Sold by
Hua Richard T and Hua Antonette F
Bought by
Current Estimated Value
Purchase Details
Closed on
Jan 25, 2022
Sold by
Hua Family Trust
Bought by
Hua Richard T and Hua Antonette F
Purchase Details
Closed on
Jan 31, 2018
Sold by
Hua David and Hua Dana
Bought by
Hua David C and Hua Dana H
Purchase Details
Closed on
Aug 30, 2017
Sold by
Hua Richard T and Hua Antonette F
Bought by
Hua Richard T and Hua Antonette F
Purchase Details
Listed on
Jul 19, 2013
Closed on
Aug 19, 2013
Sold by
Piazza David Alan
Bought by
Hua Richard T and Hua Antonette F
Seller's Agent
John Gieseker
Prudential California Realty
Buyer's Agent
Kirsten Hagen
Jaeb Real Estate
List Price
$938,000
Sold Price
$935,000
Premium/Discount to List
-$3,000
-0.32%
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
6.25%
Original Mortgage
$708,750
Interest Rate
3.37%
Mortgage Type
Adjustable Rate Mortgage/ARM
Purchase Details
Closed on
Mar 3, 2006
Sold by
Piazza Susan Lynn
Bought by
Piazza David Alan
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$60,000
Interest Rate
6.29%
Mortgage Type
Credit Line Revolving
Home Values in the Area
Average Home Value in this Area
Agents Specializing in Hillsdale, CA
-
Carmen Miranda
-
Moe Arshad
Moe Arshad
Real Estate Source, Inc.
(650) 667-7805
17 Total Sales
1 in Hillsdale
$1,400,000 Price
-
Susan Gee Berry
Susan Gee Berry
KW Advisors
(650) 649-6958
50 Total Sales
3 in Hillsdale
$450K - $577K Price Range
-
Julie Flouty
Julie Flouty
Compass
(650) 753-0031
191 Total Sales
4 in Hillsdale
$1.4M - $2.4M Price Range
-
Keith Walker
Keith Walker
Responds QuicklyIntero Real Estate Services
(669) 230-1607
145 Total Sales
3 in Hillsdale
$1.8M - $2.2M Price Range
-
Vickie Burgess
Vickie Burgess
Realsmart Properties
(650) 744-3694
115 Total Sales
3 in Hillsdale
$1.6M - $2.4M Price Range
Purchase History
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
| Date | Buyer | Sale Price | Title Company |
|---|---|---|---|
| -- | None Listed On Document | ||
| Hua Richard T | -- | None Listed On Document | |
| Hua David C | -- | None Available | |
| Hua Richard T | -- | None Available | |
| Hua Richard T | $935,000 | North American Title Co Inc | |
| Piazza David Alan | -- | First American Title Co |
Source: Public Records
Mortgage History
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
| Date | Status | Borrower | Loan Amount |
|---|---|---|---|
| Previous Owner | $150,000 | ||
| Previous Owner | Hua Richard T | $900,000 | |
| Previous Owner | Hua Richard T | $156,000 | |
| Previous Owner | Hua Richard T | $802,000 | |
| Previous Owner | Hua Richard T | $140,000 | |
| Previous Owner | Hua Richard T | $708,750 | |
| Previous Owner | Piazza David Alan | $760,000 | |
| Previous Owner | Piazza David Alan | $60,000 | |
| Previous Owner | Piazza David Alan | $697,500 | |
| Previous Owner | Piazza David Alan | $50,000 | |
| Previous Owner | Piazza David Alan | $490,000 | |
| Previous Owner | Piazza David Alan | $490,000 | |
| Previous Owner | Piazza David Alan | $175,000 | |
| Previous Owner | Piazza David Alan | $50,000 | |
| Previous Owner | Piazza David Alan | $288,000 |
Source: Public Records
Tax History
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
| 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 | $14,589 | $1,146,166 | $573,083 | $573,083 |
| 2023 | $14,589 | $1,101,662 | $550,831 | $550,831 |
| 2022 | $14,148 | $1,080,062 | $540,031 | $540,031 |
| 2021 | $14,016 | $1,058,886 | $529,443 | $529,443 |
| 2020 | $13,405 | $1,048,030 | $524,015 | $524,015 |
| 2019 | $12,928 | $1,027,482 | $513,741 | $513,741 |
| 2018 | $12,216 | $1,007,336 | $503,668 | $503,668 |
| 2017 | $11,869 | $987,586 | $493,793 | $493,793 |
| 2016 | $11,649 | $968,222 | $484,111 | $484,111 |
| 2015 | $11,572 | $953,680 | $476,840 | $476,840 |
| 2014 | $11,441 | $935,000 | $467,500 | $467,500 |
Source: Public Records
Agents Affiliated with this Home
-
JG
Seller's Agent in 2013
John Gieseker
Prudential California Realty
-
KH
Buyer's Agent in 2013
Kirsten Hagen
Jaeb Real Estate
Map
Source: MLSListings
MLS Number: ML81326288
APN: 040-227-010
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.
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
- 3981 Casanova Dr
- 3992 Pasadena Dr
- 213 Estrella Way
- 30 Oxford Place
- 4173 George Ave Unit 1
- 4238 George Ave Unit 1
- 510 Sterling View Ave
- 0 Belmont Ave
- 3090 Los Prados St Unit 24
- 19 Edgewood Place
- 400 Davey Glen Rd Unit 4623
- 400 Davey Glen Rd Unit 4503
- 400 Davey Glen Rd Unit 4601
- 400 Davey Glen Rd Unit 4824
- 600 El Camino Real Unit 302
- 600 El Camino Real Unit 311
- 3001 Los Prados St Unit 208
- 3033 Los Prados St Unit 230
- 58 Burbank Ave
- 114 E Hillsdale Blvd Unit E
- 4025 Martin Dr
- 4021 Martin Dr
- 4029 Martin Dr
- 4017 Martin Dr
- 4024 Martin Dr
- 4041 Martin Dr
- 4020 Martin Dr
- 4024 Branson Dr
- 4028 Branson Dr
- 4020 Branson Dr
- 4045 Martin Dr
- 4013 Martin Dr
- 4028 Martin Dr
- 4016 Branson Dr
- 4032 Martin Dr
- 4032 Branson Dr
- 4016 Martin Dr
- 4012 Martin Dr
- 4012 Branson Dr
- 4036 Martin Dr
Your Personal Tour Guide
Ask me questions while you tour the home.