main property photo 0
main property photo 1
main property photo 2
main property photo 3
main property photo 4
main property photo 5
main property photo 6
main property photo 7
main property photo 8
main property photo 9
main property photo 10
main property photo 11
main property photo 12
main property photo 13
main property photo 14
main property photo 15
main property photo 16
main property photo 17
main property photo 18
main property photo 19
main property photo 20
main property photo 21
main property photo 22
main property photo 23
main property photo 24
main property photo 25
main property photo 26
main property photo 27
main property photo 28
main property photo 29
main property photo 30
main property photo 31
main property photo 32
main property photo 33
main property photo 34
main property photo 35
main property photo 36
main property photo 37
main property photo 38
main property photo 39
main property photo 40
main property photo 41
main property photo 42
main property photo 43
main property photo 44
main property photo 45
main property photo 46
main property photo 47
main property photo 48
main property photo 49
main property photo 50
main property photo 51
main property photo 52
main property photo 53
main property photo 54
main property photo 55
main property photo 56
main property photo 57
main property photo 58
main property photo 59
main property photo 60
main property photo 61
main property photo 62
main property photo 63
main property photo 64
main property photo 65
main property photo 66
main property photo 67
main property photo 68
main property photo 69
main property photo 70
main property photo 71
main property photo 72
main property photo 73
main property photo 74
main property photo 75
main property photo 76
main property photo 77
main property photo 78
main property photo 79
main property photo 80
main property photo 81
main property photo 82
main property photo 83
main property photo 84
main property photo 85
main property photo 86
main property photo 87
main property photo 88
main property photo 89
main property photo 90
main property photo 91
main property photo 92
main property photo 93
main property photo 94
main property photo 95
main property photo 96
main property photo 97
main property photo 98
main property photo 99
main property photo 100
main property photo 101
main property photo 102
main property photo 103
main property photo 104
main property photo 105
main property photo 106
main property photo 107
main property photo 108
main property photo 109
main property photo 110
main property photo 111
main property photo 112
main property photo 113
main property photo 114
main property photo 115
main property photo 116
main property photo 117
main property photo 118
main property photo 119
main property photo 120
main property photo 121
main property photo 122
main property photo 123
main property photo 124
main property photo 125
main property photo 126
main property photo 127
main property photo 128
main property photo 129
main property photo 130
main property photo 131
View All (132)
property photo 1
property photo 2
property photo 3
1751 Celeste Dr , San Mateo, CA 94402
$1,999,950
Est. Payment: $10,024.61/mo
3 Bed
2 Bath
1419 Sqft
Status: active | Days on site: 0
Get Pre-Qualified
VCR-C15903466 - VCR-C159091383,VCR-C159052275

By providing your number, you are expressly consenting, in writing, to receive telemarketing and other messages, including calls or texts at the number you provided above. This consent is not required to purchase any good or service. Message and data rates may apply. Text STOP to cancel.

This site is protected by reCAPTCHA and the GooglePrivacy Policy and Terms of Service apply.

Agent profile image
View agent profile
Email
Call

House Description

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, new tankless water heater, new HVAC and AC unit, 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!
Show more

Highlights

Listed by Alana Lam , 408-981-6012 Intero Real Estate Services , (408) 342-3000. CRMLS/Multi-Regional MLS mls logo

Property Type

Residential
Lot/Acreage
0.13

Year Built

1956

County

San Mateo

Area

699 - Not Defined

 School District

Other

Listing ID

ML82052229

Questions about this listing?

Contact Agent

Interior Features

Bedrooms and Bathrooms
  • ▪ Bedrooms:3
  • ▪ Bathrooms:2
  • ▪ Full Bathrooms:2
Appliances:Dishwasher, Disposal, Refrigerator, Range Hood, Self Cleaning Oven, Vented Exhaust Fan
Air Cond:Central Air
Fireplaces:Living Room
Floor:Tile,Wood
Other:Public

Exterior Features

Lot:Level,Paved,No Land Lease
Garage Capacity:2
Zoning:R10006
Roof:Foam
Parking Features:Gated

Open House

Upcoming Open Houses
Saturday 1:30 pm - 4:00 pm Jun 27
Sunday 1:30 pm - 4:00 pm Jun 28
Principal Interest
$10,025
Taxes
$1,275

Home Price

$1,999,950

Loan Details

30 yrs
6.416%

Down Payment

20%
$399,990
All calculations are estimates and provided by Blueroof360. Today’s Rates provided by Blueroof360. Information and interactive calculators are made available to you only as self-help tools for your independent use and are not intended to provide investment or tax advice. We cannot and do not guarantee their applicability or accuracy in regards to your individual circumstances. All examples are hypothetical and are for illustrative purposes. We encourage you to seek personalized advice from qualified professionals regarding all personal finance issues.
Monthly Price:
$10,024.61

Principal

Taxes

Principal Taxes HOA Total
Monthly $10,024.61 $1,274.97 $0.00 $11,299.58
Yearly $120,295.34 $15,299.62 $0.00 $135,594.96
Total $3,608,860.28 $458,988.53 $0.00 $4,067,848.81
Lender profile image
So-Crates Johnson
Dust, Wind, Dude
Email
Call
Visit
GET PRE-QUALIFIED

Never Miss a Property

Be the first to know when a property hits the market.

Current Listings

Last 30 Days
N/A
Jun 2026

Average Price

All Price Ranges
N/A
Jun 2026

Average Days on Market

All Price Ranges
N/A
Jun 2026
Market insight data is pulled from the same city as the listing being viewed (San Mateo, CA).

The schools listed are within a 2-mile radius of the property; however, attendance is not guaranteed. Please contact the local school district to confirm zoning and enrollment options.

Based on information from California Regional Multiple Listing Service, Inc. This information is for your personal, non-commercial use and may not be used for any purpose other than to identify prospective properties you may be interested in purchasing. Display of MLS data is usually deemed reliable but is NOT guaranteed accurate by the MLS. Buyers are responsible for verifying the accuracy of all information and should investigate the data themselves or retain appropriate professionals. Information from sources other than the Listing Agent may have been included in the MLS data. Unless otherwise specified in writing, Broker/Agent has not and will not verify any information obtained from other sources. The Broker/Agent providing the information contained herein may or may not have been the Listing and/or Selling Agent. All properties are subject to prior sale, change or withdrawal.

IDX service by Blueroof 360

Data last updated: 2026-06-26T01:40:03.000Z

© 2026 CRMLS/Multi-Regional MLS

MLS Logo - CRMLS/Multi-Regional MLS