Is Mission-Foothill, Hayward, CA dog-friendly?

As of early 2026, 79% of users say it's dog friendly

Is a car needed in Mission-Foothill, Hayward, CA?

As of early 2026, 79% of users say car is needed

Does Mission-Foothill, Hayward, CA have sidewalks?

As of early 2026, 78% of users say there are sidewalks

Is there wildlife in Mission-Foothill, Hayward, CA?

As of early 2026, 67% of users say there's wildlife

Does Mission-Foothill, Hayward, CA show holiday spirit?

As of early 2026, 56% of users say there's holiday spirit

Is Mission-Foothill, Hayward, CA walkable to grocery stores?

As of early 2026, 54% of users say it's walkable to grocery stores

Are yards well-kept in Mission-Foothill, Hayward, CA?

As of early 2026, 54% of users say yards are well-kept

Is Mission-Foothill, Hayward, CA quiet?

As of early 2026, 51% of users say it's quiet

Are neighbors friendly in Mission-Foothill, Hayward, CA?

As of early 2026, 50% of users say neighbors are friendly

Do residents of Mission-Foothill, Hayward, CA plan to stay at least 5 years?

As of early 2026, 50% of users say they plan to stay for at least 5 years

Is Mission-Foothill, Hayward, CA walkable to restaurants?

As of early 2026, 45% of users say it's walkable to restaurants

Do kids play outside in Mission-Foothill, Hayward, CA?

As of early 2026, 43% of users say kids play outside

Would people walk alone at night in Mission-Foothill, Hayward, CA?

As of early 2026, 41% of users say people would walk alone at night

Is parking easy in Mission-Foothill, Hayward, CA?

As of early 2026, 40% of users say parking is easy

Are the streets well-lit in Mission-Foothill, Hayward, CA?

As of early 2026, 33% of users say streets are well-lit

Are there community events in Mission-Foothill, Hayward, CA?

As of early 2026, 15% of users say there are community events

What is 24077 2nd St estimated to be worth?

Trulia's estimated value for 24077 2nd St in Hayward, CA is $2,051,300 .

What is the price history for 24077 2nd St?

24077 2nd St in Hayward, CA last sold for $1,750,000 in August 2021.

Is Hayward a buyer's or seller's market?

Hayward is currently a seller's market, based on recent for-sale activity.

What's the median sale price in Hayward?

The median sale price in Hayward is $863K. That is up $11.67K from the prior month.

How big is the lot at 24077 2nd St?

The lot at 24077 2nd St in Hayward, CA is about 0.67 acres (28,997 sq ft).

Does 24077 2nd St have a garage?

Yes, 24077 2nd St in Hayward, CA has a garage.

OFF MARKET

$2,051,300

Trulia Estimate

6 Beds
7.5 Baths
4,859 sqft (on 0.67 acres)

24077 2nd St, Hayward, CA 94541

Mission-Foothill

Est. Refi. Payment $12,532/mo*

Refinance Your Home

Currently Off Market - Sold Aug 25, 2021 for $1,750,000

Home Value

Trulia Estimate

$2.05M

Since last month

$38K (-1.8%)

Since last year

$99K (+5.1%)

Since last sale

$294K (+16.8%)

Learn more about this home's value by checking out its Trulia Estimate, the value of nearby homes, and how much similar homes have sold for.

Trulia Estimate

The of this home's value increased by +128% in the last 10 years

Month	Estimated value
2026
August 2026	$2.04M
July 2026	$2.08M
June 2026	$2.11M
May 2026	$2.09M
April 2026	$2.07M
March 2026	$2.01M
February 2026	$2M
January 2026	$1.87M
2025
December 2025	$1.86M
November 2025	$1.91M
October 2025	$1.92M
September 2025	$1.95M
August 2025	$1.94M
July 2025	$1.96M
June 2025	$1.97M
May 2025	$2.04M
April 2025	$2.04M
March 2025	$2.07M
February 2025	$2.05M
January 2025	$1.98M
2024
December 2024	$1.95M
November 2024	$1.98M
October 2024	$1.9M
September 2024	$1.91M
August 2024	$1.98M
July 2024	$1.99M
June 2024	$2.04M
May 2024	$2.01M
April 2024	$1.97M
March 2024	$1.96M
February 2024	$1.89M
January 2024	$1.81M
2023
December 2023	$1.8M
November 2023	$1.84M
October 2023	$1.87M
September 2023	$1.9M
August 2023	$1.88M
July 2023	$1.86M
June 2023	$1.92M
May 2023	$1.93M
April 2023	$1.84M
March 2023	$1.77M
February 2023	$1.65M
January 2023	$1.73M
2022
December 2022	$1.78M
November 2022	$1.78M
October 2022	$1.81M
September 2022	$1.8M
August 2022	$1.79M
July 2022	$1.89M
June 2022	$1.96M
May 2022	$1.98M
April 2022	$2.01M
March 2022	$1.99M
February 2022	$1.91M
January 2022	$1.88M
2021
December 2021	$1.82M
November 2021	$1.82M
October 2021	$1.77M
September 2021	$1.77M
August 2021	$1.76M
July 2021	$1.89M
June 2021	$1.99M
May 2021	$2M
April 2021	$2.05M
March 2021	$2.62M
February 2021	$1.91M
January 2021	$2.37M
2020
December 2020	$2.31M
November 2020	$2.19M
October 2020	$2.08M
September 2020	$1.99M
August 2020	$2.14M
July 2020	$2.17M
June 2020	$2.1M
May 2020	$2.12M
April 2020	$2.17M
March 2020	$2.11M
February 2020	$1.92M
January 2020	$1.63M
2019
December 2019	$1.64M
November 2019	$1.66M
October 2019	$1.68M
September 2019	$1.73M
August 2019	$1.75M
July 2019	$1.69M
June 2019	$1.67M
May 2019	$1.57M
April 2019	$1.54M
March 2019	$1.53M
February 2019	$1.44M
January 2019	$1.47M
2018
December 2018	$1.44M
November 2018	$1.51M
October 2018	$1.51M
September 2018	$1.53M
August 2018	$1.45M
July 2018	$1.55M
June 2018	$1.59M
May 2018	$1.61M
April 2018	$1.43M
March 2018	$1.43M
February 2018	$1.45M
January 2018	$1.4M
2017
December 2017	$1.41M
November 2017	$1.39M
October 2017	$1.3M
September 2017	$1.25M
August 2017	$1.24M
July 2017	$1.28M
June 2017	$1.11M
May 2017	$1.09M
April 2017	$1.07M
March 2017	$1.02M
February 2017	$1.01M
January 2017	$990K
2016
December 2016	$990K
November 2016	$992K
October 2016	$972K
September 2016	$923K
August 2016	$897K

