NOT LISTED FOR SALE

Estimated Value: $663,000 - $811,000

4 Beds
3 Baths
3,029 Sq Ft
$247/Sq Ft Est. Value

Last Sold December 01, 2020

Last sale price $630,000 $208 Per Sq Ft

Est. 19% increase in value since last sale

Current estimated payment $4,773/month

14 Days on Market

Highlights

  • Private Pool
  • Double Pane Windows
  • Access to stream, creek or river
  • James C. Enochs High School Rated A-
  • Central Heating

About This Home

As of December 2020

Very rare lakefront home in the Sundance Lake gated community! This beautiful home features 4 bedrooms, 3 bathrooms, 3029 square feet with a built-in POOL/SPA combo overlooking a private lake! Other features include a chef's kitchen with large island and stainless steel appliances, downstairs bedroom and bathroom, master suite with a private sitting area, & walk in closets, 3 car garage & much more! Enjoy your lakefront view with a fire pit & paddleboat!

Last Agent to Sell the Property

Robert Moore

Redwood Real Estate License #01951575 Listed on: 09/02/2020

Last Buyer's Agent

Barbara Shu

Tuscany Real Estate Services License #01391312

Home Details

Home Type

  • Single Family

Year Built

  • Built in 2002

Lot Details

  • 8,786 Sq Ft Lot
  • Zoning described as R1

HOA Fees

  • $198 Monthly HOA Fees

Parking

  • 3 Car Garage

Home Design

  • Slab Foundation
  • Composition Roof

Interior Spaces

  • 3,029 Sq Ft Home
  • 2-Story Property
  • Double Pane Windows
  • Family Room with Fireplace
  • Laundry in unit

Bedrooms and Bathrooms

  • 4 Bedrooms
  • 3 Full Bathrooms

Outdoor Features

  • Private Pool
  • Access to stream, creek or river

Utilities

  • Central Heating

Community Details

  • Association fees include 0

Listing and Financial Details

  • Assessor Parcel Number 085-035-029

Home Details

Home Type

Single Family

Year Built

Built in 2002

Lot Details

0

HOA Fees

$198 per month

Parking

3

Listing Details

  • Property Type: Residential
  • Subtype Description: Detached
  • Property Subtype 1: Single Family Residence
  • Remodeled Updated: Unknown
  • Year Built: 2002
  • Stories: 2
  • Special Features: None
  • Property Sub Type: Detached

Interior Features

  • Appliances: Dishwasher,Disposal,Double Oven,Gas Cook Top
  • Fireplace Features: Family Room
  • Fireplaces: 1
  • Flooring: Carpet,Tile
  • Master Bathroom Features: Closet,Double Sinks,Shower Stall(s),Sunken Tub
  • Master Bedroom Features: Balcony,Outside Access
  • Bathroom Features: Double Sinks,Tub w/Shower Over
  • Bathrooms: 3.00
  • Dining Room Features: Breakfast Nook,Formal Area
  • Kitchen Features: Tile Counter,Island
  • Room Type: Baths Other,Family Room,Living Room,Master Bathroom,Master Bedroom,Downstairs Bedroom
  • Main Level: Bedroom(s),Full Bath(s)
  • Price Per Square Foot: 207.99
  • Square Footage: 3029
  • Window Features: Dual Pane Full

Exterior Features

  • Construction Materials: Frame,Stucco
  • Disclosures/Documents: CC&Rs
  • Foundation: Slab
  • Horse Property: No
  • Listing Price: 599000.00
  • Lot Features: Lake/River Access
  • Pool Features: Built-In,On Lot,Pool/Spa Combo
  • Pool: Yes
  • Roof: Composition

Garage/Parking

  • Garage Spaces: 3
  • Driveway/Sidewalks: Sidewalk/Curb/Gutter

Utilities

  • Security: Carbon Mon Detector,Smoke Detector
  • Sewer: In & Connected
  • Utilities: All Public,Natural Gas Connected
  • Cooling: Ceiling Fan(s),Central
  • Electric: 220 Volts,220 Volts in Laundry
  • Heating: Central
  • Laundry Features: Inside Room
  • Water Source: Meter on Site

Condo/Co-op/Association

  • Association Fee: 198
  • Association Fee Frequency: Monthly
  • Association Fee Includes: 0
  • Association: Yes

Schools

  • Senior High School District: Modesto City

Lot Info

  • Zoning Description: R1
  • Irrigation: None
  • Lot Size Acres: 0.2017
  • Lot Size Sq Ft: 8786

