NOT LISTED FOR SALE

9875 E Celtic Dr Unit 44 Scottsdale, AZ 85260

Horizons Neighborhood

Estimated Value: $2,168,000 - $2,429,000

5 Beds
4.5 Baths
5,357 Sq Ft
$435/Sq Ft Est. Value

Last Sold May 30, 2024

Last sale price $2,410,000 $450 Per Sq Ft

Est. 3% decrease in value since last sale

Current estimated payment $13,479/month

Highlights

  • Heated Spa
  • Solar Power System
  • Mountain View
  • Redfield Elementary School Rated A
  • Gated Community
  • 3-minute walk to Aztec Park

About This Home

As of May 2024

Welcome to this stunning 5-bedroom, 4.5-bathroom house with a full basement located in the gated Madrid Community. As you enter, you are greeted by a private courtyard, a cozy fireplace, and elegant double iron front doors. The formal dining room is adorned with a beautiful stone wall, wine and beverage refrigerators, and double doors that lead to the resort-like backyard. The kitchen is equipped with double ovens, a gas stove, walk-in pantry, warming drawer, coffee bar, and a large island. The office features custom-built cabinets and can also be used as a 6th bedroom. The basement includes a full movie theater with built-in seating, work out area,2 additional bedrooms and a full bathroom. The primary bedroom has a separate sitting area, gas fireplace and large walk in closet with custom-built cabinets.Escape to your own backyard oasis complete with a heated pool, waterfall, fire pit, artificial turf, covered area with a TV and misters. Perfect for hosting family barbecues. The one car garage has an electric car outlet... this house is a must-see!

Last Agent to Sell the Property

Jill Gee

MAR Realty, L.L.C. License #BR519169000 Listed on: 04/20/2024

Last Buyer's Agent

Tucker Blalock

The Brokery License #BR642462000

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $7,043

Year Built

  • Built in 2004

Lot Details

  • 0.36 Acre Lot
  • Wrought Iron Fence
  • Block Wall Fence
  • Artificial Turf
  • Corner Lot
  • Misting System
  • Front and Back Yard Sprinklers
  • Sprinklers on Timer

HOA Fees

  • $181 Monthly HOA Fees

Parking

  • 3 Car Garage

Home Design

  • Wood Frame Construction
  • Tile Roof
  • Stucco

Interior Spaces

  • 5,357 Sq Ft Home
  • 1-Story Property
  • Vaulted Ceiling
  • Living Room with Fireplace
  • 3 Fireplaces
  • Mountain Views
  • Washer and Dryer Hookup
  • Finished Basement

Kitchen

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

Bedrooms and Bathrooms

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

Eco-Friendly Details

  • Solar Power System

Pool

  • Heated Spa
  • Heated Pool

Outdoor Features

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

Schools

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

Utilities

  • Central Air
  • Heating System Uses Natural Gas
  • High Speed Internet
  • Cable TV Available

Listing and Financial Details

  • Tax Lot 44
  • Assessor Parcel Number 217-50-778

Community Details

Overview

  • Association fees include street maintenance
  • Brown Management Association, Phone Number (480) 339-8820
  • Built by Meritage Homes
  • Madrid Subdivision

Security

  • Gated Community

Home Details

Home Type

Single Family

Est. Annual Taxes

$7,043

Year Built

Built in 2004

Lot Details

0

HOA Fees

$181 per month

Parking

3

Listing Details

  • Cross Street: Frank Llyoyd Wright and Thunderbird
  • Property Type: Residential
  • Ownership: Fee Simple
  • HOA #2: N
  • Association Fees Land Lease Fee: N
  • Recreation Center Fee: N
  • Total Monthly Fee Equivalent: 181.33
  • Basement: Y
  • Parking Spaces Total Covered Spaces: 3.0
  • Separate Den Office Sep Den Office: Y
  • Solar Panels Grid: On
  • Solar Panelsk W: 18.48
  • Year Built: 2004
  • Spa Private: Yes
  • Tax Year: 2023
  • Directions: South on Thunderbird from FLW to the gate on the left....go right after you enter through gate home is on one the right hand side
  • Property Sub Type: Single Family Residence
  • Horses: No
  • Lot Size Acres: 0.36
  • Subdivision Name: Madrid
  • Efficiency: Solar Panels
  • Property Attached Yn: No
  • Association Fees:HOA Fee2: 544.0
  • Dining Area:Breakfast Bar: Yes
  • Technology:Cable TV Avail: Yes
  • Cooling:Central Air: Yes
  • Water Source City Water: Yes
  • Fireplace Features Fireplace Living Rm: Yes
  • Fireplace Features Fireplace Master Bdr: Yes
  • Kitchen Features:Gas Cooktop: Yes
  • Technology:High Speed Internet: Yes
  • Special Features: None

