NOT LISTED FOR SALE

47592 Avalon Heights Terrace Fremont, CA 94539

Weibel Neighborhood

Estimated Value: $4,170,000 - $5,163,000

5 Beds
4.5 Baths
4,750 Sq Ft
$1,013/Sq Ft Est. Value

Last Sold September 28, 2023

Last sale price $4,020,000 $846 Per Sq Ft

Est. 20% increase in value since last sale

Current estimated payment $30,813/month

Highlights

  • 0.63 Acre Lot
  • Fireplace in Primary Bedroom
  • Separate Family Room
  • James Leitch Elementary School Rated A
  • Forced Air Zoned Heating and Cooling System
  • Dining Area

About This Home

As of February 2024

Absolutely gorgeous ! Welcome to this amazing Avalon Heights home surrounded by rolling hillsides within an exclusive 24/7 gated/guarded community ~ Dramatic architecture and highly desirable floor plan will positively take your breath away! ~ Built in 2000~ It boasts 5 bedrooms, 1 office/ bonus room & 4.5 bathrooms, which includes a master suite, a junior suite, a large downstairs in-law suite plus 4 car garage ~ Sweeping high ceilings & large picture windows in the living room survey the breathtaking surrounding nature & invite copious amounts of natural light for an open and bright atmosphere ~Enormous backyard showcases breathtaking view, professionally designed landscape, numerous plants & fruit trees, a waterfall & Lily pond perfect for relaxing & entertaining~ The lavish master suite offers sitting area/retreat w. romantic fireplace, luxurious bath w. double vanity, stall shower, jetted sunken tub, nice view ~ Prepare & share meals in the warm and welcoming gourmet chef’s kitchen, which has a cozy breakfast nook & splendid views of the backyard ~ Excellent schools, close to shopping, restaurants,680,880 Hwy, Warm Springs BART~ Easy commute to Silicon Valley & Peninsula ~In pristine condition ~ Hurry! Don’t miss out on this dream home!

Last Agent to Rent the Property

Cindy Liu

Starriver Inc License #01458200 Listed on: 12/06/2023

Last Renter's Agent

Cindy Liu

Starriver Inc License #01458200 Listed on: 12/06/2023

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $46,363

Year Built

  • 2000

Lot Details

  • 0.63

HOA Fees

  • $327 per month

Parking

  • 4 Car Garage

Interior Spaces

  • 4,750 Sq Ft Home
  • 2-Story Property
  • Fireplace With Gas Starter
  • Separate Family Room
  • Living Room with Fireplace
  • 2 Fireplaces
  • Dining Area

Bedrooms and Bathrooms

  • 5 Bedrooms
  • Fireplace in Primary Bedroom

Additional Features

  • 0.63 Acre Lot
  • Forced Air Zoned Heating and Cooling System

Listing and Financial Details

  • Security Deposit $7,800
  • Property Available on 12/6/23
  • 12-Month Minimum Lease Term

Home Details

Home Type

Single Family

Est. Annual Taxes

$46,363

Year Built

2000

Lot Details

0

HOA Fees

$327 per month

Parking

4

Rental Info

  • Available: 12/06/2023
  • Minimum Lease Months: 12
  • Security Deposit: 7800

Listing Details

  • Subclass: House For Rent
  • Age: 23
  • Listing Class: Residential Lease/Rental
  • Structure Sq Ft: 4750
  • Special Features: None
  • Property Sub Type: Detached
  • Year Built: 2000

Interior Features

  • Family Room: Separate Family Room
  • Fireplace: Gas Starter, Living Room, Primary Bedroom
  • Dining Room: Dining Area
  • Fireplace: Yes
  • Living Sq Ft: 4750
  • Stories: 2
  • Fireplaces Min: 2
  • Maximum Numberof Bedrooms: 5
  • Minimum Numberof Bedrooms: 5
  • Full Bathrooms: 4
  • Half Bathrooms: 1
  • Total Bedrooms: 5

Garage/Parking

  • Garage Spaces: 4
  • Garage Parking Features: Attached Garage

Utilities

  • Cooling System: Multi-Zone
  • Heating System: Central Forced Air - Gas

Condo/Co-op/Association

  • Complex Name: AVALON
  • HOA Exist: Yes

Schools

  • School District: Fremont Unified

Lot Info

  • Lot Acres: 0.6260
  • Lot Size Area Minimum Units: Square Feet
  • Minimum Lot Size: 27268.00
  • Lot Size Area Maximum Units: Square Feet
  • Maximum Lot Size: 27268.00

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Jul 12, 2023
Closed on
Sep 19, 2023
Sold by
Ng Shung Kui Lawrence and Yan Shirley
Bought by
Song James J and Duan Linda L
Seller's Agent
Linda Young
Buyer's Agent
Leon Hu
Top Mission Realty & Invest
List Price
$4,288,888
Sold Price
$4,020,000
Premium/Discount to List
-$268,888
-6.27%
Total Days on Market
81
Views
266
Current Estimated Value
$4,811,089

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$791,089
Avg. Annual Appreciation
10.73%
Original Mortgage
$2,613,000
Outstanding Balance
$2,565,518
Interest Rate
6.75%
Mortgage Type
New Conventional
Estimated Equity
$2,274,037

