NOT LISTED FOR SALE

9874 E Celtic Dr Unit 31 Scottsdale, AZ 85260

Horizons Neighborhood

Estimated Value: $1,815,708

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

Sale Details

Date Sold: March 8, 2021

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

Est. 46% increase in value since last sale

Current estimated payment $10,283 / mo

2 Days on Market

Highlights

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

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

AZ Brokerage Holdings, LLC License #BR006538000 Listed on: 01/30/2021

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

  • 14,450 Sq Ft Lot
  • Desert faces the front and back of the property
  • Artificial Turf
  • Front and Back Yard Sprinklers
  • Sprinklers on Timer
  • Private Yard

HOA Fees

  • $150 Monthly HOA Fees

Parking

  • 3 Car Garage

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
  • Formal Dining Room
  • Mountain Views
  • Washer Hookup

Kitchen

  • Eat-In Kitchen
  • Walk-In Pantry
  • Built-In Oven
  • Gas Oven
  • Gas Cooktop
  • Built-In Microwave
  • Dishwasher
  • Kitchen Island
  • Granite Countertops
  • Disposal

Flooring

  • Wood
  • Carpet
  • Stone

Bedrooms and Bathrooms

  • 5 Bedrooms
  • Split Bedroom Floorplan
  • Walk-In Closet
  • Primary Bathroom is a Full Bathroom
  • Double Vanity
  • Private Water Closet
  • Separate Shower in Primary Bathroom
  • Bathtub With Separate Shower Stall

Home Security

  • Security System Owned
  • Fire Sprinkler System

Eco-Friendly Details

  • North or South Exposure

Outdoor Features

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

Additional Homes

  • Guest House
  • Separate Entry Quarters

Schools

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

Utilities

  • Zoned Heating and Cooling System
  • Heating System Uses Natural Gas
  • Water Softener is Owned
  • 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

Home Details

Home Type

Single Family

Est. Annual Taxes

$6,402

Year Built

Built in 2005

Lot Details

0.33 Acres

HOA Fees

$150 per month

Parking

3

Listing Details

  • Cross Street: FLW AND THUNDERBIRD
  • Property Type: Residential
  • Ownership: Fee Simple
  • Recreation Center Fee: N
  • Total Monthly Fee Equivalent: 150.0
  • 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
  • Separate Den Office Sep Den Office: N
  • Year Built: 2005
  • Tax Year: 2020
  • Property Sub Type: Single Family Residence
  • Horses: No
  • Lot Size Acres: 0.33
  • Subdivision Name: MADRID
  • Efficiency: Multi-Zones
  • Property Attached Yn: No
  • General Property Description:PriceSqFt: 295.33
  • Special Features: None

Interior Features

  • Flooring: Carpet, Stone, Wood
  • Basement YN: No
  • Spa Features: None
  • Appliances: Dishwasher, Disposal, Refrigerator, Gas Cooktop, Microwave, Gas Oven, Gas Range, Water Softener Owned
  • Full Bathrooms: 4
  • Half Bathrooms: 1
  • Total Bedrooms: 5
  • Fireplace Features: Family Room, Gas, Fire Pit
  • Fireplaces: 2
  • Fireplace: Yes
  • Interior Amenities: Full Bth Master Bdrm, Separate Shwr & Tub, Double Vanity, Eat-in Kitchen, Kitchen Island, Walk-in Pantry, Granite Counters, High Speed Internet, Vaulted Ceiling(s)
  • Living Area: 4218.0
  • Stories: 1
  • Window Features: Dual Pane

Exterior Features

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

Garage/Parking

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

Utilities

  • Cooling: Central Air
  • Heating: Natural Gas
  • Laundry Features: Washer Hookup
  • Security: Security System Owned, Fire Sprinkler System
  • Cooling Y N: Yes
  • Heating Yn: Yes
  • Water Source: Public

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:PAD Fee YN2: N
  • Association Fees:Cap ImprovementImpact Fee _percent_: $
  • 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 Lot: 31

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,815,708

Purchase Details

Closed on
Sep 9, 2021
Sold by
Lay Mark and Lay Cydney E
Bought by
Lay Mark 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
AZ Brokerage Holdings, LLC
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.56%
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

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
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

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Buyer Sale Price Title Company
Lay Family Trust -- Brown & Hobkirk Pllc
Lay Mark -- 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

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

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

Property History

Date Event Price List to Sale Price per Sq Ft
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

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,401 $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
See All Agents

Map

Source: Arizona Regional Multiple Listing Service (ARMLS)

MLS Number: 6186770

Arizona Regional Multiple Listing Service (ARMLS)

APN: 217-50-765

Your Personal Tour Guide

Ask me questions while you tour the home.