- 2 beds
- 2 baths
- 998 sqft
- 2,400 sqft lot
- $899 per sqft
- 1978 build
- – on site
Located in the tree-studded community of The Waters, this top-floor unit at 905 W Middlefield #924 pairs updated interiors with peaceful pond views and a convenient Mountain View location. Vaulted ceilings and fresh paint enhance the open-concept living space, which includes a fireplace and a balcony with modern glass-and-metal railing. The refreshed kitchen features new quartz countertops, painted cabinetry, updated lighting, and stainless steel appliances, while the adjacent dining room features a striking modern chandelier. Two bedrooms enjoy southern exposure and leafy outlooks; the primary includes an ensuite bath with updated vanity, tile flooring, and lighting. The secondary bathroom mirrors these updates and sits beside the second bedroom. Other features include in-unit laundry, abundant storage, and new lighting throughout. A detached garage provides dedicated parking and storage. Enjoy community amenities including pool, hot tub, and tennis courts, plus proximity to parks, Castro Street, and Caltrain.
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 Jun 30, 2025
•
MLS# ML82012527 —
The Building
-
Year Built:1978
-
Year Built Source:Assessor
-
New Construction:No
-
Unit Number:924
-
Roof:Composition
-
Foundation:Slab
-
Stories Total:1
Interior
-
Flooring:Stone, Tile, Wood
-
Room Type:Retreat
-
Living Area Source:Assessor
-
Fireplace:Yes
-
Fireplace:Living Room
Room Dimensions
-
Living Area:998.00
Location
-
Directions:Cross Street: N Shoreline Blvd
-
Latitude:37.40537543
-
Longitude:-122.07717899
The Property
-
Property Type:Residential
-
Subtype:Condominium
-
Zoning:R32
-
Lot Size Area:2400.0000
-
Lot Size Acres:0.0551
-
Lot Size SqFt:2400.00
-
Lot Size Source:Other
Listing Agent
- Contact info:
- No listing contact info available
Beds
-
Total Bedrooms:2
Baths
-
Total Baths:2
-
Full & Three Quarter Baths:2
-
Full Baths:2
The Listing
-
Special Listing Conditions:Standard
-
Parcel Number:15332020
Heating & Cooling
-
Heating:1
-
Heating:Electric
-
Cooling:Yes
-
Cooling:None
Utilities
-
Sewer:Public Sewer
-
Water Source:Public
Appliances
-
Appliances:Dishwasher, Microwave, Refrigerator
-
Included:Yes
Schools
-
High School District:Other
The Community
-
Association Amenities:Trash, Insurance, Management, Spa/Hot Tub
-
Association:The Waters HOA
-
Association:Yes
-
Association Fee:$765
-
Association Fee Frequency:Monthly
-
Pool:Community, In Ground
-
Spa:1
-
Private Pool:No
-
Spa Features:Community, In Ground
-
Assessments:No
Parking
-
Parking:Yes
-
Parking:Guest
-
Parking Spaces:1.00
-
Attached Garage:No
-
Garage Spaces:1.00
Monthly cost estimate

Asking price
$898,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. |
$4,808
|
Taxes | N/A |
Insurance | $246 |
HOA fees | $765 |
Utilities | $113 See report |
Total | $5,932/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).
Transit Score®
Provided by WalkScore® Inc.
Transit Score measures a location's access to public transit. It is based on nearby transit routes frequency, type of route (bus, rail, etc.), and distance to the nearest stop on the route. Transit Scores range from 0 (Minimal Transit) to 100 (Rider’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 |
---|---|---|---|---|
6/26/25
Jun 26, 2025
|
Listed / Active | CRMLS_CA | $898,000 | -10.0% (-1.5% / YR) |
9/24/18
Sep 24, 2018
|
CRMLS_CA | $998,000 |

44% of nearby similar homes sold for over asking price
Similar homes that sold in bidding wars went $52k above asking price on average, but some went as high as $352k over asking price.