Additional details

Listed by Axis Team, DRE #70010248 • Aspire Homes
$9,980,000
Est. payment /mo
7 Beds
7.5 Baths
6,274 SqFt
UPDATED:
Key Details
Property Type Single Family Home
Sub Type Single Family Home
Listing Status Active
Purchase Type For Sale
Square Footage 6,274 sqft
Price per Sqft $1,590
MLS Listing ID ML82046115
Bedrooms 7
Full Baths 7
Half Baths 1
Year Built 2026
Lot Size 0.456 Acres
Property Sub-Type Single Family Home
Source MLSListings, Inc.
Property Description
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 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.
Location
State CA
County San Mateo
Area Lindenwood Area
Zoning R1-A
Rooms
Family Room Separate Family Room
Dining Room Dining Area
Interior
Heating Central Forced Air
Cooling Central AC
Fireplaces Type Family Room, Living Room
Exterior
Parking Features Attached Garage
Garage Spaces 2.0
Utilities Available Public Utilities
Roof Type Other
Building
Foundation Other
Sewer Sewer - Public
Water Public
Others
Tax ID 061-121-050
Special Listing Condition Not Applicable
Read Less Info

Copyright 2026 MLSListings Inc All rights reserved.
Nearby School & Business
Get More Information

Quick Search
- Homes For Sale in Atherton, CA
- Homes For Sale in Belmont, CA
- Homes For Sale in Brisbane, CA
- Homes For Sale in Burlingame, CA
- Homes For Sale in Campbell, CA
- Homes For Sale in Cupertino, CA
- Homes For Sale in Daly City, CA
- Homes For Sale in East Palo Alto, CA
- Homes For Sale in Foster City, CA
- Homes For Sale in Fremont, CA
- Homes For Sale in Hayward, CA
- Homes For Sale in Hillsborough, CA
- Homes For Sale in Los Altos, CA
- Homes For Sale in Los Altos Hills
- Homes For Sale in Los Gatos, CA
- Homes For Sale in Menlo Park, CA
- Homes For Sale in Millbrae, CA
- Homes For Sale in Milpitas, CA
- Homes For Sale in Monte Sereno, CA
- Homes For Sale in Mountain View, CA
- Homes For Sale in Newark, CA
- Homes For Sale in Pacifica, CA
- Homes For Sale in Palo Alto, CA
- Homes For Sale in Portola Valley, CA
- Homes For Sale in Redwood City, CA
- Homes For Sale in Redwood Shores, CA
- Homes For Sale in San Bruno, CA
- Homes For Sale in San Carlos, CA
- Homes For Sale in San Jose, CA
- Homes For Sale in San Mateo, CA
- Homes For Sale in Santa Clara, CA
- Homes For Sale in Saratoga, CA
- Homes For Sale in South San Francisco, CA
- Homes For Sale in Sunnyvale, CA
- Homes For Sale in Union City, CA
- Homes For Sale in Woodside, CA



