NOT LISTED FOR SALE

9939 E Celtic Dr Unit 40 Scottsdale, AZ 85260

Horizons Neighborhood

Estimated Value: $1,784,000 - $1,945,000

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

Last Sold July 19, 2023

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

Est. 7% increase in value since last sale

Current estimated payment $10,285/month

2 Days on Market

Highlights

  • Private Pool
  • Gated Community
  • Wood Flooring
  • Redfield Elementary School Rated A
  • Fireplace in Primary Bedroom
  • 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 Uptown Brokerage Phone: 520-270-4307 License #SA558141000 Listed on: 05/18/2023

Long Realty Uptown

Co-Listed By

Melinda Eslinger

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

Last Buyer's Agent

Zachary Ziebell

Realty ONE Group License #SA689361000

Realty ONE Group

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $5,335

Year Built

  • Built in 2003

Lot Details

  • 0.34 Acre 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 ceiling height seven feet or more
  • Garage Door Opener

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
  • Living Room with Fireplace
  • 3 Fireplaces

Kitchen

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

Flooring

  • Wood
  • Carpet
  • Tile

Bedrooms and Bathrooms

  • 4 Bedrooms
  • Fireplace in Primary Bedroom
  • Primary Bathroom is a Full Bathroom
  • 3.5 Bathrooms
  • Dual Vanity Sinks in Primary Bathroom
  • Hydromassage or Jetted Bathtub
  • Bathtub With Separate Shower Stall

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

Listing and Financial Details

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

Community Details

Overview

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

Security

  • Gated Community

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
  • Legal Info Range: 5E
  • Property Type: Residential
  • Ownership: Fee Simple
  • HOA #2: N
  • Association Fees Land Lease Fee: N
  • Recreation Center Fee: N
  • Total Monthly Fee Equivalent: 181.5
  • Basement: N
  • Updated Kitchen: Partial
  • Items Updated Kitchen Yr Updated: 2019
  • Parking Spaces Slab Parking Spaces: 3.0
  • Parking Spaces Total Covered Spaces: 3.0
  • 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
  • Association Fees:HOA Fee2: 544.5
  • Dining Area:Breakfast Bar: Yes
  • Windows:Dual Pane: Yes
  • Cooling:Ceiling Fan(s): 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
  • Special Features: None

Interior Features

  • Flooring: Carpet, Tile, Wood
  • Basement YN: No
  • Spa Features: None
  • Appliances: Gas Cooktop
  • Total Bedrooms: 4
  • Fireplace Features: 3+ Fireplace, Exterior Fireplace, Living Room, Master Bedroom
  • Fireplace: Yes
  • Interior Amenities: Granite Counters, Double Vanity, Eat-in Kitchen, Breakfast Bar, 9+ Flat Ceilings, No Interior Steps, Kitchen Island, Full Bth Master Bdrm, Separate Shwr & Tub, Tub with Jets
  • Living Area: 4158.0
  • Stories: 1
  • Window Features: Dual Pane
  • 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:Wall Oven(s): Yes
  • Kitchen Features:Walk-in Pantry: Yes
  • KitchenFeatures:Refrigerator: Yes
  • Community Features:Gated: Yes
  • Kitchen Features:Granite Counters: Yes

Exterior Features

  • Fencing: Block
  • Exterior Features: Private Street(s), Private Yard
  • Lot Features: Sprinklers In Rear, Sprinklers In Front, Desert Front, Auto Timer H2O Front, Natural Desert Front, Auto Timer H2O Back
  • Pool Features: Private
  • Disclosures: Seller Discl Avail
  • Construction Type: Stucco, Wood Frame, Painted
  • Patio And Porch Features: Patio
  • Roof: Tile
  • Construction:Frame - Wood: Yes
  • Exterior Features:Patio: Yes
  • Exterior Features:Pvt Yrd(s)Crtyrd(s): Yes
  • Exterior Features:Private Street(s): Yes
  • Fireplace Features Exterior Fireplace: Yes

Garage/Parking

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

Utilities

  • Cooling: Central Air, Ceiling Fan(s)
  • Heating: Natural Gas
  • 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.5
  • Association Fee Frequency: Quarterly
  • Association Name: Madrid
  • Phone: 480-939-6057
  • 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:Special Assessment HOA: No
  • Association Fees:PAD Fee YN2: N
  • Association Fees:Cap ImprovementImpact Fee _percent_: $
  • Association Fees:Disclosure Fees HOA: 192.0
  • Association Fee Incl:Common Area Maint3: Yes
  • Association Fee Incl:Street Maint: Yes

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.00
  • Tax Lot: 40
  • Tax Map Number: 50.00

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
May 18, 2023
Closed on
Jul 19, 2023
Sold by
Frank Anthony P and Frank Ann Marie
Bought by
Boshra Soheir Seifein and Salama Adel M
Seller's Agent
Ken Elder
Long Realty Uptown
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,854,225

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$119,225
Avg. Annual Appreciation
2.61%
Original Mortgage
$1,214,500
Outstanding Balance
$1,183,422
Interest Rate
6.63%
Mortgage Type
New Conventional
Estimated Equity
$670,803

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 Schneider
Citiea
Buyer's Agent
Ken Elder
Long Realty Uptown
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 Schneider
Citiea
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
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
Boshra Soheir Seifein $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

Date Status Borrower Loan Amount
Open Boshra Soheir Seifein $1,214,500
Previous Owner Frank Anthony P $650,000
Previous Owner Schneider David $424,100
Previous Owner Coffee Jon Norman $650,000
Source: Public Records

Property History

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

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.