NOT LISTED FOR SALE

874 Overhill Dr Hayward, CA 94544

Mission-Garin Neighborhood

Estimated Value: $2,218,000 - $2,510,487

5 Beds
5.5 Baths
6,464 Sq Ft
$361/Sq Ft Est. Value

Sale Details

Date Sold: August 18, 2025

Last sale price $2,300,000 $356 Per Sq Ft

Est. 2% increase in value since last sale

Current estimated payment $14,242 / mo

11 Days on Market

Highlights

  • Solar Power System
  • Contemporary Architecture
  • Wood Flooring
  • 37,025 Sq Ft lot
  • Private Lot
  • No HOA

About This Home

As of August 2025

Welcome 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.

Last Agent to Sell the Property

Kaajal Shahani

License #01380743 Listed on: 06/20/2025

Last Buyer's Agent

Eddie Oberoi

Intero Real Estate Services License #01323567

Intero Real Estate Services

Home Details

Home Type

  • Single Family

Year Built

  • Built in 2010

Lot Details

  • 37,025 Sq Ft 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

Home Details

Home Type

Single Family

Year Built

Built in 2010

Lot Details

0.85 Acres

Parking

4

Listing Details

  • Stories: 1
  • Year Built: 2010
  • Property Sub Type: Detached
  • Prop. Type: Residential
  • Subdivision Name: Other
  • Directions: Mission Blvd to Overhill Dr
  • Architectural Style: Contemporary
  • Garage Yn: Yes
  • Unit Levels: One Story
  • New Construction: No
  • Power Production Type: Photovoltaics
  • Special Features: None

Interior Features

  • Flooring: Hardwood, Carpet
  • Appliances: Dishwasher, Gas Range, Microwave, Range, Refrigerator
  • Full Bathrooms: 5
  • Total Bedrooms: 5
  • Fireplace Features: Brick
  • Fireplaces: 1
  • Fireplace: Yes
  • Room Kitchen Features: Stone Counters, Dishwasher, Eat-in Kitchen, Gas Range/Cooktop, Microwave, Range/Oven Built-in, Refrigerator

Exterior Features

  • Roof: Tile
  • Lot Features: Private
  • Pool Features: None
  • Pool Private: No
  • Construction Type: Stucco
  • Property Condition: Existing

Garage/Parking

  • Garage Spaces: 4
  • Parking Features: Attached

Utilities

  • Heating: Zoned
  • Cooling: Central Air
  • Laundry Features: Dryer, Laundry Room, Washer
  • Cooling Y N: Yes
  • Heating Yn: Yes
  • Electric: Photovoltaics Third-Party Owned
  • Water Source: Public

Condo/Co-op/Association

  • Association: No

Lot Info

  • Lot Size Sq Ft: 37025
  • 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
$2,334,622

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$34,622
Avg. Annual Appreciation
2.07%
Original Mortgage
$1,840,000
Outstanding Balance
$1,836,773
Interest Rate
6.67%
Mortgage Type
New Conventional
Estimated Equity
$497,849

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

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Buyer Sale Price Title Company
Singh Parm Khial $2,300,000 Fidelity National Title Compan
Catapult Custodian Llc $2,400,000 Fidelity National Title Compan
Kalyan Rajendra -- None Available
Kalyan Nickesh -- None Available
Kalyan Rajendra -- None Available
Kalyan Nickesh -- None Available
Kalyan Nickesh $243,327 Orange Coast Title
Kalyan Nickesh -- Fidelity National Title Co
Kalyan Pushpa R -- Fidelity National Title Co
Kalyan Nickesh $186,000 North American Title Company
Batteate Albert A -- North American Title Company
Batteate Henry N -- North American Title Company
Batteate Kenneth A $46,500 North American Title Company
Source: Public Records

Mortgage History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Status Borrower Loan Amount
Open Singh Parm Khial $1,840,000
Previous Owner Catapult Custodian Llc $1,375,000
Previous Owner Kalyan Nickesh $1,096,000
Previous Owner Kalyan Nickesh $1,000,000
Previous Owner Kalyan Nickesh $135,000
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

    Seller's Agent in 2025

    Kaajal Shahani

    (510) 304-6754

    3 in this area

    214 Total Sales

    Kaajal Shahani
    Section Image
  • Eddie Oberoi

    Buyer's Agent in 2025

    Eddie Oberoi

    Intero Real Estate Services

    (408) 771-4088

    1 in this area

    348 Total Sales

    Eddie Oberoi
    Section Image
See All Agents

Map

Source: Bay East Association of REALTORS®

MLS Number: 41102209

Bay East Association of REALTORS®

APN: 083-0275-005-00

California Alameda County Hayward 94544 Mission-Garin

874 Overhill Dr, Hayward, CA

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 Association of REALTORS® 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
Your Personal Tour Guide

Ask me questions while you tour the home.