NOT LISTED FOR SALE

9842 E Celtic Dr Unit 29 Scottsdale, AZ 85260

Horizons Neighborhood

Estimated Value: $1,441,000 - $1,949,000

5 Beds
5 Baths
4,509 Sq Ft
$402/Sq Ft Est. Value

Last Sold September 14, 2016

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

Est. 89% increase in value since last sale

Current estimated payment $10,588/month

368 Days on Market

Highlights

  • Heated Spa
  • Gated Community
  • Outdoor Fireplace
  • Redfield Elementary School Rated A
  • Vaulted Ceiling
  • Wood Flooring

About This Home

As of September 2016

Exclusive and unique luxury home located in the North Scottsdale Subdivision of Madrid. The discerning buyer will recognize the level of quality and sophistication within this special property. The hand chosen contemporary lighting beautifully accents the many upgrades throughout. From the Chef's kitchen with custom banquette to the sleek backyard entertaining area complete with pool, spa, fire pit and built-in shade structure...this home will not disappoint!!!

Last Agent to Sell the Property

Jacqueline Possner

My Home Group Real Estate License #SA629111000 Listed on: 07/24/2015

My Home Group Real Estate

Last Buyer's Agent

Samara Glassman-Utsunomiya

Realty ONE Group License #BR556225000

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $5,320

Year Built

  • Built in 2005

Lot Details

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

HOA Fees

  • $150 Monthly HOA Fees

Parking

  • 3 Car Direct Access Garage
  • 2 Open Parking Spaces
  • Garage Door Opener

Home Design

  • Wood Frame Construction
  • Tile Roof
  • Stucco

Interior Spaces

  • 4,509 Sq Ft Home
  • 1-Story Property
  • Vaulted Ceiling
  • Ceiling Fan
  • Gas Fireplace
  • Solar Screens
  • Family Room with Fireplace

Kitchen

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

Flooring

  • Wood
  • Carpet
  • Stone

Bedrooms and Bathrooms

  • 5 Bedrooms
  • Primary Bathroom is a Full Bathroom
  • 5 Bathrooms
  • Dual Vanity Sinks in Primary Bathroom
  • Bathtub With Separate Shower Stall

Home Security

  • Security System Owned
  • Fire Sprinkler System

Accessible Home Design

  • No Interior Steps

Pool

  • Heated Spa
  • Private Pool

Outdoor Features

  • Covered Patio or Porch
  • Outdoor Fireplace
  • Fire Pit

Schools

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

Utilities

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

Listing and Financial Details

  • Tax Lot 29
  • Assessor Parcel Number 217-50-763

Community Details

Overview

  • Association fees include ground maintenance
  • Madrid HOA, Phone Number (480) 557-4300
  • Built by Meritage
  • Madrid Subdivision

Recreation

  • Bike Trail

Security

  • Gated Community

Home Details

Home Type

Single Family

Est. Annual Taxes

$5,320

Year Built

Built in 2005

Lot Details

0

HOA Fees

$150 per month

Parking

3

Listing Details

  • Cross Street: Thunderbird & Frank Lloyd Wright
  • Legal Info Range: 5E
  • Property Type: Residential
  • Ownership: Fee Simple
  • HOA #2: N
  • Association Fees Land Lease Fee: N
  • Recreation Center Fee 2: N
  • Recreation Center Fee: N
  • Total Monthly Fee Equivalent: 150.0
  • Basement: N
  • Parking Spaces Slab Parking Spaces: 2.0
  • Parking Spaces Total Covered Spaces: 3.0
  • Separate Den Office Sep Den Office: Y
  • Year Built: 2005
  • Spa Private: Yes
  • Tax Year: 2014
  • Directions: Frank Lloyd Wright to 99th Way, South through Madrid entry gate on 99th Way. West (right) on Celtic Drive. Home is on the right. No sign on property.
  • Property Sub Type: Single Family - Detached
  • Horses: No
  • Lot Size Acres: 0.33
  • Subdivision Name: MADRID
  • Efficiency: Multi-Zones
  • Property Attached Yn: No
  • ResoBuildingAreaSource: Assessor
  • Association Fees:HOA Fee2: 450.0
  • Dining Area:Breakfast Bar: Yes
  • Cooling:Ceiling Fan(s): Yes
  • Technology:Cable TV Avail: Yes
  • Technology:High Speed Internet Available: Yes
  • Special Features: VirtualTour

