NOT LISTED FOR SALE

9874 E Celtic Dr Unit 31 Scottsdale, AZ 85260

Horizons Neighborhood

Estimated Value: $1,471,000 - $1,985,000

5 Beds
4.5 Baths
4,218 Sq Ft
$425/Sq Ft Est. Value

Last Sold March 08, 2021

Last sale price $1,245,700 $295 Per Sq Ft

Est. 44% increase in value since last sale

Current estimated payment $10,344/month

2 Days on Market

Highlights

  • Guest House
  • Private Pool
  • Mountain View
  • Redfield Elementary School Rated A
  • Gated Community
  • Family Room with Fireplace

About This Home

As of March 2021

Madrid - popular Gated enclave of just 61 homes. RARE opportunity in this high demand North Scottsdale neighborhood. Single level 5 bedroom 4.5 bath home. PLUS CASITA with separate entrance off courtyard. KEY upgrades- HVAC 2015 and 2020, 2 water heaters 2020,newer exterior paint,3 panel security system, newer iron front door, California closet systems T/O home, hand scrapped wood flooring, French doors @ kitchen and Master, water softener, Oversize GE Monogram Fridge. Kitchen features a new custom backsplash, wine fridge , Bosch dishwasher, Wolf Gas oven and cooktop, granite tops. Welcoming entry through arched iron gate to courtyard Featuring a fireplace and fountain.
PRIVATE RESORT Back yard ! Pool, sport court, gas BBQ , synthetic turf, paver stone hardscape. Garage is EV READY!

Last Agent to Sell the Property

Richard Amos

Fathom Realty Elite License #BR006538000 Listed on: 01/30/2021

Fathom Realty Elite

Last Buyer's Agent

Wesley Patterson

MCG Realty License #SA551769000

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $6,402

Year Built

  • Built in 2005

Lot Details

  • 0.33 Acre Lot
  • Desert faces the front and back of the property
  • Block Wall Fence
  • Artificial Turf
  • Front and Back Yard Sprinklers
  • Sprinklers on Timer
  • Private Yard

HOA Fees

  • $150 Monthly HOA Fees

Parking

  • 3 Car Garage
  • Garage Door Opener

Home Design

  • Wood Frame Construction
  • Tile Roof
  • Stucco

Interior Spaces

  • 4,218 Sq Ft Home
  • 1-Story Property
  • Vaulted Ceiling
  • Gas Fireplace
  • Double Pane Windows
  • Family Room with Fireplace
  • 2 Fireplaces
  • Mountain Views
  • Security System Owned
  • Washer and Dryer Hookup

Kitchen

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

Flooring

  • Wood
  • Carpet
  • Stone

Bedrooms and Bathrooms

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

Outdoor Features

  • Private Pool
  • Covered Patio or Porch
  • Fire Pit
  • Built-In Barbecue

Additional Homes

  • Guest House

Schools

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

Utilities

  • Zoned Heating and Cooling System
  • Heating System Uses Natural Gas
  • High Speed Internet
  • Cable TV Available

Listing and Financial Details

  • Tax Lot 31
  • Assessor Parcel Number 217-50-765

Community Details

Overview

  • Association fees include ground maintenance
  • Brown Comm Man Association, Phone Number (480) 539-1396
  • Built by MERITAGE HOMES
  • Madrid Subdivision

Recreation

  • Sport Court

Security

  • Gated Community

Home Details

Home Type

Single Family

Est. Annual Taxes

$6,402

Year Built

Built in 2005

Lot Details

0

HOA Fees

$150 per month

Parking

3

Listing Details

  • Cross Street: FLW AND THUNDERBIRD
  • Legal Info Range: 5E
  • Property Type: Residential
  • Ownership: Fee Simple
  • HOA #2: N
  • Association Fees Land Lease Fee: N
  • Recreation Center Fee: N
  • Total Monthly Fee Equivalent: 150.0
  • Basement: N
  • Updated Floors: Partial
  • Items Updated Floor Yr Updated: 2017
  • Updated Heating or Cooling Units: Partial
  • Items Updated Ht Cool Yr Updated: 2020
  • Updated Kitchen: Partial
  • Items Updated Kitchen Yr Updated: 2016
  • Updated Pool: Full
  • Items Updated Pool Yr Updated: 2010
  • Updated Wiring: Full
  • Items Updated Wiring Yr Updated: 2016
  • Parking Spaces Slab Parking Spaces: 3.0
  • Parking Spaces Total Covered Spaces: 3.0
  • Separate Den Office Sep Den Office: N
  • Year Built: 2005
  • Tax Year: 2020
  • Directions: EAST TO 99TH WAY, SOUTH THROUGH GATE TO CELTIC, RIGHT ON CELTIC TO HOME ON RIGHT.
  • Property Sub Type: Single Family Residence
  • Horses: No
  • Lot Size Acres: 0.33
  • Subdivision Name: MADRID
  • Efficiency: Multi-Zones
  • Property Attached Yn: No
  • Association Fees:HOA Fee2: 450.0
  • Windows:Dual Pane: Yes
  • Technology:Cable TV Avail: Yes
  • Cooling:Central Air: Yes
  • Water Source City Water: Yes
  • Fireplace Features Fireplace Family Rm: Yes
  • Fireplace Features Gas Fireplace: Yes
  • Kitchen Features:Gas Cooktop: Yes
  • Technology:High Speed Internet: Yes
  • Special Features: None