Rental Info

  • Current Rent: 2995

Tax Info

  • Assessor Parcel Number: 085-035-029
  • Bonds/Assessments/Taxes: Unknown

MLS Schools

  • School District (County): Stanislaus

Ownership History

Date Name Owned For Owner Type

Purchase Details

Closed on
Jul 23, 2025
Sold by
Cheng Guo and Chai Ling Yen
Bought by
Zhu Family Living Trust and Zhu
Current Estimated Value
$746,781

Purchase Details

Listed on
Sep 2, 2020
Closed on
Nov 20, 2020
Sold by
Oseguera Ricardo
Bought by
Cheng Guo and Chai Ling Yen
Seller's Agent
Robert Moore
Redwood Real Estate
Buyer's Agent
Barbara Shu
Tuscany Real Estate Services
List Price
$599,000
Sold Price
$630,000
Premium/Discount to List
$31,000
5.18%

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
3.40%
Original Mortgage
$320,000
Interest Rate
2.8%
Mortgage Type
New Conventional

Purchase Details

Listed on
Aug 5, 2017
Closed on
Oct 23, 2017
Sold by
Garcia Raul and Fusi Scott
Bought by
Oseguera Ricardo
Seller's Agent
Dineen Sisson
RE/MAX Executive
Buyer's Agent
Jennifer Stasio
RE/MAX Executive
List Price
$685,000
Sold Price
$685,000

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
-2.66%
Original Mortgage
$411,000
Interest Rate
3.78%
Mortgage Type
New Conventional

Purchase Details

Closed on
Oct 19, 2015
Sold by
Garcia Paul and Fusi Leta
Bought by
Garcia Raul and Fusi Leta

Purchase Details

Closed on
Sep 21, 2015
Sold by
Garcia Raul
Bought by
Garcia Raul and Fusi Leta

Purchase Details

Closed on
Oct 8, 2007
Sold by
Garcia Sookie
Bought by
Garcia Raul

Home Financials for this Owner

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

Purchase Details

Closed on
Jul 11, 2006
Sold by
Piller Gordon and Piller Sharon
Bought by
Piller Gordon Howatt and Piller Sharon Kathleen

Purchase Details

Closed on
Feb 19, 2002
Sold by
Sundance Lake Modesto Llc
Bought by
Piller Gordon and Piller Sharon

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$300,000
Interest Rate
5%
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
Zhu Family Living Trust -- None Listed On Document
Cheng Guo $630,000 North American Title Co Inc
Oseguera Ricardo $685,000 Stewart Title Of Ca Inc
Garcia Raul -- None Available
Garcia Raul -- None Available
Garcia Raul -- Chicago Title Co
Garcia Raul $666,000 Chicago Title Co
Piller Gordon Howatt -- Accommodation
Piller Gordon $555,000 Chicago Title
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Previous Owner Cheng Guo $320,000
Previous Owner Oseguera Ricardo $411,000
Previous Owner Garcia Raul $417,000
Previous Owner Garcia Raul $215,600
Previous Owner Piller Gordon $300,000
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft Prior Sale
12/01/2020 12/01/20 Sold $630,000 +5.2% $208 / Sq Ft
09/16/2020 09/16/20 Pending -- -- --
09/02/2020 09/02/20 For Sale $599,000 -12.6% $198 / Sq Ft
10/27/2017 10/27/17 Sold $685,000 0.0% $226 / Sq Ft View Prior Sale
09/14/2017 09/14/17 Pending -- -- --
08/05/2017 08/05/17 For Sale $685,000 -- $226 / Sq Ft
Source: MetroList

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 $7,955 $681,929 $212,696 $469,233
2024 $7,788 $668,559 $208,526 $460,033
2023 $7,647 $655,451 $204,438 $451,013
2022 $7,337 $642,600 $200,430 $442,170
2021 $7,169 $630,000 $196,500 $433,500
2020 $8,003 $712,674 $322,524 $390,150
2019 $8,077 $698,700 $316,200 $382,500
2018 $7,835 $685,000 $310,000 $375,000
2017 $5,652 $485,500 $120,000 $365,500
2016 $5,473 $468,500 $115,000 $353,500
2015 $5,062 $430,000 $89,000 $341,000
2014 $4,626 $387,500 $80,000 $307,500
Source: Public Records

Agents Affiliated with this Home

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

Map

Source: MetroList

MLS Number: 20052291

MetroList

APN: 085-35-29