NOT LISTED FOR SALE

404 Juanita Ave Millbrae, CA 94030

Lomita Hills Neighborhood

Estimated Value: $2,358,000 - $2,892,000

3 Beds
3 Baths
2,270 Sq Ft
$1,159/Sq Ft Est. Value

Last Sold March 08, 2018

Last sale price $2,030,000 $894 Per Sq Ft

Est. 27% increase in value since last sale

Current estimated payment $16,375/month

5 Days on Market

Highlights

  • Forced Air Heating System
  • Separate Family Room
  • Gas Log Fireplace
  • Green Hills Elementary School Rated A-
  • Dining Area

About This Home

As of March 2018

Welcome to 404 Juanita Avenue, a delightfully charming home nestled in the sought after Lomita Hills. Walk through the welcoming red door. To the left, a delightful living room showcases a lovely fireplace while the bay windows bathe the room in natural light. To the right, a spacious dining room with wainscoting detail is a wonderful room to host special gatherings and celebrations. Beyond, the newly remodeled kitchen, opens to a quaint breakfast area and the light-filled family room beyond. One bedroom, one hallway bath, and an en-suite bedroom complete the main level. Upstairs, a master suite with generous master bath offers repose. Additionally, on the second floor is a bonus room that can easily be used as a fourth bedroom and bonus storage area can be used as storage, an office, an extra room or however you choose. The lower level features an exceptional recreation room and bar! The enormous backyard includes multiple patios, spacious lawn area, greenhouse and fruit trees.

Last Agent to Sell the Property

Caroline Huo

KW Advisors License #01419566 Listed on: 02/02/2018

KW Advisors

Last Buyer's Agent

Yifang Yang

Coldwell Banker Realty License #01371905

Coldwell Banker Realty

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $26,574

Year Built

  • Built in 1946

Lot Details

  • 0.26 Acre Lot
  • Zoning described as R10006

Parking

  • 1 Car Garage

Home Design

  • Composition Roof
  • Concrete Perimeter Foundation

Interior Spaces

  • 2,270 Sq Ft Home
  • 2-Story Property
  • Gas Log Fireplace
  • Separate Family Room
  • Dining Area

Bedrooms and Bathrooms

  • 3 Bedrooms
  • 3 Full Bathrooms

Utilities

  • Forced Air Heating System

Listing and Financial Details

  • Assessor Parcel Number 021-103-320

Home Details

Home Type

Single Family

Est. Annual Taxes

$26,574

Year Built

Built in 1946

Lot Details

0

Parking

1

Listing Details

  • Subclass: Single Family Home
  • Age: 72
  • Listing Class: Residential
  • Structure Sq Ft: 2270
  • Year Built: 1946
  • Zoning Description: R10006
  • Special Features: None
  • Property Sub Type: Detached

Interior Features

  • Family Room: Separate Family Room
  • Fireplace: Gas Log
  • Dining Room: Dining Area
  • Living Sq Ft: 2270
  • Stories: 2
  • Fireplaces Min: 1
  • Maximum Numberof Bedrooms: 3
  • Minimum Numberof Bedrooms: 3
  • Full Bathrooms: 3
  • Total Bedrooms: 3
  • Fireplace: Yes

Exterior Features

  • Foundation: Concrete Perimeter and Slab
  • Roof: Composition

Garage/Parking

  • Garage Spaces: 1
  • Garage Max: 1
  • Garage Min: 1
  • Garage Parking Features: Attached Garage

Utilities

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

Schools

  • School District: San Mateo Union High
  • Elementary School: Green Hills Elementary
  • Middle School: Taylor Middle
  • High School: Mills High
  • High School: 659
  • Elementary School: 733
  • Middle School: 737

Lot Info

  • Parcel Number: 021-103-320
  • Lot Acres: 0.2583
  • Lot Size Area Minimum Units: Square Feet
  • Minimum Lot Size: 11250.00
  • Lot Size Area Maximum Units: Square Feet
  • Maximum Lot Size: 11250.00

Multi Family

  • Utilities: Public Utilities

MLS Schools

  • High School District Text: San Mateo Union High
  • Elementary School Text: Green Hills Elementary
  • High School Text: Mills High
  • Middle School Text: Taylor Middle

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Feb 2, 2018
Closed on
Feb 26, 2018
Sold by
Holober Richard W
Bought by
Zhao Yifu and Hu Wenying
Seller's Agent
Caroline Huo
KW Advisors
Buyer's Agent
Yifang Yang
Coldwell Banker Realty
List Price
$1,595,000
Sold Price
$2,030,000
Premium/Discount to List
$435,000
27.27%
Current Estimated Value
$2,586,192

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$556,192
Avg. Annual Appreciation
3.07%
Original Mortgage
$1,624,000
Interest Rate
4.15%
Mortgage Type
New Conventional
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
Zhao Yifu $2,030,000 First American Title Co
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Zhao Yifu $1,551,000
Closed Zhao Yifu $1,599,000
Closed Zhao Yifu $1,624,000
Previous Owner Holober Richard W $385,000
Previous Owner Holober Richard W $417,000
Previous Owner Holober Richard W $400,000
Previous Owner Holober Richard W $200,000
Previous Owner Holober Richard W $322,700
Previous Owner Holober Richard W $275,000
Previous Owner Holober Richard W $20,000
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
03/08/2018 03/08/18 Sold $2,030,000 +27.3% $894 / Sq Ft
02/08/2018 02/08/18 Pending -- -- --
02/02/2018 02/02/18 For Sale $1,595,000 -- $703 / 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 $26,574 $2,309,789 $1,706,742 $603,047
2023 $26,574 $2,220,099 $1,640,468 $579,631
2022 $24,516 $2,176,568 $1,608,302 $568,266
2021 $24,237 $2,133,891 $1,576,767 $557,124
2020 $23,838 $2,112,012 $1,560,600 $551,412
2019 $23,267 $2,070,600 $1,530,000 $540,600
2018 $6,792 $591,284 $259,141 $332,143
2017 $6,596 $579,691 $254,060 $325,631
2016 $6,506 $568,326 $249,079 $319,247
2015 $6,461 $559,790 $245,338 $314,452
2014 $6,315 $548,826 $240,533 $308,293
Source: Public Records

Agents Affiliated with this Home

  • Caroline Huo

    Seller's Agent in 2018

    Caroline Huo

    KW Advisors

    (650) 558-6846

    117 Total Sales

    Section Image

  • Y

    Buyer's Agent in 2018

    Yifang Yang

    Coldwell Banker Realty

    Section Image
See All Agents

Map

Source: MLSListings

MLS Number: ML81691083

MLSListings

APN: 021-103-320

California San Mateo County Millbrae 94030 Lomita Hills

404 Juanita Ave, Millbrae, CA

This home is located at 404 Juanita Ave, Millbrae, CA 94030 since 02 February 2018 and is currently estimated at $2,630,459, approximately $1,158 per square foot. This property was built in 1946. 404 Juanita Ave is a home located in San Mateo County with nearby schools including Green Hills Elementary School, Taylor Middle School, and Mills 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