NOT LISTED FOR SALE

Estimated Value: $1,833,000 - $2,028,865

5 Beds
3.5 Baths
3,750 Sq Ft
$511/Sq Ft Est. Value

Last Sold December 17, 2024

Last sale price $1,900,000 $507 Per Sq Ft

Est. 1% decrease in value since last sale

Current estimated payment $11,647/month

39 Days on Market

Highlights

  • Custom Home
  • Updated Kitchen
  • Stone Countertops
  • City Lights View
  • Family Room with Fireplace
  • Cooling Available

About This Home

As of December 2024

Prepare to be captivated by the stunning bay views & breathtaking sunsets at this exquisite custom-built residence nestled in the prestigious Clearbrook community. As you enter, you are greeted by a grand foyer that flows seamlessly into a formal dining room, spacious living area features a cozy fireplace, a private home office and a Jr ensuite. A gourmet kitchen is a chef's dream, equipped with top-of-the-line appliances & ample counter space leading into the family room & breakfast nook. The home boasts 5 generously sized bedrooms designed to maximize the stunning views and three and a half bathrooms. The primary suite is a serene retreat, complete with a luxurious bathroom w/jacuzzi overlooking bay views. Addt'l amenities incl a game room, perfect for entertainment, and a laundry room with a washer/dryer. Step outside to your private outdoor space w/hot tub, an ideal setting for alfresco dining or weekend BBQ’s. The property also includes a three car garage and ample parking. Situated just off Mission Blvd (Hwy 238), this home offers easy access to major freeways including 880, 580, 680, the 84 Dumbarton Bridge, and the 92 San Mateo Bridge. Home is also conveniently close to Garin/Dry Creek Pioneer Regional Park, CSU-East Bay and South Hayward Bart. A must see!

Last Agent to Sell the Property

Diem Nguyen

Compass License #01229155 Listed on: 09/27/2024

Compass

Co-Listed By

Nina Sidhu

Compass License #01817079

Last Buyer's Agent

Gursant Ghuman

Homesmart Icare Realty License #02148617

Homesmart Icare Realty

Home Details

Home Type

  • Single Family

Year Built

  • Built in 2005

Lot Details

  • 10,059 Sq Ft Lot
  • Lot Sloped Up
  • Front Yard

HOA Fees

  • $245 Monthly HOA Fees

Parking

  • 3 Car Garage
  • Garage Door Opener

Property Views

  • City Lights
  • Hills

Home Design

  • Custom Home
  • Contemporary Architecture
  • Tile Roof
  • Stone Siding
  • Stucco

Interior Spaces

  • Multi-Level Property
  • Raised Hearth
  • Self Contained Fireplace Unit Or Insert
  • Fireplace With Gas Starter
  • Stone Fireplace
  • Family Room with Fireplace
  • 2 Fireplaces
  • Living Room with Fireplace
  • Carpet

Kitchen

  • Updated Kitchen
  • Breakfast Bar
  • Built-In Self-Cleaning Oven
  • Built-In Range
  • Dishwasher
  • Stone Countertops
  • Disposal

Bedrooms and Bathrooms

  • 5 Bedrooms

Laundry

  • Dryer
  • Washer
  • 220 Volts In Laundry

Utilities

  • Cooling Available
  • Zoned Heating
  • Thermostat
  • 220 Volts in Kitchen

Community Details

  • Association fees include common area maintenance, exterior maintenance, management fee, ground maintenance
  • Clearbrook Association, Phone Number (510) 896-2663
  • Clearbrook Subdivision, Custom Floorplan

Listing and Financial Details

  • Assessor Parcel Number 8346325

Home Details

Home Type

Single Family

Year Built

Built in 2005

Lot Details

10,059 Sq Ft Lot

HOA Fees

$245 per month

Parking

3

Listing Details

  • Year Built: 2005
  • Property Sub Type: Detached
  • Prop. Type: Residential
  • Co List Office Mls Id: SPSP08
  • Subdivision Name: Clearbrook
  • Directions: Mission to Garin to Clearbrook Cir to Silver Birch
  • Architectural Style: Contemporary, Custom
  • Garage Yn: Yes
  • Unit Levels: Multi/Split
  • New Construction: No
  • Efficiency: Thermostat
  • Special Features: VirtualTour

