NOT LISTED FOR SALE

9811 E Celtic Dr Unit 46 Scottsdale, AZ 85260

Horizons Neighborhood

Estimated Value: $2,338,000 - $2,476,370

6 Beds
4.5 Baths
5,555 Sq Ft
$429/Sq Ft Est. Value

Last Sold December 31, 2013

Last sale price $1,100,000 $198 Per Sq Ft

Est. 117% increase in value since last sale

Current estimated payment $13,819/month

266 Days on Market

Highlights

  • Heated Lap Pool
  • Gated Community
  • Mountain View
  • Redfield Elementary School Rated A
  • 0.53 Acre Lot
  • Family Room with Fireplace

About This Home

As of December 2013

Magnificent home on over half acre lot located in the gated Madrid community. No expense has been spared in this stunning home with every upgrade imagineable. Exquisite entryway courtyard with soaring vaulted ceilings, granite counters throughout, S/S appliances, double convection ovens and hardwood floors. Guest suite with separate entry. Basement with game room,3 car garage .Resort like B/Y with heated pool and spa, water feature,your kids very own bike path, built in BBQ, Many more upgrades, too many to list. This gem is move in ready, bring your most discriminating buyer

Last Agent to Sell the Property

Azroy Salim

AZ Brokerage Holdings, LLC License #SA517417000 Listed on: 03/30/2012

Last Buyer's Agent

Mary Pack

West USA Realty License #SA549645000

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $6,300

Year Built

  • Built in 2006

Lot Details

  • 0.53 Acre Lot
  • Cul-De-Sac
  • Private Streets
  • Desert faces the front and back of the property
  • Block Wall Fence
  • Front and Back Yard Sprinklers
  • Grass Covered Lot

HOA Fees

  • $156 Monthly HOA Fees

Parking

  • 3 Car Garage

Home Design

  • Santa Barbara Architecture
  • Wood Frame Construction
  • Tile Roof
  • Stone Exterior Construction
  • Stucco

Interior Spaces

  • 5,555 Sq Ft Home
  • 1-Story Property
  • Wet Bar
  • Ceiling height of 9 feet or more
  • Gas Fireplace
  • Family Room with Fireplace
  • 3 Fireplaces
  • Mountain Views
  • Finished Basement
  • Basement Fills Entire Space Under The House

Kitchen

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

Flooring

  • Wood
  • Tile

Bedrooms and Bathrooms

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

Home Security

  • Security System Owned
  • Intercom

Pool

  • Heated Lap Pool
  • Heated Spa
  • Play Pool
  • Fence Around Pool

Outdoor Features

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

Schools

  • Desert Canyon Middle School

Utilities

  • Zoned Heating and Cooling System
  • High Speed Internet
  • Cable TV Available

Listing and Financial Details

  • Tax Lot 70
  • Assessor Parcel Number 217-50-780

Community Details

Overview

  • Association fees include ground maintenance
  • Rossmar & Graham Association, Phone Number (480) 551-4300
  • Madrid Subdivision, Puerta Del Sol 2 Floorplan

Security

  • Gated Community

Home Details

Home Type

Single Family

Est. Annual Taxes

$6,300

Year Built

Built in 2006

Lot Details

0

HOA Fees

$156 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: 155.66
  • Basement: Y
  • Updated Heating or Cooling Units: Partial
  • Items Updated Ht Cool Yr Updated: 2010
  • Parking Spaces Slab Parking Spaces: 3.0
  • Parking Spaces Total Covered Spaces: 3.0
  • Year Built: 2006
  • Spa Private: Yes
  • Tax Year: 2011
  • Directions: West on Thunderbird and gate is on the left
  • Master Model: Puerta Del Sol 2
  • Property Sub Type: Single Family Residence
  • Horses: No
  • Lot Size Acres: 0.53
  • Subdivision Name: MADRID
  • Architectural Style: Santa Barbara/Tuscan
  • Efficiency: Multi-Pane Wndws, Multi-Zones
  • Association Fees:HOA Fee2: 467.0
  • Dining Area:Breakfast Bar: Yes
  • Technology:Cable TV Avail: Yes
  • Cooling:Central Air: Yes
  • Water Source City Water: Yes
  • Fireplace Features Fireplace Family Rm: Yes
  • Fireplace Features Gas Fireplace: Yes
  • Kitchen Features:Electric Cooktop: Yes
  • Technology:High Speed Internet: Yes
  • Special Features: None

Interior Features

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

Exterior Features

  • Fencing: Block
  • Exterior Features: Private Street(s), Built-in Barbecue
  • Lot Features: Sprinklers In Rear, Sprinklers In Front, Desert Back, Desert Front, Cul-De-Sac, Grass Back
  • Pool Features: Play Pool, Fenced, Heated, Lap
  • Pool Private: Yes
  • View: City Light View(s), Mountain(s)
  • Disclosures: Agency Discl Req, Seller Discl Avail
  • Construction Type: Stucco, Wood Frame, Painted, Stone
  • Other Structures: Gazebo
  • 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:GazeboRamada: Yes
  • Exterior Features:Private Street(s): Yes
  • Fireplace Features Exterior Fireplace: Yes

