NOT LISTED FOR SALE

24077 2nd St Hayward, CA 94541

Mission-Foothill Neighborhood

Estimated Value: $1,693,000 - $1,923,000

6 Beds
7.5 Baths
4,859 Sq Ft
$365/Sq Ft Est. Value

Last Sold August 25, 2021

Last sale price $1,750,000 $360 Per Sq Ft

Est. 5% increase in value since last sale

Current estimated payment $11,421/month

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 2021

Built 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

Last Buyer's Agent

Bill Aboumrad

Legacy Real Estate &Associates License #00768163

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

  • 0.67 Acre Lot
  • Forced Air Heating System

Home Details

Home Type

Single Family

Year Built

1914

Lot Details

0

Parking

3

Listing Details

  • Zoning: R3
  • Subclass: Single Family Home
  • Listing Class: Residential
  • Structure Sq Ft: 4859
  • Special Features: None
  • Property Sub Type: Detached
  • Year Built: 1914

Interior Features

  • Family Room: No Family Room
  • Fireplace: Living Room, Primary Bedroom
  • Dining Room: Formal Dining Room
  • Fireplace: Yes
  • Living Sq Ft: 4859
  • Stories: 2
  • Flooring: Carpet, Hardwood, Tile
  • Fireplaces Min: 2
  • Full Bathrooms: 7
  • Half Bathrooms: 1
  • Total Bedrooms: 6

Exterior Features

  • Foundation: Post And Beam
  • Roof: Composition, Flat / Low Pitch, Tile

Garage/Parking

  • Garage Spaces: 3
  • Garage Parking Features: Detached Garage, Gate / Door Opener, Guest / Visitor Parking, Off-Street Parking, Uncovered Parking

Utilities

  • Heating System: Forced Air
  • Sewer/Septic System: Sewer - Public

Schools

  • High School: 26928

Lot Info

  • Lot Acres: 0.6657
  • Lot Size Area Minimum Units: Square Feet
  • Minimum Lot Size: 29000.00
  • Lot Size Area Maximum Units: Square Feet
  • Maximum Lot Size: 29000.00

Multi Family

  • Utilities: Public Utilities

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Feb 3, 2021
Closed on
Aug 25, 2021
Sold by
Wiese Patricia A
Bought by
Wiese Living Trust
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
$1,837,333

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$87,333
Avg. Annual Appreciation
0.28%
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,583,912

Purchase Details

Listed on
Feb 3, 2021
Closed on
Aug 12, 2021
Sold by
Wiese Therese and Aboumrad Michael
Bought by
Dear Marie
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,583,912

Purchase Details

Closed on
Dec 19, 2002
Sold by
Wiese Patricia A and The Wiese Living Trust
Bought by
Wiese Patricia A and The Wiese Living Trust

Purchase Details

Closed on
Feb 16, 1996
Sold by
Wiese Robert T and Wiese Patricia A
Bought by
Wiese Robert T and Wiese Patricia A
Source: Public Records

Range of Values:

--
Value Increase
--
Percent Increase
--
Adjusted for Inflation
Collateral Analytics

Collateral Analytics Collateral Analytics AVMs (Automated Valuation Model) employ a number of statistical approaches combined with neighborhood-specific comparable selection guarantees the most up-to-date and precise valuations.

Not Available

Collateral Analytics does not have data for the current month. Please view the chart for historical values.

ICE

ICE Mortgage Technology ICE Mortgage Technology’s AVM (Automated Valuation Model) is a state-of-the-art online residential property valuation tool that provides a quick and accurate estimate of the value of almost any home in the U.S.

Not Available

ICE Mortgage Technology does not have data for the current month. Please view the chart for historical values.

First American

First American First American Data & Analytics’ next-generation AVM combines unrivaled data assets with a blended ensemble of valuation models to produce highly accurate, reliable valuations you can trust.

Not Available

First American does not have data for the current month. Please view the chart for historical values.

Quantarium

Quantarium Quantarium’s valuation service, repeatedly proven the industry’s most accurate and comprehensive, is supercharged with a self-learning and auto-tuning AI engine that continually becomes smarter and more accurate as it processes daily inputs from the industry’s leading RE data lake.

Not Available

Quantarium does not have data for the current month. Please view the chart for historical values.

Average Value
Not Available
List Price
Sold Price
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

Source: Public Records

Average Home Value in this Area

Source: Public Records

Purchase History

Date Buyer Sale Price Title Company
Wiese Living Trust -- --
Dear Marie $1,750,000 Old Republic Title Company
Wiese Living Trust -- --
Wiese Patricia A -- --
Wiese Robert T -- --
Wiese Robert T -- --
Wiese Robert T -- --
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Dear Marie $7,000,000
Source: Public Records

Property History

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 Compared to Growth

Source: Public Records

Tax History

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

  • D

    Seller's Agent in 2021

    Diane Leland

    Legacy Real Estate & Associates

    Section Image
  • Bill Aboumrad

    Buyer's Agent in 2021

    Bill Aboumrad

    Legacy Real Estate &Associates

    (510) 816-3611

    1 in this area

    99 Total Sales

    Bill Aboumrad
    Section Image
See All Agents

Map

Source: MLSListings

MLS Number: ML81828327

MLSListings

APN: 445-0020-028-00

California Alameda County Hayward 94541 Mission-Foothill

24077 2nd St, Hayward, CA

Not Listed for Sale

Detached

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.

MLSListings Property Information © 2025 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