Interior Features

  • Flooring: Carpet, Stone, Wood
  • Basement YN: No
  • Spa Features: None
  • Appliances: Gas Cooktop
  • Possible Bedrooms: 5
  • Total Bedrooms: 5
  • Fireplace Features: Fire Pit, 2 Fireplace, Family Room, Gas
  • Fireplace: Yes
  • Interior Amenities: High Speed Internet, Granite Counters, Double Vanity, Eat-in Kitchen, Vaulted Ceiling(s), Kitchen Island, Full Bth Master Bdrm, Separate Shwr & Tub
  • Living Area: 4218.0
  • Stories: 1
  • Window Features: Dual Pane
  • Kitchen Features:RangeOven Gas: Yes
  • Kitchen Features:Built-in Microwave: Yes
  • Kitchen Features:Kitchen Island: Yes
  • Master Bathroom:Double Sinks: Yes
  • Kitchen Features:Wall Oven(s): Yes
  • Kitchen Features:Walk-in Pantry: Yes
  • Other Rooms:Guest Qtrs-Sep Entrn: Yes
  • KitchenFeatures:Refrigerator: Yes
  • Community Features:Gated: Yes
  • Fireplace Features:Fire Pit: Yes
  • Kitchen Features:Granite Counters: Yes

Exterior Features

  • Fencing: Block
  • Exterior Features: Private Yard, Sport Court(s), Built-in Barbecue
  • Lot Features: Sprinklers In Rear, Sprinklers In Front, Desert Back, Desert Front, Synthetic Grass Back, Auto Timer H2O Front, Auto Timer H2O Back
  • Pool Private: Yes
  • View: Mountain(s)
  • Disclosures: Seller Discl Avail
  • Construction Type: Stucco, Wood Frame, Painted
  • Other Structures: Separate Guest House
  • Patio And Porch Features: Covered Patio(s)
  • Roof: Tile
  • Construction:Frame - Wood: Yes
  • Exterior Features:Covered Patio(s): Yes
  • Exterior Features:Built-in BBQ: Yes
  • Exterior Features:Pvt Yrd(s)Crtyrd(s): Yes
  • Exterior Features:Separate Guest House: Yes
  • Exterior Features:Sport Court(s): Yes

Garage/Parking

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

Utilities

  • Cooling: Central Air
  • Heating: Natural Gas
  • Laundry Features: Wshr/Dry HookUp Only
  • Security: Fire Sprinkler System, Security System Owned
  • Cooling Y N: Yes
  • Heating Yn: Yes
  • Water Source: City Water
  • Heating:Natural Gas: Yes

Condo/Co-op/Association

  • Community Features: Gated
  • Association Fee: 450.0
  • Association Fee Frequency: Quarterly
  • Association Name: MADRID
  • Phone: 480-539-1396
  • Association: Yes

Association/Amenities

  • Association Fees:HOA YN2: Y
  • Association Fees:HOA Paid Frequency: Quarterly
  • Association Fees:HOA Name4: MADRID
  • Association Fees:HOA Telephone4: 480-539-1396
  • Association Fees:PAD Fee YN2: N
  • Association Fees:Cap ImprovementImpact Fee _percent_: $
  • Association Fee Incl:Common Area Maint3: Yes
  • Association Fees:HOA Management Company: BROWN COMM MAN
  • Association Fees:HOA Management Phone: 480-539-1396

Fee Information

  • Association Fee Includes: Maintenance Grounds

Schools

  • Elementary School: Desert Canyon Elementary
  • 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-765

Building Info

  • Builder Name: MERITAGE HOMES