Interior Features

  • Flooring: Carpet
  • Appliances: Dishwasher, Gas Range, Oven, Range, Refrigerator, Self Cleaning Oven, Dryer, Washer
  • Full Bathrooms: 3
  • Total Bedrooms: 5
  • Fireplace Features: Family Room, Insert, Gas Starter, Living Room, Raised Hearth, Stone
  • Fireplaces: 2
  • Fireplace: Yes
  • Window Features: Window Coverings
  • Room Kitchen Features: 220 Volt Outlet, Breakfast Bar, Counter - Solid Surface, Counter - Stone, Dishwasher, Garbage Disposal, Gas Range/Cooktop, Oven Built-in, Pantry, Range/Oven Built-in, Refrigerator, Self-Cleaning Oven, Updated Kitchen

Exterior Features

  • Roof: Tile
  • Lot Features: Premium Lot, Sloped Up, Front Yard
  • Pool Features: None
  • Pool Private: No
  • View: City Lights, Hills
  • Construction Type: Stone, Stucco
  • Property Condition: Existing

Garage/Parking

  • Garage Spaces: 3
  • Parking Features: Garage Door Opener

Utilities

  • Heating: Zoned
  • Cooling: Ceiling Fan(s)
  • Laundry Features: 220 Volt Outlet, Dryer, Washer, Cabinets
  • Cooling Y N: Yes
  • Heating Yn: Yes
  • Electric: No Solar, 220 Volts in Kitchen

Condo/Co-op/Association

  • Amenities: Other
  • Association Fee: 245
  • Association Fee Frequency: Monthly
  • Association Name: CLEARBROOK
  • Phone: 510-896-2663
  • Association: Yes

Fee Information

  • Association Fee Includes: Common Area Maint, Exterior Maintenance, Management Fee, Maintenance Grounds

Schools

  • Senior High School District: Hayward (510) 784-2600

Lot Info

  • Lot Size Sq Ft: 10059
  • Parcel Number: 8346325

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Sep 27, 2024
Closed on
Dec 13, 2024
Sold by
Jhaveri Nailesh B
Bought by
Khivansara Revathi S
Seller's Agent
Diem Nguyen
Compass
Buyer's Agent
Gursant Ghuman
Homesmart Icare Realty
List Price
$1,988,000
Sold Price
$1,900,000
Premium/Discount to List
-$88,000
-4.43%
Views
50
Current Estimated Value
$1,886,864

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
-$13,136
Avg. Annual Appreciation
0.60%
Original Mortgage
$1,520,000
Outstanding Balance
$1,507,884
Interest Rate
6.72%
Mortgage Type
New Conventional
Estimated Equity
$406,582

Purchase Details

Listed on
Sep 27, 2024
Closed on
Dec 12, 2024
Sold by
Rd And M Chen Family Trust and Chen Rong-Dyi
Bought by
Khivansara Revathi S
Seller's Agent
Diem Nguyen
Compass
Buyer's Agent
Gursant Ghuman
Homesmart Icare Realty
List Price
$1,988,000
Sold Price
$1,900,000
Premium/Discount to List
-$88,000
-4.43%
Views
50

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$1,520,000
Outstanding Balance
$1,507,884
Interest Rate
6.72%
Mortgage Type
New Conventional
Estimated Equity
$406,582

Purchase Details

Closed on
Jun 23, 2020
Sold by
Chen Rong Dyi and Chen Mary W
Bought by
Chen Rong Dyi and Chen Mary W

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$360,000
Interest Rate
3.2%
Mortgage Type
New Conventional

Purchase Details

Closed on
May 15, 2017
Sold by
Castelo Cesar Santos and Caffey Michael Edward
Bought by
Rd & M Chen Family Trust

Purchase Details

Closed on
Apr 18, 2015
Sold by
Castelo Cesar S and Caffey Michael E
Bought by
Revoc Michael E Caffey and Revoc Cesar S Castelo

Purchase Details

