Sheldon Rilliet
Compass
(650) 825-9245
42 Total Sales
5 in Baywood-Aragon
$3.1M - $4.3M Price Range
540 Parrott Dr San Mateo, CA 94402
Baywood-Aragon NeighborhoodEstimated Value: $4,231,000 - $5,066,249
4
Beds
3
Baths
3,240
Sq Ft
$1,421/Sq Ft
Est. Value
Highlights
- Wood Flooring
- Formal Dining Room
- Forced Air Heating and Cooling System
- Baywood Elementary School Rated A
- 1 Car Detached Garage
- Separate Family Room
About This Home
As of June 2025Welcome to this beautifully updated 4-bedroom, 3-bath residence located in the highly sought-after Baywood neighborhood. Offering 3,240 sf of living space on an expansive 8,280 sf lot, this light-filled Mediterranean-inspired home blends timeless architectural details with modern sophistication. Inside, you'll find a formal and elegant dining room and a dramatic step-down living room featuring beamed ceilings and French doors that open to a charming private courtyard. The chefs kitchen has been thoughtfully updated with top end appliances, Carrera marble countertops, open shelving, and a built in dining nook. Upstairs, three spacious bedrooms and two full bathrooms include a luxurious primary suite with a spa-inspired bathroom. The lower level offers flexible living with a private en suite bedroom and separate entrance. This level also includes a welcoming family room that opens to the backyard, a dedicated office space, and a laundry room. Outdoor living with multiple entertaining areas including a new dining pergola, built-in BBQ, extra large fire pit, and award-winning landscaped gardens. Located just a short stroll from Downtown San Mateo, top-rated Baywood schools & Central Park, this home offers the perfect blend of luxury, convenience, and timeless style. Welcome home!
Last Agent to Sell the Property
Coldwell Banker Realty License #01889384 Listed on: 05/29/2025
Create a Home Valuation Report for This Property
The Home Valuation Report is an in-depth analysis detailing your home's value as well as a comparison with similar homes in the area
Home Details
Home Type
- Single Family
Year Built
- Built in 1928
Lot Details
- 8,281 Sq Ft Lot
- Zoning described as R1
Parking
- 1 Car Detached Garage
- On-Street Parking
Home Design
- Pillar, Post or Pier Foundation
- Tile Roof
Interior Spaces
- 3,240 Sq Ft Home
- Gas Log Fireplace
- Separate Family Room
- Formal Dining Room
- Wood Flooring
- Crawl Space
Bedrooms and Bathrooms
- 4 Bedrooms
- 3 Full Bathrooms
Utilities
- Forced Air Heating and Cooling System
Community Details
- 95-Story Property
Listing and Financial Details
- Assessor Parcel Number 034024140
Ownership History
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
Date
Name
Owned For
Owner Type
Purchase Details
Listed on
May 29, 2025
Closed on
Jun 11, 2025
Sold by
Bought by
Seller's Agent
Beth Taylor
Coldwell Banker Realty
Buyer's Agent
Sophia Herrera
Sotheby's Intl Rlty
List Price
$4,198,000
Sold Price
$4,400,000
Premium/Discount to List
$202,000
4.81%
Views
53
Current Estimated Value
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$202,812
Avg. Annual Appreciation
4.18%
Original Mortgage
$3,520,000
Outstanding Balance
$3,472,582
Interest Rate
5.5%
Mortgage Type
New Conventional
Estimated Equity
$1,130,230
Purchase Details
Closed on
Apr 7, 2016
Sold by
Bought by
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$2,080,000
Interest Rate
2.95%
Mortgage Type
Adjustable Rate Mortgage/ARM
Purchase Details
Closed on
Aug 8, 2012
Sold by
Bought by
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$1,528,125
Interest Rate
2.87%
Mortgage Type
New Conventional
Purchase Details
Closed on
Jun 13, 2009
Sold by
Bought by
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$625,000
Interest Rate
4.83%
Mortgage Type
New Conventional
Purchase Details
Closed on
Jun 1, 2004
Sold by
Bought by
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$725,000
Interest Rate
5.86%
Mortgage Type
Purchase Money Mortgage
Purchase Details
Closed on
May 14, 2004
Sold by
Bought by
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$725,000
Interest Rate
5.86%
Mortgage Type
Purchase Money Mortgage
Purchase Details
Closed on
Mar 19, 2003
Sold by
Bought by
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$270,000
Interest Rate
5.79%
Home Values in the Area
Average Home Value in this Area
Agents Specializing in Baywood-Aragon, CA
-
Sheldon Rilliet
-
Sunaina Arora
Sunaina Arora
Compass
(669) 236-2959
70 Total Sales
1 in Baywood-Aragon
$3,380,000 Price
-
Astha Mathur
Astha Mathur
Compass
(669) 202-1667
67 Total Sales
1 in Baywood-Aragon
$3,380,000 Price
-
Emma Elfving
Emma Elfving
Compass
(650) 525-2423
91 Total Sales
2 in Baywood-Aragon
$1.1M - $5.5M Price Range
-
Kathleen Sparer
Kathleen Sparer
Compass
(650) 562-8667
25 Total Sales
11 in Baywood-Aragon
$848K - $3.2M Price Range
-
Joseph Stein
Joseph Stein
Realty World Peninsula
(650) 481-7810
21 Total Sales
1 in Baywood-Aragon
$2,100,000 Price
Purchase History
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
| Date | Buyer | Sale Price | Title Company |
|---|---|---|---|
| $4,400,000 | Wfg National Title Insurance C | ||
| $3,200,000 | Old Republic Title Company | ||
| $2,037,500 | First American Title | ||
| -- | Orange Coast Title | ||
| -- | Orange Coast Title | ||
| -- | -- | ||
| $1,734,000 | Fidelity National Title Co | ||
| -- | North American Title Company |
Source: Public Records
Mortgage History
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
| Date | Status | Borrower | Loan Amount |
|---|---|---|---|
| Open | $3,520,000 | ||
| Previous Owner | $2,080,000 | ||
| Previous Owner | $1,528,125 | ||
| Previous Owner | $625,000 | ||
| Previous Owner | $725,000 | ||
| Previous Owner | $500,000 | ||
| Previous Owner | $270,000 | ||
| Previous Owner | $270,000 |
Source: Public Records
Property History
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
| Date | Event | Price | List to Sale | Price per Sq Ft |
|---|---|---|---|---|
| 06/26/2025 06/26/25 | Sold | $4,400,000 | +4.8% | $1,358 / Sq Ft |
| 06/03/2025 06/03/25 | Pending | -- | -- | -- |
| 05/29/2025 05/29/25 | For Sale | $4,198,000 | -- | $1,296 / Sq Ft |
Source: MLSListings
Tax History
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
| Year | Tax Paid | Tax Assessment Tax Assessment Total Assessment is a certain percentage of the fair market value that is determined by local assessors to be the total taxable value of land and additions on the property. | Land | Improvement |
|---|---|---|---|---|
| 2025 | $44,082 | $3,788,144 | $1,894,072 | $1,894,072 |
| 2023 | $44,082 | $3,641,048 | $1,820,524 | $1,820,524 |
| 2022 | $43,138 | $3,569,656 | $1,784,828 | $1,784,828 |
| 2021 | $42,318 | $3,499,664 | $1,749,832 | $1,749,832 |
| 2020 | $40,976 | $3,463,780 | $1,731,890 | $1,731,890 |
| 2019 | $39,448 | $3,395,864 | $1,697,932 | $1,697,932 |
| 2018 | $38,576 | $3,329,280 | $1,664,640 | $1,664,640 |
| 2017 | $37,803 | $3,264,000 | $1,632,000 | $1,632,000 |
| 2016 | $25,307 | $2,119,480 | $1,059,740 | $1,059,740 |
| 2015 | $24,723 | $2,087,644 | $1,043,822 | $1,043,822 |
| 2014 | $24,580 | $2,046,750 | $1,023,375 | $1,023,375 |
Source: Public Records
Agents Affiliated with this Home
-
Beth Taylor
Seller's Agent in 2025
Beth Taylor
Coldwell Banker Realty
(650) 255-9510
1 in this area
15 Total Sales
-
Sophia Herrera
S
Buyer's Agent in 2025
Sophia Herrera
Sotheby's Intl Rlty
(650) 577-3700
1 in this area
54 Total Sales
Map
Source: MLSListings
MLS Number: ML82008887
APN: 034-024-140
Disclaimer: Certain information contained herein is derived from information provided by parties other than Homes.com. All information provided is deemed reliable, but is not guaranteed to be accurate and should be independently verified.
Property Information © 2026 MLSListings Inc. All rights reserved. Listing information is deemed reliable but not guaranteed. Certain information contained herein is derived from information which is the licensed property of, and copyrighted by, MLSListings Inc. The viewer acknowledges ownership and validity of its copyright. Information provided is for personal, non-commercial use by a viewer with a bona fide interest in the purchase or sale of real estate of the type being offered via this website or other electronic means. The viewer is prohibited from copying, redistributing or retransmitting any of the data or information provided by MLSListing, Inc.
Nearby Homes
- 222 Harvard Rd
- 280 Uplands Dr
- 523 Maple St
- 0 Parrott Dr
- 1050 Merner Rd
- 30 Mission Dr
- 862 Chiltern Rd
- 20 W 3rd Ave Unit 601
- 336 Brentwood Rd
- 31 Belford Way
- 452 Roblar Ave
- 10 Crystal Springs Rd Unit 1509
- 10 Crystal Springs Rd Unit 1206
- 10 Crystal Springs Rd Unit 1405
- 10 Crystal Springs Rd Unit 1402
- 10 Crystal Springs Rd Unit 1202
- 810 Lombardi Ln
- 115 Hobart Ave Unit E
- 109 Hobart Ave
- 9 Seville Way
- 532 Parrott Dr
- 548 Parrott Dr
- 545 Fairfax Ave
- 539 Fairfax Ave
- 526 Parrott Dr
- 556 Parrott Dr
- 551 Fairfax Ave
- 531 Fairfax Ave
- 541 Parrott Dr
- 518 Parrott Dr
- 525 Fairfax Ave
- 531 Parrott Dr
- 551 Parrott Dr
- 523 Parrott Dr
- 401 Alameda de Las Pulgas
- 512 Parrott Dr
- 519 Fairfax Ave
- 517 Parrott Dr
- 542 Fairfax Ave
- 536 Fairfax Ave
Your Personal Tour Guide
Ask me questions while you tour the home.