$1,850,000
UNDER CONTRACT $100K PRICE DROP

9842 E Celtic Dr Unit 29 Scottsdale, AZ 85260

Horizons Neighborhood

Estimated payment $10,517/month

Total Views 11,009
5 Beds
4.5 Baths
4,509 Sq Ft
$410 Price per Sq Ft

Highlights

  • Heated Spa
  • Sub-Zero Refrigerator
  • Outdoor Fireplace
  • Redfield Elementary School Rated A
  • Vaulted Ceiling
  • Wood Flooring

About This Home

BEST PRICED HOME IN THE NEIGHBORHOOD! LOCATED IN THE PRIVATE, GATED, EXCLUSIVE COMMUNITY OF MADRID, this fantastic home has it all! OPEN SPLIT FLOOR PLAN featuring vaulted ceilings, large rooms, and bathed in natural light. Meticulously maintained. AMAZING CHEF KITCHEN with double ovens, gas range, large sub-zero refrigerator and walk-in pantry. Backyard features lush mature greenery with a nice size pool and spa, built-in gas BBQ, raised planters, fire pit, and multiple covered patios. AWESOME LOCATION convenient to the 101 freeway, tons of eateries, and hiking/biking trails. TAKE MARICOPA TRAIL FROM HOUSE ALL THE WAY TO TEMPE. The neighborhood is very friendly and quiet. In fact, if you're looking for a peaceful and private property, this is definitely a great option! CORNER LOT.

Listing Agent

Jeff Fields

Russ Lyon Sotheby's International Realty License #SA643055000 Listed on: 09/25/2025

Russ Lyon Sotheby's International Realty

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $6,775

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

  • $220 Monthly HOA Fees

Parking

  • 3 Car Direct Access Garage
  • 2 Open Parking Spaces

Home Design

  • Wood Frame Construction
  • Tile Roof
  • Stucco

Interior Spaces

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

Kitchen

  • Eat-In Kitchen
  • Breakfast Bar
  • Double Oven
  • Sub-Zero Refrigerator
  • ENERGY STAR Qualified Appliances
  • Kitchen Island

Flooring

  • Wood
  • Carpet
  • Stone

Bedrooms and Bathrooms

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

Accessible Home Design

  • No Interior Steps

Pool

  • Heated Spa
  • Play Pool
  • Pool Pump

Outdoor Features

  • Covered Patio or Porch
  • Outdoor Fireplace
  • Fire Pit

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

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

Home Details

Home Type

Single Family

Est. Annual Taxes

$6,775

Year Built

Built in 2005

Lot Details

0.33 Acres

HOA Fees

$220 per month

Parking

3

Listing Details

  • Cross Street: Thunderbird & Frank Lloyd Wright
  • Property Type: Residential
  • Ownership: Fee Simple
  • Recreation Center Fee 2: N
  • Recreation Center Fee: N
  • Total Monthly Fee Equivalent: 220.0
  • Separate Den Office Sep Den Office: Y
  • Year Built: 2005
  • Tax Year: 2024
  • 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: 410.29
  • Special Features: UnderContract

Interior Features

  • Flooring: Carpet, Stone, Wood
  • Basement YN: No
  • Possible Use: None
  • Spa Features: Private, Heated
  • Appliances: Dishwasher, Disposal, Refrigerator, Gas Cooktop, Microwave, Reverse Osmosis, Built-In Gas Oven, Gas Oven, Gas Range, Washer, Dryer, Water Softener Owned, Water Purifier
  • Full Bathrooms: 3
  • Half Bathrooms: 3
  • Total Bedrooms: 5
  • Fireplace Features: Family Room, Gas, Exterior Fireplace, Fire Pit
  • Fireplaces: 1
  • Fireplace: Yes
  • Interior Amenities: Full Bth Master Bdrm, Separate Shwr & Tub, Double Vanity, Eat-in Kitchen, Breakfast Bar, Kitchen Island, Walk-in Pantry, Granite Counters, High Speed Internet, Master Downstairs, Vaulted Ceiling(s), No Interior Steps
  • Living Area: 4509.0
  • Stories: 1
  • Window Features: Solar Screens

Exterior Features

  • Fencing: Block
  • Exterior Features: Private Yard
  • Lot Features: Corner Lot, Sprinklers In Front, Sprinklers In Rear, Gravel/Stone Front, Gravel/Stone Back, Grass Front, Auto Timer H2O Front, Auto Timer H2O Back
  • Pool Features: Heated, Play Pool, Variable Speed Pump
  • Pool Private: Yes
  • Disclosures: Seller Discl Avail, Agency Discl Req
  • Common Walls: All on One Level
  • Construction Type: Wood Frame, Painted, Stucco
  • Patio And Porch Features: Patio, Covered Patio(s)
  • Roof: Tile

Garage/Parking

  • Total Covered Spaces: 3.0
  • Parking Features: Extended Length Garage, Garage Door Opener, Attch'd Gar Cabinets, Direct Access
  • Attached Garage: No
  • Garage Spaces: 3.0
  • Open Parking Spaces: 2.0

Utilities

  • Cooling: Ceiling Fan(s), Central Air
  • Heating: Natural Gas
  • Laundry Features: Engy Star (See Rmks)
  • Security: Security System Owned, Fire Sprinkler System
  • Cooling Y N: Yes
  • Heating Yn: Yes
  • Water Source: Public

Condo/Co-op/Association

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

Association/Amenities

  • Association Fees:HOA DisclosureAddendum Affirmation: Yes
  • Association Fees:Special Assessment HOA: No
  • Association Fees:PAD Fee YN2: N
  • Association Fees:Cap ImprovementImpact Fee _percent_: $
  • Association Fees:Prepaid Association Fees HOA: 660.0
  • Association Fees:Disclosure Fees HOA: 190.0
  • Association Fees:Cap ImprovementImpact Fee 2 _percent_: $

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

Building Info

  • Builder Name: Meritage

Tax Info

  • Tax Annual Amount: 6775.0
  • Tax Book Number: 217.0
  • Tax Lot: 29
  • Tax Map Number: 50.0

Map

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

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 $7,098 $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

Property History

Date Event Price List to Sale Price per Sq Ft Prior Sale
01/29/2026 01/29/26 Price Changed $1,850,000 -3.9% $410 / Sq Ft
11/14/2025 11/14/25 Price Changed $1,925,000 -1.3% $427 / Sq Ft
09/25/2025 09/25/25 For Sale $1,950,000 +103.1% $432 / Sq Ft
09/14/2016 09/14/16 Sold $960,000 -4.0% $213 / Sq Ft View Prior Sale
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)

Purchase History

Date Type Sale Price Title Company
Warranty Deed $960,000 First American Title Ins Co
Special Warranty Deed -- First American Title Ins Co
Special Warranty Deed $934,535 --
Cash Sale Deed $1,085,850 --
Source: Public Records

Mortgage History

Date Status Loan Amount Loan Type
Open $200,000 New Conventional
Previous Owner $700,900 New Conventional
Closed $91,700 No Value Available
Source: Public Records

Source: Arizona Regional Multiple Listing Service (ARMLS)

MLS Number: 6924440

Arizona Regional Multiple Listing Service (ARMLS)

APN: 217-50-763

Arizona Maricopa County Scottsdale 85260 Horizons

9842 E Celtic Dr Unit 29, Scottsdale, AZ

Under Contract

Detached

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
Jeff Fields
Listing Agent
Jeff Fields
Section Image
Russ Lyon Sotheby's International Realty
(480) 269-3123
Your Personal Tour Guide

Ask me questions while you tour the home.