---
listing_id: ML82061617
status: Active
price: 6790000
beds: 1
baths_full: 3
baths_half: 0
sqft_living: 3880
sqft_lot: 40314
lot_acres: 
year_built: 1948
property_type: Residential
property_subtype: Single Family Residence
address: "2 Irving Ave"
city: Atherton
state: CA
zip: 94027
county: "San Mateo County"
lat: 37.468198
lng: -122.190237
days_on_market: 0
hoa_fee: 
hoa_frequency: 
garage_spaces: 2
list_agent: "Stanley Lo"
list_office: "Green Banker Realty"
list_agent_phone: "(650) 373-0007"
list_agent_license: 00874415
mls_source: MLSL
modified: 2026-09-17
transaction_type: buy
---

Home | San Mateo County | Atherton | 94027 | 2 Irving Ave

2 Irving Ave, Atherton, CA 94027

MLS: ML82061617 | Status: Active | Price: $6,790,000
Beds/Baths: 1 / 3
Property Type: Residential

Quick Facts

Bed Baths Sq Ft Sq Ft Lot Yr Built
1 3 3,880 40,314 1948

Upcoming Open Houses

Date Time Hosted By
Saturday, September 19 2:00 pm - 4:00 pm Stanley Lo

Remarks

Tucked away at the end of a quiet cul-de-sac in Atherton's prestigious Lindenwood neighborhood, this gated 5-bedroom estate offers privacy and indoor-outdoor living amid expansive grounds and mature trees. A large motor court, 2 covered parking spaces and an attached 2-car garage provide ample parking. The living room features oversized picture windows and a fireplace, while the den has a second fireplace. Sliding glass doors open the den to the backyard. Living and formal dining rooms open to a covered patio for gatherings. The eat-in kitchen is complemented by a butler's pantry, wine cellar and laundry room. This wing also includes two bedrooms, a full bathroom and access to the attached garage. The primary suite offers generous closets, a dressing area, soaking tub, walk-in shower and private patio. Outside, enjoy a sparkling pool, spacious pool deck, sprawling lawn, gardens and patios for lounging and gathering. An outdoor kitchen with a sink and wood-fired oven invites alfresco meals, while poolside bathrooms and changing areas add convenience. Near Holbrook-Palmer Park, Encinal Elementary and Menlo-Atherton High School, with access to downtown Menlo Park, Stanford Shopping Center, Highway 101 and Woodside Road. An opportunity to make this private Lindenwood estate your own.

MLS Listing Information

Field Value
MLS # ML82061617
MLS Source MLSListings, Inc.
Days on Site 0

Features

Interior Features

Feature Details
Bedrooms Primary Bedroom on Ground Floor, More than One Bedroom on Ground Floor
Bathrooms Double Sinks, Primary - Stall Shower(s), Primary - Sunken Tub, Outside Access, Showers over Tubs - 2+, Full on Ground Floor
Kitchen Countertop - Tile, Pantry
Appliances Cooktop - Electric, Dishwasher, Freezer, Garbage Disposal, Hood Over Range, Oven - Built-In, Oven - Double, Refrigerator
Dining Room Eat in Kitchen, Formal Dining Room
Family Room Separate Family Room
Fireplace Family Room, Living Room
Flooring Carpet
Laundry Inside
Cooling None
Heating Central Forced Air

Exterior Features

Feature Details
Roof Bitumen
Foundation Raised, Concrete Perimeter and Slab
Pool In Ground

Parking, School, and Other Information

Feature Details
Garage/Parking Attached Garage, Carport, Electric Gate, Gate/Door Opener, Guest / Visitor Parking, Garage: 2 Car(s)
Elementary District Menlo Park City Elementary
High School District Sequoia Union High
Sewer Public Sewer
Water Public
Zoning R1001A

Contact Information

Stanley Lo
Green Banker Realty
License #: 00874415
Phone: (650) 373-0007

School Ratings

School data provided by GreatSchools.org

Nearby Schools

School Type Grades Distance Rating
Encinal Elementary School public K-5 0.34 mi 9
Garfield Elementary School public K-5 0.69 mi 6
Sequoia District Adult Education public UG 0.74 mi N/A
Taft Elementary School public K-5 0.91 mi 4
Menlo-Atherton High School public 9-12 0.97 mi 8
Laurel Elementary School public K-5 1.03 mi 10
Tide Academy public 9-12 1.32 mi 9
Hoover Elementary School public K-8 1.65 mi 5
Belle Haven Elementary School public K-5 1.70 mi 1
Adelante Selby Spanish Immersion School public K-5 1.79 mi 6
Hillview Middle School public 6-8 1.96 mi 9
Packard Children's Hospital/Stanford public K-12 2.32 mi N/A
Las Lomitas Elementary School public K-3 2.41 mi 10
Ravenswood Comprehensive Middle public 6-8 2.50 mi 4
Henry Ford Elementary School public K-5 2.52 mi 4
Oak Knoll Elementary School public K-5 2.62 mi 10
McKinley Institute Of Technology public 6-8 2.66 mi 6
North Star Academy public 3-8 2.66 mi 10
Addison Elementary School public K-5 2.66 mi 9
John F. Kennedy Middle School public 6-8 2.69 mi 7

Nearby Homes

Address Price Beds Baths Sq Ft Status
1049 Woodland Ave $5,990,000 7 7/1 4,823 PendingDoNotShow
1145 Saxon Way $5,998,000 5 4/1 2,984 Active
15 San Juan Ave $7,388,000 5 5 4,726 Active
28 Holbrook Ln $5,888,000 5 4/1 3,765 Active

Disclosures

©2026 MLSListings Inc. All rights reserved. All data, including all measurements and calculations of area, is obtained from various sources and has not been, and will not be, verified by broker or MLS. All information should be independently reviewed and verified for accuracy. Properties may or may not be listed by the office/agent presenting the information. Information provided is for personal, non-commercial use by the viewer and may not be redistributed without explicit authorization from MLSListings Inc.

Presently MLSListings.com displays Active, Contingent, Pending, and Recently Sold listings. Recently Sold listings are properties which were sold within the last three years. After that period listings are no longer displayed in MLSListings.com. Pending listings are properties under contract and no longer available for sale. Contingent listings are properties where there is an accepted offer, and seller may be seeking back-up offers. Active listings are available for sale.

This listing information is up-to-date as of September 17, 2026. For the most current information, please contact Stanley Lo, (650) 373-0007.