NOT LISTED FOR SALE

174 Sierrawood Ave Hayward, CA 94544

Whitman-Wocine Neighborhood

Estimated Value: $1,181,000 - $1,338,000

4 Beds
2.5 Baths
2,127 Sq Ft
$582/Sq Ft Est. Value

Last Sold August 02, 2021

Last sale price $1,212,121 $570 Per Sq Ft

Est. 2% increase in value since last sale

Current estimated payment $7,892/month

3 Days on Market

Highlights

  • Contemporary Architecture
  • Granite Countertops
  • 2 Car Detached Garage
  • Vaulted Ceiling
  • Balcony
  • Open to Family Room

About This Home

As of August 2021

Welcome home to Magnolia Place! Sunlit home with a floorplan for entertaining. Remodeled kitchen and bathrooms. Kitchen has SS appliances and granite slab countertops. Recessed lighting and 2 zone AC/Heating. Wooden flooring, tile entry, vaulted ceilings. Master bedroom has ample walk-in closet. Home is situated on a greenbelt for full privacy. Walking distance to BART station. Come see for yourself all this well-maintained, tasteful remodel has to offer. Offers will be reviewed Monday, 6/28, by 1:00pm.

Last Agent to Sell the Property

Yvonne Casteel

Coldwell Banker Realty License #01410996 Listed on: 06/24/2021

Coldwell Banker Realty

Last Buyer's Agent

Elin Matter

Compass License #01332507

Home Details

Home Type

  • Single Family

Year Built

  • 2000

Lot Details

  • 3,999 Sq Ft Lot
  • Sprinklers on Timer
  • Back Yard Fenced

HOA Fees

  • $99 Monthly HOA Fees

Parking

  • 2 Car Detached Garage
  • On-Street Parking

Home Design

  • Contemporary Architecture
  • Tile Roof
  • Concrete Perimeter Foundation
  • Stucco

Interior Spaces

  • 2,127 Sq Ft Home
  • 2-Story Property
  • Vaulted Ceiling
  • Wood Burning Fireplace
  • Garden Windows
  • Combination Dining and Living Room

Kitchen

  • Open to Family Room
  • Gas Oven
  • Self-Cleaning Oven
  • Range Hood
  • Microwave
  • Freezer
  • Ice Maker
  • Dishwasher
  • Granite Countertops
  • Disposal

Flooring

  • Carpet
  • Laminate
  • Stone
  • Tile

Bedrooms and Bathrooms

  • 4 Bedrooms
  • Walk-In Closet
  • Bathroom on Main Level
  • Bidet
  • Dual Sinks
  • Dual Flush Toilets
  • Walk-in Shower

Laundry

  • Laundry in unit
  • Electric Dryer Hookup

Home Security

  • Smart Home
  • Alarm System

Outdoor Features

  • Balcony

Utilities

  • Forced Air Zoned Heating and Cooling System
  • Vented Exhaust Fan
  • 220 Volts

Community Details

  • Association fees include garbage, maintenance - common area
  • Magnolia Place Association

Home Details

Home Type

Single Family

Year Built

2000

Lot Details

3,999 Sq Ft Lot

HOA Fees

$99 per month

Parking

2

Listing Details

  • Zoning: RS
  • Subclass: Single Family Home
  • Style: Contemporary
  • Listing Class: Residential
  • Structure Sq Ft: 2127
  • Special Features: None
  • Property Sub Type: Detached
  • Year Built: 2000

Interior Features

  • Family Room: Kitchen / Family Room Combo
  • Fireplace: Wood Burning
  • Dining Room: Dining Area In Living Room
  • Kitchen: 220 Volt Outlet, Countertop - Granite, Dishwasher, Exhaust Fan, Freezer, Garbage Disposal, Hood Over Range, Ice Maker, Microwave, Oven - Self Cleaning, Oven Range - Gas, Refrigerator
  • Fireplace: Yes
  • Living Sq Ft: 2127
  • Stories: 2
  • Security: Security Alarm
  • Laundry: Electricity Hookup (110V), Inside
  • Flooring: Carpet, Laminate, Stone, Tile
  • Fireplaces Min: 1
  • Full Bathrooms: 2
  • Half Bathrooms: 1
  • Total Bedrooms: 4
  • Bathroom: Bidet, Double Sinks, Dual Flush Toilet, Half On Ground Floor, Primary - Stall Shower(s)

Exterior Features

  • Foundation: Concrete Perimeter And Slab
  • Roof: Tile
  • Yard/Grounds: Back Yard, Balcony / Patio, Fenced, Sprinklers - Auto
  • Fencing: Fenced Back, Wood
  • Construction Type: Stucco

Garage/Parking

  • Garage Spaces: 2
  • Garage Parking Features: Detached Garage, On Street

Utilities

  • Cooling System: Central Ac, Multi-Zone
  • Heating System: Central Forced Air - Gas, Heating - 2+ Zones
  • Sewer/Septic System: Sewer Connected

Condo/Co-op/Association

  • Complex Name: Magnolia Place
  • HOA Fees: 99
  • HOA Fee Frequency: Monthly
  • Association Fees Include: Garbage, Maintenance - Common Area
  • HOA Exist: Yes
  • H O A Name Text: Magnolia Place

Association/Amenities

  • Amenities Miscellaneous: Garden Window, High Ceiling, Vaulted Ceiling, Walk-In Closet