Comparable sales

These are recently sold homes that have a similar location or other similar features to this home, like bedrooms, bathrooms, and square footage. Get a sense of the expected prices in the area by viewing these homes.

Address	Distance	Property Type	Sold Price	Sold Date	Bed	Bath	Sqft
1474 C St, Hayward, CA	0.52	Single-Family Home	$1,320,000	04/21/26	5	3.5	3,492
24107 Amaranth Loop, Hayward, CA	0.04	Single-Family Home	$1,010,000	08/26/26	3	4	2,009
921 Warren St, Hayward, CA	0.78	Single-Family Home	$1,550,000	06/08/26	3	2	3,488
24498 2nd St, Hayward, CA	0.28	Single-Family Home	$799,000	11/20/25	4	2	2,838
24170 Amaranth Loop, Hayward, CA	0.19	Single-Family Home	$1,150,000	04/03/26	3	4	1,922
24185 Amaranth Loop, Hayward, CA	0.23	Single-Family Home	$1,150,000	05/05/26	3	3.5	1,922
1607 Ward St, Hayward, CA	0.51	Single-Family Home	$1,100,000	02/06/26	4	3	2,393
22843 2nd St, Hayward, CA	0.26	Single-Family Home	$530,000	05/15/26	4	3	2,000
1236 Highland Blvd, Hayward, CA	0.36	Single-Family Home	$928,000	12/04/25	3	2	1,507
1665 Highland Blvd, Hayward, CA	0.76	Single-Family Home	$1,350,000	04/27/26	5	3	2,677

Nearby home prices

Get a sense of expected prices in the area by checking the value of nearby homes.

Address	Distance	Price	Bed	Bath	Sqft	Status
1271 Walpert St, Hayward, CA 94541	0.03	$992,500	3	3	1,922	Off Market
24105 Amaranth Loop, Hayward, CA 94541	0.04	$1,048,888	3	3.5	2,009	For Sale
24107 Amaranth Loop, Hayward, CA 94541	0.04	$1,010,000	3	3	2,009	Recently Sold
24203 2nd St, Hayward, CA 94541	0.05	$1,053,400	3	3	2,009	Off Market
24207 2nd St, Hayward, CA 94541	0.06	$1,037,200	3	3.5	2,009	Off Market
1314 Antonella Pl, Hayward, CA 94541	0.07	$1,082,700	3	3.5	2,009	Off Market
24025 2nd St, Hayward, CA 94541	0.05	$939,999	3	2	2,261	For Sale
Address Not Disclosed, Hayward, CA 94541	0.07	$738,800	4	2	1,330	Off Market
Address Not Disclosed, Hayward, CA 94541	0.06	$773,500	3	2	1,138	Off Market
24035 2nd St, Hayward, CA 94541	0.07	-	26	1	14,112	Off Market
24047 Carmelita Dr, Hayward, CA 94541	0.08	$823,600	3	1	1,294	Off Market
24223 2nd St, Hayward, CA 94541	0.10	$1,097,400	3	3.5	2,009	Off Market

Local Information

Map ViewExplore the area around 24077 2nd St.
Schools1 Elementary School1 Middle School1 High School
Shop & Eat

-- mins to

Commute Destination

Home Highlights

Property Type

Single-Family Home

Year Built

1914

Lot Size

0.67 acres

Living Area

4,859 sqft

Price/Sqft

$422

Parking

Garage

