Home | San Mateo County | San Mateo | 94402 | 605 Barroilhet Ave
MLS: ML82050829 | Status: Active | Price: $3,650,000
Beds/Baths: 4 / 3 /1
Property Type: Residential
| Beds | Baths | Sq Ft | Sq Ft Lot | Yr Built |
|---|---|---|---|---|
| 4 | 3 /1 | 2,590 | 9,893 | 1956 |
| Date | Time | Hosted By |
|---|---|---|
| Saturday, June 13 | 2:00 pm - 4:00 pm | The Dwyer Group |
| Sunday, June 14 | 2:00 pm - 4:00 pm | The Dwyer Group |
Nestled in the coveted San Mateo Park neighborhood this exceptional residence offers a rare combination of privacy, elegance, and walkable access to downtown Burlingame's vibrant dining and shopping district. Featuring 4 bedrooms and 3.5 baths, the residence seamlessly blends timeless charm with abundant natural light and a welcoming open floor plan including a separate family room with a vaulted ceiling. Bifold glass doors in the formal living and dining areas open to a spacious patio and expansive wraparound grounds, creating the ultimate indoor-outdoor lifestyle. The beautifully landscaped yard showcases mature trees, lush gardens, a fountain, whimsical garden details, and charming brick and fossil stone pathways that invite year-round enjoyment. The thoughtfully designed floor plan includes three bedrooms on the main level, while the private upper-level primary suite offers a vaulted ceiling, updated custom bathroom, a deck and serene garden views. Timeless architectural details throughout the home include fine millwork, beamed ceilings, leaded glass windows, and hardwood flooring. A separate bonus space provides flexibility for a home office, fitness studio or creative retreat. Welcome Home! County Assessor has updated county record as having 4 bedrooms and 3.5 bathrooms
| Field | Value |
|---|---|
| MLS # | ML82050829 |
| MLS Source | MLSListings, Inc. |
| Days on Site | 0 |
| Feature | Details |
|---|---|
| Bedrooms | Primary Suite/Retreat, More than One Bedroom on Ground Floor |
| Bathrooms | Double Sinks, Shower over Tub - 1, Stall Shower - 2+, Updated Bath(s), Full on Ground Floor, Half on Ground Floor |
| Kitchen | Pantry |
| Appliances | Cooktop - Gas, Dishwasher, Microwave, Oven - Built-In, Refrigerator, Washer/Dryer |
| Dining Room | Dining Area in Living Room |
| Family Room | Separate Family Room |
| Fireplace | Living Room |
| Flooring | Hardwood |
| Cooling | None |
| Heating | Central Forced Air - Gas |
| Feature | Details |
|---|---|
| Roof | Wood |
| Foundation | Concrete Perimeter, Raised, Crawl Space |
| Feature | Details |
|---|---|
| Garage/Parking | Attached Garage, Enclosed, Gate/Door Opener, Garage: 1 Car(s) |
| Elementary District | San Mateo-Foster City Elementary |
| High School District | San Mateo Union High |
| Sewer | Public Sewer |
| Water | Public |
| Zoning | R1 |
The Dwyer Group
Compass
License #: 01856588
Phone: (650) 796-3039
School data provided by GreatSchools.org
| School | Type | Grades | Distance | Rating |
|---|---|---|---|---|
| San Mateo Park Elementary School | public | K-5 | 0.41 mi | 2 |
| North Hillsborough School | public | K-5 | 0.66 mi | 9 |
| McKinley Elementary School | public | K-5 | 0.71 mi | 8 |
| Crocker Middle School | public | 6-8 | 0.72 mi | 8 |
| Burlingame High School | public | 9-12 | 0.86 mi | 10 |
| Washington Elementary School | public | K-5 | 0.87 mi | 7 |
| South Hillsborough School | public | K-5 | 0.93 mi | 9 |
| San Mateo High School | public | 9-12 | 1.24 mi | 9 |
| BSD Preschool | public | UG | 1.24 mi | N/A |
| Roosevelt Elementary School | public | K-5 | 1.24 mi | 6 |
| San Mateo Adult | public | UG | 1.30 mi | N/A |
| Baywood Elementary School | public | K-5 | 1.61 mi | 7 |
| West Hillsborough School | public | K-5 | 1.70 mi | 9 |
| Hoover Elementary | public | K-5 | 1.76 mi | 8 |
| Aragon High School | public | 9-12 | 1.85 mi | 10 |
| North Shoreview Montessori Elementary School | public | K-8 | 1.89 mi | 10 |
| Lincoln Elementary School | public | K-5 | 1.95 mi | 8 |
| Sunnybrae Elementary School | public | K-5 | 2.13 mi | 2 |
| Borel Middle School | public | 6-8 | 2.13 mi | 8 |
| Peninsula High (Continuation) | public | 9-12 | 2.16 mi | 4 |
| Address | Price | Beds | Baths | Sq Ft | Status |
|---|---|---|---|---|---|
| 723 Winchester Dr | $2,998,000 | 4 | 2 | 2,120 | PendingDoNotShow |
| 612 Hobart Ave | $3,595,000 | 4 | 4 | 2,463 | Active |
| 1361 Vancouver Ave | $3,698,000 | 4 | 3 | 2,653 | PendingDoNotShow |
| 2835 Hillside Dr | $3,989,000 | 4 | 3 | 2,960 | Active |
©2026 MLSListings Inc. All rights reserved. All data, including all measurements and calculations of area, is obtained from various sources and has not been, and will not be, verified by broker or MLS. All information should be independently reviewed and verified for accuracy. Properties may or may not be listed by the office/agent presenting the information. Information provided is for personal, non-commercial use by the viewer and may not be redistributed without explicit authorization from MLSListings Inc.
Presently MLSListings.com displays Active, Contingent, Pending, and Recently Sold listings. Recently Sold listings are properties which were sold within the last three years. After that period listings are no longer displayed in MLSListings.com. Pending listings are properties under contract and no longer available for sale. Contingent listings are properties where there is an accepted offer, and seller may be seeking back-up offers. Active listings are available for sale.
This listing information is up-to-date as of June 12, 2026. For the most current information, please contact The Dwyer Group, (650) 796-3039.