NOT LISTED FOR SALE

900 Country Club Dr Modesto, CA 95356

Del Rio Neighborhood

Estimated Value: $2,248,000 - $2,471,000

6 Beds
5.5 Baths
5,610 Sq Ft
$413/Sq Ft Est. Value

Last Sold December 04, 2017

Last sale price $1,610,000 $287 Per Sq Ft

Est. 44% increase in value since last sale

Current estimated payment $14,053/month

6 Days on Market

Highlights

  • Private Pool
  • Custom Home
  • No HOA
  • Joseph A. Gregori High School Rated A-
  • 2 Fireplaces
  • Double Pane Windows

About This Home

As of December 2017

This modern masterpiece is newly constructed that offers a dramatic visual experience once entering through the front doors! This contemporary estate highlights 6 bedrooms,5.5 baths and over 5600 Sf,soaring ceiling heights,2 master suites located downstairs, open concept kitchen built for the most discerning chef, restaurant size bar with a built in humidifier, & the design plan offers glamorous entertaining spaces at every corner! Incredible cabana w/full kitchen,bathroom and custom pool & spa!

Last Agent to Sell the Property

Jocelyn Singh

PMZ Real Estate License #01196663 Listed on: 09/01/2017

PMZ Real Estate

Co-Listed By

Jason Forcade

PMZ Real Estate License #02002143

Last Buyer's Agent

Jocelyn Singh

PMZ Real Estate License #01196663 Listed on: 09/01/2017

PMZ Real Estate

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $20,399

Year Built

  • Built in 2015

Lot Details

  • 0.37 Acre Lot
  • North Facing Home
  • Zoning described as R1

Parking

  • 3 Car Garage

Home Design

  • Custom Home
  • Contemporary Architecture
  • Slab Foundation

Interior Spaces

  • 5,610 Sq Ft Home
  • 2-Story Property
  • Wet Bar
  • 2 Fireplaces
  • Double Pane Windows
  • Carbon Monoxide Detectors
  • 220 Volts In Laundry

Bedrooms and Bathrooms

  • 6 Bedrooms

Pool

  • Private Pool
  • Spa

Utilities

  • Central Heating

Community Details

  • No Home Owners Association

Listing and Financial Details

  • Assessor Parcel Number 004-007-043-000

Home Details

Home Type

Single Family

Est. Annual Taxes

$20,399

Year Built

Built in 2015

Lot Details

0

Parking

3

Listing Details

  • Property Type: Residential
  • Subtype Description: Custom
  • Property Subtype 1: Single Family Residence
  • Remodeled Updated: No
  • Year Built: 2015
  • Architectural Style: Contemporary
  • Stories: 2
  • Special Features: None
  • Property Sub Type: Detached

Interior Features

  • Appliances: Built-In Refrigerator,Dishwasher,Disposal,Electric Cook Top,Free Standing Gas Range
  • Interior Amenities: Wet Bar
  • Fireplace Features: Family Room,Living Room
  • Fireplaces: 2
  • Flooring: Laminate,Tile,Wood
  • Master Bathroom Features: Multiple Shower Heads,Shower Stall(s),Sunken Tub,Walk-In Closet
  • Master Bedroom Features: Ground Floor,Walk-In Closet
  • Bathroom Features: Double Sinks,Shower Stall(s)
  • Bathrooms: 6.00
  • Dining Room Features: Dining Bar,Formal Room
  • Kitchen Features: Granite Counter,Pantry Closet
  • Room Type: Baths Other,Bonus Room,Den,Family Room,Master Bathroom,Master Bedroom,Master Bedrooms 2+
  • Main Level: Bedroom(s),Full Bath(s)
  • Price Per Square Foot: 286.99
  • Square Footage: 5610
  • Window Features: Dual Pane Full

Exterior Features

  • Construction Materials: Stucco,Wood
  • Property Faces: North
  • Exterior Features: BBQ Built-In,Kitchen
  • Foundation: Slab
  • Horse Property: No
  • Listing Price: 1750000.00
  • Lot Features: Shape Regular
  • Patio And Porch Features: Covered Deck,Covered Patio
  • Pool Features: Built-In,On Lot,Pool/Spa Combo
  • Pool: Yes
  • Roof: Flat,Tile
  • Spa Features: Spa/Hot Tub Built-In
  • Spa: Yes

Garage/Parking

  • Garage Spaces: 3
  • Parking Features: Attached,RV Possible,See Remarks
  • Driveway/Sidewalks: Sidewalk/Curb/Gutter

Utilities

  • Security: Carbon Mon Detector
  • Sewer: See Remarks
  • Utilities: All Public,Cable Available
  • Cooling: Ceiling Fan(s),Central
  • Electric: 220 Volts in Laundry
  • Heating: Central
  • Laundry Features: Cabinets,Gas Hook-Up,Inside Room,Sink
  • Water Source: Public

