1550 Frontera WAY 117
Millbrae, CA 94030
- 1 bed
- 1 bath
- 764 sqft
- $818 per sqft
- 1973 build
- – on site
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 with dues. 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!
Last checked:
As a licensed real estate brokerage, Estately has access to the same database professional Realtors use: the Multiple Listing Service (or MLS). That means we can display all the properties listed by other member brokerages of the local Association of Realtors—unless the seller has requested that the listing not be published or marketed online.
The MLS is widely considered to be the most authoritative, up-to-date, accurate, and complete source of real estate for-sale in the USA.
Estately updates this data as quickly as possible and shares as much information with our users as allowed by local rules. Estately can also email you updates when new homes come on the market that match your search, change price, or go under contract.
Checking…
•
Last updated Mar 11, 2025
•
MLS# 81997126 —
The Building
-
Year Built:1973
-
Age:52
-
Style:Contemporary
-
Subclass:Condominium
-
Roofing:Other
-
Foundation:Other
-
# of Stories:1
-
Unit Features:Other Unit Above
-
Special Features:Elevator / Lift
-
Structure SqFt:764
-
Structure SqFt Source:Assessor
Interior
-
Kitchen:Countertop - Quartz, Dishwasher, Garbage Disposal, Ice Maker, Microwave, Oven Range - Electric, Refrigerator
-
Dining Room:Breakfast Bar, Dining Area
-
Family Room:No Family Room
-
Fireplace:No
-
Flooring:Tile, Vinyl / Linoleum
Room Dimensions
-
Living SqFt:764
Location
-
Cross Street:Murchison Drive
-
City Limits:Yes
-
Property Faces:South
The Property
-
Lot Description:Views
-
Zoning:RG0000
-
Parcel Number:100-710-170
-
Available Views:Bay, Hills
-
Horse Property:No
-
Yard/Grounds:Balcony / Patio
Listing Agent
- Contact info:
- No listing contact info available
Taxes
-
Property ID:81997126
Beds
-
Total:1
-
Bedrooms:Walk-in Closet
-
Beds Max:1
-
Beds Min:1
Baths
-
Full Baths:1
-
Bathroom Features:Shower over Tub - 1, Solid Surface, Tile, Updated Bath
The Listing
-
Branded 3D Tour:
-
Unbranded 3D Tour:
-
Additional Listing Info:Not Applicable
-
Automated Valuations Allowed:1
Heating & Cooling
-
Cooling Methods:None
-
Heating Methods:Baseboard, Electric
Utilities
-
Utilities:Public Utilities
-
Sewer/Septic System:Sewer Connected
-
Water Source:Public
Appliances
-
Laundry:Community Facility
The Community
-
Complex Name:The Bayview Condominiums
-
HOA:Yes
-
HOA Fee:Monthly
-
HOA Fee:$527
-
Association Fees Include:Common Area Electricity, Common Area Gas, Decks, Exterior Painting, Garbage, Insurance - Common Area, Maintenance - Common Area, Maintenance - Exterior, Pool, Spa, or Tennis, Reserves, Sewer, Water, Water / Sewer
-
HOA Amenities:Community Pool, Elevator, Recreation Room, Trash Chute
-
Restrictions:Pets - Rules, Other
-
Pool:Yes
-
Pool:Community Facility
Parking
-
Description and Access:Assigned Spaces, Covered Parking, Electric Gate, Enclosed, Gate / Door Opener
-
Garage:1
-
Garage:1
-
Garage Spaces:1
Monthly cost estimate
Asking price
$625,000
| Expense | Monthly cost |
|---|---|
|
Mortgage
This calculator is intended for planning and education purposes only. It relies on assumptions and information provided by you regarding your goals, expectations and financial situation, and should not be used as your sole source of information. The output of the tool is not a loan offer or solicitation, nor is it financial or legal advice. |
$3,346
|
| Taxes | N/A |
| Insurance | $171 |
| HOA fees | $527 |
| Utilities | $117 See report |
| Total | $4,161/mo.* |
| *This is an estimate |
Walk Score®
Provided by WalkScore® Inc.
Walk Score is the most well-known measure of walkability for any address. It is based on the distance to a variety of nearby services and pedestrian friendliness. Walk Scores range from 0 (Car-Dependent) to 100 (Walker’s Paradise).
Bike Score®
Provided by WalkScore® Inc.
Bike Score evaluates a location's bikeability. It is calculated by measuring bike infrastructure, hills, destinations and road connectivity, and the number of bike commuters. Bike Scores range from 0 (Somewhat Bikeable) to 100 (Biker’s Paradise).
Soundscore™
Provided by HowLoud
Soundscore is an overall score that accounts for traffic, airport activity, and local sources. A Soundscore rating is a number between 50 (very loud) and 100 (very quiet).
Air Pollution Index
Provided by ClearlyEnergy
The air pollution index is calculated by county or urban area using the past three years data. The index ranks the county or urban area on a scale of 0 (best) - 100 (worst) across the United Sates.
Sale history
| Date | Event | Source | Price | % Change |
|---|---|---|---|---|
|
3/8/25
Mar 8, 2025
|
Listed / Active | MLSLISTINGS | $625,000 |