Interior Features

  • Flooring: Carpet, Stone, Wood
  • Basement YN: No
  • Possible Use: None
  • Spa Features: Heated, Private
  • Possible Bedrooms: 6
  • Total Bedrooms: 5
  • Fireplace Features: 1 Fireplace, Exterior Fireplace, Fire Pit, Family Room, Gas
  • Fireplace: Yes
  • Interior Amenities: Master Downstairs, Eat-in Kitchen, Breakfast Bar, Drink Wtr Filter Sys, Fire Sprinklers, No Interior Steps, Soft Water Loop, Vaulted Ceiling(s), Kitchen Island, Pantry, Double Vanity, Full Bth Master Bdrm, Separate Shwr & Tub, High Speed Internet, Granite Counters
  • Living Area: 4509.0
  • Stories: 1
  • Window Features: Sunscreen(s)
  • Kitchen Features:Built-in Microwave: Yes
  • Community Features:Gated Community2: Yes
  • Kitchen Features:Granite Countertops: Yes
  • Kitchen Features:Kitchen Island: Yes
  • Master Bathroom:Double Sinks: Yes
  • Community Features:BikingWalking Path: Yes
  • Kitchen Features Pantry: Yes
  • Fireplace:Fireplace Family Rm: Yes
  • Fireplace:Exterior Fireplace: Yes
  • Other Rooms:Family Room: Yes
  • Fireplace:Gas Fireplace: Yes
  • Kitchen Features:Reverse Osmosis: Yes
  • Kitchen Features:Cook Top Gas: Yes
  • Fireplace:Firepit: Yes
  • Kitchen Features:Multiple Ovens: Yes
  • Other Rooms:Media Room: Yes
  • KitchenFeatures:Refrigerator: Yes

Exterior Features

  • Fencing: Block
  • Exterior Features: Covered Patio(s), Patio, Private Yard
  • Lot Features: Sprinklers In Rear, Sprinklers In Front, Corner Lot, Gravel/Stone Front, Gravel/Stone Back, Grass Front, Auto Timer H2O Front, Auto Timer H2O Back
  • Pool Features: Private
  • Pool Private: Yes
  • Disclosures: Agency Discl Req, Seller Discl Avail
  • Construction Type: Stucco, Frame - Wood
  • Roof: Tile
  • Construction:Frame - Wood: Yes
  • Exterior Features:Covered Patio(s): Yes
  • Exterior Features:Patio: Yes
  • Exterior Features:Pvt Yrd(s)Crtyrd(s): Yes

Garage/Parking

  • Total Covered Spaces: 3.0
  • Parking Features: Attch'd Gar Cabinets, Dir Entry frm Garage, Electric Door Opener, Extnded Lngth Garage
  • Attached Garage: No
  • Garage Spaces: 3.0
  • Open Parking Spaces: 2.0
  • Parking Features:Dir Entry frm Garage: Yes
  • Parking Features:Electric Door Opener: Yes
  • Parking Features:Attch_squote_d Gar Cabinets: Yes
  • Parking Features:Extnded Lngth Garage: Yes

Utilities

  • Cooling: Refrigeration, Ceiling Fan(s)
  • Heating: Natural Gas
  • Security: Security System Owned
  • Water Source: City Water
  • Heating:Natural Gas: Yes

Condo/Co-op/Association

  • Community Features: Gated Community, Biking/Walking Path
  • Association Fee: 450.0
  • Association Fee Frequency: Quarterly
  • Association Name: Madrid HOA
  • Phone: 480-557-4300
  • Association: Yes

Association/Amenities

  • Association Fees:HOA YN2: Y
  • Association Fees:HOA Transfer Fee2: 467.0
  • Association Fees:HOA Paid Frequency: Quarterly
  • Association Fees:HOA Name4: Madrid HOA
  • Association Fees:HOA Telephone4: 480-557-4300
  • 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_: $

Fee Information

  • Association Fee Includes: Maintenance Grounds

Schools

  • Elementary School: Aztec Elementary School
  • High School: Desert Mountain High School
  • Junior High Dist: Scottsdale Unified District
  • Middle Or Junior School: Desert Canyon Middle School

Lot Info

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

Building Info

  • Builder Name: Meritage

