2 Rosewood DR
Atherton, CA 94027
- 6 beds
- 8 baths
- 9,003 sqft
- ~1 acre lot
- $1,875 per sqft
- 2023 build
- – on site
More homes
Just completed new construction, this Hamptons-inspired estate with transitional and contemporary design offers airy and light-drenched spaces on three levels. The property has a total of six bedroom suites in the main residence plus two bedrooms and one bath in the Guest House/ADU. It is rich with amenities including an elevator, six heating/ac zones, heated floors in the primary bath, a vast lower level with a tiered theater, sauna, steam shower, bedroom or fitness suite, and full kitchen with bar, a detached guest house/ADU and pool with spa and outdoor kitchen. The property is located in close proximity to exceptional Atherton and Menlo Park private & public schools and Stanford University and has easy access to the 101 tech corridor and San Francisco and San Jose International Airports. Built by Yaeger Construction.
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 Apr 6, 2025
•
MLS# 81883833 —
The Building
-
Year Built:2023
-
Construction Status:Completed
-
Construction Type:Wood Frame
-
Style:Other
-
Type:Detached
-
Subclass:Single Family Home
-
Roofing:Wood Shakes / Shingles
-
Foundation:Reinforced Concrete, Wood Frame, Other
-
# of Stories:3
-
Special Features:Elevator / Lift, Wide Halls / Doors (3 Ft +)
-
Structure SqFt:9003
-
Structure SqFt Source:Other
Interior
-
Kitchen:Countertop - Stone, Dishwasher, Freezer, Garbage Disposal, Hood Over Range, Ice Maker, Island, Island with Sink, Microwave, Oven - Gas, Oven Range - Gas, Pantry, Refrigerator
-
Dining Room:Formal Dining Room
-
Family Room:Kitchen / Family Room Combo
-
Description Secondary Living Space:Guest House
-
Additional Rooms:Basement - Finished, Den / Study / Office, Formal Entry, Great Room, Laundry Room, Media / Home Theater, Mud Room, Recreation Room, Storage, Utility Room, Wine Cellar / Storage
-
Fireplace:Yes
-
Fireplaces:Family Room, Gas Burning, Gas Log, Living Room, Primary Bedroom
-
Flooring:Hardwood, Marble, Stone, Wood
Room Dimensions
-
Living SqFt:9003
-
Secondary Living Space Sq Ft:941 Sqft
Location
-
Cross Street:Greenoaks
-
City Limits:Yes
The Property
-
Lot Description:Grade - Level
-
Lot Acres:0.9040
-
Lot Size Area Min:39378.24
-
Zoning:R1
-
Parcel Number:061-103-090
-
Available Views:Neighborhood
-
Horse Property:No
-
Yard/Grounds:Back Yard, Balcony / Patio, Courtyard, Drought Tolerant Plants, Fenced, Outdoor Kitchen, Sprinklers - Auto, Sprinklers - Lawn
-
Fencing:Fenced Back
Listing Agent
- Contact info:
- No listing contact info available
Taxes
-
Property ID:81883833
Beds
-
Total:6
-
Bedrooms:Ground Floor Bedroom, Primary Suite / Retreat, Walk-in Closet
-
Beds Max:6
-
Beds Min:6
Baths
-
Full Baths:7
-
Half Baths:2
-
Bathroom Features:Double Sinks, Dual Flush Toilet, Full on Ground Floor, Half on Ground Floor, Marble, Primary - Oversized Tub, Showers over Tubs - 2+, Stall Shower - 2+, Tub in Primary Bedroom, Tubs - 2+
The Listing
-
Additional Listing Info:Not Applicable
-
Automated Valuations Allowed:1
Heating & Cooling
-
Cooling Methods:Multi-Zone
-
Heating Methods:Heating - 2+ Zones
Utilities
-
Utilities:Public Utilities
-
Sewer/Septic System:Sewer Connected
-
Water Source:Public
-
Energy Features:Ceiling Insulation, Tankless Water Heater, Thermostat Controller, Walls Insulated
-
Communications:Audio / Video Prewired, Networked
Appliances
-
Laundry:Dryer, In Utility Room, Inside, Tub / Sink, Upper Floor, Washer
The Community
-
Security Features:Fire System - Sprinkler, Security Alarm
-
HOA:No
-
Amenities Misc.:High Ceiling, Skylight, Vaulted Ceiling, Walk-in Closet
-
Pool:Pool - Cover, Pool - Heated, Pool - In Ground, Pool - Sweep, Pool / Spa Combo, Spa - Cover, Steam Room or Sauna
Parking
-
Description and Access:Detached Garage, Off-Street Parking
-
Parking Spaces:5
-
Garage:2
-
Garage:2
-
Garage Spaces:2
-
Carport:1
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 |
---|---|---|---|---|
11/27/23
Nov 27, 2023
|
BRIDGE | $17,750,000 | ||
8/14/23
Aug 14, 2023
|
Listed / Active | MLSLISTINGS | $17,750,000 | 367.1% (35.8% / YR) |
5/15/13
May 15, 2013
|
CRMLS_CA | $3,800,000 |