D
Seller's Agent in 2021
Diane Leland
Legacy Real Estate & Associates
24077 2nd St Hayward, CA 94541
Mission-Foothill NeighborhoodEstimated Value: $1,546,000 - $1,834,000
6
Beds
7.5
Baths
4,859
Sq Ft
$344/Sq Ft
Est. Value
Highlights
- 0.67 Acre Lot
- Post and Beam
- Formal Dining Room
- Fireplace in Primary Bedroom
- Wood Flooring
- 3 Car Detached Garage
About This Home
As of August 2021Built in 1912 by William Connors and nestled in a world of its own behind a massive gate, this magnificent Castle is ready and waiting for its new king and / or queen to take reign. It was originally designed with a reception hall, living room, music room, dining room and kitchen, as well as several stained glass windows lining a grand circular staircase. The stained glass windows have been preserved and still remain in mint condition. It is once again a private residence, after being divided into apartments in the early 1940's. There are 4 bedrooms located inside the Castle, each with its own private bath, with another 1 1/2 baths downstairs. The historic Carriage house on the grounds has been converted into 2 studio apartments, which currently have dependable and responsible tenants. Make this historic piece of Hayward history your new home!!
Last Agent to Sell the Property
Diane Leland
Legacy Real Estate & Associates License #01908353 Listed on: 02/03/2021
Home Details
Home Type
- Single Family
Year Built
- 1914
Lot Details
- 0.67
Parking
- 3 Car Detached Garage
- Garage Door Opener
- Guest Parking
- Uncovered Parking
- Off-Street Parking
Home Design
- Post and Beam
- Flat Roof Shape
- Tile Roof
- Composition Roof
Interior Spaces
- 4,859 Sq Ft Home
- 2-Story Property
- Living Room with Fireplace
- 2 Fireplaces
- Formal Dining Room
Flooring
- Wood
- Carpet
- Tile
Bedrooms and Bathrooms
- 6 Bedrooms
- Fireplace in Primary Bedroom
Additional Features
- 28,998 Sq Ft Lot
- Forced Air Heating System
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
Feb 3, 2021
Closed on
Aug 25, 2021
Sold by
Bought by
Seller's Agent
Diane Leland
Legacy Real Estate & Associates
Buyer's Agent
Bill Aboumrad
Legacy Real Estate &Associates
List Price
$1,875,000
Sold Price
$1,750,000
Premium/Discount to List
-$125,000
-6.67%
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
-$80,000
Avg. Annual Appreciation
-0.97%
Original Mortgage
$7,000,000
Outstanding Balance
$6,355,579
Interest Rate
2.8%
Mortgage Type
Reverse Mortgage Home Equity Conversion Mortgage
Estimated Equity
-$4,685,579
Purchase Details
Listed on
Feb 3, 2021
Closed on
Aug 12, 2021
Sold by
Bought by
Seller's Agent
Diane Leland
Legacy Real Estate & Associates
Buyer's Agent
Bill Aboumrad
Legacy Real Estate &Associates
List Price
$1,875,000
Sold Price
$1,750,000
Premium/Discount to List
-$125,000
-6.67%
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$7,000,000
Outstanding Balance
$6,355,579
Interest Rate
2.8%
Mortgage Type
Reverse Mortgage Home Equity Conversion Mortgage
Estimated Equity
-$4,685,579
Purchase Details
Closed on
Dec 19, 2002
Sold by
Bought by
Purchase Details
Closed on
Feb 16, 1996
Sold by
Bought by
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 Values in the Area
Average Home Value in this Area
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 |
|---|---|---|---|
| -- | -- | ||
| $1,750,000 | Old Republic 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 | $7,000,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 |
|---|---|---|---|---|
| 08/25/2021 08/25/21 | Sold | $1,750,000 | -6.7% | $360 / Sq Ft |
| 04/26/2021 04/26/21 | Pending | -- | -- | -- |
| 04/26/2021 04/26/21 | For Sale | $1,875,000 | +7.1% | $386 / Sq Ft |
| 02/07/2021 02/07/21 | Off Market | $1,750,000 | -- | -- |
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 | $21,540 | $1,798,629 | $891,020 | $914,609 |
| 2024 | $21,540 | $1,763,234 | $873,553 | $896,681 |
| 2023 | $21,210 | $1,735,531 | $856,429 | $879,102 |
| 2022 | $21,453 | $1,694,501 | $839,637 | $861,864 |
| 2021 | $6,468 | $449,584 | $126,326 | $330,258 |
| 2020 | $6,399 | $451,904 | $125,031 | $326,873 |
| 2019 | $6,434 | $443,045 | $122,580 | $320,465 |
| 2018 | $6,070 | $434,359 | $120,177 | $314,182 |
| 2017 | $5,955 | $427,444 | $117,821 | $309,623 |
| 2016 | $5,641 | $419,095 | $115,511 | $303,584 |
| 2015 | $5,478 | $412,825 | $113,776 | $299,049 |
| 2014 | $5,274 | $404,772 | $111,548 | $293,224 |
Source: Public Records
Agents Affiliated with this Home
-
-
Bill Aboumrad
Buyer's Agent in 2021
Bill Aboumrad
Legacy Real Estate &Associates
(510) 816-3611
1 in this area
96 Total Sales
Map
Source: MLSListings
MLS Number: ML81828327
APN: 445-0020-028-00
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
- 24221 2nd St
- 23933 Carmelita Dr
- 1250 E St
- 944 Walpert St
- 1210 Highland Blvd
- 22824 High St
- 1510 E St Unit 23
- 1467 Clay St
- 1556 E St
- 1251 Bellina St
- 24657 Leona Dr
- 24366 Israel Ct
- 22622 2nd St
- 1723 Germaine Ct
- 22836 Watkins St
- 1743 Panda Way
- 24805 Canyon View Ct
- 1225 Richard Place
- 22526 Richard Place
- 629 Artistic Place Unit 27
- 24103 Amaranth Loop
- 24105 Amaranth Loop
- 24107 Amaranth Loop
- 24111 Amaranth Loop
- 24109 Amaranth Loop
- 24101 Amaranth Loop
- 1275 Walpert St
- 24117 Amaranth Loop
- 24113 Amaranth Loop
- 1316 Antonella Place
- 24123 Amaranth Loop
- 24119 Amaranth Loop
- 24201 2nd St
- 24121 Amaranth Loop
- 24203 2nd St
- 24205 2nd St
- 24207 2nd St
- 1312 Antonella Place
- 1314 Antonella Place
- 24209 2nd St
Your Personal Tour Guide
Ask me questions while you tour the home.