NOT LISTED FOR SALE

401 Derby Ave San Mateo, CA 94403

Hillsdale Neighborhood

Estimated Value: $2,143,119 - $2,295,000

4 Beds
3 Baths
2,704 Sq Ft
$816/Sq Ft Est. Value

Last Sold August 16, 2013

Last sale price $1,202,081 $445 Per Sq Ft

Est. 84% increase in value since last sale

Current estimated payment $13,193/month

Highlights

  • 0.29 Acre Lot
  • Wood Flooring
  • Balcony
  • George Hall Elementary School Rated A
  • Den
  • 2-minute walk to Paddock Park

About This Home

As of August 2023

One of the most exceptional corner units in Bay Meadows! This 4 bedroom + 3 bathroom plus office is a spacious model townhouse and offers beautiful views of the park. Expansive sun-lit living room w/ high ceilings transitions beautifully to the huge gourmet chef's kitchen featuring granite counters, stainless steel appliances, island + breakfast bar and eat-in dining area. Enjoy the covered balcony off of the kitchen. Elegant primary suite with walk-in closet and en-suite bathroom features luxurious bathtub, stall shower and dual vanity. Features include downstairs office/play room, Air Conditioning, new carpets, new interior paint, beautiful hardwood floors, in-unit laundry and an attached 2-car garage + extra storage throughout. Offering the ultimate urban lifestyle, Bay Meadows is walkable to multiple parks, playgrounds, community garden w/ BBQs, Caltrain, Whole Foods, Nueva School, Hillsdale Shopping Center, Fieldworks Brewery, & Blue Bottle. Close prox. to 101, 92, 280 & SFO

Last Agent to Rent the Property

Casey Sternsmith

Compass License #70016718 Listed on: 07/11/2023

Compass

Last Renter's Agent

Gabby Nadel

Compass License #02105667

Compass

Townhouse Details

Home Type

  • Townhome

Year Built

  • 2013

Lot Details

  • 0.29

Parking

  • 2 Car Attached Garage
  • Garage Door Opener

Interior Spaces

  • 2,704 Sq Ft Home
  • 3-Story Property
  • Dining Area
  • Den
  • Storage Room

Kitchen

  • Eat-In Kitchen
  • Breakfast Bar
  • Gas Oven
  • Gas Cooktop
  • Microwave
  • Freezer
  • Dishwasher
  • Kitchen Island

Flooring

  • Wood
  • Carpet
  • Tile

Bedrooms and Bathrooms

  • 4 Bedrooms
  • 3 Full Bathrooms

Laundry

  • Laundry Room
  • Washer and Dryer

Additional Features

  • Balcony
  • Forced Air Heating and Cooling System

Community Details

  • Property has a Home Owners Association

Listing and Financial Details

  • Security Deposit $10,000
  • Property Available on 7/11/23
  • Rent includes association fees, laundry facilities
  • 12-Month Minimum Lease Term

Townhouse Details

Home Type

Townhome

Year Built

2013

Lot Details

0.29 Acres

Parking

2

Rental Info

  • Available: 07/11/2023
  • Lease Terms: Credit Report Required, Deposit Required
  • Minimum Lease Months: 12
  • Rent Includes: Association Fees, Laundry Facilities
  • Security Deposit: 10000

Listing Details

  • Subclass: Townhouse For Rent
  • Listing Class: Residential Lease/Rental
  • Structure Sq Ft: 2704
  • Special Features: None
  • Property Sub Type: Townhouses
  • Year Built: 2013

Interior Features

  • Family Room: No Family Room
  • Dining Room: Breakfast Bar, Dining Area, Eat In Kitchen
  • Kitchen: Cooktop - Gas, Dishwasher, Freezer, Island, Microwave, Oven - Gas, Refrigerator
  • Living Sq Ft: 2704
  • Stories: 3
  • Laundry: Washer / Dryer
  • Flooring: Carpet, Hardwood, Tile
  • Additional Rooms: Laundry Room, Office Area, Storage
  • Full Bathrooms: 3
  • Total Bedrooms: 4

Exterior Features

  • Yard/Grounds: Balcony / Patio

Garage/Parking

  • Garage Spaces: 2
  • Garage Parking Features: Attached Garage, Gate / Door Opener

Utilities

  • Cooling System: Central Ac
  • Heating System: Central Forced Air

