NOT LISTED FOR SALE

9938 E Celtic Dr Unit 35 Scottsdale, AZ 85260

Horizons Neighborhood

Estimated Value: $1,561,666 - $2,008,000

4 Beds
3.5 Baths
3,752 Sq Ft
$474/Sq Ft Est. Value

Last Sold April 30, 2013

Last sale price $800,000 $213 Per Sq Ft

Est. 122% increase in value since last sale

Current estimated payment $9,882/month

12 Days on Market

Highlights

  • Play Pool
  • Gated Community
  • Fireplace in Primary Bedroom
  • Redfield Elementary School Rated A
  • Two Primary Bathrooms
  • Santa Barbara Architecture

About This Home

As of April 2013

Absolutely stunning Tuscan style home in the prestigious Madrid gated community with countless upgrades. Neutral tone travertine flooring throughout the home, and a chef's dream kitchen with beautiful cherry finishes, granite countertops, gas cook top, and professional grade Sub Zero, Viking, and Wolf stainless steel appliances. Relax by the fireplace in the luxurious master bedroom, while the kids play in the open play area. Enjoy weekends entertaining friends under the covered patio with the built in barbeque, and sparkling private pool, and beautiful mountain views. Approximately $150K in front and back landscaping done to top off this gem. A must see!

Last Agent to Sell the Property

Kelly Cook

Real Broker License #SA562405000 Listed on: 03/20/2013

Real Broker

Co-Listed By

Kelly Wells

Keller Williams Arizona Realty License #SA563448000

Last Buyer's Agent

Claire Ackerman

Compass License #SA571364000

Compass

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $4,228

Year Built

  • Built in 2005

Lot Details

  • 0.36 Acre Lot
  • Block Wall Fence
  • Corner Lot
  • Front and Back Yard Sprinklers
  • Sprinklers on Timer
  • Grass Covered Lot

Parking

  • 3 Car Garage
  • Garage Door Opener

Home Design

  • Santa Barbara Architecture
  • Wood Frame Construction
  • Concrete Roof
  • Stucco

Interior Spaces

  • 3,752 Sq Ft Home
  • 1-Story Property
  • Ceiling height of 9 feet or more
  • Ceiling Fan
  • Family Room with Fireplace
  • 2 Fireplaces

Kitchen

  • Eat-In Kitchen
  • Breakfast Bar
  • Gas Cooktop
  • Dishwasher
  • Kitchen Island
  • Granite Countertops

Flooring

  • Carpet
  • Stone

Bedrooms and Bathrooms

  • 4 Bedrooms
  • Fireplace in Primary Bedroom
  • Walk-In Closet
  • Two Primary Bathrooms
  • Primary Bathroom is a Full Bathroom
  • 3.5 Bathrooms
  • Dual Vanity Sinks in Primary Bathroom
  • Hydromassage or Jetted Bathtub
  • Bathtub With Separate Shower Stall

Laundry

  • Laundry in unit
  • Washer and Dryer Hookup

Home Security

  • Security System Owned
  • Fire Sprinkler System

Pool

  • Play Pool
  • Fence Around Pool

Outdoor Features

  • Covered Patio or Porch
  • Playground

Schools

  • Redfield Elementary School
  • Desert Canyon Elementary Middle School
  • Desert Mountain Elementary High School

Utilities

  • Refrigerated Cooling System
  • Zoned Heating
  • Heating System Uses Natural Gas
  • Water Filtration System
  • High Speed Internet
  • Cable TV Available

Listing and Financial Details

  • Home warranty included in the sale of the property
  • Tax Lot 35
  • Assessor Parcel Number 217-50-769

Community Details

Overview

  • Property has a Home Owners Association
  • Madrid Association, Phone Number (602) 954-9252
  • Built by Meritage Homes
  • Madrid Subdivision

Recreation

  • Community Playground

Security

  • Gated Community

Home Details

Home Type

Single Family

Est. Annual Taxes

$4,228

Year Built

Built in 2005

Lot Details

0

Parking

3

