Property Details
Upcoming Open Houses
About this Property
Discover the epitome of Westwood living in this exquisitely updated and expanded residence, where modern luxury meets timeless elegance. Imagine seamless transitions from sophisticated formal spaces, featuring glowing hardwood floors and soaring ceilings, to relaxed indoor/outdoor living. The heart of the home is a stunning chef's kitchen and spacious family room that effortlessly extend to an entertainer's dream patio and a tranquil, verdant backyard your private oasis. Retreat to the upper-level primary suite with a generous walk-in closet, or welcome guests in the convenient main-level suite. Offering exceptional flexibility, the 5-bedroom, 4.5-bath layout includes a lower-level suite with a separate entrance, presenting exciting ADU potential. Connoisseurs will appreciate the stylish wine cellar. Enjoy the unparalleled convenience of being just a half-block from Indian Springs Park and a short stroll to Hillsdale Shopping Center, downtown amenities, and major commute routes. This is more than a home; it's a lifestyle.
MLS Listing Information
MLS #
ML82006112
MLS Source
MLSListings, Inc.
Days on Site
3
Interior Features
Bedrooms
Ground Floor Bedroom, Primary Suite/Retreat, Walk-in Closet, More than One Primary Bedroom
Bathrooms
Double Sinks, Marble, Primary - Stall Shower(s), Shower over Tub - 1, Stall Shower, Stone, Tile, Full on Ground Floor, Primary - Oversized Tub, Half on Ground Floor
Kitchen
Countertop - Granite, Exhaust Fan, Pantry
Appliances
Dishwasher, Exhaust Fan, Garbage Disposal, Hood Over Range, Ice Maker, Microwave, Oven Range - Gas, Refrigerator, Wine Refrigerator, Washer/Dryer
Dining Room
Breakfast Nook, Breakfast Room, Dining "L", Eat in Kitchen, Formal Dining Room
Family Room
Kitchen/Family Room Combo, Separate Family Room
Fireplace
Living Room
Flooring
Carpet, Hardwood, Tile
Laundry
Tub / Sink, Inside
Cooling
Ceiling Fan
Heating
Central Forced Air
Exterior Features
Roof
Composition
Foundation
Concrete Perimeter
Style
Cape Cod, Traditional
Parking, School, and Other Information
Garage/Parking
Detached, Gate/Door Opener, Garage: 2 Car(s)
Elementary District
San Mateo-Foster City Elementary
High School District
San Mateo Union High
Sewer
Public Sewer
Water
Public
Zoning
R10006
Neighborhood: Around This Home
Neighborhood: Local Demographics
Market Trends Charts
Nearby Homes for Sale
3740 Hacienda St is a Single Family Residence in San Mateo, CA 94403. This 3,158 square foot property sits on a 7,662 Sq Ft Lot and features 5 bedrooms & 4 full and 1 partial bathrooms. It is currently priced at $3,098,000 and was built in 1948. This address can also be written as 3740 Hacienda St, San Mateo, CA 94403.
©2025 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 May 11, 2025. For the most current information, please contact JJ Team:Jones/Cassel, (650) 430-7000
