NOT LISTED FOR SALE

Estimated Value: $2,706,860 - $3,073,000

4 Beds
4 Baths
3,695 Sq Ft
$768/Sq Ft Est. Value

Last Sold January 17, 2019

Last sale price $1,590,000 $430 Per Sq Ft

Est. 79% increase in value since last sale

Current estimated payment $17,134/month

99 Days on Market

Highlights

  • Wine Cellar
  • 24-Hour Security
  • Updated Kitchen
  • Ladera Elementary School Rated A
  • Primary Bedroom Suite
  • Fireplace in Primary Bedroom

About This Home

As of January 2019

Beautiful Custom Estate located in the highly sought out Madrid community in Tustin Ranch. This exquisite luxury home offers over 3600+ sqft of custom upgrades with 4 bedrooms, 3.75 bathrooms, custom kitchen equipped with top of the line appliances, and a complete entertainer's backyard with your own fireplace and pizza oven! Bright & spacious home exudes luxury the moment you walk in with 2 story ceiling entry, formal dining and living area to host large gatherings. Swing around to the family room with built in speakers, fireplace, and custom wine cabinet to display all of your finest collections. European style gourmet kitchen offers dramatic over sized island, custom cabinetry with self closers, calacatta marble back splash, built in wine cooler, top of the line Wolf range, microwave drawer and a cozy dining area with french doors looking out to breathtaking entertainers backyard. Additional highlights includes Brazilian hard wood flooring, custom window coverings, LED lights, walk in pantry, 2 electric car charging portals. All bedrooms upstairs with a den and balcony looking out into the quiet, private cul-de-sac neighborhood. The 24 hr gate-guarded Madrid community is just steps away from the Tustin Ranch Golf Course and has direct access to Ladera Elementary. Close proximity to Pioneer Middle School, and Beckman High School all award-winning schools in TUSD.

Last Agent to Sell the Property

Nicole Han

Lifetime Realty Inc License #02009968 Listed on: 08/29/2018

Lifetime Realty Inc

Co-Listed By

Jamie Kim

Lifetime Realty Inc License #01823039

Last Buyer's Agent

Sally Picciuto

Seven Gables Real Estate License #01279725

Seven Gables Real Estate

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $18,197

Year Built

  • Built in 1998 | Remodeled

Lot Details

  • 7,356 Sq Ft Lot
  • Cul-De-Sac
  • Front and Back Yard Sprinklers
  • Back and Front Yard
  • Density is up to 1 Unit/Acre

HOA Fees

Parking

  • 3 Car Direct Access Garage
  • Parking Available
  • Three Garage Doors

Home Design

  • Mediterranean Architecture
  • Tile Roof

Interior Spaces

  • 3,695 Sq Ft Home
  • Cathedral Ceiling
  • Recessed Lighting
  • Double Pane Windows
  • French Doors
  • Entrance Foyer
  • Wine Cellar
  • Family Room with Fireplace
  • Dining Room
  • Home Office
  • Loft
  • Laundry Room

Kitchen

  • Updated Kitchen
  • Breakfast Area or Nook
  • Breakfast Bar
  • Walk-In Pantry
  • Double Self-Cleaning Oven
  • Six Burner Stove
  • Range Hood
  • Dishwasher
  • Kitchen Island
  • Quartz Countertops
  • Self-Closing Drawers and Cabinet Doors
  • Disposal

Flooring

  • Wood
  • Carpet

Bedrooms and Bathrooms

  • 4 Bedrooms
  • Fireplace in Primary Bedroom
  • Fireplace in Primary Bedroom Retreat
  • All Upper Level Bedrooms
  • Primary Bedroom Suite
  • Walk-In Closet
  • Upgraded Bathroom
  • Dual Sinks
  • Soaking Tub
  • Bathtub with Shower
  • Separate Shower
  • Closet In Bathroom

Home Security

  • Security Lights
  • Carbon Monoxide Detectors

Accessible Home Design

  • More Than Two Accessible Exits

Outdoor Features

  • Balcony
  • Exterior Lighting

Schools

  • Ladera Elementary School
  • Pioneer Middle School
  • Beckman High School

Utilities

  • Two cooling system units
  • Central Heating and Cooling System
  • Sewer on Bond
  • Sewer Paid

Listing and Financial Details

  • Tax Lot 32
  • Tax Tract Number 15420
  • Assessor Parcel Number 50127128

Community Details

Overview

  • Madrid Association, Phone Number (714) 692-1670
  • Tustin Ranch Association
  • Maintained Community