Listing Details

  • Cross Street: ***Frank Lloyd Wright & Thunderbird
  • Legal Info Range: 5E
  • Property Type: Residential
  • HOA #2: N
  • HOA #3 Fee: N
  • Association Fees Land Lease Fee: N
  • Recreation Center Fee 2: N
  • Recreation Center Fee: N
  • Total Monthly Fee Equivalent: 165.0
  • Basement: N
  • Parking Spaces Total Covered Spaces: 3.0
  • Separate Den Office Sep Den Office: Y
  • Year Built: 2005
  • Tax Year: 2012
  • Directions: Southwest on Thunderbird to Madrid entrance on left. Enter & go south on 98th Place to Celtic. East to home on left
  • Property Sub Type: Single Family - Detached
  • Lot Size Acres: 0.36
  • Co List Office Mls Id: kwaz10
  • Co List Office Phone: 480-767-3000
  • Subdivision Name: Madrid
  • Architectural Style: Santa Barbara/Tuscan
  • Efficiency: Multi-Zones
  • ResoBuildingAreaSource: Assessor
  • Association Fees:HOA Fee2: 495.0
  • Dining Area:Breakfast Bar: Yes
  • Cooling:Ceiling Fan(s): Yes
  • Technology:Cable TV Avail: Yes
  • Technology:High Speed Internet Available: Yes
  • Special Features: None

Interior Features

  • Basement: None
  • Flooring: Carpet, Stone
  • Spa Features: None
  • Possible Bedrooms: 6
  • Total Bedrooms: 4
  • Fireplace Features: 2 Fireplace, Family Room, Master Bedroom
  • Fireplace: Yes
  • Interior Amenities: Walk-In Closet(s), Eat-in Kitchen, Breakfast Bar, 9+ Flat Ceilings, Drink Wtr Filter Sys, Fire Sprinklers, Kitchen Island, Pantry, 2 Master Baths, Double Vanity, Full Bth Master Bdrm, Separate Shwr & Tub, Tub with Jets, High Speed Internet, Granite Counters
  • Living Area: 3752.0
  • Stories: 1
  • Kitchen Features:Dishwasher2: Yes
  • Community Features:Gated Community2: Yes
  • Kitchen Features:Granite Countertops: Yes
  • Kitchen Features:Kitchen Island: Yes
  • Master Bathroom:Double Sinks: Yes
  • Kitchen Features:Disposal2: Yes
  • Kitchen Features:Refrigerator2: Yes
  • Kitchen Features Pantry: Yes
  • Fireplace:_two_ Fireplace: Yes
  • Fireplace:Fireplace Family Rm: Yes
  • Other Rooms:Family Room: Yes
  • Kitchen Features:Wall Oven(s): Yes
  • Community Features:Children_squote_s Playgrnd: Yes
  • Kitchen Features:Walk-in Pantry: Yes
  • Other Rooms:BonusGame Room: Yes
  • Kitchen Features:Cook Top Gas: Yes
  • Fireplace:Fireplace Master Bdr: Yes

Exterior Features

  • Fencing: Block
  • Exterior Features: Covered Patio(s), Playground, Patio
  • Lot Features: Corner Lot, Gravel/Stone Front, Grass Front, Grass Back, Auto Timer H2O Front, Auto Timer H2O Back, Irrigation Front, Irrigation Back
  • Pool Features: Play Pool, Fenced, Private
  • Disclosures: Agency Discl Req, Seller Discl Avail
  • Home Warranty: Yes
  • Construction Type: Painted, Stucco, Frame - Wood
  • Roof: Concrete
  • Construction:Frame - Wood: Yes
  • Exterior Features:Covered Patio(s): Yes
  • Exterior Features:Childrens Play Area: Yes
  • Exterior Features:Patio: Yes

Garage/Parking

  • Total Covered Spaces: 3.0
  • Parking Features: Electric Door Opener
  • Attached Garage: No
  • Garage Spaces: 3.0
  • Parking Features:Electric Door Opener: Yes

Utilities

  • Cooling: Refrigeration, Ceiling Fan(s)
  • Heating: Natural Gas
  • Laundry Features: Inside, Wshr/Dry HookUp Only
  • Security: Security System Owned, Gated Community
  • Water Source: City Water
  • Heating:Natural Gas: Yes

Condo/Co-op/Association

  • Community Features: Playground
  • Amenities: Management
  • Association Fee Frequency: Quarterly
  • Association Name: Madrid
  • Phone: 602-954-9252
  • Association: Yes

Association/Amenities

  • Association Fees:HOA YN2: Y
  • Association Fees:HOA Transfer Fee2: 350.0
  • Association Fees:HOA Paid Frequency: Quarterly
  • Association Fees:HOA Name4: Madrid
  • Association Fees:HOA Telephone4: 602-954-9252
  • Association Fees:PAD Fee YN2: N
  • Association Fees:Cap ImprovementImpact Fee _percent_: $
  • Association Fee Incl:Common Area Maint3: Yes
  • Association Fees:Cap ImprovementImpact Fee 2 _percent_: $
  • Association Fee Incl:Street Maint: Yes

