24077 2nd St

4,859 Sq. Ft.
$360 / Sq. Ft.
4,859
Sq. Ft.
$360
per Sq. Ft.

Description

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...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!
  1. Listed by Diane Leland • DRE #01908353 • Brokerage DRE #01154757 • Legacy Real Estate & Associates • 408-218-8625

Property Details for 24077 2nd Street

MLS City Name
HAYWARD
Building Type
Detached
Garage Spaces
3
Cross Street
Walpert
LISTING UPDATED: 08/25/2021 06:46 PM

Property Details for 24077 2nd Street

StatusSold
MLS #ML81828327
Days on Compass4
Taxes-
HOA Fees-
Condo/Co-op Fees-
Compass TypeSingle Family
MLS TypeSingle-Family Homes / Detached
Year Built1914
Lot Size0.67 AC / 29,000 SF
CountyAlameda County

Location

Listing Courtesy of Legacy Real Estate & Associates, Diane Leland, DRE #01908353

Sold By Legacy Real Estate &Associates, William Aboumrad, DRE #00768163

Add your commute

Building Information for 24077 2nd Street

Stories2Year Built1914Building Size-Lot Size0.67 AC / 29,000 SF

Payment Calculator

Get preapproved with
OriginPoint Mortgage or Rocket Mortgage1

$10,342 per month

30 year fixed, 6.15% Interest

Principal and Interest

$8,529

Property Taxes

$1,813

HOA Dues

$0

The Payment Calculator is for illustrative purposes only.

Know your buying power with a preapproval and custom rate in minutes

Rocket Mortgage1

Property Information for 24077 2nd Street

Features
Room Information
  • Dining Room: Formal Dining Room
  • Family Room: No Family Room
  • Number of Full Bathrooms: 7
  • Number of Half Bathrooms: 1
Features
  • Fireplace: Yes
  • Fireplaces: Living Room, Primary Bedroom
  • Fireplaces Min: 2
  • Flooring: Carpet, Hardwood, Tile
  • Living SqFt: 4859
  • Pool: No
Utilities
  • Cooling: None
  • Heating: Forced Air
  • Sewer Septic: Sewer - Public
  • Utilities: Public Utilities
  • Water: Public
Garage
  • Garage and Parking: Detached Garage, Gate / Door Opener, Guest / Visitor Parking, Off-Street Parking, Uncovered Parking
  • Garage Max: 3
  • Garage Min: 3
Property Details
Homeowners Association
  • HOA Exists: 0
  • HOA Fee: $0
Property Details
  • Area Text: Hayward
  • Roof: Composition, Flat / Low Pitch, Tile
  • Stories: Two Story
  • Subclass: Single Family Home
  • Year Built Source: Other
  • Street Number: 24077
  • Street Name: 2nd
  • Street Suffix: Street
  • Area ID: 3400
Lot / Property Details
Building Information
  • Number Of Stories: 2
  • Structure SqFt: 4859
  • Structure SqFt Source: Assessor
  • Age: 107
Development Information
  • Zoning Detail: R3
Location Information
  • City Limits: Yes
  • Incorporated: Yes
  • Parcel Number: 445-0020-028
  • County Name: Alameda
  • City Name: HAYWARD
  • City Postal ID: 127
  • Postal Code: 94541
  • Elementary School District: 1368
  • High School District Text: Hayward Unified
  • High School Text: Hayward High
Lot Information
  • Foundation: Post and Beam
  • Horse Property: No
  • Lot Acres: .67
  • Lot Size Area Maximum Units: Square Feet
  • Lot Size Area Minimum Units: Square Feet
  • Lot Size Source: Assessor
Mobile / Manufactured Information
Other Information
  • Dual Variable: Yes

Property History for 24077 2nd Street

DateEvent & SourcePriceAppreciation
Aug 25, 2021

Sold

MLSListings #ML81828327

$1,750,000
Aug 12, 2021

Sold (Public Record)

Public Record #1470960626

$1,750,000
Jul 7, 2021

Temporarily Off Market

EBRD #ML81828327

Jul 1, 2021

Contingent - Show