Amenities

  • Picnic Area
  • Laundry Facilities

Security

  • 24-Hour Security

Home Details

Home Type

Single Family

Est. Annual Taxes

$18,197

Year Built

Built in 1998 | Remodeled

Lot Details

0

HOA Fees

$148 per month

Parking

3

Listing Details

  • Assessments: Yes
  • Property Attached: No
  • Security: 24 Hour Security, Carbon Monoxide Detector(s), Gated Community, Gated with Guard, Security Lights
  • Subdivision Name Other: Madrid (MADR)
  • View: No
  • Architectural Style: Mediterranean
  • Property Condition: Updated/Remodeled
  • Property Sub Type: Single Family Residence
  • Property Type: Residential
  • Parcel Number: 50127128
  • Year Built: 1998
  • Special Features: None

Interior Features

  • Fireplace: Yes
  • Living Area: 3695.00 Square Feet
  • Interior Amenities: Balcony, Cathedral Ceiling(s), High Ceilings, Recessed Lighting
  • Common Walls: No Common Walls
  • Flooring: Carpet, Wood
  • Accessibility Features: 2+ Access Exits
  • Appliances: Yes
  • Full Bathrooms: 2
  • Full And Three Quarter Bathrooms: 4
  • Three Quarter Bathrooms: 2
  • Total Bedrooms: 4
  • Door Features: French Doors
  • Eating Area: Breakfast Counter / Bar, Breakfast Nook, Dining Room
  • Fireplace Features: Family Room, Master Bedroom, Master Retreat
  • Levels: Two
  • Main Level Bathrooms: 1
  • Price Per Square Foot: 430.31
  • Room Type: All Bedrooms Up, Foyer, Loft, Master Bedroom, Master Suite, Office, Separate Family Room, Walk-In Closet, Walk-In Pantry, Wine Cellar
  • Window Features: Double Pane Windows
  • Bathroom Features: Bathtub, Shower, Shower In Tub, Closet In Bathroom, Double Sinks In Bath(s), Separate Tub And Shower, Soaking Tub, Upgraded, Walk-In Shower
  • Room Kitchen Features: Kitchen Island, Quartz Counters, Remodeled Kitchen, Self-Closing Cabinet Doors, Self-Closing Drawers, Walk-In Pantry

Exterior Features

  • Exterior Features: Lighting
  • Pool Private: No
  • Roof: Tile
  • Spa: No

Garage/Parking

  • Attached Garage: Yes
  • Garage Spaces: 3.00
  • Parking: Yes
  • Parking Features: Direct Garage Access, Garage - Three Door
  • Total Parking Spaces: 3.00

Utilities

  • Sprinklers: Yes
  • Heating: Yes
  • Laundry: Yes
  • Appliances: 6 Burner Stove, Dishwasher, Double Oven, Disposal, Range Hood, Self Cleaning Oven
  • Heating Type: Central
  • Laundry Features: Common Area, Individual Room
  • Sewer: Sewer On Bond, Sewer Paid
  • Water Source: Public
  • Cooling: Central Air, Dual
  • Cooling: Yes

Condo/Co-op/Association

  • Association: Yes
  • Association: Tustin Ranch
  • Amenities: Picnic Area, Maintenance Grounds, Dues Paid Monthly, Guard
  • Association Fee: 68.00
  • Association #2 Fee: 80.00
  • Association #2 Fee Frequency: Monthly
  • Association Fee Frequency: Monthly
  • Association Name: Madrid
  • Phone: 714.692.1670
  • Senior Community: No
  • Community Features: Curbs, Sidewalks, Street Lights

Schools

  • School District: Tustin Unified
  • Elementary School: Ladera
  • Middle School: Pioneer
  • High School: Beckman
  • Elementary School: Ladera
  • High School: Beckman
  • Middle Or Junior School: Pioneer
  • Elementary School #2: LADERA
  • High School2: BECKMA

Lot Info

  • Additional Parcels: No
  • Land Lease: No
  • Lot Features: 0-1 Unit/Acre, Back Yard, Cul-De-Sac, Front Yard, Sprinklers In Front, Sprinklers In Rear
  • Lot Size Sq Ft: 7356.00
  • Lot Size Acres: 0.1689

Multi Family

  • Lease Considered: No
  • Lot Size Area: 7356.0000 Square Feet
  • Number Of Units Total: 1

