NOT LISTED FOR SALE

9939 E Celtic Dr Unit 40 Scottsdale, AZ 85260

Horizons Neighborhood

Estimated Value: $1,800,596

4 Beds
3.5 Baths
4,158 Sq Ft
$433/Sq Ft Est. Value

Sale Details

Date Sold: July 19, 2023

Last sale price $1,735,000 $417 Per Sq Ft

Est. 4% increase in value since last sale

Current estimated payment $10,898 / mo

2 Days on Market

Highlights

  • Private Pool
  • Sitting Area In Primary Bedroom
  • Fireplace in Primary Bedroom
  • Redfield Elementary School Rated A
  • 0.34 Acre Lot
  • 4-minute walk to Aztec Park

About This Home

As of July 2023

Located in the prestigious, gated Madrid community. Lovely curb appeal with mature landscaping in bloom. The charming entry courtyard with FP sets the tone and lets you know this home will be special. Custom iron entry doors welcome you to explore your new home. Upon entry, your eyes will lead you straight through, past the french doors to the back yard and pool. Split bedroom plan with lux primary suite. Large sitting area and fabulous bathroom make this room a sanctuary. The kitchen is the heart of the home and this one is truly special. Soaring ceilings, huge island, custom granite. Wolf and Kitchen Aid appliances, the chefs needs are met in every way! The AZ indoor/outdoor lifestyle will be a dream with the entertainer's backyard. One of a kind pool and multiple entertaining areas.

Last Agent to Sell the Property

Ken Elder

Long Realty Old Town Brokerage Phone: 520-270-4307 License #SA558141000 Listed on: 05/18/2023

Long Realty Old Town

Co-Listed By

Melinda Eslinger

Long Realty Old Town Brokerage Phone: 520-270-4307 License #BR637166000

Last Buyer's Agent

Zachary Ziebell

Realty ONE Group License #SA689361000

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 Details

Home Type

  • Single Family

Est. Annual Taxes

  • $5,335

Year Built

  • Built in 2003

Lot Details

  • 14,790 Sq Ft Lot
  • Desert faces the front of the property
  • Private Streets
  • Block Wall Fence
  • Front and Back Yard Sprinklers
  • Sprinklers on Timer
  • Private Yard

HOA Fees

  • $182 Monthly HOA Fees

Parking

  • 3 Car Direct Access Garage
  • Garage Ceilings 7 ft or Higher

Home Design

  • Wood Frame Construction
  • Tile Roof
  • Stucco

Interior Spaces

  • 4,158 Sq Ft Home
  • 1-Story Property
  • Ceiling height of 9 feet or more
  • Ceiling Fan
  • Double Pane Windows
  • Great Room
  • Family Room
  • Living Room with Fireplace
  • 3 Fireplaces
  • Formal Dining Room
  • Fire Sprinkler System

Kitchen

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

Flooring

  • Wood
  • Carpet
  • Tile

Bedrooms and Bathrooms

  • 4 Bedrooms
  • Sitting Area In Primary Bedroom
  • Fireplace in Primary Bedroom
  • Split Bedroom Floorplan
  • Walk-In Closet
  • Primary Bathroom is a Full Bathroom
  • Double Vanity
  • Private Water Closet
  • Jettted Tub and Separate Shower in Primary Bathroom
  • Hydromassage or Jetted Bathtub
  • Bathtub With Separate Shower Stall

Laundry

  • Laundry in unit
  • Dryer
  • Washer

Accessible Home Design

  • No Interior Steps

Outdoor Features

  • Private Pool
  • Patio
  • Outdoor Fireplace

Schools

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

Utilities

  • Central Air
  • Heating System Uses Natural Gas
  • Tankless Water Heater
  • Water Softener is Owned

Community Details

  • Association fees include ground maintenance, street maintenance
  • Madrid Association, Phone Number (480) 939-6057
  • Built by Meritage
  • Madrid Subdivision

Listing and Financial Details

  • Tax Lot 40
  • Assessor Parcel Number 217-50-774

Home Details

Home Type

Single Family

Est. Annual Taxes

$5,335

Year Built

Built in 2003

Lot Details

0.34 Acres

HOA Fees

$182 per month

Parking

3

