Seller's Agent in 2025
Kaajal Shahani
(510) 304-6754
3 in this area
227 Total Sales
874 Overhill Dr Hayward, CA 94544
Mission-Garin Neighborhood
5
Beds
5.5
Baths
6,464
Sq Ft
37,025
Sq Ft Lot
Highlights
- Solar Power System
- Contemporary Architecture
- Wood Flooring
- 37,025 Sq Ft lot
- Private Lot
- No HOA
About This Home
As of August 2025Welcome to your private hillside retreat with panoramic views worth a million dollars, your own slice of country tucked into the heart of the Bay Area. Set on nearly an acre, this expansive 5-bedroom, 5.5-bath estate offers over 6,400 square feet of beautifully designed living space. Inside, you’ll find a formal dining room perfect for entertaining, a cozy living room, a sunken family room with a fireplace and built-in bar. The chef’s kitchen features stainless steel appliances, walk-in pantry, abundant counter space, and two skylights that flood the space with natural light. The home features two luxurious master suites each with its own full bath plus three additional bedrooms, all with ensuite bathrooms for ultimate comfort and privacy. Work from home in the oversized open office space, recharge in the private gym, and enjoy everyday convenience with a dedicated laundry room, utility rooms, and an attached 6-car garage. Individual temp controls for each room, central vacuum throughout the home. Whether you're hosting guests or just enjoying the tranquil surroundings, this property offers a rare blend of peaceful living and city proximity.
Home Details
Home Type
- Single Family
Year Built
- Built in 2010
Lot Details
- 0.85 Acre Lot
- Private Lot
Parking
- 4 Car Attached Garage
Home Design
- Contemporary Architecture
- Tile Roof
- Stucco
Interior Spaces
- 1-Story Property
- Brick Fireplace
Kitchen
- Built-In Range
- Microwave
- Dishwasher
Flooring
- Wood
- Carpet
Bedrooms and Bathrooms
- 5 Bedrooms
Laundry
- Dryer
- Washer
Eco-Friendly Details
- Solar Power System
- Solar owned by a third party
Utilities
- Zoned Heating and Cooling System
Community Details
- No Home Owners Association
Listing and Financial Details
- Assessor Parcel Number 832755
Ownership History
Date
Name
Owned For
Owner Type
Purchase Details
Listed on
Jun 20, 2025
Closed on
Jul 24, 2025
Sold by
Catapult Custodian Llc
Bought by
Singh Parm Khial and Saini Sukhjit
Seller's Agent
Kaajal Shahani
Buyer's Agent
Eddie Oberoi
Intero Real Estate Services
List Price
$2,399,000
Sold Price
$2,300,000
Premium/Discount to List
-$99,000
-4.13%
Views
20
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
$14,568
Avg. Annual Appreciation
4.38%
Original Mortgage
$1,840,000
Outstanding Balance
$1,836,773
Interest Rate
6.67%
Mortgage Type
New Conventional
Estimated Equity
$521,129
Purchase Details
Closed on
May 13, 2025
Sold by
Rp Kalyan Revocable Trust and Nickesh Kalyan
Bought by
Catapult Custodian Llc
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$1,375,000
Interest Rate
6.62%
Mortgage Type
New Conventional
Purchase Details
Closed on
Aug 4, 2020
Sold by
Kalyan Nickesh and Kalyan Hinal
Bought by
Kalyan Rajendra and Kalyan Puspha
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$1,096,000
Interest Rate
3%
Mortgage Type
Purchase Money Mortgage
Purchase Details
Closed on
Nov 3, 2011
Sold by
Kalyan Pushpa
Bought by
Kalyan Rajendra and Kalyan Pushpa
Purchase Details
Closed on
Sep 26, 2007
Sold by
Kalyan Nickesh and Kalyan Pushpa R
Bought by
Kalyan Nickesh and Kalyan Hinal
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$1,000,000
Interest Rate
6.46%
Mortgage Type
Construction
Purchase Details
Closed on
Jan 10, 2005
Sold by
Kalyan Hinal
Bought by
Kalyan Nickesh
Purchase Details
Closed on
Jan 6, 2005
Sold by
Kalyan Rajindra
Bought by
Kalyan Pushpa R
Purchase Details
Closed on
Feb 7, 2003
Sold by
Batteate Kenneth A and Batteate Henry N
Bought by
Kalyan Nickesh
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$135,000
Interest Rate
6.95%
Mortgage Type
Balloon
Purchase Details
Closed on
Dec 4, 2002
Sold by
Batteate Allison
Bought by
Batteate Albert A
Purchase Details
Closed on
Oct 7, 2002
Sold by
Batteate Ronald and Batteate Tammy
Bought by
Batteate Kenneth A
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
| Date | Type | Sale Price | Title Company |
|---|---|---|---|
| Grant Deed | $2,300,000 | Fidelity National Title Compan | |
| Grant Deed | $2,400,000 | Fidelity National Title Compan | |
| Warranty Deed | -- | None Available | |
| Warranty Deed | -- | None Available | |
| Interfamily Deed Transfer | -- | None Available | |
| Interfamily Deed Transfer | -- | None Available | |
| Grant Deed | $243,327 | Orange Coast Title | |
| Interfamily Deed Transfer | -- | Fidelity National Title Co | |
| Interfamily Deed Transfer | -- | Fidelity National Title Co | |
| Individual Deed | $186,000 | North American Title Company | |
| Interfamily Deed Transfer | -- | North American Title Company | |
| Interfamily Deed Transfer | -- | North American Title Company | |
| Interfamily Deed Transfer | $46,500 | North American Title Company |
Source: Public Records
Mortgage History
| Date | Status | Loan Amount | Loan Type |
|---|---|---|---|
| Open | $1,840,000 | New Conventional | |
| Previous Owner | $1,375,000 | New Conventional | |
| Previous Owner | $1,096,000 | Purchase Money Mortgage | |
| Previous Owner | $1,000,000 | Construction | |
| Previous Owner | $135,000 | Balloon |
Source: Public Records
Property History
| Date | Event | Price | List to Sale | Price per Sq Ft |
|---|---|---|---|---|
| 08/18/2025 08/18/25 | Sold | $2,300,000 | -4.1% | $356 / Sq Ft |
| 07/01/2025 07/01/25 | Pending | -- | -- | -- |
| 06/20/2025 06/20/25 | For Sale | $2,399,000 | -- | $371 / Sq Ft |
Source: Bay East Association of REALTORS®
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,343 | $1,805,631 | $450,365 | $1,355,266 |
| 2024 | $21,343 | $1,770,237 | $441,536 | $1,328,701 |
| 2023 | $21,020 | $1,735,532 | $432,881 | $1,302,651 |
| 2022 | $20,603 | $1,701,509 | $424,394 | $1,277,115 |
| 2021 | $20,437 | $1,668,159 | $416,076 | $1,252,083 |
| 2020 | $20,204 | $1,651,063 | $411,811 | $1,239,252 |
| 2019 | $20,378 | $1,618,694 | $403,739 | $1,214,955 |
| 2018 | $19,076 | $1,586,965 | $395,824 | $1,191,141 |
| 2017 | $18,619 | $1,555,854 | $388,065 | $1,167,789 |
| 2016 | $17,612 | $1,525,356 | $380,457 | $1,144,899 |
| 2015 | $17,245 | $1,502,454 | $374,744 | $1,127,710 |
| 2014 | $16,343 | $1,473,035 | $367,406 | $1,105,629 |
Source: Public Records
Agents Affiliated with this Home
-
Kaajal Shahani
-
Eddie Oberoi
Buyer's Agent in 2025
Eddie Oberoi
Intero Real Estate Services
(408) 771-4088
1 in this area
343 Total Sales
Map
Source: Bay East Association of REALTORS®
MLS Number: 41102209
APN: 083-0275-005-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.
Bay East ©2026. CCAR ©2026. bridgeMLS ©2026. Information Deemed Reliable But Not Guaranteed. This information is being provided by the Bay East MLS, or CCAR MLS, or bridgeMLS. The listings presented here may or may not be listed by the Broker/Agent operating this website. This information is intended for the personal use of consumers and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing.
Nearby Homes
- 680 Dartmore Ln Unit 260
- 685 Dartmore Ln Unit 165
- 685 Dartmore Ln Unit 365
- 673 Royston Ln Unit 233
- 729 Delve Ct
- 675 Delve Ct
- 28957 Ashwell Ave
- 28961 Hideaway St
- 29583 Vanderbilt St Unit 310
- 28968 Parkridge Loop Unit 117
- 27260 Cosmo Ct
- 27277 Cosmo Ct
- 807 Maybeck Place
- 27261 Cosmo Ct
- 806 Maybeck Place
- 802 Maybeck Place
- 28837 Hideaway St
- 28954 Parkwood Ln Unit 66
- 500 Somi Ct Unit 314
- 500 Somi Ct Unit 214
Your Personal Tour Guide
Ask me questions while you tour the home.