Tax Info

  • Tax Census Tract: 756.06
  • Tax Lot: 32
  • Tax Tract Number: 15420

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Aug 29, 2018
Closed on
Dec 11, 2018
Sold by
Ariga Taro and Ariga Ayako
Bought by
Barlow Christopher and Barlow Kelly
Seller's Agent
Nicole Han
Lifetime Realty Inc
Buyer's Agent
Sally Picciuto
Seven Gables Real Estate
List Price
$1,679,000
Sold Price
$1,590,000
Premium/Discount to List
-$89,000
-5.3%
Current Estimated Value
$2,839,215

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$1,249,215
Avg. Annual Appreciation
8.80%
Original Mortgage
$1,351,500
Interest Rate
4.7%
Mortgage Type
New Conventional

Purchase Details

Listed on
Apr 21, 2014
Closed on
Jul 18, 2014
Sold by
Dicostanzo Donald J and Dicostanzo Roseann
Bought by
Ariga Taro and Ariga Ayako
Seller's Agent
Linda Beck
Keller Williams Realty Irvine
Buyer's Agent
Tommy Kim
Lifetime Realty Inc
List Price
$1,449,000
Sold Price
$1,374,750
Premium/Discount to List
-$74,250
-5.12%

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.35%
Original Mortgage
$824,750
Interest Rate
3.25%
Mortgage Type
Adjustable Rate Mortgage/ARM

Purchase Details

Closed on
Apr 19, 2006
Sold by
Dicostanzo Donald J and Dicostanzo Roseann F
Bought by
Dicostanzo Donald J and Dicostanzo Roseann

Home Financials for this Owner

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

Purchase Details

Closed on
Jun 24, 2004
Sold by
Dicostanzo Donald J and Dicostanzo Roseann F
Bought by
Dicostanzo Donald J and Dicostanzo Roseann

Purchase Details

Closed on
Nov 25, 1998
Sold by
Wl Homes Llc
Bought by
Dicostanzo Donald J and Dicostanzo Roseann F

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$470,750
Interest Rate
6.86%
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
Barlow Christopher $1,590,000 Chicago Title Company
Ariga Taro $1,375,000 Fidelity National Title
Dicostanzo Donald J -- Accommodation
Dicostanzo Donald J -- Chicago Title Co
Dicostanzo Donald J -- --
Dicostanzo Donald J $588,500 Chicago Title Co
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Barlow Christopher $1,311,575
Closed Barlow Christopher $1,304,000
Closed Barlow Christopher $1,351,500
Previous Owner Ariga Taro $285,000
Previous Owner Ariga Taro $824,750
Previous Owner Dicostanzo Donald J $822,000
Previous Owner Dicostanzo Donald J $650,000
Previous Owner Dicostanzo Donald J $500,000
Previous Owner Dicostanzo Donald J $455,000
Previous Owner Dicostanzo Donald J $470,750
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
01/17/2019 01/17/19 Sold $1,590,000 -0.5% $430 / Sq Ft
12/06/2018 12/06/18 Pending -- -- --
10/17/2018 10/17/18 Price Changed $1,598,000 -4.8% $432 / Sq Ft
08/29/2018 08/29/18 For Sale $1,679,000 +22.1% $454 / Sq Ft
08/18/2014 08/18/14 Sold $1,374,750 -5.1% $373 / Sq Ft
07/21/2014 07/21/14 Pending -- -- --
04/21/2014 04/21/14 For Sale $1,449,000 -- $393 / Sq Ft
Source: California Regional Multiple Listing Service (CRMLS)

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 $18,197 $1,773,673 $1,053,580 $720,093
2024 $18,197 $1,738,896 $1,032,922 $705,974
2023 $17,783 $1,704,800 $1,012,668 $692,132
2022 $18,949 $1,671,373 $992,812 $678,561
2021 $18,531 $1,638,601 $973,345 $665,256
2020 $18,294 $1,621,800 $963,365 $658,435
2019 $16,743 $1,481,142 $891,907 $589,235
2018 $16,390 $1,452,100 $874,418 $577,682
2017 $15,944 $1,423,628 $857,273 $566,355
2016 $15,648 $1,395,714 $840,464 $555,250
2015 $15,464 $1,374,750 $827,840 $546,910
2014 $9,058 $752,601 $308,385 $444,216
Source: Public Records

Agents Affiliated with this Home

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

Map

Source: California Regional Multiple Listing Service (CRMLS)

MLS Number: PW18210624

California Regional Multiple Listing Service (CRMLS)

APN: 501-271-28