Listing Details

  • Cross Street: Frank Lloyd Wright/Thunderbird
  • Property Type: Residential
  • Ownership: Fee Simple
  • HOA #2: N
  • Recreation Center Fee: N
  • Total Monthly Fee Equivalent: 181.5
  • Updated Kitchen: Partial
  • Items Updated Kitchen Yr Updated: 2019
  • Separate Den Office Sep Den Office: Y
  • Solar Panels Grid: On
  • Solar Panelsk W: 14.8
  • Year Built: 2003
  • Tax Year: 2022
  • Property Sub Type: Single Family Residence
  • Horses: No
  • Lot Size Acres: 0.34
  • Co List Office Mls Id: ltwn01
  • Co List Office Phone: 602-935-1383
  • Subdivision Name: MADRID
  • Property Attached Yn: No
  • General Property Description:PriceSqFt: 417.27
  • Const - Finish:Const - Finish: Painted, Stucco
  • Cooling:Cooling: Ceiling Fan(s), Central Air
  • Other Rooms:Other Rooms: Family Room, Great Room
  • Plumbing:Plumbing: Tankless Ht Wtr Heat
  • Special Features: None

Interior Features

  • Flooring: Carpet, Tile, Wood
  • Basement YN: No
  • Spa Features: None
  • Appliances: Dishwasher, Disposal, Refrigerator, Gas Cooktop, Microwave, Washer, Dryer, Water Softener Owned
  • Full Bathrooms: 3
  • Half Bathrooms: 1
  • Total Bedrooms: 4
  • Fireplace Features: Living Room, Master Bedroom, Exterior Fireplace
  • Fireplaces: 3
  • Fireplace: Yes
  • Interior Amenities: Full Bth Master Bdrm, Separate Shwr & Tub, Double Vanity, Tub with Jets, Eat-in Kitchen, Breakfast Bar, Kitchen Island, Walk-in Pantry, Granite Counters, 9+ Flat Ceilings, No Interior Steps
  • Living Area: 4158.0
  • Stories: 1
  • Window Features: Dual Pane
  • Additional Bedroom:Additional Bedroom: Master Bedroom Walk-in Closet, Master Bedroom Sitting Room
  • Dining Area:Dining Area: Formal, Eat-in Kitchen, Breakfast Bar
  • Interior Features:Interior Features: 9+ Flat Ceilings, Fire Sprinkler System, No Interior Steps, 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
  • Laundry:Laundry: Washer Included, Dryer Included, Inside
  • Master Bathroom:Master Bathroom: Full Bth Master Bdrm, Separate Shwr & Tub, Double Vanity, Tub with Jets, Private Toilet Room
  • Master Bedroom:Master Bedroom: Split
  • Window Features:Window Features: Dual Pane

Exterior Features

  • Fencing: Block
  • Exterior Features: Private Street(s), Private Yard
  • Lot Features: Desert Front, Sprinklers In Front, Sprinklers In Rear, Natural Desert Front, Auto Timer H2O Front, Auto Timer H2O Back
  • Pool Private: Yes
  • Disclosures: Seller Discl Avail
  • Construction Type: Wood Frame, Painted, Stucco
  • Patio And Porch Features: Patio
  • 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: Over Height Garage, Extended Length Garage, Garage Door Opener, Attch'd Gar Cabinets, Direct Access
  • Attached Garage: No
  • Garage Spaces: 3.0
  • Open Parking Spaces: 3.0

Utilities

  • Cooling: Ceiling Fan(s), Central Air
  • Heating: Natural Gas
  • Laundry Features: Inside
  • Security: 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: 544.5
  • Association Fee Frequency: Quarterly
  • Association Name: Madrid
  • Phone: 480-939-6057
  • 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:Disclosure Fees HOA: 192.0

Fee Information

  • Association Fee Includes: Maintenance Grounds, Street Maint

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: 14790.0
  • Parcel #: 217-50-774

Green Features

  • Green Water Conservation: Tankless Ht Wtr Heat

Building Info

  • Builder Name: Meritage

Tax Info

  • Tax Annual Amount: 5335.0
  • Tax Book Number: 217.0
  • Tax Lot: 40
  • Tax Map Number: 50.0

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

Listed on
May 18, 2023
Closed on
Jun 30, 2023
Sold by
Frank Anthony and Marie Ann
Bought by
Seller's Agent
Ken Elder
Long Realty Old Town
Buyer's Agent
Zachary Ziebell
Realty ONE Group
List Price
$1,720,000
Sold Price
$1,735,000
Premium/Discount to List
$15,000
0.87%
Views
38
Current Estimated Value
$1,800,596

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$65,596
Avg. Annual Appreciation
1.18%
Original Mortgage
$1,214,500
Outstanding Balance
$1,170,687
Interest Rate
6.63%
Mortgage Type
New Conventional
Estimated Equity
$629,909

Purchase Details

