2 Irving AVE, Atherton, CA 94027
REQUEST A TOUR If you would like to see this home without being there in person, select the "Virtual Tour" option and your agent will contact you to discuss available opportunities.
In-PersonVirtual Tour
Sharad Gupta

Sharad Gupta

+1(408) 401-1003
Listed by Stanley Lo • Green Banker Realty, DRE#00874415
$6,790,000
Est. payment /mo
5 Beds
3 Baths
3,880 SqFt
Save

UPDATED:

Key Details

Property Type Single Family Home

Sub Type Single Family Home

Listing Status Pending

Purchase Type For Sale

Square Footage 3,880 sqft

Price per Sqft $1,750

MLS Listing ID ML82061617

Bedrooms 5

Full Baths 3

Year Built 1948

Lot Size 0.925 Acres

Property Sub-Type Single Family Home

Property Description

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.

Location

State CA

County San Mateo

Area Lindenwood Area

Zoning R1001A

Rooms

Family Room Separate Family Room

Other Rooms Den / Study / Office, Laundry Room

Dining Room Eat in Kitchen, Formal Dining Room

Kitchen Cooktop - Electric, Countertop - Tile, Dishwasher, Freezer, Garbage Disposal, Hood Over Range, Oven - Built-In, Oven - Double, Pantry, Refrigerator

Interior

Heating Central Forced Air

Cooling None

Flooring Carpet

Fireplaces Type Family Room, Living Room

Laundry Inside

Exterior

Exterior Feature Back Yard, Balcony / Patio, Fenced, Outdoor Fireplace, Outdoor Kitchen, Storage Shed / Structure

Parking Features Attached Garage, Carport , Electric Gate, Gate / Door Opener, Guest / Visitor Parking

Garage Spaces 2.0

Fence Complete Perimeter, Gate, Mixed Height / Type

Pool Pool - In Ground

Utilities Available Public Utilities

Roof Type Bitumen

Building

Lot Description Grade - Level

Story 1

Foundation Concrete Perimeter and Slab, Raised

Sewer Sewer - Public

Water Public

Level or Stories 1

Others

Tax ID 061-140-030

Miscellaneous Skylight

Horse Property No

Special Listing Condition Not Applicable

Read Less Info
MLSListings Inc. (MLSListings)
Copyright 2026 MLSListings Inc All rights reserved.
Nearby Locations

GET MORE INFORMATION

Sharad Gupta
Sharad Gupta

Broker License ID: 02213637

+1(408) 401-1003

5201 Great America Pkwy, Santa Clara, CA 95054, USA

Name
Phone*
Message

By checking this box, I agree by electronic signature to the Electronic Disclosure Consent Agreement; to receive recurring marketing communication from or on behalf of Sharad Gupta, including auto-dialed calls, texts, and artificial/prerecorded voice messages (message frequency varies; data rates may apply; reply "STOP" to opt-out of texts or "HELP" for assistance); and to the Terms of Service and Privacy Policy of this website. Consent not required to make a purchase. I understand that I can call to obtain direct assistance.

Go tour this home

2 Irving AVE

QUICK SEARCH
There are 23 quick searches