MLSListings #ML81828327

Apr 26, 2021

Pending

MLSListings #ML81828327

Apr 26, 2021

Contingent - Show

MLSListings #ML81828327

Apr 26, 2021

Pending

EBRD #ML81828327

Feb 7, 2021

Temporarily Off Market

MLSListings #ML81828327

Feb 7, 2021

Temporarily Off Market

EBRD #ML81828327

Feb 3, 2021

Listed (Active)

MLSListings #ML81828327

$1,875,000
Feb 3, 2021

Listed (Active)

EBRD #ML81828327

$1,875,000
DateEvent & SourcePrice
08/25/2021

Sold

MLSListings #ML81828327

$1,750,000
08/12/2021

Sold (Public Record)

Public Record #1470960626

$1,750,000
07/07/2021

Temporarily Off Market

EBRD #ML81828327

07/01/2021

Contingent - Show

MLSListings #ML81828327

04/26/2021

Pending

MLSListings #ML81828327

04/26/2021

Contingent - Show

MLSListings #ML81828327

04/26/2021

Pending

EBRD #ML81828327

02/07/2021

Temporarily Off Market

MLSListings #ML81828327

02/07/2021

Temporarily Off Market

EBRD #ML81828327

02/03/2021

Listed (Active)

MLSListings #ML81828327

$1,875,000
02/03/2021

Listed (Active)

EBRD #ML81828327

$1,875,000

For completeness, Compass often displays two records for one sale: the MLS record and the public record.

Public Records for 24077 2nd Street

Taxable ValueLand$891,020Additions$914,609Total$1,805,629
Tax Record2025$21,752 ($1,813 / month)
Home Facts
Total Finished SqFt4,859 SqFtAbove Grade Finished SqFt4,859 SqFtStories2Lot Size29,000 SqFtStyleTriplexYear Built1914CountyALAMEDAAPN445-20-28

Schools near 24077 2nd Street

This home is within Hayward Unified School District.
Rating
School
Type
Grades
Distance
Public - K to 6
Public - 7 to 8
Public - 9 to 12
Charter - K to 8
Rating
School
Distance
East Avenue Elementary School
PublicK to 6

Bret Harte Middle School
Public7 to 8

Hayward High School
Public9 to 12

Knowledge Enlightens You (Key) Academy
CharterK to 8

School ratings and boundaries are provided by GreatSchools.org and Pitney Bowes. This information should only be used as a reference. Proximity or boundaries shown here are not a guarantee of enrollment. Please reach out to schools directly to verify all information and enrollment eligibility.

Similar Homes

Similar Sold Homes

No guarantee, warranty or representation of any kind is made regarding the completeness or accuracy of descriptions or measurements (including square footage measurements and property condition), such should be independently verified, and Compass, Inc., its subsidiaries, affiliates and their agents and associated third parties expressly disclaims any liability in connection therewith. Photos may be virtually staged or digitally enhanced and may not reflect actual property conditions. Offers of compensation are subject to change at the discretion of the seller. No financial or legal advice provided. Equal Housing Opportunity.

Listing Courtesy of Legacy Real Estate & Associates, Diane Leland, DRE #01908353

Based on information from one of the following Multiple Listing Services: San Francisco Association of Realtors, the MLSListings MLS, the BAREIS MLS, the EBRD MLS, Shasta Association of REALTORS® Information being provided is for the visitor’s personal, noncommercial use and may not be used for any purpose other than to identify prospective properties visitor may be interested in purchasing. The data contained herein is copyrighted by San Francisco Association of Realtors, the MLSListings MLS, the BAREIS MLS, the EBRD MLS, Shasta Association of REALTORS® is protected by all applicable copyright laws. Any dissemination of this information is in violation of copyright laws and is strictly prohibited. Property information referenced on this web site comes from the Internet Data Exchange (IDX) program of the MLS. This web site may reference real estate listing(s) held by a brokerage firm other than the broker and/or agent who owns this web site. For the avoidance of doubt, the accuracy of all information, regardless of source, is deemed reliable but not guaranteed and should be personally verified through personal inspection by and/or with the appropriate professionals.