About this House

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!!

24077 2nd St, Hayward, CA 94541 is a 6 bedroom, 8 bathroom, 4,859 sqft single-family home in Mission-Foothill, built in 1914. It last sold for $1,750,000 on Aug 25, 2021. This property is not currently displayed as for sale or rent on Trulia. The Trulia Estimate is $2,051,300, with a rent estimate of $5,507/month.

Home Details for 24077 2nd St

Interior Features
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 Features
Exterior Home Features Roof: Composition, Tile
Parking & Garage GarageParking: Garage Detached, Off Street

Property Information
Year Built Year Built: 1914Year Updated: 1914
Property Type / Style Property Type: Single Family HomeArchitecture: Other

Community
Units in Building: 4

Lot Information
Lot Area: 0.67 acres

Price and Tax history

Date	Event	Price
Aug 25, 2021 Source: MLSListings Inc #ML81828327	Sold	$1,750,000
Apr 27, 2021 Source: MLSListings Inc #ML81828327	Contingent	$1,875,000
Apr 27, 2021 Source: MLSListings Inc #ML81828327	Listed For Sale	$1,875,000

Year	Property tax	Tax assessment
2025	$21,752	$1,805,629

Additional Cost

Market trends in Hayward

Last updated July 2026

Avg. sale price

$863K

$11.67KMoM

Sale-to-List Price

101.3%

0.2%MoM

Price per sq ft

$585

$13MoM

Available listings

271

6MoM

Around this home

East Avenue Elementary School
K-6
Public
407 Students
Hayward Unified School District
5/10
GreatSchools Rating
Parent Rating Average
My twins have attended East Ave. since kinder and this school has been such a blessing for my sons. The teachers, staff, (Ms. Nikki/Mr. Nahal), and Principal Mr. Wilson are truly amazing and dedicated to each of the students. My sons are special needs in a mainstream class and at times have needed extra support and I have always left a meeting or event knowing East Ave. had my sons best interest for success at hand. We will miss East Ave. next year as my son's move on and just wanted to Thank East Ave. for such a great time building authentic genuine relationships we have made over the years. If you want a school that cares, offers opportunities, and supports your child's success, consider East Ave. Getting up the hill is well worth the walk, bus, or drive.
Parent Review
4y ago
6 Reviews

View nearby schools on GreatSchools

The GreatSchools Rating compares schools on a variety of school quality indicators including test scores, college readiness, equity and more. Learn more.

Neighborhood Overview

Mission-Foothill

24 Homes For You
Buy: $400k - $4.33m

See Local Highlights

Neighborhood stats provided by third party data sources.

What Locals Say about Mission-Foothill

At least 34 Trulia users voted on each feature.

79 % Say it's dog friendly
79 % Say car is needed
78 % Say there are sidewalks
67 % Say there's wildlife
56 % 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
50 % 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.

Sai Manish Reddy Nandyala
Visitor
6mo ago
"CSU East Bay campus is really good. It is well maintained and good ambience. Really good place to take a bicycle ride wherever you go. Cheers!"
0
Flag
Erwin
Resident
3y ago
"I've lived in this neighborhood for three years. It's a mix of commercial and residential. While it would be nice to have some grocery stores and other food related businesses, it's not too far of a drive from downtown. Good distance from some hiking spots with great views of the east bay too."
5
Flag
Alicia L.
Resident
6y ago
"My neighborhood has great access to shopping centers and the freeway. It also has diverse restaurants to check out and try something new"
0
Flag
knl124
Resident
7y ago
"A few young families (numbers are growing), close to some nice playgrounds. Stonebrae elementary school is nice. Area is centrally located to a lot of parks and other family-centered activities (the library, downtown, easy drive to Castro Valley)."
4
Flag
Greiner m.
Resident
7y ago
"there is alot of people that walk there dogs and they don't always pick up there. dog poop. it is so. disgusting "
0
Flag
Lucy Q.
Resident
8y ago
"I’ve lived here for almost 3 years & enjoy the nature. We have deer, wild turkeys & lots of beautiful birds, especially hummingbirds, my fav!"
13
Flag
Lucy Q.
Resident
8y ago
"I’ve lived in this area for three years almost & love the nature! We have wild turkeys & a lot of beautiful deer! The deer frequent my yard & we love it!"
5
Flag

LGBTQ Local Legal Protections

Frequently asked questions about 24077 2nd St

What is 24077 2nd St estimated to be worth?
Trulia's estimated value for 24077 2nd St in Hayward, CA is $2,051,300.
What is the price history for 24077 2nd St?
24077 2nd St in Hayward, CA last sold for $1,750,000 in August 2021.
Is Hayward a buyer's or seller's market?
Hayward is currently a seller's market, based on recent for-sale activity.
What's the median sale price in Hayward?
The median sale price in Hayward is $863K. That is up $11.67K from the prior month.
How big is the lot at 24077 2nd St?
The lot at 24077 2nd St in Hayward, CA is about 0.67 acres (28,997 sq ft).
Does 24077 2nd St have a garage?
Yes, 24077 2nd St in Hayward, CA has a garage.