NOT LISTED FOR SALE

Estimated Value: $2,355,000 - $2,822,000

4 Beds
4.5 Baths
4,674 Sq Ft
$561/Sq Ft Est. Value

Last Sold August 30, 2022

Last sale price $2,620,000 $561 Per Sq Ft

Current estimated payment $16,919/month

1 Day on Market

Highlights

  • Golf Course Community
  • Clubhouse
  • Contemporary Architecture
  • Gated Community
  • Fireplace in Primary Bedroom
  • Wood Flooring

About This Home

As of August 2022

Positioned within a 24 hour guard-gated enclave of luxurious estate style residences, 28 Stirling is one of the most exquisite homes in the exclusive & secluded TPC Golf Course community of Stonebrae! Sparing no expense, incomparable attention to detail was masterfully accomplished in the design, with lavish upgrades including an impressive backyard with California room, built-in grill, hot tub, patio with firepit, & two terraces in which to enjoy the bay views! Largest & most desirable floorplan in Stonebrae with 4,678 sq. ft, 4 bedrooms, 4 full bathrooms, a den, & powder room. Of the bedrooms, TWO are primary suites with one on the lower level & one on the upper level! Perfect for multi-generational living/au pair! Open & flowing floorplan featuring a formal dining room, chef's kitchen with secondary dining area & serving nook, & upstairs loft that is perfect for media/game room! Enjoy Stonebrae Country Club amenities & Stonebrae Elementary! 3d tour @ www.28Stirling.com/mls.

Last Agent to Sell the Property

Julienne Courtney

License #01376948 Listed on: 07/26/2022

Last Buyer's Agent

Lily Do

Compass License #01728793

Compass

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $32,619

Year Built

  • Built in 2016

Lot Details

  • 0.27 Acre Lot
  • Fenced
  • Landscaped
  • Terraced Lot
  • Garden
  • Back and Front Yard

HOA Fees

  • $220 Monthly HOA Fees

Parking

  • 3 Car Attached Garage
  • Garage Door Opener

Home Design

  • Contemporary Architecture
  • Stucco

Interior Spaces

  • 2-Story Property
  • Two Way Fireplace
  • Living Room with Fireplace
  • 2 Fireplaces
  • Den
  • Wood Flooring
  • Security Gate
  • Gas Range

Bedrooms and Bathrooms

  • 4 Bedrooms
  • Fireplace in Primary Bedroom

Utilities

  • Zoned Heating and Cooling
  • Heating System Uses Natural Gas

Listing and Financial Details

  • Assessor Parcel Number 85A644189

Community Details

Overview

  • Association fees include security/gate fee
  • Stonebrae Country Club Association, Phone Number (925) 830-4848
  • Stonebrae Country Club Subdivision
  • Greenbelt

Recreation

  • Golf Course Community
  • Tennis Courts
  • Community Pool
  • Pool Membership Available
  • Trails

Additional Features

  • Clubhouse
  • Gated Community

Home Details

Home Type

Single Family

Est. Annual Taxes

$32,619

Year Built

Built in 2016

Lot Details

0

HOA Fees

$220 per month

Parking

3

Listing Details

  • Stories: 2
  • Year Built: 2016
  • Property Sub Type: Single Family Residence
  • Prop. Type: Residential
  • Lot Size Acres: 0.27
  • Subdivision Name: STONEBRAE COUNTRY CLUB
  • Directions: 28 Stirling Way Hayward on GPS
  • Architectural Style: Contemporary
  • Carport Y N: No
  • Garage Yn: Yes
  • Unit Levels: Two Story
  • New Construction: No
  • ResoPropertyType: Residential
  • ResoBuildingAreaSource: PublicRecords
  • Special Features: None

Interior Features

  • Flooring: Wood
  • Appliances: Gas Range
  • Full Bathrooms: 4
  • Total Bedrooms: 4
  • Fireplace Features: Living Room, Master Bedroom, Two-Way
  • Fireplaces: 2
  • Fireplace: Yes
  • Interior Amenities: Den
  • Window Features: Window Coverings
  • Room Kitchen Features: Gas Range/Cooktop

Exterior Features

  • Fencing: Fenced
  • Lot Features: Level, Landscape Back
  • Pool Features: Membership (Optional), Community
  • Pool Private: No
  • Construction Type: Stucco
  • Exterior Features: Backyard, Back Yard, Front Yard, Garden/Play, Terraced Back, Landscape Back, Landscape Front
  • Property Condition: Existing