Garage/Parking

  • Total Covered Spaces: 3.0
  • Garage Spaces: 3.0
  • Open Parking Spaces: 3.0

Utilities

  • Cooling: Central Air
  • Heating: Electric
  • Security: Fire Sprinkler System, Security System Owned
  • Cooling Y N: Yes
  • Heating Yn: Yes
  • Water Source: City Water
  • Heating:Electric: Yes

Condo/Co-op/Association

  • Community Features: Gated
  • Association Fee: 467.0
  • Association Fee Frequency: Quarterly
  • Association Name: Madrid
  • Phone: 480-551-4300
  • Association: Yes

Association/Amenities

  • Association Fees:HOA YN2: Y
  • Association Fees:HOA Transfer Fee2: 350.0
  • Association Fees:HOA Paid Frequency: Quarterly
  • Association Fees:HOA Name4: Madrid
  • Association Fees:HOA Telephone4: 480-551-4300
  • Association Fees:PAD Fee YN2: N
  • Association Fees:Cap ImprovementImpact Fee _percent_: $
  • Association Fee Incl:Common Area Maint3: Yes
  • Association Fees:HOA Management Company: Rossmar & Graham

Fee Information

  • Association Fee Includes: Maintenance Grounds

Schools

  • Junior High Dist: Scottsdale Unified District
  • Middle Or Junior School: Desert Canyon Middle School

Lot Info

  • Land Lease: No
  • Lot Size Sq Ft: 23080.0
  • Parcel #: 217-50-780

Building Info

  • Builder Name: Unknown

Tax Info

  • Tax Annual Amount: 6300.0
  • Tax Book Number: 217.00
  • Tax Lot: 70
  • Tax Map Number: 50.00

Ownership History

Date Name Owned For Owner Type

Purchase Details

Closed on
Apr 29, 2016
Sold by
Rosengren Timothy and Rosengren Sarah
Bought by
Rosengren Family Trust
Current Estimated Value
$2,385,593

Purchase Details

Closed on
Jan 4, 2013
Sold by
Ausband Anthony and Liang Eva I
Bought by
Rosengren Timothy and Rosengren Sarah

Home Financials for this Owner

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

Purchase Details

Closed on
Feb 7, 2005
Sold by
Meritage Homes Of Arizona Inc
Bought by
Ausband Anthony and Liang Eva I

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$930,100
Interest Rate
6.37%
Mortgage Type
Purchase Money Mortgage

Purchase Details

Closed on
Oct 21, 2004
Sold by
Taro Properties Arizona I Llc
Bought by
Meritage Homes Construction Inc
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
Rosengren Family Trust -- None Available
Rosengren Timothy $1,100,000 First Arizona Title Agency
Ausband Anthony $1,162,665 First American Title Ins Co
Meritage Homes Of Arizona Inc -- First American Title Ins Co
Meritage Homes Construction Inc $1,085,850 --
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Rosengren Timothy $660,000
Previous Owner Rosengren Timothy $770,000
Previous Owner Ausband Anthony $930,100
Closed Ausband Anthony $116,250
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
12/31/2013 12/31/13 Sold $1,100,000 -2.2% $198 / Sq Ft
12/21/2012 12/21/12 Pending -- -- --
10/12/2012 10/12/12 Price Changed $1,125,000 -5.9% $203 / Sq Ft
09/26/2012 09/26/12 For Sale $1,195,000 0.0% $215 / Sq Ft
08/27/2012 08/27/12 Pending -- -- --
07/23/2012 07/23/12 Price Changed $1,195,000 -4.4% $215 / Sq Ft
03/30/2012 03/30/12 For Sale $1,250,000 -- $225 / 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,975 $126,736 -- --
2024 $7,876 $120,701 -- --
2023 $7,876 $140,930 $28,180 $112,750
2022 $7,442 $112,070 $22,410 $89,660
2021 $7,944 $109,530 $21,900 $87,630
2020 $7,869 $104,880 $20,970 $83,910
2019 $7,572 $105,100 $21,020 $84,080
2018 $7,313 $102,700 $20,540 $82,160
2017 $6,979 $101,550 $20,310 $81,240
2016 $6,832 $94,150 $18,830 $75,320
2015 $6,474 $89,000 $17,800 $71,200
Source: Public Records

Agents Affiliated with this Home

  • A

    Seller's Agent in 2013

    Azroy Salim

    Realty Executives

  • M

    Buyer's Agent in 2013

    Mary Pack

    West USA Realty

See All Agents

Map

Source: Arizona Regional Multiple Listing Service (ARMLS)

MLS Number: 4737678

Arizona Regional Multiple Listing Service (ARMLS)

APN: 217-50-780

Arizona Maricopa County Scottsdale 85260 Horizons

9811 E Celtic Dr Unit 46, Scottsdale, AZ

This home is located at 9811 E Celtic Dr Unit 46, Scottsdale, AZ 85260 since 30 March 2012 and is currently estimated at $2,385,593, approximately $429 per square foot. This property was built in 2006. 9811 E Celtic Dr Unit 46 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