Home | San Mateo County | Millbrae | 94030 | 1550 Frontera Way 117
MLS: ML82020053 | Status: Sold | Price: $2,800
Beds/Baths: 1 / 1
Property Type: Residential Lease
| Bed | Bath | Sq Ft | Sq Ft Lot | Yr Built |
|---|---|---|---|---|
| 1 | 1 | 764 | – | 1973 |
Spectacular condo with all the amenities! Completely renovated and filled with natural light from the southern exposure and large windows. Stylish design highlighting new wide plank floors, fresh paint, new lighting and hardware throughout. Open kitchen with quartz counters, stainless appliances and breakfast bar. Inviting dining area and spacious living room opening to large, private patio. Updated bath and bedroom en suite with walk in closet. Excellent storage space. Sought after Bayview Condo HOA with pool, views and impressive open space. Well run and established community with healthy reserves, onsite management and water included. Centrally located and close proximity to highway 280; Peninsula Hospital; shopping, leisure, SFO and public transportation. A must see for those who seek the best of location, style and value!
| Field | Value |
|---|---|
| MLS # | ML82020053 |
| MLS Source | MLSListings, Inc. |
| Feature | Details |
|---|---|
| Appliances | Cooktop - Electric, Dishwasher, Freezer, Microwave, Oven - Electric, Refrigerator, Washer/Dryer |
| Dining Room | Breakfast Bar, Dining Area |
| Family Room | No Family Room |
| Cooling | None |
| Heating | Electric |
| Feature | Details |
|---|---|
| Pool | Community Facility |
| Feature | Details |
|---|---|
| Garage/Parking | Assigned Spaces, Gate/Door Opener, Garage: 1 Car(s) |
| Elementary District | Millbrae Elementary |
| High School District | San Mateo Union High |
| Complex Amenities | Community Pool, Elevator, Garden / Greenbelt/ Trails |
| Feature | Details |
|---|---|
| Rent Includes | Management, Sewer, TrashCollection, Water, AssociationFees, LaundryFacilities, PoolSpa |
Mike Bohnert
Coldwell Banker Realty
License #: 01325031
Phone: (650) 504-2378
School data provided by GreatSchools.org
| School | Type | Grades | Distance | Rating |
|---|---|---|---|---|
| Spring Valley Elementary School | public | K-5 | 0.87 mi | 10 |
| Franklin Elementary School | public | K-5 | 0.90 mi | 10 |
| Burlingame Intermediate School | public | 6-8 | 1.01 mi | 9 |
| Mills High School | public | 9-12 | 1.07 mi | 10 |
| Taylor Middle School | public | 6-8 | 1.12 mi | 8 |
| Hoover Elementary | public | K-5 | 1.25 mi | 7 |
| Lincoln Elementary School | public | K-5 | 1.41 mi | 6 |
| Green Hills Elementary School | public | K-5 | 1.57 mi | 10 |
| Meadows Elementary School | public | K-5 | 1.62 mi | 8 |
| BSD Preschool | public | UG | 1.84 mi | N/A |
| Roosevelt Elementary School | public | K-5 | 1.87 mi | 5 |
| Capuchino High School | public | 9-12 | 1.93 mi | 7 |
| Lomita Park Elementary School | public | K-5 | 2.03 mi | 5 |
| Peninsula High | public | 9-12 | 2.14 mi | N/A |
| Peninsula High (Continuation) | public | 9-12 | 2.14 mi | 4 |
| North Hillsborough School | public | K-5 | 2.37 mi | 9 |
| Crocker Middle School | public | 6-8 | 2.44 mi | 8 |
| Parkside Intermediate School | public | 6-8 | 2.50 mi | 4 |
| McKinley Elementary School | public | K-5 | 2.55 mi | 7 |
| John Muir Elementary School | public | K-5 | 2.77 mi | 9 |
©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 January 30, 2026. For the most current information, please contact Mike Bohnert, (650) 504-2378.