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

1/1

$2,200,000

Sold
Closed
Single Family
4 Beds
2 Full Baths
1 Partial Bath
2,243 Sq. Ft.
1 Car Garage

1/1

Property Description

OFFERS DUE TUESDAY (30TH) BY 2PM - Extraordinary Spanish-style residence, where timeless architecture meets modern luxury. Surrounded by lush tropical landscaping: towering Windmill Palms, elegant Phoenix reclinate, and dramatic Giant Birds of Paradise, this home offers privacy and a breathtaking natural backdrop. Meticulously updated while honoring its vintage character, this 4-bed, 2.5-bath treasure showcases an enchanting interior courtyard, intricate tilework, curved walls, arched doorways, and stained-glass windows. Open kitchen, sunroom, and formal dining room flow seamlessly to the patio with a built-in propane BBQ, pergola, arched patio walls, and tranquil fountain. Upstairs, hardwood floors and a Juliet balcony add romance and charm, while the fourth bedroom doubles as a private home office. Additional highlights include wall niches, travertine tile, granite countertops, wood accents, luxury vinyl flooring, and a Sundance six-person spa. Located on a wide, tree-lined street between vibrant downtowns: San Mateo and Burlingame. Love the water? Coyote Point is moments away, offering the Bay Trail, sandy beaches, public golf, and endless waterfront recreation. A lifestyle as much as a home, blending timeless charm with modern convenience in the heart of the Bay Area.

Full Property Details

Full Property Details for 829 N Idaho St

General

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

Interior

Rooms/Areas: Unfinished Basement, Bonus / Hobby Room, Den / Study / Office, Formal Entry, Library, Office Area, Storage, Workshop, Other
Interior Features: Walk-In Closet
Fireplace(s): Living Room
Flooring: Hardwood, Tile, Vinyl / Linoleum

Rooms

Bathrooms

Total Bathrooms: 3
Full Bathrooms: 2
Half Bathrooms: 1
Bathroom Features: Full on Ground Floor, Shower and Tub, 1 Shower over Tub, Updated Bath

Bedrooms

Total Bedrooms: 4
Bedroom Features: Primary Suite / Retreat, Walk-In Closet

Other Rooms

Family Room: Kitchen / Family Room Combo
Kitchen: Granite Countertop, Dishwasher, Freezer, Garbage Disposal, Microwave, Double Oven, Gas Oven/Range, Refrigerator
Laundry: Electricity Hookup (220V), In Garage, Washer / Dryer

Additional Information

Extras: Not Applicable
Security/Safety: Video / Audio System, Other

Parking

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

Location

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

Heating & Cooling

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

Utilities

Sewer: Public Sewer
Water: Public
Utility Description: Individual Electric Meters, Individual Gas Meters

Structural Information

Architectural Style: Spanish
Construction: Detached
Foundation: Raised
Roof: Clay, Tile
Square Feet: 2,243
Year Built: 1929

Lot Features

Property View: Neighborhood
Lot Size (Acres): 0.1664
Minimum Lot Size: 7250
Lot Size (Sq. Ft.): 7,250
Grounds/Landscape: Back Yard, Balcony / Patio, BBQ Area, Courtyard, Outdoor Kitchen, Sprinklers - Lawn, Other
Zoning: R20000
Fencing (Description): Fenced Back

Green Features

Energy Efficient: Thermostat Controller

Listed by KW Advisors, Christopher Eckert
Sold by Sxcw01, David Kao

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

— 829 N Idaho St —

Christopher Eckert

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 829 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.7 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 829 N Idaho St

Date

Details

Price

Change

Source

10/21/2025

Sold

$2,200,000

4.76%

MLS

9/22/2025

Listed

$2,100,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.

1145 California Dr 1145, Burlingame, CA 94010 - Photo 1

Price Reduced

-$188 (-2.81%)

$6,512

1145 California Dr 1145 Burlingame, CA 94010

Commercial Lease
Active
Updated 1 day ago

2,135
Sq. Ft.

Listed by Endri Hoxha (CalRE#: 02059299) (415) 941-9875

1145 California Dr 1147, Burlingame, CA 94010 - Photo 1

Price Reduced

-$79 (-2.14%)

$3,621

1145 California Dr 1147 Burlingame, CA 94010

Commercial Lease
Active
Updated 1 day ago

1,420
Sq. Ft.

Listed by Endri Hoxha (CalRE#: 02059299) (415) 941-9875

33 Park Rd 5, Burlingame, CA 94010 - Photo 1

Just Listed

$1,348,000

Open House

33 Park Rd 5 Burlingame, CA 94010

Townhouse
Active
Updated 3 days ago

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

Listed by Province Real Estate, Tom Ruan

605 Concord Way, Burlingame, CA 94010 - Photo 1

Just Listed

$3,788,000

Open House

605 Concord Way Burlingame, CA 94010

Single Family
Active
Updated 2 days ago

3
Beds
4
Total Baths
2,248
Sq. Ft.

Listed by Tuscana Properties, Sandra Jamison

Price Reduced

-$79 (-2.14%)

$3,621

1145 California Dr 1147 Burlingame, CA 94010

Commercial Lease
Active
Updated 1 day ago

1,420
Sq. Ft.

Listed by Endri Hoxha (CalRE#: 02059299) (415) 941-9875

Price Reduced

-$188 (-2.81%)

$6,512

1145 California Dr 1145 Burlingame, CA 94010

Commercial Lease
Active
Updated 1 day ago

2,135
Sq. Ft.

Listed by Endri Hoxha (CalRE#: 02059299) (415) 941-9875

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

1433 Floribunda Ave 7 Burlingame, CA 94010

Condo
Active
Updated 1 day ago

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

Listed by Compass, John Sayage

1102 Admiralty Ln, Foster City, CA 94404 - Photo 1

1102 Admiralty Ln Foster City, CA 94404

Condo
Active
Updated 4 days ago

1
Bed
1
Total Bath

Listed by Prestige Realty, Michelle Chiou and Prestige Realty, Russ Engle

219 Dwight Rd, Burlingame, CA 94010 - Photo 1

Sold

$1,898,000

219 Dwight Rd Burlingame, CA 94010

Single Family
Closed

2
Beds
1
Total Bath
1,340
Sq. Ft.

Listed by Arlene Sullivan (CalRE#: 01053539)
Sold by Comps, Kitty Tranggana

700 Howard Ave, Burlingame, CA 94010 - Photo 1

Sold

$2,400,000

700 Howard Ave Burlingame, CA 94010

Single Family
Closed

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

Listed by Christie's International Real Estate Sereno, Judy Guardino and Christie's International Real Estate Sereno, Christina McDermott
Sold by The Bohnert Group

437 Turner Terrace, San Mateo, CA 94401 - Photo 1

Sold

$1,895,000

437 Turner Terrace San Mateo, CA 94401

Single Family
Closed

4
Beds
4
Total Baths
2,430
Sq. Ft.

Listed by Compass, The Patty Dwyer Group
Sold by Cckelr, Yelena Vayn

45 N Ellsworth Ave, San Mateo, CA 94401 - Photo 1

Sold

$2,000,000

45 N Ellsworth Ave San Mateo, CA 94401

Duplex
Closed

3,290
Sq. Ft.

Listed by Colliers Parrish International, Inc., Don Sung
Sold by Train, Training Manager

829 N Idaho St, San Mateo, CA 94401 (MLS# ML82022429) is a Single Family property that was sold at $2,200,000 on October 21, 2025. Want to learn more about 829 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.

829 N Idaho St San Mateo, CA 94401