Condo/Co-op/Association

  • HOA Exist: Yes

Lot Info

  • Lot Acres: 0.2916
  • Lot Size Area Minimum Units: Square Feet
  • Minimum Lot Size: 12701.00
  • Lot Size Area Maximum Units: Square Feet
  • Maximum Lot Size: 12701.00

Ownership History

Date Name Owned For Owner Type

Purchase Details

Closed on
Apr 7, 2014
Sold by
Madan Ajay and Poruri Laxmi
Bought by
The Poruri Madan Revocable Trust
Current Estimated Value
$2,207,280

Purchase Details

Listed on
May 10, 2013
Closed on
Sep 5, 2013
Sold by
Tri Pointe Homes Inc
Bought by
Madan Ajay and Poruri Laxmi
Seller's Agent
Diana Belknap
TRI Pointe Communities Inc
Buyer's Agent
Sanjeev Dixit
Sanjeev Dixit, Broker
List Price
$1,050,000
Sold Price
$1,202,081
Premium/Discount to List
$152,081
14.48%

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
4.98%
Original Mortgage
$920,000
Outstanding Balance
$685,446
Interest Rate
4.36%
Mortgage Type
New Conventional
Estimated Equity
$1,521,834
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
The Poruri Madan Revocable Trust -- None Available
Madan Ajay $1,202,500 First American Title Company
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Madan Ajay $920,000
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft Prior Sale
08/01/2023 08/01/23 Rented $7,500 +4.2% --
07/17/2023 07/17/23 Under Contract -- -- --
07/11/2023 07/11/23 For Rent $7,200 -6.5% --
05/19/2022 05/19/22 Rented $7,700 0.0% --
05/19/2022 05/19/22 Under Contract -- -- --
05/13/2022 05/13/22 For Rent $7,700 +10.0% --
06/01/2020 06/01/20 Rented $7,000 0.0% --
05/25/2020 05/25/20 Under Contract -- -- --
05/13/2020 05/13/20 For Rent $7,000 +0.4% --
07/09/2015 07/09/15 Rented $6,975 0.0% --
06/09/2015 06/09/15 Under Contract -- -- --
05/18/2015 05/18/15 For Rent $6,975 0.0% --
08/16/2013 08/16/13 Sold $1,202,081 +14.5% $474 / Sq Ft View Prior Sale
05/31/2013 05/31/13 Pending -- -- --
05/10/2013 05/10/13 For Sale $1,050,000 -- $414 / 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 $22,267 $1,473,578 $442,071 $1,031,507
2023 $22,267 $1,416,358 $424,905 $991,453
2022 $21,271 $1,388,587 $416,574 $972,013
2021 $21,719 $1,361,360 $408,406 $952,954
2020 $20,941 $1,347,402 $404,219 $943,183
2019 $20,344 $1,320,984 $396,294 $924,690
2018 $19,634 $1,295,083 $388,524 $906,559
2017 $19,192 $1,269,690 $380,906 $888,784
2016 $18,952 $1,244,795 $373,438 $871,357
2015 $18,473 $1,226,098 $367,829 $858,269
2014 $17,564 $1,202,081 $360,624 $841,457
Source: Public Records

Agents Affiliated with this Home

  • Casey Sternsmith

    Landlord's Agent in 2023

    Casey Sternsmith

    Compass

    (650) 678-5455

    48 in this area

    299 Total Sales

    Casey Sternsmith
    Section Image

  • G

    Tenant's Agent in 2023

    Gabby Nadel

    Compass

    (650) 375-1111

    11 Total Sales

    Gabby Nadel
    Section Image
  • Louie Kappen

    Seller's Agent in 2015

    Louie Kappen

    Coldwell Banker Realty

    (650) 208-5060

    1 in this area

    18 Total Sales

    Louie Kappen
    Section Image

  • D

    Seller's Agent in 2013

    Diana Belknap

    TRI Pointe Communities Inc

  • S

    Buyer's Agent in 2013

    Sanjeev Dixit

    Sanjeev Dixit, Broker

    (650) 576-3110

    14 Total Sales

    Sanjeev Dixit
    Section Image
See All Agents

Map

Source: MLSListings

MLS Number: ML81934562

MLSListings

APN: 123-930-100

California San Mateo County San Mateo 94403 Hillsdale

401 Derby Ave, San Mateo, CA

Not Listed for Sale

Townhouses

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.