Interior Features

  • Basement: Finished
  • Basement YN: Yes
  • Spa Features: Heated, Private
  • Appliances: Gas Cooktop
  • Possible Bedrooms: 6
  • Total Bedrooms: 5
  • Fireplace Features: Fire Pit, 3+ Fireplace, Living Room, Master Bedroom
  • Fireplace: Yes
  • Interior Amenities: High Speed Internet, Granite Counters, Double Vanity, Eat-in Kitchen, Breakfast Bar, 9+ Flat Ceilings, Vaulted Ceiling(s), Kitchen Island, Full Bth Master Bdrm, Separate Shwr & Tub
  • Living Area: 5357.0
  • Stories: 1
  • Kitchen Features:RangeOven Elec: Yes
  • Kitchen Features:Built-in Microwave: Yes
  • Kitchen Features:Kitchen Island: Yes
  • Master Bathroom:Double Sinks: Yes
  • Other Rooms:Great Room: Yes
  • Other Rooms:Family Room: Yes
  • Kitchen Features:Reverse Osmosis: Yes
  • Kitchen Features:Wall Oven(s): Yes
  • Kitchen Features:Walk-in Pantry: Yes
  • Kitchen Features:Multiple Ovens: Yes
  • Other Rooms:Media Room: Yes
  • Basement Description:Finished2: Yes
  • KitchenFeatures:Refrigerator: Yes
  • Community Features:Gated: Yes
  • Fireplace Features:Fire Pit: Yes
  • Kitchen Features:Granite Counters: Yes

Exterior Features

  • Fencing: Block, Wrought Iron
  • Exterior Features: Misting System, Built-in Barbecue
  • Lot Features: Sprinklers In Rear, Sprinklers In Front, Corner Lot, Synthetic Grass Back, Auto Timer H2O Front, Auto Timer H2O Back
  • Pool Features: Heated, Private
  • View: Mountain(s)
  • Disclosures: Agency Discl Req, Seller Discl Avail
  • Common Walls: No Common Walls
  • Construction Type: Stucco, Wood Frame, Painted
  • Patio And Porch Features: Covered Patio(s), Patio
  • Roof: Tile
  • Construction:Frame - Wood: Yes
  • Exterior Features:Covered Patio(s): Yes
  • Exterior Features:Built-in BBQ: Yes
  • Exterior Features:Patio: Yes
  • Exterior Features:Misting System: Yes

Garage/Parking

  • Total Covered Spaces: 3.0
  • Garage Spaces: 3.0

Utilities

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

Condo/Co-op/Association

  • Community Features: Gated
  • Association Fee: 544.0
  • Association Fee Frequency: Quarterly
  • Association Name: Madrid
  • Phone: 480-339-8820
  • Association: Yes

Association/Amenities

  • Association Fees:HOA YN2: Y
  • Association Fees:HOA DisclosureAddendum Affirmation: Yes
  • Association Fees:HOA Paid Frequency: Quarterly
  • Association Fees:HOA Name4: Madrid
  • Association Fees:HOA Telephone4: 480-339-8820
  • Association Fees:Special Assessment HOA: No
  • Association Fees:PAD Fee YN2: N
  • Association Fees:Cap ImprovementImpact Fee _percent_: $
  • Association Fees:Prepaid Association Fees HOA: 544.0
  • Association Fees:Disclosure Fees HOA: 190.0
  • Association Fees:Other Fees HOA: 25.0
  • Association Fees:Other Fees Description: 185.00 resale/new owner fee
  • Association Fees:HOA Management Company: Brown Management
  • Association Fee Incl:Street Maint: Yes

Fee Information

  • Association Fee Includes: Street Maint

Schools

  • Elementary School: Redfield 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: 15755.0
  • Parcel #: 217-50-778

