840 N Idaho St, San Mateo, CA 94401 - Photo 1

1/1

$2,830,000

Sold
Closed
Single Family
5 Beds
4 Full Baths
2,773 Sq. Ft.
3 Car Garage

1/1

Property Description

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.

Full Property Details

Full Property Details for 840 N Idaho St

General

Sold For: $2,830,000
Status: Closed
Type: Single Family
Source: RE_Infolink
MLS ID: ML82023781
Added to Site: 135 day(s) ago

Interior

Rooms/Areas: Storage
Fireplace(s): Living Room, Wood-Burning
Flooring: Hardwood

Rooms

Bathrooms

Total Bathrooms: 4
Full Bathrooms: 4
Bathroom Features: Primary - Stall Shower(s), Shower and Tub, Stall Shower, Updated Bath

Bedrooms

Total Bedrooms: 5
Bedroom Features: Ground-Floor Bedroom, Primary Suite / Retreat

Other Rooms

Family Room: Other
Kitchen: Dishwasher, Freezer, Island, Gas Oven/Range, Refrigerator
Laundry: In Garage, Washer / Dryer, Inside

Additional Information

Pool: Yes
Pool Description: Pool - In Ground
Extras: Not Applicable

Parking

Garage Spaces: 3
Parking Features: Attached Garage, On Street

Location

Area: Bowie Estate Etc.
County: San Mateo
Cross Streets: Peninsula

Heating & Cooling

Cooling Type: Central AC
Heating Type: Central Air (Gas/Forced Air)

Utilities

Sewer: Public Sewer
Water: Public
Utility Description: Public Utilities

Structural Information

Architectural Style: Traditional
Construction: Detached
Foundation: Concrete Perimeter and Slab
Roof: Tile
Square Feet: 2,773
Year Built: 2023

Lot Features

Lot Size (Acres): 0.1664
Minimum Lot Size: 7250
Lot Size (Sq. Ft.): 7,250
Grounds/Landscape: Back Yard, Balcony / Patio, BBQ Area, Courtyard, Fenced
Zoning: R20000
Lot Description: Level
Fencing (Description): Fenced Back

Listed by KW Advisors, Disen Cai RE Group
Sold by Comps, Sam Bird-Robinson and Compass, Charlie Lambert

What's Your Home Worth?

* Indicates a required field

For a complimentary comparative market analysis, please contact us so we can discuss your home's value.

Your Property Information

Address optional

City *State *

Zip Code optional

Your Contact Information

First Name *Last Name *

Email Address *

Phone Number *

Comment *

Yes, I would like more information. Please use and/or share my information with a Coldwell Banker ® affiliated agent to contact me about my real estate needs. By clicking Submit, I request to be contacted by phone or text message and consent to being contacted by automated means. I understand that my consent to receive calls or texts is not a condition of purchasing any property, goods, or services. Alternatively, I understand that I can access real estate services by email or I can contact the agent myself.

If an Coldwell Banker affiliated agent is not available in the area where I need assistance, I agree to be contacted by a real estate agent affiliated with another brand owned or licensed by Anywhere Real Estate (BHGRE®, CENTURY 21®, Corcoran®, ERA®, or Sotheby’s International Realty®). I acknowledge that I have read and agree to the Terms of Use and Privacy Notice.

Listing agent

— 840 N Idaho St —

Disen Cai RE Group

KW Advisors

Get Pre-Approved Today

Be ready to buy your new home!

with our affiliated lender

NMLS#: 1598647

Get Pre-Approved

Schools

Schools serving 840 N Idaho St

School Districts:San Mateo Union High School District, San Mateo-Foster City Elementary School District

Name	Grades	Distance
Laurel Elementary School, San Mateo, CA 316 36th Avenue, San Mateo, CA 94403	K-5	3.7 mi
Abbott Middle School 600 36th Avenue, San Mateo, CA 94403	6-8	3.8 mi
San Mateo High School 506 North Delaware Street, San Mateo, CA 94401	9-12	0.4 mi

Disclaimer: School attendance boundaries provided by Pitney Bowes and are for reference only. Contact the school directly to verify enrollment eligibility.

Price & Sales History for 840 N Idaho St

Date

Details

Price

Change

Source

11/10/2025

Sold

$2,830,000

34.83%

MLS

10/03/2025

Listed

$2,099,000

—

MLS

Disclaimer: Historical sales information is derived from public records provided by the county offices. Information is not guaranteed and should be independently verified.

1500 Willow Ave 301, Burlingame, CA 94010 - Photo 1

Just Listed

$895,000