Lot Info

  • Lot Acres: 0.0918
  • Lot Size Area Minimum Units: Square Feet
  • Minimum Lot Size: 4000.00
  • Lot Size Area Maximum Units: Square Feet
  • Maximum Lot Size: 4000.00

Green Features

  • Energy Features: Smart Home System

Multi Family

  • Utilities: Public Utilities

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Jun 24, 2021
Closed on
Jul 16, 2021
Sold by
Das Sambit Kumar and Nayak Prak Smita
Bought by
Ujjwal Kumar and Baloda Meenu
Seller's Agent
Yvonne Casteel
Coldwell Banker Realty
Buyer's Agent
Elin Matter
Compass
List Price
$1,050,000
Sold Price
$1,212,121
Premium/Discount to List
$162,121
15.44%
Current Estimated Value
$1,238,950

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$26,829
Avg. Annual Appreciation
0.47%
Original Mortgage
$940,000
Outstanding Balance
$845,797
Interest Rate
2.37%
Mortgage Type
New Conventional
Estimated Equity
$393,153

Purchase Details

Closed on
May 16, 2016
Sold by
Singh Jitender P and Kaur Indeep
Bought by
Das Sambit Kumar and Nayak Prak Smita

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$596,000
Interest Rate
3.5%
Mortgage Type
Adjustable Rate Mortgage/ARM

Purchase Details

Closed on
Sep 13, 2013
Sold by
Sharma Satya Prakash
Bought by
Singh Jitender P and Kaur Indeep

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$465,600
Interest Rate
3.75%
Mortgage Type
Adjustable Rate Mortgage/ARM

Purchase Details

Closed on
May 17, 2013
Sold by
Coker Elston L and Coker Jessie
Bought by
Sharma Satya Prakash

Purchase Details

Closed on
Apr 5, 2005
Sold by
Coker Elston L
Bought by
Coker Elston L and Coker Jessie

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$550,000
Interest Rate
1%
Mortgage Type
Negative Amortization

Purchase Details

Closed on
Apr 12, 2004
Sold by
Coker Elston L and Coker Jessie L
Bought by
Coker Elston L

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$100,000
Interest Rate
5.35%
Mortgage Type
Credit Line Revolving

Purchase Details

Closed on
Jun 13, 2001
Sold by
Frias Moises and Frias Adrianna
Bought by
Coker Elston L and Coker Jessie L

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$390,400
Interest Rate
7.15%

Purchase Details

Closed on
Feb 13, 2001
Sold by
First American Title Guaranty Company
Bought by
Frias Moises and Frias Adriana

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$319,150
Interest Rate
7.08%
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

Date Buyer Sale Price Title Company
Ujjwal Kumar $1,212,500 Old Republic Title Company
Das Sambit Kumar $745,000 Old Republic Title Company
Singh Jitender P $582,000 First American Title Company
Sharma Satya Prakash -- First American Title Company
Sharma Satya Prakash $400,000 First American Title Company
Coker Elston L -- First California Title Co
Coker Elston L -- Commonwealth Land Title Co
Coker Elston L $488,000 Chicago Title Co
Frias Moises $456,000 First American Title Guarant
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Ujjwal Kumar $940,000
Previous Owner Das Sambit Kumar $596,000
Previous Owner Singh Jitender P $465,600
Previous Owner Coker Elston L $550,000
Previous Owner Coker Elston L $100,000
Previous Owner Coker Elston L $390,400
Previous Owner Frias Moises $319,150
Closed Coker Elston L $13,500
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft
08/02/2021 08/02/21 Sold $1,212,121 +15.4% $570 / Sq Ft
06/28/2021 06/28/21 Pending -- -- --
06/24/2021 06/24/21 For Sale $1,050,000 -- $494 / Sq Ft
Source: MLSListings

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 $15,311 $1,286,280 $385,884 $900,396
2024 $15,311 $1,261,068 $378,320 $882,748
2023 $15,081 $1,236,341 $370,902 $865,439
2022 $14,783 $1,212,100 $363,630 $848,470
2021 $10,086 $807,754 $244,426 $570,328
2020 $9,972 $806,402 $241,920 $564,482
2019 $10,054 $790,593 $237,178 $553,415
2018 $9,422 $775,097 $232,529 $542,568
2017 $9,199 $759,900 $227,970 $531,930
2016 $7,075 $602,677 $180,803 $421,874
2015 $6,931 $593,627 $178,088 $415,539
2014 $6,577 $582,000 $174,600 $407,400
Source: Public Records

Agents Affiliated with this Home

  • Y

    Seller's Agent in 2021

    Yvonne Casteel

    Coldwell Banker Realty

    Section Image

  • E

    Buyer's Agent in 2021

    Elin Matter

    Compass

See All Agents

Map

Source: MLSListings

MLS Number: ML81850640

MLSListings

APN: 452-0086-099-00

California Alameda County Hayward 94544 Whitman-Wocine

174 Sierrawood Ave, Hayward, CA

Not Listed for Sale

Detached

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.

MLSListings Property Information © 2026 MLSListings Inc. All rights reserved. Listing information is deemed reliable but not guaranteed. Certain information contained herein is derived from information which is the licensed property of, and copyrighted by, MLSListings Inc. The viewer acknowledges ownership and validity of its copyright. Information provided is for personal, non-commercial use by a viewer with a bona fide interest in the purchase or sale of real estate of the type being offered via this website or other electronic means. The viewer is prohibited from copying, redistributing or retransmitting any of the data or information provided by MLSListing, Inc.

Nearby Homes
Your Personal Tour Guide

Ask me questions while you tour the home.