Set on a nearly half-acre, mostly level lot with sweeping bay views, this exceptional Emerald Hills estate offers privacy, scale, and refined living on a quiet cul-de-sac just moments from Roy Cloud School. A spectacular entry with vaulted ceilings introduces light-filled interiors enhanced by fresh paint and expansive windows that capture the views throughout. The living room features a striking fireplace and opens to a balcony overlooking the backyard and bay. A formal dining room connects to a spacious great room anchored by a beautifully appointed chefs kitchen with an oversized island, abundant cabinetry, Thermador Professional gas range with grill, two dishwashers & breakfast nook and opens to a second balcony with tranquil views. The ground-floor primary suite offers a fireplace & spa-like bath with soaking tub, shower, dual vanity & walk-in closet. 5 bedrooms plus an optional 6th bed provide flexibility for guests or office use. The expansive yard features a large flat lawn & patio with space for a pool or ADU (buyer to verify). Additional highlights include a 3-car garage, air conditioning, EV charger & dual laundry areas. With its generous grounds & captivating views this remarkable property presents an exceptional opportunity to enjoy peaceful Emerald Hills living.
| LIST_PRICE |
4588000 |
| DCID |
4ECDF2ACD12096EBE0631501030AFA28 |
| BEDROOMS_TOTAL |
5 |
| MLS_STATUS |
SLD |
| LONGITUDE |
-122.26144 |
| STREET_NUMBER |
40 |
| COUNTY_OR_PARISH |
San Mateo |
| LISTING_ID |
ML82041718 |
| SQFT |
4055 |
| DISPLAY_PRICE |
4720000 |
| REPORT_DISPLAY_PRICE |
4720000 |
| SOURCE_MLS |
MLSLISTINGS |
| STATE_OR_PROVINCE |
CA |
| PARCEL_NUMBER |
057-174-160 |
| CITY_STATE_ZIP |
Redwood City, CA 94062 |
| DAYS_ON_MARKET |
15 |
| POSTAL_CODE |
94062 |
| STREET_DIR_PREFIX |
— |
| YEAR_BUILT |
1997 |
| STREET_NAME |
Kataoka |
| SRCHPRICE |
4720000 |
| PROPERTY_TYPE |
RE |
| HOA_DISPLAY |
— |
| PHOTO_VIRTUAL_TOUR |
— |
| LOT_SQFT |
18122 |
| GAR_DISPLAY |
/ |
| BATHS_DISPLAY |
— |
| ACRES |
— |
| ALLLIST.DCID |
4ECDF2ACD12196EBE0631501030AFA28 |
| CLOSE_DATE |
1778569200000 |
| RAW_STATUS |
SLD |
| CITY |
REDWOODCIY |
| STREET_ADDRESS |
40 Kataoka |
| LATITUDE |
37.465119 |
| BUILDING_TYPE |
Detached |
| ALLLIST |
{'DCID': '4ECDF2ACD12196EBE0631501030AFA28'} |
Details fetched: September 27 2026 02:06AM
First seen: 2026-09-27 01:10 UTC
|
Last updated: 2026-10-26 02:23 UTC