Purchase Details

Closed on
Nov 12, 2009
Sold by
Ng Shung Kui Lawrence and Ng Shirley Mo Yan
Bought by
Ng Shung Kui Lawrence and Ng Shirley Mo Yan

Home Financials for this Owner

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

Purchase Details

Closed on
Feb 19, 2008
Sold by
Ng Shung Kui Lawrence and Ng Shirley Mo Yan
Bought by
Ng Shung Kui Lawrence and Ng Shirley Mo Yan

Home Financials for this Owner

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

Purchase Details

Closed on
Oct 25, 2007
Sold by
Ng Shung Kui Lawrence and Ng Shirley Mo Yan
Bought by
Ng Shung Kui Lawrence and Ng Shirley Mo Yan

Home Financials for this Owner

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

Purchase Details

Closed on
Oct 10, 2002
Sold by
Ng Lawrence and Ng Shirley Mo Yan
Bought by
Ng Shung Kui Lawrence and Ng Shirley Mo Yan

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$750,000
Interest Rate
5.12%
Mortgage Type
Purchase Money Mortgage

Purchase Details

Closed on
Aug 1, 2000
Sold by
Avalon Homes
Bought by
Ng Lawrence and Ng Shirley Mo Yan

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$750,000
Interest Rate
7.87%
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
Song James J $4,020,000 Chicago Title
Ng Shung Kui Lawrence -- None Available
Ng Shung Kui Lawrence -- Fidelity National Title Co
Ng Shung Kui Lawrence -- Fidelity National Title Comp
Ng Shung Kui Lawrence -- Fidelity National Title Co
Ng Shung Kui Lawrence -- Atc
Ng Shung Kui Lawrence -- Alliance Title Company
Ng Shung Kui Lawrence -- Fidelity National Title Co
Ng Lawrence $1,260,000 Chicago Title Co
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Song James J $2,613,000
Previous Owner Ng Shung Kui Lawrence $750,000
Previous Owner Ng Shung Kui Lawrence $1,000,000
Previous Owner Ng Shung Kui Lawrence $616,000
Previous Owner Ng Shung Kui Lawrence $695,200
Previous Owner Ng Lawrence S $300,000
Previous Owner Ng Shung Kui Lawrence $714,000
Previous Owner Ng Shung Kui Lawrence $726,000
Previous Owner Ng Shung Kui Lawrence $729,750
Previous Owner Ng Shung Kui Lawrence $750,000
Previous Owner Ng Shung Kui Lawrence $250,000
Previous Owner Ng Shung Kui Lawrence $750,000
Previous Owner Ng Shung Kui Lawrence $750,000
Previous Owner Ng Lawrence $250,000
Previous Owner Ng Lawrence $750,000
Previous Owner Ng Lawrence $750,000
Previous Owner Ng Lawrence $750,000
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
02/04/2025 02/04/25 Off Market $4,020,000 -- --
02/26/2024 02/26/24 Rented $7,800 0.0% --
02/26/2024 02/26/24 Under Contract -- -- --
12/06/2023 12/06/23 For Rent $7,800 0.0% --
09/28/2023 09/28/23 Sold $4,020,000 -6.3% $955 / Sq Ft
08/24/2023 08/24/23 Pending -- -- --
07/12/2023 07/12/23 For Sale $4,288,888 -- $1,019 / Sq Ft
Source: MLSListings

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
2024 $46,363 $4,020,000 $1,608,000 $2,412,000
2023 $21,201 $1,817,768 $547,430 $1,277,338
2022 $21,039 $1,781,997 $536,699 $1,252,298
2021 $20,512 $1,746,920 $526,176 $1,227,744
2020 $20,701 $1,735,938 $520,781 $1,215,157
2019 $20,458 $1,701,907 $510,572 $1,191,335
2018 $20,063 $1,668,541 $500,562 $1,167,979
2017 $19,561 $1,635,831 $490,749 $1,145,082
2016 $19,249 $1,603,765 $481,129 $1,122,636
2015 $19,014 $1,579,687 $473,906 $1,105,781
2014 $18,702 $1,548,753 $464,626 $1,084,127
Source: Public Records

Agents Affiliated with this Home

  • Cindy Liu

    Landlord's Agent in 2024

    Cindy Liu

    Starriver Inc

    (408) 373-1778

    98 Total Sales

    Cindy Liu
    Section Image
  • Linda Young

    Seller's Agent in 2023

    Linda Young

    (510) 673-8811

    22 in this area

    91 Total Sales

    Linda Young
    Section Image

  • L

    Buyer's Agent in 2023

    Leon Hu

    Top Mission Realty & Invest

See All Agents

Map

Source: MLSListings

MLS Number: ML81949247

MLSListings

APN: 519-1726-064-00

California Alameda County Fremont 94539 Weibel

47592 Avalon Heights Terrace, Fremont, CA

This home is located at 47592 Avalon Heights Terrace, Fremont, CA 94539 since 06 December 2023 and is currently priced at $4,811,089. This property was built in 2000. 47592 Avalon Heights Terrace is a home located in Alameda County with nearby schools including James Leitch Elementary School, Warm Springs Elementary School, and John M. Horner Junior High School.

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