Condo/Co-op/Association

  • Association: No

Schools

  • Senior High School District: Modesto City

Lot Info

  • Zoning Description: R1
  • Irrigation: None
  • Lot Size Acres: 0.3652
  • Lot Size Sq Ft: 15908

Tax Info

  • Assessor Parcel Number: 004-007-043-000
  • Bonds/Assessments/Taxes: Unknown

MLS Schools

  • School District (County): Stanislaus

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Sep 1, 2017
Closed on
Nov 28, 2017
Sold by
Ismail John Z and Ismail Diana
Bought by
Ghumman Ambrish Singh and Bains Manpreet
Seller's Agent
Jocelyn Singh
PMZ Real Estate
Buyer's Agent
Jocelyn Singh
PMZ Real Estate
List Price
$1,750,000
Sold Price
$1,610,000
Premium/Discount to List
-$140,000
-8%
Current Estimated Value
$2,318,560

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$708,560
Avg. Annual Appreciation
5.59%
Original Mortgage
$1,288,000
Outstanding Balance
$1,095,372
Interest Rate
3.88%
Mortgage Type
New Conventional
Estimated Equity
$1,364,937

Purchase Details

Closed on
Apr 18, 2014
Sold by
Ismail John Z and John Z Ismail Trust
Bought by
Jd Ismail Trust

Home Financials for this Owner

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

Purchase Details

Closed on
Sep 10, 2013
Sold by
Ismail John
Bought by
Ismail John Z and John Z Ismail Trust

Purchase Details

Closed on
Jun 6, 2012
Sold by
Ismail Diana
Bought by
Ismail John

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$169,000
Interest Rate
3.79%
Mortgage Type
Seller Take Back

Purchase Details

Closed on
Sep 14, 2010
Sold by
Deutsche Bank National Trust Company
Bought by
Masellis Scott J and Masellis Krista J

Purchase Details

Closed on
May 14, 2010
Sold by
Shiba Ashur
Bought by
Deutsche Bank National Trust Company

Purchase Details

Closed on
Nov 3, 2006
Sold by
Jebri Doreen E
Bought by
Shiba Ashur

Home Financials for this Owner

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

Purchase Details

Closed on
Oct 10, 2006
Sold by
Claussen W Henry and Claussen Olga V
Bought by
Shiba Ashur

Home Financials for this Owner

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

Purchase Details

Closed on
Mar 1, 2005
Sold by
Aderholt Steven
Bought by
Claussen W Henry and Claussen Olga V

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
5.65%
Mortgage Type
Purchase Money Mortgage
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
Ghumman Ambrish Singh $1,610,000 Chicago Title Company
Jd Ismail Trust -- Old Republic Title Company
Ismail John Z -- None Available
Ismail John -- Chicago Title Company
Ismail John $170,000 Chicago Title Company
Masellis Scott J $173,000 Lsi Title Company
Deutsche Bank National Trust Company $217,748 Accommodation
Shiba Ashur -- Chicago Title Company
Shiba Ashur $575,000 Chicago Title Company
Claussen W Henry $375,000 Chicago Title
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Ghumman Ambrish Singh $1,288,000
Previous Owner Jd Ismail Trust $780,000
Previous Owner Ismail John $169,000
Previous Owner Masellis Scott J $80,000
Previous Owner Shiba Ashur $488,750
Previous Owner Claussen W Henry $250,000
Previous Owner Claussen W Henry $250,000
Previous Owner Aderholt Steven $50,000
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
12/04/2017 12/04/17 Sold $1,610,000 -8.0% $287 / Sq Ft
09/07/2017 09/07/17 Pending -- -- --
09/01/2017 09/01/17 For Sale $1,750,000 -- $312 / 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
2024 $20,399 $1,795,982 $613,534 $1,182,448
2023 $20,028 $1,760,767 $601,504 $1,159,263
2022 $19,484 $1,726,243 $589,710 $1,136,533
2021 $18,421 $1,692,397 $578,148 $1,114,249
2020 $18,177 $1,675,044 $572,220 $1,102,824
2019 $17,960 $1,642,200 $561,000 $1,081,200
2018 $17,743 $1,610,000 $550,000 $1,060,000
2017 $12,799 $1,158,083 $189,083 $969,000
2016 $12,466 $1,135,376 $185,376 $950,000
2015 $4,076 $362,167 $177,667 $184,500
2014 $2,003 $174,187 $174,187 $0
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
See All Agents

Map

Source: MetroList

MLS Number: 17056912

MetroList

APN: 004-07-43