Home | San Mateo County | San Mateo | 94402 | 1751 Celeste Dr
MLS: ML82045289 | Status: Active | Price: $2,199,950
Beds/Baths: 3 / 2
Property Type: Residential
| Beds | Baths | Sq Ft | Sq Ft Lot | Yr Built |
|---|---|---|---|---|
| 3 | 2 | 1,528 | 5,452 | 1956 |
| Date | Time | Hosted By |
|---|---|---|
| Saturday, May 2 | 1:30 pm - 4:00 pm | Alana Lam |
| Sunday, May 3 | 1:30 pm - 4:00 pm | Alana Lam |
This is it, YOUR NEW HOME! Welcome to this beautifully updated Eichler home in the highly desirable Sunnybrae neighborhood of San Mateo. Boasting numerous high-end upgrades and immaculate attention to detail throughout, this stunning property features a bright and open floor plan, brand new exterior and interior designer paint, gorgeous engineered wood flooring, stylishly renovated bathrooms, and a truly exquisite kitchen with custom quartz countertops, custom cabinets with auto-sensor LED lighting, and top-of-the-line appliances. Technical upgrades include all new electricals, new copper plumbing, tankless water heater, Milgard windows and sliding doors, Hansgrohe fixtures, designer ceiling lights, luxurious Porcelanosa brand floor and bathroom tiles, brand new pavers and low-maintenance artificial grass in backyard, new redwood fence in front, and so much more. Whatever your lifestyle, Sunnybrae's ideal location and distinctive community lets you create a life uniquely you, and this beautiful modern home will have you and your family living the good life for years to come. WELCOME TO YOUR NEW HOME!
| Field | Value |
|---|---|
| MLS # | ML82045289 |
| MLS Source | MLSListings, Inc. |
| Days on Site | 1 |
| Feature | Details |
|---|---|
| Bedrooms | Primary Suite/Retreat |
| Bathrooms | Primary - Stall Shower(s), Shower and Tub, Stall Shower, Tile, Tub in Primary Bedroom, Updated Bath(s) |
| Kitchen | Exhaust Fan, Hookups - Gas, Island, Pantry |
| Appliances | Dishwasher, Exhaust Fan, Garbage Disposal, Hood Over Range, Oven - Self Cleaning, Oven Range - Gas, Refrigerator |
| Dining Room | Dining Area |
| Family Room | No Family Room |
| Fireplace | Living Room |
| Flooring | Tile, Wood |
| Laundry | Hookup - Gas Dryer, In Garage |
| Cooling | Central Forced Air |
| Heating | Central Forced Air - Gas, Fireplace |
| Feature | Details |
|---|---|
| Roof | Foam |
| Foundation | Slab |
| Style | Eichler |
| Feature | Details |
|---|---|
| Garage/Parking | Attached Garage, Gate/Door Opener, Garage: 2 Car(s) |
| Elementary District | San Mateo-Foster City Elementary |
| High School District | San Mateo Union High |
| Water | Public |
| Zoning | R10006 |
Alana Lam
Intero Real Estate Services
License #: 01049403
Phone: (408) 981-6012
School data provided by GreatSchools.org
| Address | Price | Beds | Baths | Sq Ft | Status |
|---|---|---|---|---|---|
| 343 27th Ave | $2,098,888 | 4 | 2 | 1,740 | Active |
| 105 Louise Ln | $2,358,000 | 4 | 3 | 1,886 | Active |
| 1736 Hamlet St | $1,949,000 | 4 | 3 | 1,700 | Active |
| 453 26th Ave | $2,095,000 | 3 | 2 | 1,907 | Active |
©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 May 01, 2026. For the most current information, please contact Alana Lam, (408) 981-6012.