Listed on
Jul 17, 2019
Closed on
Sep 17, 2019
Sold by
Schneider David and Schneider Anita
Bought by
Frank Anthony P and Frank Ann Marie
Seller's Agent
Anita Baum
HomeSmart
Buyer's Agent
Ken Elder
Long Realty Old Town
List Price
$1,099,000
Sold Price
$1,050,000
Premium/Discount to List
-$49,000
-4.46%

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
14.05%
Original Mortgage
$650,000
Interest Rate
3%
Mortgage Type
Adjustable Rate Mortgage/ARM

Purchase Details

Listed on
Mar 30, 2017
Closed on
Nov 29, 2017
Sold by
Pelham Judith C and Judith C Pelham Revocable Trus
Bought by
Schneider David and Schneider Anita
Seller's Agent
Sam Havens
HomeSmart
Buyer's Agent
Anita Baum
HomeSmart
List Price
$1,000,000
Sold Price
$955,000
Premium/Discount to List
-$45,000
-4.5%

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
5.50%
Original Mortgage
$424,100
Interest Rate
3.94%
Mortgage Type
New Conventional

Purchase Details

Closed on
Jun 3, 2009
Sold by
Coffee Jon Norman and Pelham Judith Carol
Bought by
Judith C Pelham Revocable Trust

Purchase Details

Closed on
Mar 8, 2005
Sold by
Gmac Model Home Finance Inc
Bought by
Coffee Jon Norman and Pelham Judith Carol

Home Financials for this Owner

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

Purchase Details

Closed on
Dec 31, 2003
Sold by
Taro Properties Arizona I Llc
Bought by
Taro Properties Arizona I Llc
Source: Public Records

Home Values in the Area

Source: Public Records

Average Home Value in this Area





Source: Public Records

Agents Specializing in Horizons, AZ

See All Agents

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
$1,735,000 Old Republic Title Agency
Frank Anthony P $1,050,000 Old Republic Title Agency
Schneider David $955,000 North American Title Company
Judith C Pelham Revocable Trust -- None Available
Coffee Jon Norman $1,112,014 First American Title Ins Co
Taro Properties Arizona I Llc $636,300 First American Title
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
Open $1,214,500
Previous Owner Frank Anthony P $650,000
Previous Owner Schneider David $50,000
Previous Owner Schneider David $50,000
Previous Owner Schneider David $424,100
Previous Owner Coffee Jon Norman $650,000
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 Prior Sale
07/19/2023 07/19/23 Sold $1,735,000 +0.9% $417 / Sq Ft
05/21/2023 05/21/23 Pending -- -- --
05/18/2023 05/18/23 For Sale $1,720,000 +63.8% $414 / Sq Ft
09/25/2019 09/25/19 Sold $1,050,000 -2.7% $253 / Sq Ft View Prior Sale
08/07/2019 08/07/19 Price Changed $1,079,000 -1.8% $259 / Sq Ft
07/16/2019 07/16/19 For Sale $1,099,000 +15.1% $264 / Sq Ft
12/18/2017 12/18/17 Sold $955,000 -2.5% $230 / Sq Ft View Prior Sale
09/24/2017 09/24/17 Price Changed $979,000 -3.5% $235 / Sq Ft
08/08/2017 08/08/17 Price Changed $1,015,000 -7.7% $244 / Sq Ft
04/02/2017 04/02/17 Price Changed $1,100,000 +99900.0% $265 / Sq Ft
04/02/2017 04/02/17 Price Changed $1,100 -99.9% $0 / Sq Ft
03/30/2017 03/30/17 For Sale $1,000,000 -- $241 / 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 $6,606 $93,544
2024 $5,656 $89,090
2023 $5,656 $113,530 $22,700 $90,830
2022 $5,335 $91,730 $18,340 $73,390
2021 $5,706 $88,870 $17,770 $71,100
2020 $5,651 $84,400 $16,880 $67,520
2019 $5,432 $79,100 $15,820 $63,280
2018 $5,241 $83,630 $16,720 $66,910
2017 $4,994 $86,320 $17,260 $69,060
2016 $5,727 $79,120 $15,820 $63,300
2015 $5,422 $77,080 $15,410 $61,670
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
  • Section Image
  • Section Image
  • Section Image
  • Section Image
See All Agents

Map

Source: Arizona Regional Multiple Listing Service (ARMLS)

MLS Number: 6556378

Arizona Regional Multiple Listing Service (ARMLS)

APN: 217-50-774

Your Personal Tour Guide

Ask me questions while you tour the home.