Building Info

  • Builder Name: Meritage Homes

Tax Info

  • Tax Annual Amount: 7043.0
  • Tax Book Number: 217.00
  • Tax Lot: 44
  • Tax Map Number: 50.00

Ownership History

Date Name Owned For Owner Type

Purchase Details

Closed on
Feb 18, 2025
Sold by
Mueller Brandon and Mueller Jody
Bought by
Brandon D Mueller And Jody L Mueller Revocabl and Mueller
Current Estimated Value
$2,331,665

Purchase Details

Listed on
Apr 20, 2024
Closed on
May 30, 2024
Sold by
Stottlemyre Todd and Stottlemyre Erica
Bought by
Mueller Brandon and Mueller Jody
Seller's Agent
Jill Gee
MAR Realty, L.L.C.
Buyer's Agent
Tucker Blalock
The Brokery
List Price
$2,390,000
Sold Price
$2,410,000
Premium/Discount to List
$20,000
0.84%
Views
9

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
-2.67%
Original Mortgage
$1,687,000
Interest Rate
7.1%
Mortgage Type
New Conventional

Purchase Details

Listed on
Feb 18, 2022
Closed on
Mar 21, 2022
Sold by
Rabin Family Trust
Bought by
Stottlemyre Todd and Stottlemyre Erica
Seller's Agent
Carole Rabin
HomeSmart
Buyer's Agent
Jill Gee
MAR Realty, L.L.C.
List Price
$2,250,000
Sold Price
$2,250,000

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
3.22%
Original Mortgage
$647,200
Interest Rate
4.42%
Mortgage Type
New Conventional

Purchase Details

Closed on
Feb 26, 2016
Sold by
Rabin Steve M and Rabin Jennifer
Bought by
The Rabin Family Trust

Home Financials for this Owner

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

Purchase Details

Closed on
Jun 2, 2012
Sold by
Rabin Steven M and Rabin Jennifer
Bought by
Rabin Steven M and Rabin Jennifer

Purchase Details

Listed on
Feb 5, 2012
Closed on
Feb 13, 2012
Sold by
Espinosa Russell G and Espinosa Maria
Bought by
Rabin Steven M and Rabin Jennifer
Seller's Agent
Kathy Loeffler
Fathom Realty Elite
Buyer's Agent
Carole Rabin
HomeSmart
List Price
$930,000
Sold Price
$893,000
Premium/Discount to List
-$37,000
-3.98%

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.41%
Original Mortgage
$297,400
Interest Rate
3.91%
Mortgage Type
Credit Line Revolving

Purchase Details

Closed on
Nov 12, 2009
Sold by
Espinosa Russell G
Bought by
Espinosa Russell G and Espinosa Maria

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

Purchase Details

Closed on
Aug 6, 2008
Sold by
Espinosa Russell G
Bought by
Espinosa Russell G and Espinosa Maria

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
6.42%
Mortgage Type
Purchase Money Mortgage

Purchase Details

Closed on
Jul 21, 2008
Sold by
Espinosa Maria L
Bought by
Espinosa Russell G

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
6.42%
Mortgage Type
Purchase Money Mortgage

Purchase Details

Closed on
Dec 6, 2004
Sold by
Meritage Homes Of Arizona Inc
Bought by
Walder Howard E and Walder Berta

Home Financials for this Owner

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

Purchase Details

Closed on
May 25, 2004
Sold by
Schuler Homes Of Arizona Llc
Bought by
Purdy Julie A and Garcia Rebecca A

Home Financials for this Owner

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

Purchase Details