Tax Info

  • Tax Annual Amount: 6402.0
  • Tax Book Number: 217.00
  • Tax Lot: 31
  • Tax Map Number: 50.00

Ownership History

Date Name Owned For Owner Type

Purchase Details

Closed on
Jul 14, 2022
Sold by
Lay Mark D and Lay Cydney E
Bought by
Lay Family Trust
Current Estimated Value
$1,791,872

Purchase Details

Closed on
Sep 9, 2021
Sold by
Lay Mark D and Lay Cydney E
Bought by
Lay Mark D and Lay Cydney E

Home Financials for this Owner

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

Purchase Details

Listed on
Jan 30, 2021
Closed on
Mar 1, 2021
Sold by
Pierce John D and Pierce Hilarie H
Bought by
Pierce Hilarie H
Seller's Agent
Richard Amos
Fathom Realty Elite
Buyer's Agent
Wesley Patterson
MCG Realty
List Price
$1,250,000
Sold Price
$1,245,700
Premium/Discount to List
-$4,300
-0.34%

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
7.63%
Original Mortgage
$548,250
Interest Rate
2.7%
Mortgage Type
New Conventional

Purchase Details

Closed on
Jun 30, 2015
Sold by
Reagan Michael J and Reagan Jami M
Bought by
The Michael & Jami Reagan Revocable Livi

Purchase Details

Closed on
Feb 1, 2014
Sold by
Reagan Michael J
Bought by
Reagan Michael J and Reagan Jami M

Purchase Details

Closed on
Feb 19, 2013
Sold by
Reagan Michael J
Bought by
Reagan Michael J and The M J Reagan Separate Proper

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

Purchase Details

Closed on
Mar 8, 2011
Sold by
Reagan Micahel J
Bought by
Reagan Michael J and M J Reagan Separate Property T

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$75,000
Interest Rate
4.71%
Mortgage Type
Credit Line Revolving

Purchase Details

Closed on
Nov 22, 2010
Sold by
U S Bank National Association
Bought by
Reagan Michael J

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

Purchase Details

Closed on
Sep 14, 2005
Sold by
Meritage Homes Of Arizona Inc
Bought by
Kang Hak Sung and Kang Yeon Ok

Home Financials for this Owner

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

Purchase Details

Closed on
Sep 9, 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
$631,550
Interest Rate
5.76%
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
Lay Family Trust -- Brown & Hobkirk Pllc
Lay Mark D -- Magnus Title
Pierce Hilarie H -- Lawyers Title Of Arizona Inc
Lay Mark D $1,245,700 Lawyers Title Of Arizona Inc
The Michael & Jami Reagan Revocable Livi -- None Available
Reagan Michael J -- None Available
Reagan Michael J -- Driggs Title Agency Inc
Reagan Michael J -- Driggs Title Agency Inc
Reagan Michael J -- Driggs Title Agency Inc
Reagan Michael J -- None Available
Reagan Michael J $615,000 First American Title Ins Co
Kang Hak Sung $789,491 --
Meritage Homes Of Arizona Inc -- First American Title Ins Co
Meritage Homes Construction Inc $1,085,850 --
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Previous Owner Lay Mark D $509,000
Previous Owner Pierce Hilarie H $548,250
Previous Owner Reagan Michael J $250,000
Previous Owner Reagan Michael J $417,000
Previous Owner Reagan Michael J $75,000
Previous Owner Reagan Michael J $417,000
Previous Owner Kang Hak Sung $948,750
Previous Owner Kang Hak Sung $631,550
Previous Owner Meritage Homes Of Arizona Inc $78,900
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
03/08/2021 03/08/21 Sold $1,245,700 -0.3% $295 / Sq Ft
01/30/2021 01/30/21 Pending -- -- --
01/28/2021 01/28/21 For Sale $1,250,000 -- $296 / 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,175 $104,776 -- --
2024 $7,007 $99,786 -- --
2023 $7,007 $117,200 $23,440 $93,760
2022 $6,648 $95,220 $19,040 $76,180
2021 $7,063 $92,530 $18,500 $74,030
2020 $6,402 $87,850 $17,570 $70,280
2019 $6,156 $85,180 $17,030 $68,150
2018 $5,942 $80,680 $16,130 $64,550
2017 $5,666 $82,020 $16,400 $65,620
2016 $5,544 $74,420 $14,880 $59,540
2015 $5,248 $72,230 $14,440 $57,790
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: 6186770

Arizona Regional Multiple Listing Service (ARMLS)

APN: 217-50-765