24077 2nd St
Hayward, CA 94541
Mission-Foothill- 6 Beds
- 7.5 Baths
- 4,859 sqft (on 0.67 acres)
6 Beds
7.5 Baths
4,859 sqft
(on 0.67 acres)
Local Information
© Google
-- mins to
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 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!!
This property is off market, which means it's not currently listed for sale or rent on Trulia. This may be different from what's available on other websites or public sources.
Home Highlights
Parking
Garage
Outdoor
No Info
A/C
Heating only
HOA
None
Price/Sqft
No Info
Listed
No Info
Home Details for 24077 2nd St
|
|---|
Heating & Cooling Heating: Forced AirHeating Fuel: Forced Air |
Interior Details Number of Rooms: 15Types of Rooms: Dining Room |
Fireplace & Spa Fireplace |
Levels, Entrance, & Accessibility Floors: Tile, Carpet, Hardwood |
|
|---|
Exterior Home Features Roof: Composition, Tile |
Parking & Garage GarageParking: Garage Detached, Off Street |
|
|---|
Year Built Year Built: 1914Year Updated: 1914 |
Property Type / Style Property Type: Single Family HomeArchitecture: Other |
|
|---|
Units in Building: 4 |
|
|---|
Lot Area: 0.67 acres |
Price History for 24077 2nd St
| Date | Price | Event | Source |
|---|---|---|---|
| 08/25/2021 | $1,750,000 | Sold | MLSListings Inc #ML81828327 |
| 04/27/2021 | $1,875,000 | Contingent | MLSListings Inc #ML81828327 |
| 04/27/2021 | $1,875,000 | Listed For Sale | MLSListings Inc #ML81828327 |
Property Tax and Assessment
| Year | 2025 |
|---|---|
| Tax | |
| Assessment | $1,805,629 |
Home facts updated by county records
Comparable Sales for 24077 2nd St
Address | Distance | Property Type | Sold Price | Sold Date | Bed | Bath | Sqft |
|---|---|---|---|---|---|---|---|
0.35 | Single-Family Home | $1,400,000 | 05/30/25 | 7 | 7.5 | 2,820 | |
0.58 | Single-Family Home | $1,100,000 | 07/25/25 | 6 | 2 | 2,490 | |
0.85 | Single-Family Home | $1,270,000 | 08/15/25 | 4 | 4 | 3,226 | |
0.03 | Single-Family Home | $996,000 | 07/30/25 | 3 | 4 | 1,922 | |
0.69 | Single-Family Home | $1,190,000 | 06/05/25 | 5 | 3 | 3,149 | |
0.11 | Single-Family Home | $1,000,000 | 07/30/25 | 3 | 3.5 | 2,005 | |
0.36 | Single-Family Home | $850,000 | 04/15/26 | 5 | 3 | 2,064 | |
0.28 | Single-Family Home | $799,000 | 11/20/25 | 4 | 2 | 2,838 | |
0.19 | Single-Family Home | $1,150,000 | 04/03/26 | 3 | 4 | 1,922 | |
0.23 | Single-Family Home | $1,150,000 | 05/05/26 | 3 | 3.5 | 1,922 |
Nearby homes
Get a sense of prices in the area by checking nearby homes.Assigned Schools
These are the assigned schools for 24077 2nd St.
What Locals Say about Mission-Foothill
At least 34 Trulia users voted on each feature.
79 % Say car is needed
79 % Say it's dog friendly
78 % Say there are sidewalks
67 % Say there's wildlife
55 % Say there's holiday spirit
54 % Say it's walkable to grocery stores
54 % Say yards are well-kept
51 % Say it's quiet
50 % Say neighbors are friendly
49 % Say they plan to stay for at least 5 years
45 % Say it's walkable to restaurants
43 % Say kids play outside
41 % Say people would walk alone at night
40 % Say parking is easy
33 % Say streets are well-lit
15 % Say there are community events
Sourced by Trulia users. Learn more about our methodology.
LGBTQ Local Legal Protections
LGBTQ Local Legal Protections
Apartments for Rent
Explore by feature
Homes for sale near 24077 2nd St
Off Market Homes Near 24077 2nd St
Homes for rent near 24077 2nd St
24077 2nd St, Hayward, CA 94541 is a 6 bedroom, 8 bathroom, 4,859 sqft single-family home built in 1914. 24077 2nd St is located in Mission-Foothill, Hayward. This property is not currently available for sale. 24077 2nd St was last sold on Aug 25, 2021 for $1,750,000. The current Trulia Estimate for 24077 2nd St is $2,083,600.

