Home | San Mateo County | Burlingame | 94010 | 904 Bayswater Ave 1
MLS: ML81927860 | Status: Sold | Price: $1,470,000
Beds/Baths: 2 / 2 /1
Property Type: Residential
| Beds | Baths | Sq Ft | Sq Ft Lot | Yr Built |
|---|---|---|---|---|
| 2 | 2 /1 | 1,410 | 4,318 | 2015 |
Outstanding luxury townhome built in 2014 with all the bells and whistles just blocks to Burlingame Avenue. Hardwood floors, quartz countertops, lofty ceilings, and high-end stainless steel appliances. Prime end-unit location benefits from many windows and abundant natural light on both levels. Open-concept living/dining room flows into a gorgeous gourmet kitchen with breakfast/wine bar seating. Two spacious upstairs bedrooms, each with beautiful en suite bath. Private laundry tucked beneath the stairs plus underground parking for 2 cars with Tesla charger and elevator access. Private and shared barbecue and gardens in this cozy community of just 5 other homes. The perfect location midway between San Francisco and Silicon Valley, steps to parks, downtown Burlingame shopping, dining, and Caltrain, plus excellent Burlingame schools.
| Field | Value |
|---|---|
| MLS # | ML81927860 |
| MLS Source | MLSListings, Inc. |
| Feature | Details |
|---|---|
| Bedrooms | Primary Suite/Retreat - 2+, More than One Primary Bedroom |
| Bathrooms | Double Sinks, Dual Flush Toilet, Primary - Stall Shower(s), Shower over Tub - 1, Tile, Updated Bath(s), Half on Ground Floor |
| Kitchen | Exhaust Fan |
| Appliances | Cooktop - Gas, Dishwasher, Exhaust Fan, Garbage Disposal, Hood Over Range, Microwave, Oven Range - Gas, Refrigerator, Dryer, Washer |
| Dining Room | Dining Area in Family Room, No Formal Dining Room |
| Family Room | Kitchen/Family Room Combo |
| Flooring | Hardwood, Tile |
| Laundry | Inside |
| Cooling | Central Forced Air |
| Heating | Central Forced Air - Gas |
| Feature | Details |
|---|---|
| Roof | Composition |
| Foundation | Slab |
| Feature | Details |
|---|---|
| Garage/Parking | Assigned Spaces, Electric Car Hookup, Electric Gate, Gate/Door Opener, Guest / Visitor Parking, Garage: 2 Car(s) |
| Elementary District | Burlingame Elementary |
| High School District | San Mateo Union High |
| Sewer | Public Sewer |
| E.V. Hookup | Electric Vehicle Hookup Level 2 (240 volts) |
| Water | Public |
| HOA Fee | $595 |
| HOA Fee Frequency | Monthly |
| Complex Amenities | Barbecue Area, Elevator |
| Zoning | R3 |
Raziel A. Ungar
Compass
License #: 01701234
Phone: (650) 720-5483
School data provided by GreatSchools.org
| School | Type | Grades | Distance | Rating |
|---|---|---|---|---|
| Washington Elementary School | public | K-5 | 0.11 mi | 7 |
| Burlingame High School | public | 9-12 | 0.42 mi | 10 |
| San Mateo High School | public | 9-12 | 0.61 mi | 9 |
| San Mateo Adult | public | UG | 0.66 mi | N/A |
| San Mateo Park Elementary School | public | K-5 | 0.70 mi | 2 |
| McKinley Elementary School | public | K-5 | 0.90 mi | 8 |
| South Hillsborough School | public | K-5 | 1.20 mi | 9 |
| North Shoreview Montessori Elementary School | public | K-8 | 1.30 mi | 10 |
| North Hillsborough School | public | K-5 | 1.44 mi | 9 |
| Crocker Middle School | public | 6-8 | 1.56 mi | 8 |
| Roosevelt Elementary School | public | K-5 | 1.58 mi | 6 |
| BSD Preschool | public | UG | 1.61 mi | N/A |
| Sunnybrae Elementary School | public | K-5 | 1.91 mi | 2 |
| Baywood Elementary School | public | K-5 | 1.94 mi | 7 |
| Peninsula High | public | 9-12 | 2.06 mi | N/A |
| Peninsula High (Continuation) | public | 9-12 | 2.06 mi | 4 |
| Aragon High School | public | 9-12 | 2.08 mi | 10 |
| Lincoln Elementary School | public | K-5 | 2.17 mi | 8 |
| Hoover Elementary | public | K-5 | 2.24 mi | 8 |
| LEAD Elementary | public | K-5 | 2.24 mi | 2 |
©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 February 01, 2026. For the most current information, please contact Raziel A. Ungar, (650) 720-5483.