1500 Willow Ave 301 Burlingame, CA 94010

Condo
Active
Updated 3 days ago

2
Beds
2
Total Baths
1,453
Sq. Ft.

Listed by Compass, Raziel A. Ungar

1144 Bernal Ave, Burlingame, CA 94010 - Photo 1

Just Listed

$4,450,000

1144 Bernal Ave Burlingame, CA 94010

Single Family
Active
Updated 2 days ago

4
Beds
5
Total Baths
2,710
Sq. Ft.

Listed by Golden Gate Sotheby's International Realty, Jenn Gilson

1228 Capuchino Ave, Burlingame, CA 94010 - Photo 1

Just Listed

$1,950,000

1228 Capuchino Ave Burlingame, CA 94010

Single Family
Active
Updated 3 days ago

3
Beds
1
Total Bath
1,400
Sq. Ft.

Listing provided by Victoria Maxwell, Real Estate Broker, Victoria L Maxwell

839 Crossway Rd, Burlingame, CA 94010 - Photo 1

Just Listed

$4,688,000

Open House

839 Crossway Rd Burlingame, CA 94010

Single Family
Active
Updated 3 days ago

5
Beds
4
Total Baths
3,075
Sq. Ft.

Listed by eXp Realty of California Inc, Mike Danao

1111 Laguna, Burlingame, CA 94010 - Photo 1

Price Reduced

-$151,000 (-4.79%)

$2,999,000

1111 Laguna Burlingame, CA 94010

Single Family
Active
Updated 5 days ago

6
Beds
4
Total Baths
3,050
Sq. Ft.

Listed by Margaret Duffy (CalRE#: 01810445) (650) 676-0294

1433 Floribunda Ave 8, Burlingame, CA 94010 - Photo 1

Price Reduced

-$37,000 (-2.49%)

$1,448,000

1433 Floribunda Ave 8 Burlingame, CA 94010

Condo
Active
Updated 4 days ago

2
Beds
3
Total Baths
1,314
Sq. Ft.

Listed by Compass, John Sayage

1018 Condor Ln, Foster City, CA 94404 - Photo 1

Price Reduced

-$55,000 (-3.79%)

$1,395,000

1018 Condor Ln Foster City, CA 94404

Townhouse
Active
Updated 1 day ago

3
Beds
3
Total Baths
1,670
Sq. Ft.

Listed by Compass, Sue Walsh

219 Commons Ln, Foster City, CA 94404 - Photo 1

Price Reduced

-$20,000 (-1.56%)

$1,260,000

219 Commons Ln Foster City, CA 94404

Townhouse
Active
Updated 2 days ago

2
Beds
2
Total Baths

Listed by Alliance Bay Realty, Jun Li and Alliance Bay Realty, Fiona Yi Shi

729 Concord Way, Burlingame, CA 94010 - Photo 1

Sold

$3,250,000

729 Concord Way Burlingame, CA 94010

Single Family
Closed

3
Beds
3
Total Baths
2,183
Sq. Ft.

Listed by Christie's International Real Estate Sereno, Steve&ChristinePerry
Sold by Apr, Serena Conti

733 Lexington Way, Burlingame, CA 94010 - Photo 1

Sold

$2,900,000

733 Lexington Way Burlingame, CA 94010

Single Family
Closed

3
Beds
3
Total Baths
1,640
Sq. Ft.

Listed by Berkshire Hathaway HomeServices DrysdaleProperties, Jose Dos Ramos
Sold by Comp90, Sophia Yapp and Compass, David Juarez

729 Plymouth Way, Burlingame, CA 94010 - Photo 1

Sold

$2,905,000

729 Plymouth Way Burlingame, CA 94010

Single Family
Closed

3
Beds
2
Total Baths
2,040
Sq. Ft.

Listed by Compass, Cheryl A. Bower
Sold by Apr, Raziel A. Ungar

479 Marin Dr, Burlingame, CA 94010 - Photo 1

Sold

$2,775,000

479 Marin Dr Burlingame, CA 94010

Single Family
Closed

2
Beds
2
Total Baths
1,482
Sq. Ft.

Listed by Elfie Ravens (CalRE#: 00331689)
Sold by Apr, Raziel A. Ungar

840 N Idaho St, San Mateo, CA 94401 (MLS# ML82023781) is a Single Family property that was sold at $2,830,000 on November 10, 2025. Want to learn more about 840 N Idaho St? Do you have questions about finding other Single Family real estate for sale in San Mateo? You can browse all San Mateo real estate or contact a Coldwell Banker agent to request more information.

840 N Idaho St San Mateo, CA 94401