NOT LISTED FOR SALE

9874 E Celtic Dr Unit 31 Scottsdale, AZ 85260

Horizons Neighborhood

Estimated Value: $1,509,000 - $1,925,480

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

Sale Details

Date Sold: March 8, 2021

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

Est. 41% increase in value since last sale

Current estimated payment $10,197 / mo

2 Days on Market

Highlights

  • Guest House
  • Private Pool
  • Mountain View
  • Redfield Elementary School Rated A
  • 0.33 Acre Lot
  • 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

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

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
  • Const - Finish:Const - Finish: Painted, Stucco
  • Cooling:Cooling: Central Air
  • EnergyGreen Feature:EnergyGreen Feature: Multi-Zones
  • Other Rooms:Other Rooms: Guest Qtrs-Sep Entrn
  • Technology:Technology: Cable TV Avail, High Speed Internet, Security System Owned
  • 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
  • Additional Bedroom:Additional Bedroom: Master Bedroom Walk-in Closet
  • Dining Area:Dining Area: Formal, Eat-in Kitchen
  • Interior Features:Interior Features: Vaulted Ceiling(s), Fire Sprinkler System, Water Softener Owned
  • Kitchen Features:Kitchen Features: Dishwasher, Disposal, Refrigerator, Kitchen Island, Gas Cooktop, Built-in Microwave, Wall Oven(s), Walk-in Pantry, Granite Counters, Gas Oven, Gas Range
  • Laundry:Laundry: Washer Hookup
  • Master Bathroom:Master Bathroom: Full Bth Master Bdrm, Separate Shwr & Tub, Double Vanity, Private Toilet Room
  • Master Bedroom:Master Bedroom: Split
  • Window Features: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
  • General Property Description:Community Pool YN2: No
  • General Property Description:Private Pool YN2: 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

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
  • Utilities:Utilities: APS, SW Gas

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

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 Name Owned For Owner Type

Purchase Details

Closed on
Jul 14, 2022
Sold by
Bought by
Current Estimated Value
$1,761,370

Purchase Details

Closed on
Sep 9, 2021
Sold by
Bought by

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

Purchase Details

Listed on
Jan 30, 2021
Closed on
Mar 1, 2021
Sold by
Bought by
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
6.62%
Original Mortgage
$548,250
Interest Rate
0.027%
Mortgage Type
New Conventional

Purchase Details

Closed on
Jun 30, 2015
Sold by
Bought by

Purchase Details

Closed on
Feb 1, 2014
Sold by
Bought by

Purchase Details

Closed on
Feb 19, 2013
Sold by
Bought by

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

Purchase Details

Closed on
Mar 8, 2011
Sold by
Bought by

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
0.0471%
Mortgage Type
Credit Line Revolving

Purchase Details

Closed on
Nov 22, 2010
Sold by
Bought by

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

Purchase Details

Closed on
Sep 14, 2005
Sold by
Bought by

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

Purchase Details

Closed on
Sep 9, 2005
Sold by
Bought by

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

Purchase Details

Closed on
Sep 21, 2004
Sold by
Bought by
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
-- Brown & Hobkirk Pllc
-- Magnus Title
$1,245,700 Lawyers Title Of Arizona Inc
-- Lawyers Title Of Arizona Inc
-- None Available
-- None Available
-- Driggs Title Agency Inc
-- Driggs Title Agency Inc
-- Driggs Title Agency Inc
-- None Available
$615,000 First American Title Ins Co
$789,491 --
-- First American Title Ins Co
$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 $509,000
Previous Owner $548,250
Previous Owner $250,000
Previous Owner $417,000
Previous Owner $75,000
Previous Owner $417,000
Previous Owner $948,750
Previous Owner $631,550
Previous Owner $78,900
Source: Public Records

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

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

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.