- 5
- beds
- 3
- baths
- 3,880
- sqft
- 1948
- year built
- Status:
- Pending
- MLS #:
- ML82061617
- County:
- San Mateo
- Listed By:
- Stanley Lo - Green Banker Realty
- Agent Phone:
- (650) 373-0007
Sponsoring Broker: Mia Park, Intero
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.
-
- Bedrooms
- 5
-
- Bathrooms
- 3
-
- Year Built
- 1948
-
- Stories
- 1.0
-
- Foundation
- Raised
-
- Garage Spaces
- 2.0
-
- Parking Features
- Attached, Garage, Guest
-
- Living Area
- 3880.0
-
- Interior Features
- Pantry
-
- Appliances
- Dishwasher, Electric Range, Oven, Double Oven
-
- Pool Features
- Private
-
- Cooling
- None
-
- Heating
- Forced Air
-
- Lot Features
- Level
-
- Water
- Public
-
- County
- San Mateo
-
- City
- Atherton
-
- Zip Code
- 94027
-
Nearby Schools
-
78out of 100
-
53out of 100
-
48out of 100
-
51out of 100
-
52out of 100
-
36out of 100
-
56out of 100
-
51out of 100
-
56out of 100
-
53out of 100
Disclaimer: ez Home Search School Ratings are on a scale of 1-100 and represent our evaluation of school quality based on academic performance, school resources, community feedback, and demographic factors. School attendance boundaries are for reference only. Contact the school directly to verify enrollment eligibility.
-
Ask a Question
ez Mortgage Calculator
Enter your details below to estimate your monthly mortgage payment with taxes, fees and insurance.
Please enter a valid number
Cost of the current home: $6790000
Please enter a valid number
Cash you pay when you close
Affects interest rates. 30- or 15- year loans are standard.
Default rate is illustrative, set internally by ez Home Search and updated periodically; actual rates vary by lender, credit score, and market conditions.
Please enter a valid number
Please enter a valid number
Typically 0.25% of home value per year.
Please enter a valid number
Homeowners association dues.
$ 0
Monthly
Principal and interest:
Property Taxes:
Homeowners Insurance:
HOA Dues:
$0 (0%)
$0 (0%)
$0 (0%)
$0 (0%)
The ez Mortgage Calculator is for educational purposes only. Real-world interest rates and payments can differ due to factors like market trends, location, and loan specifics. Calculations are based on your inputs and might not consider extra costs a lender may add, such as insurance, taxes, and fees; thus, actual repayments could surpass estimates. Please note, ez Home Search does not provide loans, and this tool does not promise lending.
Price History
| 09/17/2026 | Listed | $6,790,000 |
| Source: bridgeMLS #ML82061617 | ||
Source: MLS Data
Deed History
| 04/09/2012 | Intrafamily Transfer - Transaction is between related parties for any reason & no consideration. | $0 |
| 04/09/2012 | Intrafamily Transfer - Transaction is between related parties for any reason & no consideration. | $0 |
| 07/22/2011 | Quit Claim Deed (non-arm's length) | $0 |
Source: Public records via Constellation Data Labs
Mortgage History
| 07/13/2015 | Open End with Future Advance Clause / Open End Mortgage | $280,000 |
| 12/06/2006 | Credit Line (Revolving) / HELOC | $250,000 |
| 04/04/2005 | Credit Line (Revolving) / HELOC | $200,000 |
| 08/21/2001 | Credit Line (Revolving) / HELOC | $200,000 |
Source: Public records via Constellation Data Labs
What's your home worth?
Calculate your current home value within seconds.
Frequently Asked Questions
How do I schedule a tour of 2 Irving Ave?
We can make that happen quickly. Click Tour This Home and we'll connect you directly with our vetted local partner to schedule your visit to 2 Irving Ave.
They know residentials in the area well and can give you the guidance you need to buy with confidence.
How do I get more information about 2 Irving Ave?
Click Ask a Question to talk with our team. You already know it is a 5 bed, 3 bath, listed for $6,790,000. We can talk through recent upgrades, potential seller motivation, how this single family residence compares to others in Atherton, and can even get you in to see the property quickly.
How much is the monthly mortgage payment for 2 Irving Ave?
With a 20% down payment and a 30-year fixed loan at an illustrative 7.25% rate, the ez Mortgage Calculator estimates the monthly payment for 2 Irving Ave at around $38,640. This includes estimated property taxes and insurance.
Want to see how this changes with different down payments or interest rates? Jump to the calculator to run the numbers and fine-tune your plan.
How do I get pre-approved to buy 2 Irving Ave?
Stand out in a competitive market by getting pre-approved today. Our quick and private pre-approval process helps you understand your true buying power—no credit pull required to explore all of your options.
Or, let us connect you with our preferred local lender in San Mateo County. They will give you all of your available financing options, based on your specific situation and what is available to you.
Can I negotiate the asking price for 2 Irving Ave?
In most cases, yes. Whether 2 Irving Ave is priced competitively or not, your best offer depends on your personal situation, the seller's timeline, and recent activity in Atherton's market. Our preferred local partner will help you craft a strategy—factoring in comparable properties that have sold, timing, and deal structure—to make a smart, strong offer. Click here to ask about negotiation opportunities.
How do I make an offer on 2 Irving Ave?
We can handle that for you. Our preferred local agent specializes in residentials in Atherton and can guide you through every step of the offer process.
You need an expert who is looking out for your best interests. From market valuation to contingencies and timing, they'll help you present a compelling offer that fits your goals. Click Ask a Question to get started today.
What is the price per square foot for this home?
This home is listed at $6,790,000 with 3,880 sqft of space—that comes out to approximately $1,750 per square foot.
How long has this property been on the market?
2 Irving Ave was listed on September 17, 2026, which means it's been on the market for 54 days.
Want to keep tabs on it? Click the ♥ to favorite this home and get notified of price drops or changes.
When was this house built?
This home was built in 1948, making it approximately 78 years old.
Is 2 Irving Ave still available for sale?
This home is pending sale, which means the seller has accepted an offer. You can favorite it to track status or ask our expert to help you find similar homes in this area. We'll also let you know if this property comes back on the market.
Source: ez Home Search, MLS Data
Popular Home Searches in Atherton, CA
Open Houses Near Atherton, CA
Land for Sale Near Atherton, CA
Townhomes for Sale Near Atherton, CA
Waterfront Homes for Sale Near Atherton, CA
Waterfront Condos for Sale Near Atherton, CA
Homes with Pools for Sale Near Atherton, CA
Gated Community Homes for Sale Near Atherton, CA
Homes with No Hoa for Sale Near Atherton, CA
Homes in Adult Communities for Sale Near Atherton, CA
Search Nearby Cities
Search Nearby Counties
Search Nearby Postal Codes
Bay East ©2026. CCAR ©2026. bridgeMLS ©2026. Information Deemed Reliable But Not Guaranteed. This information is being provided by the Bay East MLS, or CCAR MLS, or bridgeMLS. The listings presented here may or may not be listed by the Broker/Agent operating this website. This information is intended for the personal use of consumers and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Data last updated at November 10, 2026 at 06:07AM.
IDX information is provided exclusively for consumers’ personal, non-commercial use and that it may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Information deemed reliable but not guaranteed to be accurate. Listing information updated daily.