Tax Info

  • Tax Annual Amount: 5320.0
  • Tax Book Number: 217.00
  • Tax Lot: 29
  • Tax Map Number: 50.00

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Jul 24, 2015
Closed on
Sep 10, 2016
Sold by
Khalid Irfan
Bought by
Cohen Jospeh R and Cohen Susan R
Seller's Agent
Jacqueline Possner
My Home Group Real Estate
Buyer's Agent
Samara Glassman-Utsunomiya
Realty ONE Group
List Price
$1,100,000
Sold Price
$960,000
Premium/Discount to List
-$140,000
-12.73%
Current Estimated Value
$1,812,064

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$852,064
Avg. Annual Appreciation
7.37%
Original Mortgage
$390,000
Outstanding Balance
$314,778
Interest Rate
3.42%
Mortgage Type
Future Advance Clause Open End Mortgage
Estimated Equity
$1,497,286

Purchase Details

Closed on
Aug 22, 2005
Sold by
Meritage Homes Construction Inc
Bought by
Meritage Homes Of Arizona Inc and Hancock Mth Communities Inc

Home Financials for this Owner

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

Purchase Details

Closed on
Aug 19, 2005
Sold by
Meritage Homes Of Arizona Inc
Bought by
Khalid Irfan

Home Financials for this Owner

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

Purchase Details

Closed on
Sep 21, 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
Cohen Jospeh R $960,000 First American Title Ins Co
Meritage Homes Of Arizona Inc -- First American Title Ins Co
Khalid Irfan $934,535 --
Meritage Homes Construction Inc $1,085,850 --
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Cohen Joseph R $390,000
Closed Cohen Jospeh R $200,000
Previous Owner Khalid Irfan $375,000
Previous Owner Khalid Irfan $672,000
Previous Owner Khalid Irfan $700,900
Closed Khalid Irfan $91,700
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
09/14/2016 09/14/16 Sold $960,000 -4.0% $213 / Sq Ft
07/26/2016 07/26/16 Pending -- -- --
06/23/2016 06/23/16 Price Changed $1,000,000 -2.9% $222 / Sq Ft
03/19/2016 03/19/16 Price Changed $1,030,000 -1.9% $228 / Sq Ft
02/27/2016 02/27/16 Price Changed $1,050,000 -1.9% $233 / Sq Ft
02/10/2016 02/10/16 Price Changed $1,070,000 -0.5% $237 / Sq Ft
10/25/2015 10/25/15 Price Changed $1,075,000 -2.3% $238 / Sq Ft
07/24/2015 07/24/15 For Sale $1,100,000 -- $244 / 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 $6,775 $109,000 -- --
2024 $6,690 $103,809 -- --
2023 $6,690 $121,330 $24,260 $97,070
2022 $6,316 $97,850 $19,570 $78,280
2021 $6,748 $95,320 $19,060 $76,260
2020 $6,684 $90,360 $18,070 $72,290
2019 $6,429 $87,330 $17,460 $69,870
2018 $6,206 $84,050 $16,810 $67,240
2017 $5,918 $84,860 $16,970 $67,890
2016 $5,792 $77,820 $15,560 $62,260
2015 $5,484 $75,720 $15,140 $60,580
Source: Public Records

Agents Affiliated with this Home

  • J

    Seller's Agent in 2016

    Jacqueline Possner

    My Home Group

    (480) 948-4711

    2 Total Sales

    Jacqueline Possner
    Section Image
  • Samara Glassman-Utsunomiya

    Buyer's Agent in 2016

    Samara Glassman-Utsunomiya

    Realty One Group

    (602) 799-0683

    2 in this area

    137 Total Sales

    Samara Glassman-Utsunomiya
    Section Image

  • S

    Buyer's Agent in 2016

    Samara Glassman

    Compass

See All Agents

Map

Source: Arizona Regional Multiple Listing Service (ARMLS)

MLS Number: 5311882

Arizona Regional Multiple Listing Service (ARMLS)

APN: 217-50-763

Arizona Maricopa County Scottsdale 85260 Horizons

9842 E Celtic Dr Unit 29, Scottsdale, AZ

This home is located at 9842 E Celtic Dr Unit 29, Scottsdale, AZ 85260 since 24 July 2015 and is currently estimated at $1,812,064, approximately $401 per square foot. This property was built in 2005. 9842 E Celtic Dr Unit 29 is a home located in Maricopa County with nearby schools including Redfield Elementary School, Desert Canyon Middle School, and Desert Mountain High School.

Disclaimer: Certain information contained herein is derived from information provided by parties other than Homes.com. All information provided is deemed reliable, but is not guaranteed to be accurate and should be independently verified.

Arizona Regional Multiple Listing Service (ARMLS) All information should be verified by the recipient and none is guaranteed as accurate by ARMLS

Listing Information presented by local MLS brokerage: Ten-X, local REALTOR®- Arlene Richardson - (888)-952-6393

Nearby Homes