NOT LISTED FOR SALE

410 Millbrae Ave Millbrae, CA 94030

Highlands Neighborhood

Estimated Value: $2,131,000 - $2,371,608

4 Beds
3 Baths
2,665 Sq Ft
$833/Sq Ft Est. Value

Last Sold September 30, 2021

Last sale price $1,900,000 $713 Per Sq Ft

Est. 17% increase in value since last sale

Current estimated payment $13,619/month

19 Days on Market

Highlights

  • 2 Car Attached Garage
  • Secured Garage or Parking
  • 1-minute walk to Millbrae Skate Park
  • Spring Valley Elementary School Rated A-
  • Forced Air Heating System

About This Home

As of September 2021

Rare investment opportunity In prime Millbrae location with upside potential or live in one and rent the other. Front unit, #410 consist of 1 bedroom, 1 bath and 1 enclosed car garage with washer/dryer hook up. Back unit #420 is a spacious 3 bedroom, 2 baths, with plantation shutters on all windows, wood laminate in dining area, kitchen and hallways, ceiling fans in bedrooms, 1 enclosed car garage with washer/dryer hook up, and good size yard perfect for entertaining. Conveniently located, walking distance to shops, restaurants, schools, Bart and Caltrain Station, easy access to freeway 101 and minutes to SFO.

Last Agent to Sell the Property

Bing Hattori

Intero Real Estate Services License #01139096 Listed on: 07/14/2021

Intero Real Estate Services

Last Buyer's Agent

RECIP

Out of Area Office License #00000000

Property Details

Home Type

  • Multi-Family

Year Built

  • 1960

Lot Details

  • 5,502

Parking

  • 2 Car Attached Garage
  • Secured Garage or Parking

Home Design

  • Duplex
  • Wood Shingle Roof
  • Concrete Perimeter Foundation

Interior Spaces

  • 2,665 Sq Ft Home
  • 2-Story Property

Additional Features

  • 5,502 Sq Ft Lot
  • Forced Air Heating System

Listing and Financial Details

  • Total Actual Rent $34,800

Community Details

Overview

Building Details

  • 2 Leased Units
  • Gardener Expense $600
  • Insurance Expense $1,500
  • Maintenance Expense $1,000
  • Operating Expense $6,600
  • Gross Income $34,800

Property Details

Home Type

Multi-Family

Year Built

1960

Lot Details

0

Parking

2

Listing Details

  • Zoning: R20000
  • Subclass: Duplex
  • Listing Class: Residential Income (2-4 Units)
  • Structure Sq Ft: 2665
  • Special Features: None
  • Property Sub Type: MultiFamily
  • Year Built: 1960

Interior Features

  • Living Sq Ft: 2665
  • Stories: 2
  • Security: Secured Garage / Parking

Exterior Features

  • Foundation: Concrete Perimeter
  • Roof: Wood Shakes / Shingles

Garage/Parking

  • Garage Spaces: 2
  • Parking Spaces: 2
  • Garage Parking Features: Attached Garage

Utilities

  • Heating System: Forced Air
  • Sewer/Septic System: Sewer - Public

Schools

  • High School: 659

Lot Info

  • Lot Acres: 0.1263
  • Lot Size Area Minimum Units: Square Feet
  • Minimum Lot Size: 5500.00
  • Lot Size Area Maximum Units: Square Feet
  • Maximum Lot Size: 5500.00

Rental Info

  • Existing Lease Term(s): Month To Month
  • Gross Rent Multiplier: 59.63
  • Number Of Leased: 2

Multi Family

  • Utilities: Public Utilities
  • Expense Insurance: 1500
  • Expense Landscape: 600
  • Expense Maintenance: 1000
  • Expenses Total: 6600
  • Income Annual Gross: 34800.00
  • Income Annual Rental: 34800
  • Income Gross Scheduled: 34800
  • Meters: Separate Electric, Separate Water
  • Number Of Buildings: 1
  • Operating Expenses Include: Loan - Principle & Interest
  • Tenant Expenses: Utilities - Electric, Utilities - Water

Ownership History

Date Name Owned For Owner Type

Purchase Details

Closed on
Mar 2, 2023
Sold by
Alan Tran And Laurie L Yam Revocable Tru
Bought by
Alan Tran And Laurie L Yam Revocable Trust
Current Estimated Value
$2,219,402

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$1,440,000
Outstanding Balance
$1,382,871
Interest Rate
5%
Mortgage Type
New Conventional
Estimated Equity
$836,531

Purchase Details

Listed on
Jul 14, 2021
Closed on
Sep 22, 2021
Sold by
Coleiro Rosalie A and Murphy Frances M
Bought by
Tran Alan and Yam Laurie L
Seller's Agent
Bing Hattori
Intero Real Estate Services
Buyer's Agent
RECIP
Out of Area Office
List Price
$2,100,000
Sold Price
$1,900,000
Premium/Discount to List
-$200,000
-9.52%

Home Financials for this Owner

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

Purchase Details

Closed on
Oct 7, 2016
Sold by
Coleiro Rosalie A and Murphy Frances M
Bought by
Coleiro Rosalie A and Murphy Frances M

Purchase Details

Closed on
Mar 15, 2001
Sold by
Coleiro Theresa
Bought by
Coleiro Theresa
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
Alan Tran And Laurie L Yam Revocable Trust -- Chicago Title Company
Tran Alan $1,900,000 Orange Coast Ttl Co Of Nocal
Coleiro Rosalie A -- None Available
Coleiro Theresa -- --
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Alan Tran And Laurie L Yam Revocable Trust $1,440,000
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft
09/30/2021 09/30/21 Sold $1,900,000 -8.4% $713 / Sq Ft
08/02/2021 08/02/21 Pending -- -- --
07/30/2021 07/30/21 Price Changed $2,075,000 -1.2% $779 / Sq Ft
07/14/2021 07/14/21 For Sale $2,100,000 -- $788 / 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 $24,848 $2,016,294 $1,284,061 $732,233
2023 $24,848 $1,938,000 $1,234,200 $703,800
2022 $21,649 $1,900,000 $1,210,000 $690,000
2021 $2,280 $159,181 $45,268 $113,913
2020 $2,250 $157,549 $44,804 $112,745
2019 $2,207 $154,461 $43,926 $110,535
2018 $2,172 $151,433 $43,065 $108,368
2017 $2,050 $148,465 $42,221 $106,244
2016 $2,018 $145,555 $41,394 $104,161
2015 $2,007 $143,370 $40,773 $102,597
2014 $1,969 $140,563 $39,975 $100,588
Source: Public Records

Agents Affiliated with this Home

  • B

    Seller's Agent in 2021

    Bing Hattori

    Intero Real Estate Services

    Section Image

  • R

    Buyer's Agent in 2021

    RECIP

    Out of Area Office

See All Agents

Map

Source: MLSListings

MLS Number: ML81853143

MLSListings

APN: 024-276-060

California San Mateo County Millbrae 94030 Highlands

410 Millbrae Ave, Millbrae, CA

Not Listed for Sale

MultiFamily

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