NOT LISTED FOR SALE

534 W Esplanade Dr Mountain House, CA 95391

Estimated Value: $821,000 - $858,000

4 Beds
3 Baths
2,144 Sq Ft
$393/Sq Ft Est. Value

Last Sold July 22, 2016

Last sale price $520,000 $243 Per Sq Ft

Est. 62% increase in value since last sale

Current estimated payment $5,169/month

11 Days on Market

Highlights

  • Contemporary Architecture
  • 1 Fireplace
  • 2 Car Attached Garage
  • Altamont Elementary School Rated A
  • No HOA
  • Double Pane Windows

About This Home

As of July 2016

Absolutely fabulous Shea home featuring 4 bedrooms/3 bathrooms (bed/bath downstairs) nice open concept living room/dining room/kitchen. Kitchen has a huge island, SS gas cooktop and built in oven/microwave. Big bedrooms, all bathrooms have custom upgraded granite, upgraded carpet/padding, and a finished garage. Then step out into PARADISE! This backyard is stunning, with the large pergola, the gas plumbed fire pit, stamped concrete and so much more.

Last Agent to Sell the Property

Alicia Hernandez

Keller Williams Merced License #01373886 Listed on: 06/10/2016

Keller Williams Merced

Home Details

Home Type

  • Single Family

Year Built

  • Built in 2012

Lot Details

  • 5,811 Sq Ft Lot
  • Northeast Facing Home
  • Back Yard Fenced
  • Zoning described as R1

Parking

  • 2 Car Attached Garage

Home Design

  • Contemporary Architecture
  • Slab Foundation
  • Tile Roof

Interior Spaces

  • 2,144 Sq Ft Home
  • 2-Story Property
  • 1 Fireplace
  • Double Pane Windows
  • Family or Dining Combination

Bedrooms and Bathrooms

  • 4 Bedrooms
  • 3 Full Bathrooms

Outdoor Features

  • Fire Pit

Utilities

  • Central Heating and Cooling System
  • 220 Volts

Community Details

  • No Home Owners Association
  • Built by Shea
  • Campania Subdivision, Prato Floorplan

Listing and Financial Details

  • Assessor Parcel Number 256-350-10

Home Details

Home Type

Single Family

Year Built

Built in 2012

Lot Details

5,811 Sq Ft Lot

Parking

2

Listing Details

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

Interior Features

  • Appliances: Built-In Gas Oven,Dishwasher,Gas Cook Top,Microwave
  • Fireplace Features: Family Room,Gas Log
  • Fireplaces: 1
  • Flooring: Carpet,Tile
  • Master Bathroom Features: Double Sinks,Shower Stall(s),Stone,Sunken Tub,Walk-In Closet 2+
  • Bathroom Features: Double Sinks,Stone
  • Bathrooms: 3.00
  • Dining Room Features: Dining/Family Combo
  • Kitchen Features: Granite Counter,Island,Pantry Cabinet
  • Room Type: Baths Other,Master Bathroom
  • Main Level: Bedroom(s),Full Bath(s)
  • Price Per Square Foot: 242.54
  • Square Footage: 2144
  • Window Features: Dual Pane Full

Exterior Features

  • Other Structures: Pergola,Shed(s)
  • Builder Name: Shea
  • Construction Materials: Frame,Stucco
  • Property Faces: Northeast
  • Disclosures/Documents: CC&Rs,TDS Available
  • Exterior Features: Fire Pit
  • Fencing: Back Yard
  • Foundation: Slab
  • Listing Price: 519900.00
  • Lot Features: Auto Sprinkler Rear,Shape Regular,Street Lights
  • Pool: No
  • Roof: Tile

Garage/Parking

  • Garage Spaces: 2
  • Parking Features: Attached
  • Driveway/Sidewalks: Sidewalk/Curb/Gutter

Utilities

  • Security: Carbon Mon Detector,Security System Leased,Smoke Detector,Video System
  • Sewer: Sewer Connected
  • Utilities: All Public,Cable Available,Natural Gas Available,Natural Gas Connected
  • Cooling: Central
  • Electric: 220 Volts
  • Heating: Central
  • Laundry Features: Gas Hook-Up,Inside Room
  • Water Source: Meter on Site

Condo/Co-op/Association

  • Association: No

Schools

  • Senior High School District: Lammersville

Lot Info

  • Zoning Description: R1
  • Irrigation: None
  • Lot Size Acres: 0.1334
  • Lot Size Sq Ft: 5811

Tax Info

  • Assessor Parcel Number: 256-350-10
  • Bonds/Assessments/Taxes: Unknown

MLS Schools

  • School District (County): San Joaquin

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Jun 10, 2016
Closed on
Jul 21, 2016
Sold by
Stewart Ii Rodney
Bought by
Huynh Annie C and Tran Michael T
Seller's Agent
Alicia Hernandez
Keller Williams Merced
List Price
$519,900
Sold Price
$520,000
Premium/Discount to List
$100
0.02%
Current Estimated Value
$841,700

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$321,700
Avg. Annual Appreciation
5.16%
Original Mortgage
$416,000
Outstanding Balance
$332,308
Interest Rate
3.6%
Mortgage Type
New Conventional
Estimated Equity
$509,392

Purchase Details

Closed on
Nov 30, 2012
Sold by
Stewart Theresa
Bought by
Stewart Ii Rodney

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$320,037
Interest Rate
3.25%
Mortgage Type
FHA

Purchase Details

Closed on
Nov 29, 2012
Sold by
Shea Homes Limited Partnership
Bought by
Stewart Ii Rodney

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$320,037
Interest Rate
3.25%
Mortgage Type
FHA
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

Purchase History

Date Buyer Sale Price Title Company
Huynh Annie C $520,000 North American Title Co Inc
Stewart Ii Rodney -- Chicago Title Company
Stewart Ii Rodney $325,945 Chicago Title Company
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Huynh Annie C $416,000
Previous Owner Stewart Ii Rodney $320,037
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft Prior Sale
07/22/2016 07/22/16 Sold $520,000 0.0% $243 / Sq Ft
06/21/2016 06/21/16 Pending -- -- --
06/10/2016 06/10/16 For Sale $519,900 +63.5% $242 / Sq Ft
01/31/2013 01/31/13 Sold $318,000 0.0% $149 / Sq Ft View Prior Sale
04/27/2012 04/27/12 Pending -- -- --
04/12/2012 04/12/12 For Sale $318,000 -- $149 / Sq Ft
Source: MetroList

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 $9,994 $603,498 $211,222 $392,276
2024 $9,728 $591,666 $207,081 $384,585
2023 $9,555 $580,066 $203,021 $377,045
2022 $9,347 $568,693 $199,041 $369,652
2021 $9,241 $557,543 $195,139 $362,404
2020 $9,130 $551,827 $193,139 $358,688
2019 $9,015 $541,007 $189,352 $351,655
2018 $9,263 $530,400 $185,640 $344,760
2017 $8,723 $520,000 $182,000 $338,000
2016 $6,626 $339,054 $84,259 $254,795
2015 $6,491 $333,962 $82,993 $250,969
2014 $6,415 $327,421 $81,368 $246,053
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
See All Agents

Map

Source: MetroList

MLS Number: 16037297

MetroList

APN: 256-350-10

Your Personal Tour Guide

Ask me questions while you tour the home.