Welcome to this beautifully remodeled Spanish-style home that effortlessly blends old-world charm with modern luxury in the heart of San Mateo. Timeless architectural details such as arched doorways and tile accents pair seamlessly with contemporary finishes and an updated layout. The main home offers 4 bedrooms and 3 bathrooms across a thoughtfully designed floor plan, ideal for today's lifestyle. From the moment you step inside, you're greeted by an open and airy living space with updated finishes, contemporary lighting, and designer touches throughout. The chef's kitchen is a true centerpiece, featuring premium appliances, custom cabinetry, and elegant countertops -perfect for both everyday living and entertaining. Step outside to a private backyard retreat, where a sparkling pool invites relaxation and a covered porch with a built-in outdoor kitchen sets the stage for seamless indoor-outdoor living. Completing the property is a beautiful ADU, offering its own bedroom, bathroom, full kitchen, and living/dining area, along with a 2-car garage-ideal for extended family, guests, or potential rental income. Located near downtown San Mateo, top-rated schools, parks, and major commuter routes, this turnkey home is the perfect blend of historic character and modern convenience.
Sold for $2,830,000
$2,830,000
840 N Idaho St, San Mateo, CA 94401
5beds
2,773sqft
Single Family Residence, Residential
Built in 2023
7,250 Square Feet Lot
$2,951,000 Zestimate®
$1,021/sqft
$7,892 Estimated rent
Home value
$2,951,000
$2.69M - $3.25M
$7,892/mo
Zestimate® history
Owner options
List your home for rent
$7,892/mo
Rent Zestimate®
Find your next renter with Zillow Rental Manager. Plus, with online applications, you can quickly screen prospective tenants – for free.
$7,892/mo
Rent Zestimate®
Refinance and save
$17,722/mo
Est. payment
Refinancing to a lower rate could help reduce your monthly payments and save thousands over the life of the loan.
$17,722/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
Sparkling poolOld-world charmArchitectural detailsPrivate backyard retreatContemporary finishesElegant countertopsModern luxury
Zillow last checked:
Listing updated:
Listed by:
Disen Cai RE Group 70010134 650-622-2156,
KW Advisors 650-627-3700
Bought with:
Sam Bird-Robinson, 01901727
Compass
Charlie Lambert, 02241273
Compass
Source: MLSListings Inc,MLS#: ML82023781
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 5
- Bathrooms: 4
- Full bathrooms: 4
Bedroom
- Features: GroundFloorBedroom, PrimarySuiteRetreat
Bathroom
- Features: PrimaryStallShowers, ShowerandTub, StallShower, UpdatedBaths
Dining room
- Features: DiningArea, EatinKitchen, FormalDiningRoom
Family room
- Features: Other
Kitchen
- Features: Island
Heating
- Central Forced Air Gas
Cooling
- Central Air
Appliances
- Included: Dishwasher, Freezer, Gas Oven/Range, Refrigerator, Washer/Dryer
- Laundry: In Garage, Inside
Features
- Flooring: Hardwood
- Number of fireplaces: 1
- Fireplace features: Living Room, Wood Burning
Interior area
- Total structure area: 2,773
- Total interior livable area: 2,773 sqft
Property
Parking
- Total spaces: 3
- Parking features: Attached, On Street
- Attached garage spaces: 3
Features
- Stories: 2
- Patio & porch: Balcony/Patio
- Exterior features: Back Yard, Barbecue, Fenced, Courtyard
- Pool features: In Ground
- Fencing: Back Yard
Lot
- Size: 7,250 Square Feet
- Features: Level
Details
- Parcel number: 033023210
- Zoning: R20000
- Special conditions: Standard
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Traditional
- Property subtype: Single Family Residence, Residential
Materials
- Foundation: Concrete Perimeter and Slab
- Roof: Tile
Condition
- New construction: No
- Year built: 2023
Utilities & green energy
- Gas: PublicUtilities
- Sewer: Public Sewer
- Water: Public
- Utilities for property: Public Utilities, Water Public
Community & HOA
Location
- Region: San Mateo
Financial & listing details
- Price per square foot: $1,021/sqft
- Tax assessed value: $2,267,225
- Annual tax amount: $26,990
- Date on market: 10/3/2025
- Listing agreement: ExclusiveRightToSell
Price history
| Date | Event | Price |
|---|---|---|
| 11/10/2025 | Sold | $2,830,000+34.8%$1,021/sqft |
Source:  MLSListings Inc #ML82023781 Report a problem | ||
| 10/21/2025 | Pending sale | $2,099,000+44.8%$757/sqft |
Source: MLSListings Inc #ML82023781 Report a problem | ||
| 4/5/2021 | Sold | $1,450,000+20.9%$523/sqft |
Source:  MLSListings Inc #ML81831591 Report a problem | ||
| 2/26/2021 | Listed for sale | $1,199,000$432/sqft |
Source: Intero Real Estate Services #ML81831591 Report a problem | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2025 | $26,990 +16.7% | $2,267,225 +18.2% |
| 2024 | $23,124 +8.7% | $1,918,751 +13.6% |
| 2023 | $21,270 +13.1% | $1,689,080 +14.2% |
| 2022 | $18,807 +24.6% | $1,479,000 +1194.4% |
| 2021 | $15,095 +485.7% | $114,261 +1% |
| 2020 | $2,577 +5.3% | $113,090 +2% |
| 2019 | $2,447 +18.4% | $110,874 +2% |
| 2018 | $2,068 +9.5% | $108,701 +2% |
| 2017 | $1,888 +5.1% | $106,570 +2% |
| 2016 | $1,796 -16% | $104,482 +1.5% |
| 2015 | $2,138 | $102,914 +2% |
| 2014 | $2,138 | $100,899 +0.5% |
| 2013 | -- | $100,444 +2% |
| 2012 | -- | $98,475 |
| 2011 | -- | $98,475 +2.8% |
| 2010 | -- | $95,825 -0.2% |
| 2009 | -- | $96,054 +2% |
| 2008 | -- | $94,172 +2% |
| 2007 | -- | $92,327 +2% |
| 2006 | -- | $90,518 |
| 2005 | -- | $90,518 +4% |
| 2004 | -- | $87,006 +1.9% |
| 2003 | -- | $85,412 +2% |
| 2002 | -- | $83,738 +2% |
| 2001 | -- | $82,097 +2% |
| 2000 | -- | $80,488 |
Find assessor info on the county website
Neighborhood: North Central
Nearby homes
- $1,269,9003 bd1 ba1.7k sqft848 N Idaho St, San Mateo, CA 94401Off Market
- $2,038,5005 bd4 ba3.2k sqft836 N Idaho St, San Mateo, CA 94401Off Market
- $1,726,0003 bd2 ba1.4k sqft832 N Idaho St, San Mateo, CA 94401Off Market
- $2,422,5003 bd4 ba2.4k sqft852 N Idaho St, San Mateo, CA 94401Off Market
- $1,873,7005 bd3 ba2.7k sqft844-848 N Idaho St, San Mateo, CA 94401Off Market
- $2,635,5004 bd4 ba2.7k sqft856 N Idaho St, San Mateo, CA 94401Off Market
- $2,286,5004 bd3 ba2.5k sqft828 N Idaho St, San Mateo, CA 94401Off Market
- $--1 bd1 ba-- sqft851 N Amphlett Blvd #776F18CCB, San Mateo, CA 94401Off Market
Nearby schools
GreatSchools rating
- 3/10Laurel Elementary SchoolGrades: K-5Distance: 3.7 mi
- 4/10Abbott Middle SchoolGrades: 6-8Distance: 3.8 mi
- 9/10San Mateo High SchoolGrades: 9-12Distance: 0.3 mi
Schools provided by the listing agent
- District: SanMateoFosterCityElementary
Source: MLSListings Inc. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.
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,951,000
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,951,000
- California
- San Mateo County
- San Mateo
- 94401
- North Central
- 840 N Idaho St
Nearby cities
Nearby neighborhoods
Nearby zip codes
Other San Mateo Topics