Closed on
May 26, 2010
Sold by
The Bank Of New York Mellon
Bought by
Castelo Cesar S and Caffey Michael E

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$570,000
Interest Rate
4.91%
Mortgage Type
New Conventional

Purchase Details

Closed on
Jan 5, 2010
Sold by
Lai Randy Hai and Lai Mimi
Bought by
The Bank Of New York Mellon and The Bank Of New York

Purchase Details

Closed on
Jun 20, 2005
Sold by
Nguyen Buu Ngoc
Bought by
Lai Randy Hai and Lai Mimi

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$999,999
Interest Rate
5.65%
Mortgage Type
Fannie Mae Freddie Mac

Purchase Details

Closed on
Oct 23, 2003
Sold by
Tran Lan
Bought by
Nguyen Buu Ngoc

Purchase Details

Closed on
May 3, 2002
Sold by
Nguyen Buu Ngoc
Bought by
Tran Lan

Purchase Details

Closed on
Dec 21, 2000
Sold by
Nguyen Buu Ngoc
Bought by
Tran Lan

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$123,000
Interest Rate
7.81%
Mortgage Type
Balloon

Purchase Details

Closed on
Dec 18, 2000
Sold by
Oak Hills Enterprises
Bought by
Nguyen Buu Ngoc

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$123,000
Interest Rate
7.81%
Mortgage Type
Balloon

Purchase Details

Closed on
Nov 22, 2000
Sold by
Tran Hong Thi
Bought by
Nguyen Buu Ngoc

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$123,000
Interest Rate
7.81%
Mortgage Type
Balloon

Purchase Details

Closed on
Aug 10, 1999
Sold by
Standard Pacific Corp
Bought by
Oak Hills Enterprises
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
Khivansara Revathi S -- Wfg National Title Insurance C
Khivansara Revathi S $1,900,000 Wfg National Title Insurance C
Chen Rong Dyi -- Chicago Title Company
Chen Rong Dyi -- Chicago Title Company
Rd & M Chen Family Trust $1,215,000 Chicago Title Company
Revoc Michael E Caffey -- None Available
Castelo Cesar S $801,000 Landsafe Title
The Bank Of New York Mellon $629,000 Landsafe Title
Lai Randy Hai $1,465,000 Chicago Title Co
Nguyen Buu Ngoc -- --
Tran Lan -- --
Tran Lan -- --
Nguyen Buu Ngoc $160,000 Chicago Title Co
Nguyen Buu Ngoc -- Chicago Title Co
Oak Hills Enterprises $50,000 Chicago Title Co
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Khivansara Revathi S $1,520,000
Previous Owner Chen Rong Dyi $360,000
Previous Owner Castelo Cesar S $570,000
Previous Owner Lai Randy Hai $999,999
Previous Owner Nguyen Buu Ngoc $123,000
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft
02/04/2025 02/04/25 Off Market $1,898,000 -- --
12/17/2024 12/17/24 Sold $1,900,000 +0.1% $507 / Sq Ft
11/05/2024 11/05/24 Pending -- -- --
10/16/2024 10/16/24 Price Changed $1,898,000 -4.5% $506 / Sq Ft
09/27/2024 09/27/24 For Sale $1,988,000 -- $530 / 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 $16,666 $1,893,000 $570,000 $1,330,000
2024 $16,666 $1,375,438 $414,731 $967,707
2023 $16,429 $1,355,331 $406,599 $948,732
2022 $16,170 $1,328,760 $398,628 $930,132
2021 $16,040 $1,302,710 $390,813 $911,897
2020 $15,858 $1,289,357 $386,807 $902,550
2019 $15,993 $1,264,085 $379,225 $884,860
2018 $14,977 $1,239,300 $371,790 $867,510
2017 $11,365 $890,855 $267,256 $623,599
2016 $11,187 $873,394 $262,018 $611,376
2015 $10,957 $860,281 $258,084 $602,197
2014 $10,887 $843,436 $253,031 $590,405
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
  • Section Image
See All Agents

Map

Source: Bay East Association of REALTORS®

MLS Number: 41074749

Bay East Association of REALTORS®

APN: 083-0463-025-00

Your Personal Tour Guide

Ask me questions while you tour the home.