Garage/Parking

  • Garage Spaces: 3
  • Attached Garage: Yes
  • Covered Parking Spaces: 3
  • Parking Features: Attached, Garage Door Opener

Utilities

  • Heating: Zoned, Natural Gas
  • Utilities: All Public Utilities
  • Cooling: Zoned
  • Laundry Features: Laundry Room
  • Security: Gated with Guard, Secured Access, Security Gate
  • Cooling Y N: Yes
  • Heating Yn: Yes
  • Electric: No Solar
  • Sewer: Public Sewer
  • Water Source: Public

Condo/Co-op/Association

  • Amenities: Clubhouse, Golf Course, Greenbelt, Playground, Pool, Gated, Tennis Court(s), Trail(s)
  • Association Fee: 220
  • Association Fee Frequency: Monthly
  • Association Name: STONEBRAE COUNTRY CLUB
  • Phone: 925-830-4848
  • Association: Yes
  • ResoAssociationFeeFrequency: Monthly

Fee Information

  • Association Fee Includes: Security/Gate Fee

Lot Info

  • Lot Size Sq Ft: 11699
  • Parcel Number: 85A644189
  • ResoLotSizeUnits: Acres

Ownership History

Date Name Owned For Owner Type

Purchase Details

Closed on
May 6, 2025
Sold by
Smith Michael W and Smith Sanae
Bought by
Smith Living Trust and Smith
Current Estimated Value
$2,624,205

Purchase Details

Listed on
Jul 26, 2022
Closed on
Aug 5, 2022
Sold by
Gaskill Charley and Gaskill Michelle
Bought by
Smith Michael W and Smith Sanae
Seller's Agent
Julienne Courtney
Buyer's Agent
Lily Do
Compass
List Price
$2,620,000
Sold Price
$2,620,000
Views
8

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
1.80%
Original Mortgage
$1,500,000
Interest Rate
5.51%
Mortgage Type
Balloon

Purchase Details

Closed on
Sep 17, 2018
Sold by
Gaskill Hames Michelle J and Hames Charley
Bought by
Hames Charley and Gaskill Hames Michelle J

Purchase Details

Closed on
Sep 13, 2016
Sold by
Meritage Homes Of California Inc
Bought by
Gaskill Hames Michelle J and Hames Charley

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$1,251,864
Interest Rate
3.47%
Mortgage Type
New Conventional

Purchase Details

Closed on
Feb 17, 2005
Sold by
Stonebrae Lp
Bought by
Meritage Homes Of California Inc
Source: Public Records

Range of Values:

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

Date Buyer Sale Price Title Company
Smith Living Trust -- None Listed On Document
Smith Michael W $2,620,000 Chicago Title
Hames Charley -- None Available
Gaskill Hames Michelle J $1,565,000 Old Republic Title Company
Meritage Homes Of California Inc $5,250,000 Old Republic Title Company
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Previous Owner Smith Michael W $1,500,000
Previous Owner Gaskill Hames Michelle J $1,251,864
Previous Owner Meritage Homes Of California Inc $0
Previous Owner Meritage Homes Of California Inc $0
Closed Meritage Homes Of California Inc $0
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
02/04/2025 02/04/25 Off Market $2,620,000 -- --
08/30/2022 08/30/22 Sold $2,620,000 0.0% $561 / Sq Ft
07/27/2022 07/27/22 Pending -- -- --
07/26/2022 07/26/22 For Sale $2,620,000 -- $561 / Sq Ft
Source: Bay East Association of REALTORS®

Tax History Compared to Growth

Source: Public Records

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 $32,619 $2,725,847 $817,754 $1,908,093
2024 $32,619 $2,672,400 $801,720 $1,870,680
2023 $32,094 $2,620,000 $786,000 $1,834,000
2022 $21,231 $1,711,311 $625,665 $1,085,646
2021 $21,042 $1,677,762 $613,399 $1,064,363
2020 $20,789 $1,660,565 $607,112 $1,053,453
2019 $20,918 $1,628,017 $595,212 $1,032,805
2018 $19,540 $1,596,096 $583,542 $1,012,554
2017 $19,025 $1,564,800 $572,100 $992,700
2016 $959 $61,100 $61,100 $0
Source: Public Records

Agents Affiliated with this Home

  • Section Image
See All Agents

Map

Source: Bay East Association of REALTORS®

MLS Number: 41003109

Bay East Association of REALTORS®

APN: 085A-6441-089-00