Home | San Mateo County | San Mateo | 94402 | 404 Hillsborough Blvd
MLS: ML82057745 | Status: Active | Price: $3,598,000
Beds/Baths: 4 / 3 /1
Property Type: Residential
| Beds | Baths | Sq Ft | Sq Ft Lot | Yr Built |
|---|---|---|---|---|
| 4 | 3 /1 | 2,950 | 12,306 | 1965 |
| Date | Time | Hosted By |
|---|---|---|
| Saturday, August 15 | 2:00 pm - 4:00 pm | Julie Halpin |
| Sunday, August 16 | 2:00 pm - 4:00 pm | Julie Halpin |
Set among mature trees in coveted San Mateo Park, 404 Hillsborough Boulevard pairs architectural character and serene nature with move-in-ready updates. This home features 4 bedrooms 3.5 bathrooms plus bonus structure perfect for office or art studio. Vaulted wood-beamed ceilings, a stacked-stone facade, and stained-glass accents set the tone, while walls of windows frame the treetops and connect the living, dining, and kitchen in one bright, open flow. The kitchen features a Wolf range, stainless appliances, and a quartz island wrapped in rich green cabinetry. The primary suite offers a private sitting area, a second bedroom opens to its own deck, and all bathrooms have been updated. Porcelain tile runs through the main level; downstairs has refinished wood floors and new carpet. Multiple decks including a lower patio perfect for entertaining complete this rare offering. Minutes from Burlingame Avenue, top schools, and 101/Caltrain access.
| Field | Value |
|---|---|
| MLS # | ML82057745 |
| MLS Source | MLSListings, Inc. |
| Days on Site | 0 |
| Feature | Details |
|---|---|
| Bedrooms | Inverted Floor Plan, Primary Suite/Retreat, Walk-in Closet |
| Bathrooms | Double Sinks, Jack and Jill, Primary - Stall Shower(s), Primary - Tub w/ Jets, Shower over Tub - 1, Stall Shower, Updated Bath(s), Primary - Oversized Tub, Oversized Tub |
| Appliances | Oven - Gas, Refrigerator, Washer/Dryer |
| Dining Room | Dining Area in Living Room |
| Family Room | Separate Family Room |
| Fireplace | Gas Starter |
| Flooring | Carpet, Hardwood, Stone |
| Cooling | None |
| Heating | Radiant |
| Feature | Details |
|---|---|
| Roof | Shingle |
| Foundation | Concrete Perimeter and Slab |
| Feature | Details |
|---|---|
| Garage/Parking | Attached Garage, Garage: 2 Car(s) |
| Elementary District | San Mateo-Foster City Elementary |
| High School District | San Mateo Union High |
| Sewer | Public Sewer |
| E.V. Hookup | Electric Vehicle Hookup Level 1 (120 volts) |
| Water | Public |
| Zoning | R10010 |
Julie Halpin
Intero Real Estate Services
License #: 01310416
Phone: (650) 315-4017
School data provided by GreatSchools.org
| School | Type | Grades | Distance | Rating |
|---|---|---|---|---|
| Crocker Middle School | public | 6-8 | 0.67 mi | 8 |
| North Hillsborough School | public | K-5 | 0.70 mi | 9 |
| San Mateo Park Elementary School | public | K-5 | 0.76 mi | 2 |
| South Hillsborough School | public | K-5 | 0.86 mi | 9 |
| West Hillsborough School | public | K-5 | 1.13 mi | 9 |
| McKinley Elementary School | public | K-5 | 1.25 mi | 8 |
| Baywood Elementary School | public | K-5 | 1.33 mi | 7 |
| Washington Elementary School | public | K-5 | 1.47 mi | 7 |
| Burlingame High School | public | 9-12 | 1.49 mi | 10 |
| Aragon High School | public | 9-12 | 1.55 mi | 10 |
| BSD Preschool | public | UG | 1.55 mi | N/A |
| Roosevelt Elementary School | public | K-5 | 1.55 mi | 6 |
| San Mateo High School | public | 9-12 | 1.71 mi | 9 |
| San Mateo Adult | public | UG | 1.76 mi | N/A |
| Hoover Elementary | public | K-5 | 1.87 mi | 8 |
| Borel Middle School | public | 6-8 | 1.91 mi | 8 |
| Sunnybrae Elementary School | public | K-5 | 2.19 mi | 2 |
| North Shoreview Montessori Elementary School | public | K-8 | 2.23 mi | 10 |
| Lincoln Elementary School | public | K-5 | 2.29 mi | 8 |
| Meadow Heights Elementary School | public | K-5 | 2.55 mi | 7 |
| Address | Price | Beds | Baths | Sq Ft | Status |
|---|---|---|---|---|---|
| 1407 Carlton Rd | $3,750,000 | 4 | 3/1 | 4,070 | Active |
| 1715 Ralston Ave | $3,198,000 | 3 | 2 | 1,880 | PendingDoNotShow |
| 35 Silk Tree Pl | $3,998,000 | 4 | 3/1 | 3,671 | PendingDoNotShow |
| 804 Acacia Dr | $2,888,000 | 4 | 3/1 | 2,041 | 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 August 14, 2026. For the most current information, please contact Julie Halpin, (650) 315-4017.