Schools

  • Elementary School: Redfield Elementary School
  • High School: Desert Mountain Elementary
  • Middle Or Junior School: Desert Canyon Elementary

Lot Info

  • Land Lease: No
  • Lot Size Sq Ft: 15540.0
  • Parcel #: 217-50-769
  • ResoLotSizeUnits: SquareFeet

Building Info

  • Builder Name: Meritage Homes

Tax Info

  • Tax Annual Amount: 4227.74
  • Tax Book Number: 217.00
  • Tax Lot: 35
  • Tax Map Number: 50.00

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Mar 20, 2013
Closed on
Apr 25, 2013
Sold by
Caldwell Peter E and Caldwell Michelle M
Bought by
Miller Todd
Seller's Agent
Kelly Cook
Real Broker
Buyer's Agent
Claire Ackerman
Compass
List Price
$839,000
Sold Price
$800,000
Premium/Discount to List
-$39,000
-4.65%
Current Estimated Value
$1,777,167

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$977,167
Avg. Annual Appreciation
6.63%

Purchase Details

Closed on
Dec 31, 2008
Sold by
Caldwell Peter E
Bought by
Caldwell Peter E and Caldwell Michelle M

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
5.97%
Mortgage Type
New Conventional

Purchase Details

Closed on
Dec 19, 2008
Sold by
Caldwell Michelle M
Bought by
Caldwell Peter E

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
5.97%
Mortgage Type
New Conventional

Purchase Details

Closed on
May 3, 2007
Sold by
Caldwell Peter and Caldwell Michelle
Bought by
Caldwell Peter E and Caldwell Michelle M

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.14%
Mortgage Type
New Conventional

Purchase Details

Closed on
Feb 15, 2007
Sold by
Caldwell Peter
Bought by
Caldwell Peter and Caldwell Michelle

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$42,000
Interest Rate
6.21%
Mortgage Type
Stand Alone Second

Purchase Details

Closed on
Feb 6, 2007
Sold by
Brown Ryan
Bought by
Caldwell Peter

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$42,000
Interest Rate
6.21%
Mortgage Type
Stand Alone Second

Purchase Details

Closed on
Dec 21, 2005
Sold by
Meritage Homes Of Arizona Inc
Bought by
Brown Ryan

Home Financials for this Owner

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

Purchase Details

Closed on
Nov 24, 2004
Sold by
Taro Properties Arizona I Llc
Bought by
Meritage Homes Construction Inc
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
Miller Todd $800,000 Stewart Title & Trust Of Pho
Caldwell Peter E -- Grand Canyon Title Agency In
Caldwell Peter E -- Grand Canyon Title Agency In
Caldwell Peter E -- Grand Canyon Title Agency In
Caldwell Peter -- Transnation Title Ins Co
Caldwell Peter $930,000 Transnation Title Ins Co
Brown Ryan $962,919 First American Title Ins Co
Meritage Homes Of Arizona Inc -- First American Title Ins Co
Meritage Homes Construction Inc $2,171,700 --
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Previous Owner Caldwell Peter E $417,000
Previous Owner Caldwell Peter E $417,000
Previous Owner Caldwell Peter $42,000
Previous Owner Brown Ryan $770,335
Closed Brown Ryan $191,566
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
04/30/2013 04/30/13 Sold $800,000 -4.6% $213 / Sq Ft
03/18/2013 03/18/13 For Sale $839,000 -- $224 / Sq Ft
Source: Arizona Regional Multiple Listing Service (ARMLS)

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 $5,519 $90,434 -- --
2024 $5,448 $86,127 -- --
2023 $5,448 $95,870 $19,170 $76,700
2022 $5,138 $78,120 $15,620 $62,500
2021 $5,551 $75,060 $15,010 $60,050
2020 $5,695 $78,020 $15,600 $62,420
2019 $5,475 $75,860 $15,170 $60,690
2018 $5,282 $73,760 $14,750 $59,010
2017 $5,034 $75,020 $15,000 $60,020
2016 $4,924 $68,700 $13,740 $54,960
2015 $4,658 $66,670 $13,330 $53,340
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
See All Agents

Map

Source: Arizona Regional Multiple Listing Service (ARMLS)

MLS Number: 4907541

Arizona Regional Multiple Listing Service (ARMLS)

APN: 217-50-769