Welcome to this custom-designed Trousdale masterpiece, ideally situated in Athertons prestigious Lindenwood enclave, known for privacy, tranquility, and timeless estate living. Offered as a presale opportunity with estimated completion in Q4 2026, this residence is a rare chance to secure a future legacy home at todays pricing in one of… Read More Silicon Valleys most coveted locations. Expansive glass openings, soaring ceilings, and abundant natural light create seamless indoor-outdoor flow. Wide-plank oak flooring adds warmth and texture, while clean lines enhance understated elegance. A sculptural floating staircase with sleek glass railing sets the tone. The chef-caliber kitchen features natural marble surfaces for elevated living and entertaining. Well-separated bedroom suites provide privacy, highlighted by a luxurious primary suite with private balcony, spa-like bath, and generous walk-in wardrobe. The lower level offers a gym, theater, virtual golf space, and guest accommodations. The attached 789 sq ft ADU, included in the total 6,274 sq ft, adds flexibility for family, office, or guests. Disclaimer: Buy early for preferred pricing and design personalization. Imagery is illustrative and subject to change. Pool permit is in progress. Read Less
Courtesy of Aspire Homes, Axis Team 415-734-8513
Listing Snapshot
Days Online
53
Last Updated
Property Type
Single Family Residence
Beds
7
Full Baths
7
Partial Baths
1
Square Ft.
6,274
Lot Size
0.46 Acres
Year Built
2026
MLS Number
ML82046115
30 Days Snapshot Of 94027
$12.14M
-20%
(avg) sold price
8
+14%
homes sold
28
-24%
(avg) days on market
Snapshot
Area Map
Additional Details
Lot
Max Area: 19862.00, Max Area Units: Square Feet
Building
Built in 2026, 6,274 square feet, 6,274 living square feet, Building type: Detached
Dining Room
Dining Area
Family Room
Separate Family Room
Fireplaces
Family Room, Living Room
Foundation
Other
Roof
Other
Cooling
Central AC
Garage
2 garage spaces, Attached Garage
Water Features
Public
Heating
Central Forced Air
Utilities
Public Utilities
Sewer
Sewer - Public
Pool
Pool
Property
Zoning: R1-A, Horse property?: No
Find The Perfect Home
'VIP' Listing Search
Whenever a listing hits the market that matches your criteria you will be immediately notified.
The data relating to real estate for sale on this website comes in part from the Internet Data Exchange program of the MLSListingsTM MLS system. Real estate listings held by brokerage firms other than the office represented by this website are marked with the Internet Data Exchange icon (a stylized house inside a circle) and detailed information about them includes the names of the listing brokers and listing agents. The broker providing this data believes the data to be correct, but advises interested parties to confirm all information before relying on it for a purchase decision. The information being provided is for consumers' personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Listings last updated on .
Confirm your time
Fill in your details and we will contact you to confirm a time.
This website uses cookies so that we can provide you with the best user experience possible. Cookie information is stored in your browser and performs functions such as recognising you when you return to our website and helping our team to understand which sections of the website you find most interesting and useful.
Strictly Necessary Cookies
Strictly Necessary Cookie should be enabled at all times so that we can save your preferences for cookie settings.
If you disable this cookie, we will not be able to save your preferences. This means that every time you visit this website you will need to enable or disable cookies again.