Judy Smith
COLDWELL BANKER ASSOCIATED BROKERS
(530) 641-9456
35 Total Sales
1 in Rex Manor
$1,257,500 Price
905 W Middlefield Rd Unit 974 Mountain View, CA 94043
Rex Manor NeighborhoodEstimated Value: $898,000 - $929,000
2
Beds
2
Baths
998
Sq Ft
2,396
Sq Ft Lot
Highlights
- In Ground Pool
- Sauna
- 1 Car Detached Garage
- Crittenden Middle School Rated A-
- Tennis Courts
- 3-minute walk to San Veron Park
About This Home
As of August 2025Welcome to Unit 974 at The Waters, a refined 2-bedroom, 2-bath upper-level condo offering 998 sq ft of thoughtfully designed space in one of Mountain Views most tranquil communities. While model matches exist, none compare to this home's combination of location, ambiance, and upgrades. Overlooking peaceful lake views & fountains, this serene retreat is shaded by a mature oak tree, offering natural light w/o the heat. Enjoy morning coffee or evening wine while hummingbirds visit your private balcony. Updated with Phillips Hue smart lighting system throughout the home, customized from your phone. Radiant ceiling heating for those cozy winters. Upgraded Milgard double-pane windows throughout maintain comfortable temperatures & your peace and quiet. Both bedrooms include walk-in closets, & the home is complete with in-unit washer/dryer, folding station, & one-car garage, a rare find under $1M in Mountain View. Despite its proximity to Middlefield Rd, the unit is astonishingly peaceful. Open the sliding door, and all you'll hear is the gentle fountain and leaves rustling in the breeze. Best of all? Youre just minutes from Google HQ & major tech campuses. Unit 974 is more than a home, it's a lifestyle of serenity, comfort, and understated success.
Last Agent to Sell the Property
Payne Sharpley
Coldwell Banker Realty License #02195155 Listed on: 07/16/2025
Create a Home Valuation Report for This Property
The Home Valuation Report is an in-depth analysis detailing your home's value as well as a comparison with similar homes in the area
Property Details
Home Type
- Condominium
Year Built
- Built in 1978
Lot Details
- 2,396
HOA Fees
- $765 Monthly HOA Fees
Parking
- 1 Car Detached Garage
- Guest Parking
- Off-Site Parking
- Assigned Parking
Home Design
- Composition Roof
- Concrete Perimeter Foundation
Interior Spaces
- 998 Sq Ft Home
- 1-Story Property
- Wood Burning Fireplace
- Combination Dining and Living Room
Bedrooms and Bathrooms
- 2 Bedrooms
- 2 Full Bathrooms
Pool
- In Ground Pool
- In Ground Spa
Utilities
- Radiant Heating System
Listing and Financial Details
- Assessor Parcel Number 153-31-024
Community Details
Overview
- Association fees include common area electricity, decks, exterior painting, fencing, garbage, hot water, insurance, insurance - common area, insurance - earthquake, insurance - structure, landscaping / gardening, maintenance - common area, maintenance - exterior, maintenance - road, management fee, pool spa or tennis, reserves, roof, water
- The Waters Homeowner Association
- Built by The Waters Homeowner Association
Amenities
- Sauna
Recreation
- Tennis Courts
- Community Pool
Ownership History
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
Date
Name
Owned For
Owner Type
Purchase Details
Listed on
Jul 16, 2025
Closed on
Aug 19, 2025
Sold by
Bought by
Seller's Agent
Payne Sharpley
Coldwell Banker Realty
Buyer's Agent
Bill Lister
Coldwell Banker Realty
List Price
$968,888
Sold Price
$930,000
Premium/Discount to List
-$38,888
-4.01%
Views
18
Current Estimated Value
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
-$16,762
Avg. Annual Appreciation
-1.92%
Original Mortgage
$750,000
Outstanding Balance
$743,835
Interest Rate
6.56%
Mortgage Type
New Conventional
Estimated Equity
$169,403
Purchase Details
Listed on
Oct 25, 2022
Closed on
Nov 29, 2022
Sold by
Bought by
Seller's Agent
Kathleen Pasin
Christie's International Real Estate Sereno
Buyer's Agent
Ryan Greco
Compass
List Price
$895,000
Sold Price
$920,000
Premium/Discount to List
$25,000
2.79%
Views
4
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
0.40%
Original Mortgage
$874,000
Interest Rate
6.95%
Mortgage Type
New Conventional
Purchase Details
Closed on
May 31, 2022
Sold by
Bought by
Purchase Details
Closed on
May 27, 2022
Sold by
Bought by
Purchase Details
Closed on
Mar 9, 2021
Sold by
Bought by
Home Values in the Area
Average Home Value in this Area
Agents Specializing in Rex Manor, CA
-
Judy Smith
-
Pam Sauceda
Pam Sauceda
Pams Homes
(650) 668-0815
233 Total Sales
2 in Rex Manor
$135K - $175K Price Range
-
Li Hong Liang
Li Hong Liang
Bay Home Investments&loans
(510) 544-6957
31 Total Sales
1 in Rex Manor
$170,000 Price
-
Mary Murphy
Mary Murphy
Compass
(650) 870-9175
30 Total Sales
1 in Rex Manor
$565,000 Price
-
Geeta Phadte
Geeta Phadte
Century 21 Real Estate Alliance Inc
(669) 260-5449
29 Total Sales
1 in Rex Manor
$1,780,000 Price
-
Keith Walker
Keith Walker
Responds QuicklyIntero Real Estate Services
(669) 230-1607
148 Total Sales
1 in Rex Manor
$618,000 Price
Purchase History
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
| Date | Buyer | Sale Price | Title Company |
|---|---|---|---|
| $930,000 | First American Title | ||
| $920,000 | Fidelity National Title | ||
| -- | Placer Law Group Apc | ||
| -- | Placer Law Group Apc | ||
| -- | None Available |
Source: Public Records
Mortgage History
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
| Date | Status | Borrower | Loan Amount |
|---|---|---|---|
| Open | $750,000 | ||
| Previous Owner | $874,000 |
Source: Public Records
Property History
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
| Date | Event | Price | List to Sale | Price per Sq Ft | Prior Sale |
|---|---|---|---|---|---|
| 08/25/2025 08/25/25 | Sold | $930,000 | -2.2% | $932 / Sq Ft | |
| 08/10/2025 08/10/25 | Pending | -- | -- | -- | |
| 08/07/2025 08/07/25 | Price Changed | $950,888 | -1.9% | $953 / Sq Ft | |
| 07/16/2025 07/16/25 | For Sale | $968,888 | +5.3% | $971 / Sq Ft | |
| 12/02/2022 12/02/22 | Sold | $920,000 | +2.8% | $922 / Sq Ft | View Prior Sale |
| 11/02/2022 11/02/22 | Pending | -- | -- | -- | |
| 10/25/2022 10/25/22 | For Sale | $895,000 | -- | $897 / Sq Ft |
Source: MLSListings
Tax History
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
| Year | Tax Paid | Tax Assessment Tax Assessment Total Assessment is a certain percentage of the fair market value that is determined by local assessors to be the total taxable value of land and additions on the property. | Land | Improvement |
|---|---|---|---|---|
| 2026 | $11,260 | $930,000 | $465,000 | $465,000 |
| 2025 | $11,362 | $957,168 | $478,584 | $478,584 |
| 2024 | $11,362 | $938,400 | $469,200 | $469,200 |
| 2023 | $11,214 | $920,000 | $460,000 | $460,000 |
| 2022 | $12,808 | $1,028,504 | $514,252 | $514,252 |
| 2021 | $3,292 | $248,791 | $99,512 | $149,279 |
| 2020 | $3,274 | $246,241 | $98,492 | $147,749 |
| 2019 | $3,139 | $241,413 | $96,561 | $144,852 |
| 2018 | $3,122 | $236,680 | $94,668 | $142,012 |
| 2017 | $2,990 | $232,040 | $92,812 | $139,228 |
| 2016 | $2,854 | $227,492 | $90,993 | $136,499 |
| 2015 | $2,785 | $224,076 | $89,627 | $134,449 |
| 2014 | $2,755 | $219,688 | $87,872 | $131,816 |
Source: Public Records
Agents Affiliated with this Home
-
P
Seller's Agent in 2025
Payne Sharpley
Coldwell Banker Realty
-
Joe Velasco
Seller Co-Listing Agent in 2025
Joe Velasco
Coldwell Banker Realty
(650) 833-8498
2 in this area
186 Total Sales
-
Bill Lister
Buyer's Agent in 2025
Bill Lister
Coldwell Banker Realty
(408) 892-9300
1 in this area
193 Total Sales
-
Kathleen Pasin
Seller's Agent in 2022
Kathleen Pasin
Sereno Group
(650) 450-1912
1 in this area
17 Total Sales
-
R
Buyer's Agent in 2022
Ryan Greco
Compass
Map
Source: MLSListings
MLS Number: ML82014901
APN: 153-31-024
Disclaimer: Certain information contained herein is derived from information provided by parties other than Homes.com. All information provided is deemed reliable, but is not guaranteed to be accurate and should be independently verified.
Property Information © 2026 MLSListings Inc. All rights reserved. Listing information is deemed reliable but not guaranteed. Certain information contained herein is derived from information which is the licensed property of, and copyrighted by, MLSListings Inc. The viewer acknowledges ownership and validity of its copyright. Information provided is for personal, non-commercial use by a viewer with a bona fide interest in the purchase or sale of real estate of the type being offered via this website or other electronic means. The viewer is prohibited from copying, redistributing or retransmitting any of the data or information provided by MLSListing, Inc.
Nearby Homes
- 905 W Middlefield Rd Unit 918
- 905 W Middlefield Rd Unit 972
- 874 San Simeon Dr
- 440 Moffett Blvd Unit 86
- 500 W Middlefield Rd Unit 98
- 500 W Middlefield Rd Unit 41
- 750 San Clemente Way
- 982 Wright Ave Unit 3
- 928 Wright Ave Unit 1103
- 425 Poppy Place Unit 1
- 470 Mountain Laurel Ct
- 1235 Verano Rd
- 284 Elmwood St
- 806 Emily Dr
- 1603 Morgan St
- 168 Granada Dr
- 108 Bryant St Unit 36
- 711 Farley St
- 71 Tyrella Ct
- 221 Hope St
- 905 W Middlefield Rd
- 905 W Middlefield Rd Unit 932
- 905 W Middlefield Rd Unit 945
- 905 W Middlefield Rd
- 905 W Middlefield Rd Unit 928
- 905 W Middlefield Rd Unit 927
- 905 W Middlefield Rd Unit 926
- 905 W Middlefield Rd Unit 925
- 905 W Middlefield Rd Unit 924
- 905 W Middlefield Rd Unit 923
- 905 W Middlefield Rd Unit 922
- 905 W Middlefield Rd Unit 995
- 905 W Middlefield Rd Unit 994
- 905 W Middlefield Rd Unit 993
- 905 W Middlefield Rd Unit 992
- 905 W Middlefield Rd Unit 991
- 905 W Middlefield Rd Unit 988
- 905 W Middlefield Rd Unit 987
- 905 W Middlefield Rd Unit 986
- 905 W Middlefield Rd Unit 985
Your Personal Tour Guide
Ask me questions while you tour the home.