NOT LISTED FOR SALE

604 E 40th Ave San Mateo, CA 94403

Hillsdale Neighborhood

Estimated Value: $1,661,000 - $2,256,000

5 Beds
3 Baths
2,030 Sq Ft
$964/Sq Ft Est. Value

Last Sold August 30, 2013

Last sale price $935,000 $461 Per Sq Ft

Est. 109% increase in value since last sale

Current estimated payment $11,439/month

28 Days on Market

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

As of August 2013

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

Prudential California Realty

Last Buyer's Agent

Kirsten Hagen

Jaeb Real Estate License #01490617

Jaeb Real Estate

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

Home Details

Home Type

Single Family

Year Built

Built in 1951

Lot Details

0

Parking

2

Listing Details

  • Subclass: Single Family Home
  • Sale Price Per Sq Ft: 460.59
  • Listing Class: Residential
  • Structure Sq Ft: 2030
  • Incorporated: Yes
  • Map Book Page: 749
  • Map Side Coordinate: 6
  • Map Top Coordinate: E
  • Thomas Bros Page: 749
  • Thomas Brothers: E6
  • Year Built: 1951
  • Zoning Description: R1
  • Special Features: None
  • Property Sub Type: Detached

Interior Features

  • Family Room: Separate Family Room
  • Fireplace: Living Room, Insert, Yes
  • Dining Room: Formal Dining Room, Eat in Kitchen
  • Kitchen: Refrigerator, Oven Range, Microwave
  • Living Sq Ft: 2030
  • Stories: 2
  • Laundry: In Laundry Room, Gas Hookup
  • Flooring: Laminate
  • Additional Rooms: Bonus / Hobby Room
  • Maximum Bathrooms: 3
  • Minimum Bathrooms: 3
  • Full Bathrooms: 3
  • Total Bedrooms: 5

Exterior Features

  • Foundation: Concrete Perimeter and Slab
  • Pool Description: Pool - No
  • Roof: Composition
  • Yard/Grounds: Fenced

Garage/Parking

  • Garage Spaces: 2

Utilities

  • Heating System: Heating - 2+ Zones, Forced Air
  • Sewer/Septic System: Sewer in Street, Sewer Connected

Association/Amenities

  • Amenities Miscellaneous: Double Pane Windows(s)

Lot Info

  • Parcel Number: 040-227-010
  • Lot Location: Corner
  • List Price per Sq Ft: 462.07
  • Lot Size Area Minimum Units: Square Feet
  • Minimum Lot Size: 5000.00
  • Lot Size Area Maximum Units: Square Feet
  • Lot Size Area Max Search: 5000.00
  • Lot Size Area Min Search: 5000.00
  • Maximum Lot Size: 5000.00
  • Map Book: Thomas Bros

Green Features

  • Energy Features: Double Pane Windows, Ceiling Fan(s)

Multi Family

  • Maximum Building Height: 2
  • Minimum Building Height: 2

MLS Schools

  • High School District Text: Sequoia Union High

Ownership History

Date Name Owned For Owner Type

Purchase Details

Closed on
Oct 19, 2024
Sold by
Hua Richard T and Hua Antonette F
Bought by
Hua Family Trust and David & Dana Hua Family Trust
Current Estimated Value
$1,956,950

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.16%
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
$697,500
Interest Rate
6.97%
Mortgage Type
Negative Amortization
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
Hua Family Trust -- None Listed On Document
Hua Family Trust -- None Listed On Document
Hua Richard T -- 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

Date Status Borrower Loan Amount
Previous Owner Hua Richard T $708,750
Previous Owner Piazza David Alan $697,500
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft
08/30/2013 08/30/13 Sold $935,000 -0.3% $461 / Sq Ft
08/16/2013 08/16/13 Pending -- -- --
07/19/2013 07/19/13 For Sale $938,000 -- $462 / Sq Ft
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 $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

  • J

    Seller's Agent in 2013

    John Gieseker

    Prudential California Realty

    Section Image

  • K

    Buyer's Agent in 2013

    Kirsten Hagen

    Jaeb Real Estate

    Section Image
See All Agents

Map

Source: MLSListings

MLS Number: ML81326288

MLSListings

APN: 040-227-010

California San Mateo County San Mateo 94403 Hillsdale

604 E 40th Ave, San Mateo, CA

Not Listed for Sale

Detached

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