Step into your dream home! This beautifully updated 3 bedroom, 2 bathroom rental offers the perfect blend of comfort, style, and functionality all located in a highly sought-after school district, ideal for families or those seeking top-tier education access.
Features Include:
Newly Renovated Island Kitchen Enjoy cooking and entertaining in a sleek, modern kitchen featuring quartz countertops, stainless steel appliances, and a spacious island with bar seating.
Open-Concept Living Room Bright and airy living space with plenty of natural light, perfect for relaxing or hosting guests.
Modern Design Throughout Fresh paint, updated fixtures, and a clean, contemporary aesthetic.
Hardwood Floors Gorgeous flooring runs throughout the main living areas and bedrooms, adding warmth and elegance.
Beautiful Garden & Front Yard Enjoy the outdoors with a well-maintained garden, ideal for relaxing evenings or weekend gardening. The charming front yard adds great curb appeal.
Additional Amenities:
In-unit laundry
Central heating
Driveway or street parking
Prime Location: Nestled in a quiet, family-friendly neighborhood close to parks, shops, restaurants, public transit and part of an excellent school district known for strong academics and community involvement.
Don't miss this opportunity to make this stunning home yours!
Lease Terms
Lease Duration: 12-month lease (annual)
Rent Due: Monthly rent due on the 1st of each month
Deposit: Last month's rent due at signing
Utilities:
Tenant responsible for splitting all utilities, including:
Water, Garbage, Electricity, Internet
Smoking Policy: No smoking allowed on the premises (inside or outside)
Sold for $1,760,000
$1,760,000
523 Lomita Ave, Millbrae, CA 94030
3beds
1,230sqft
Single Family Residence
Built in ----
-- sqft lot
$2,172,300 Zestimate®
$1,431/sqft
$6,147 Estimated rent
Home value
$2,172,300
$2.00M - $2.39M
$6,147/mo
Zestimate® history
Owner options
List your home for rent
$6,147/mo
Rent Zestimate®
Find your next renter with Zillow Rental Manager. Plus, with online applications, you can quickly screen prospective tenants – for free.
$6,147/mo
Rent Zestimate®
Refinance and save
$11,245/mo
Est. payment
Refinancing to a lower rate could help reduce your monthly payments and save thousands over the life of the loan.
$11,245/mo
Est. payment
Explore your selling options
Work with a Zillow partner agent
Leverage their expertise and Zillow's premium Showcase listings to get your home seen by more buyers.
Get startedList with your own agent
Get your home in front of millions of buyers by listing it on Zillow.
Learn how to do itSell it yourself
Take full control of how buyers see your home on Zillow by listing For Sale by Owner (FSBO).
List your homeWhat's special
Well-maintained gardenSleek modern kitchenFresh paintUpdated fixturesClean contemporary aestheticQuartz countertopsStainless steel appliances
Zillow last checked:
Listing updated:
Source: Zillow Rentals
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 3
- Bathrooms: 2
- Full bathrooms: 2
Heating
- Heat Pump
Cooling
- Window Unit
Appliances
- Included: Dishwasher, Dryer, Freezer, Microwave, Oven, Refrigerator, Washer
- Laundry: In Unit
Features
- Flooring: Hardwood
Interior area
- Total interior livable area: 1,230 sqft
Property
Parking
- Parking features: Off Street
- Details: Contact manager
Features
- Exterior features: Bicycle storage, Electric Vehicle Charging Station, Garden, No Utilities included in rent
Details
- Parcel number: 021074610
Construction
Type & style
- Home type: SingleFamily
- Property subtype: Single Family Residence
Community & HOA
Community
- Deposit fee: $4,800
Location
- Region: Millbrae
Financial & listing details
- Price per square foot: $1,431/sqft
- Tax assessed value: $1,795,200
- Annual tax amount: $21,785
- Date on market: 8/22/2025
- Date available: 09/01/2025
- Lease term: 1 Year
Price history
| Date | Event | Price |
|---|---|---|
| 8/29/2025 | Listing removed | $4,800$4/sqft |
Source: Zillow Rentals Report a problem | ||
| 8/27/2025 | Price change | $4,800+6.7%$4/sqft |
Source: Zillow Rentals Report a problem | ||
| 8/22/2025 | Listed for rent | $4,500$4/sqft |
Source: Zillow Rentals Report a problem | ||
| 6/11/2024 | Sold | $1,760,000+26.8%$1,431/sqft |
Source: Public Record Report a problem | ||
| 5/11/2024 | Pending sale | $1,388,000$1,128/sqft |
Source: | ||
| 4/26/2024 | Listed for sale | $1,388,000$1,128/sqft |
Source: | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2025 | $21,785 +549.3% | $1,795,200 +1079.9% |
| 2024 | $3,355 -1.7% | $152,146 +2% |
| 2023 | $3,415 +75.4% | $149,163 +2% |
| 2022 | $1,946 +4.4% | $146,239 +1% |
| 2021 | $1,865 +1.4% | $144,775 +1% |
| 2020 | $1,838 +2.1% | $143,292 +2% |
| 2019 | $1,800 +1.8% | $140,484 +2% |
| 2018 | $1,768 +7.3% | $137,731 +2% |
| 2017 | $1,648 +1.9% | $135,031 +2% |
| 2016 | $1,617 +2.9% | $132,384 +1.5% |
| 2015 | $1,572 | $130,396 +2% |
| 2014 | $1,572 | $127,842 +0.5% |
| 2013 | -- | $127,265 +2% |
| 2012 | -- | $124,770 |
| 2011 | -- | $124,770 +2.8% |
| 2010 | -- | $121,410 -0.2% |
| 2009 | -- | $121,700 +2% |
| 2008 | -- | $119,314 +2% |
| 2007 | -- | $116,975 +2% |
| 2006 | -- | $114,682 |
| 2005 | -- | $114,682 +4% |
| 2004 | -- | $110,230 +1.9% |
| 2003 | -- | $108,210 +2% |
| 2002 | -- | $106,089 +2% |
| 2001 | -- | $104,010 +2% |
| 2000 | -- | $101,971 |
Find assessor info on the county website
Neighborhood: 94030
Nearby homes
- $1,703,3003 bd1 ba1.1k sqft601 Santa Barbara Ave, Millbrae, CA 94030Off Market
- $1,507,3003 bd1 ba1.1k sqft519 Lomita Ave, Millbrae, CA 94030Off Market
- $1,645,4003 bd1 ba1.2k sqft508 Vista Ct, Millbrae, CA 94030Off Market

- $1,550,1003 bd1 ba1.2k sqft512 Vista Ct, Millbrae, CA 94030Off Market
- $1,898,9003 bd1 ba1.6k sqft603 Santa Barbara Ave, Millbrae, CA 94030Off Market
- $1,477,9002 bd1 ba1.2k sqft534 Lomita Ave, Millbrae, CA 94030Off Market
- $1,789,8003 bd1 ba1.2k sqft530 Lomita Ave, Millbrae, CA 94030Off Market
- $1,396,1002 bd1 ba1k sqft524 Lomita Ave, Millbrae, CA 94030Off Market
Nearby schools
GreatSchools rating
- 10/10Green Hills Elementary SchoolGrades: K-5Distance: 0.6 mi
- 8/10Taylor Middle SchoolGrades: 6-8Distance: 1 mi
- 10/10Mills High SchoolGrades: 9-12Distance: 1.7 mi
Get a cash offer in 3 minutes
Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
Estimated market value
$2,172,300
Get a cash offer in 3 minutes
Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
Estimated market value
$2,172,300
- California
- San Mateo County
- Millbrae
- 94030
- 523 Lomita Ave