Closed on
Apr 27, 2004
Sold by
Taro Properties Arizona I Llc
Bought by
Hancock Mth Builders Inc

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$295,000
Interest Rate
5.86%
Mortgage Type
New Conventional
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
Brandon D Mueller And Jody L Mueller Revocabl -- None Listed On Document
Mueller Brandon $2,410,000 Landmark Title
Stottlemyre Todd $2,250,000 Chicago Title
The Rabin Family Trust -- None Available
Rabin Steven M -- Nationwide Title Clearing In
Rabin Steven M -- None Available
Rabin Steven M $893,000 First American Title Ins Co
Espinosa Russell G -- Accommodation
Espinosa Russell G -- Pioneer Title Agency Inc
Espinosa Russell G -- Pioneer Title Agency Inc
Espinosa Russell G -- Fidelity Natl Title Ins Co
Espinosa Russell G $1,125,000 Fidelity Natl Title Ins Co
Espinosa Russell G -- Fidelity National Title
Walder Howard E $847,807 First American Title Ins Co
Meritage Homes Of Arizona Inc -- First American Title Ins Co
Purdy Julie A $294,817 Dhi Title Of Arizona Inc
Hancock Mth Builders Inc $1,085,850 --
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Previous Owner Mueller Brandon $1,687,000
Previous Owner Stottlemyre Todd $250,000
Previous Owner Stottlemyre Todd $647,200
Previous Owner Rabin Steven M $386,000
Previous Owner Rabin Steve M $297,400
Previous Owner Rabin Steven M $417,000
Previous Owner Espinosa Russell G $417,000
Previous Owner Espinosa Russell G $417,000
Previous Owner Espinosa Russell G $150,000
Previous Owner Espinosa Russell G $150,000
Previous Owner Walder Howard E $0
Previous Owner Walder Howard E $1,064,000
Previous Owner Walder Howard E $482,000
Previous Owner Walder Howard E $250,000
Previous Owner Walder Howard E $650,000
Previous Owner Purdy Julie A $295,000
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
05/30/2024 05/30/24 Sold $2,410,000 +0.8% $450 / Sq Ft
04/20/2024 04/20/24 For Sale $2,390,000 +6.2% $446 / Sq Ft
03/31/2022 03/31/22 Sold $2,250,000 0.0% $420 / Sq Ft
02/13/2022 02/13/22 For Sale $2,250,000 +152.0% $420 / Sq Ft
03/23/2012 03/23/12 Sold $893,000 -4.0% $161 / Sq Ft
02/10/2012 02/10/12 Pending -- -- --
02/05/2012 02/05/12 For Sale $930,000 -- $168 / 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 $7,132 $114,285 -- --
2024 $7,043 $108,843 -- --
2023 $7,043 $125,250 $25,050 $100,200
2022 $6,651 $100,230 $20,040 $80,190
2021 $7,105 $98,360 $19,670 $78,690
2020 $7,037 $95,730 $19,140 $76,590
2019 $6,769 $95,750 $19,150 $76,600
2018 $6,536 $93,150 $18,630 $74,520
2017 $6,234 $92,860 $18,570 $74,290
2016 $6,102 $85,380 $17,070 $68,310
2015 $5,779 $80,550 $16,110 $64,440
Source: Public Records

Agents Affiliated with this Home

  • J

    Seller's Agent in 2024

    Jill Gee

    MAR Realty, L.L.C.

    (602) 550-3145

    2 in this area

    17 Total Sales

    Jill Gee
    Section Image
  • Tucker Blalock

    Buyer's Agent in 2024

    Tucker Blalock

    The Brokery

    (602) 892-4444

    1 in this area

    362 Total Sales

    Tucker Blalock
    Section Image
  • Oleg Bortman

    Buyer Co-Listing Agent in 2024

    Oleg Bortman

    The Brokery

    (602) 402-2296

    3 in this area

    361 Total Sales

    Oleg Bortman
    Section Image
  • Carole Rabin

    Seller's Agent in 2022

    Carole Rabin

    HomeSmart

    (602) 321-2444

    1 in this area

    7 Total Sales

    Carole Rabin
    Section Image
  • Kathy Loeffler

    Seller's Agent in 2012

    Kathy Loeffler

    Fathom Realty Elite

    (602) 359-7270

    51 Total Sales

    Kathy Loeffler
    Section Image
See All Agents

Map

Source: Arizona Regional Multiple Listing Service (ARMLS)

MLS Number: 6683818

Arizona Regional Multiple Listing Service (ARMLS)

APN: 217-50-778

Arizona Maricopa County Scottsdale 85260 Horizons

9875 E Celtic Dr Unit 44, Scottsdale, AZ

This home is located at 9875 E Celtic Dr Unit 44, Scottsdale, AZ 85260 since 20 April 2024 and is currently estimated at $2,331,665, approximately $435 per square foot. This property was built in 2004. 9875 E Celtic Dr Unit 44 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