$1,325,000
SOLD NOV 20, 2025
5 Beds
3.5 Baths
3,940 Sq Ft
0.53 Acres

Recently Sold

$336 Per Sq Ft

2% Below List Price

57 Days on Market

Highlights

  • Heated Spa
  • Gated Community
  • 0.53 Acre Lot
  • Franklin at Brimhall Elementary School Rated A
  • City Lights View
  • Covered Patio or Porch

About This Home

As of November 2025

This exquisite hidden gem is nestled in the highly sought-after gated community of Madrid, on a premium cul-de-sac lot with spectacular sunset, mountain and city light views and surrounded by the natural wash. Recently remodeled with no expense spared, this meticulously maintained home is move-in ready and offers the pinnacle of luxury, elegance, and comfort. Offering 3940 Sq. Ft. including an approx.1200 basement, 5 Bed, 3.5 Bath. Step inside to soaring 12-foot ceilings, a dramatic beamed circular entry, and versatile formal spaces ideal as a living room, dining room, or game/bonus room. The chef's kitchen is a dream, featuring a 6-burner gas cooktop with custom designed hood, wall oven and microwave, Sub-Zero refrigerator/freezer, an oversized sit-up island, and opens to a warm an inviting great room with elegant fireplace, dining with built-in bench seating, and a wall of glass for seamless indoor/outdoor living. The primary suite is a private retreat with a spa-like bathroom boasting an oversized shower, dual sinks, and a custom-designed walk-in closet. Two additional bedrooms share a Jack-and-Jill bath, while the basement offers two more bedrooms and a spacious bonus/great room, perfect for guests or a family retreat.
Step outside to the resort-style backyard, perfect for relaxing at the end of the day or entertaining family and friends. Unwind in the sparkling heated pool with Baja step, water and fire features, soak in the raised spa, or practice your game on the large putting green. Expansive travertine decking, a covered patio, and built-in BBQ create the ultimate outdoor living experience, all set against a serene natural wash with breathtaking sunsets, mountain views, and twinkling city lights. This backyard truly feels like your own private retreat. Additional upgrades include new surround sound and wireless smart house technology, two new AC units 2023, new Subzero Fridge 2021 and new washer and dryer and water heater. Madrid is ideally located just minutes from the Tonto National Forest, with some of the best hiking and biking trails, and only 15 minutes to Saguaro Lake and the Salt River. Easy freeway access to Loop 202, and just 25 minutes to Sky Harbor Airport, William Gateway Airport and Scottsdale.
Don't miss the opportunity to own this incredible home that perfectly blends luxury, comfort, and the natural beauty of Arizona's desert landscape

Last Agent to Sell the Property

Lorraine Ryall

KOR Properties License #BR625914000 Listed on: 09/24/2025

Last Buyer's Agent

Natascha Ovando-Karadsheh

KOR Properties License #BR649524000

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $5,447

Year Built

  • Built in 2005

Lot Details

  • 0.53 Acre Lot
  • Cul-De-Sac
  • Desert faces the front and back of the property
  • Wrought Iron Fence
  • Block Wall Fence
  • Artificial Turf
  • Front and Back Yard Sprinklers
  • Sprinklers on Timer

HOA Fees

  • $145 Monthly HOA Fees

Parking

  • 3 Car Direct Access Garage
  • 4 Open Parking Spaces
  • Tandem Garage
  • Garage Door Opener

Property Views

  • City Lights
  • Mountain

Home Design

  • Wood Frame Construction
  • Tile Roof
  • Stone Exterior Construction
  • Stucco

Interior Spaces

  • 3,940 Sq Ft Home
  • 1-Story Property
  • Ceiling height of 9 feet or more
  • Ceiling Fan
  • Double Pane Windows
  • Family Room with Fireplace
  • Finished Basement
  • Basement Fills Entire Space Under The House
  • Smart Home

Kitchen

  • Breakfast Bar
  • Built-In Electric Oven
  • Gas Cooktop
  • Built-In Microwave
  • Kitchen Island

Flooring

  • Carpet
  • Tile

Bedrooms and Bathrooms

  • 5 Bedrooms
  • Remodeled Bathroom
  • Primary Bathroom is a Full Bathroom
  • 3.5 Bathrooms
  • Dual Vanity Sinks in Primary Bathroom

Pool

  • Heated Spa
  • Heated Pool
  • Pool Pump

Outdoor Features

  • Covered Patio or Porch
  • Built-In Barbecue

Schools

  • Zaharis Elementary School
  • Fremont Junior High School
  • Red Mountain High School

Utilities

  • Cooling System Updated in 2021
  • Central Air
  • Heating Available
  • High Speed Internet
  • Cable TV Available

Additional Features

  • No Interior Steps
  • North or South Exposure

Listing and Financial Details

  • Tax Lot 40
  • Assessor Parcel Number 219-31-115

Community Details

Overview

  • Association fees include ground maintenance
  • 360 Community Mngmt Association, Phone Number (602) 863-3600
  • Madrid Subdivision

Recreation

  • Community Playground

Security

  • Gated Community

Home Details

Home Type

Single Family

Est. Annual Taxes

$5,447

Year Built

Built in 2005

Lot Details

0

HOA Fees

$145 per month

Parking

3

Listing Details

  • Cross Street: Mc Dowell and Ellsworth
  • Legal Info Range: 7E
  • Property Type: Residential
  • Ownership: Fee Simple
  • HOA #2: N
  • Association Fees Land Lease Fee: N
  • Recreation Center Fee: N
  • Total Monthly Fee Equivalent: 144.87
  • Basement: Y
  • Updated Partial or Full Bathrooms: Partial
  • Bathrooms Year Updated: 2019
  • Updated Floors: Full
  • Items Updated Floor Yr Updated: 2019
  • Updated Heating or Cooling Units: Full
  • Items Updated Ht Cool Yr Updated: 2021
  • Updated Kitchen: Full
  • Items Updated Kitchen Yr Updated: 2019
  • Updated Plumbing: Partial
  • Items Updated Plmbg Yr Updated: 2020
  • Updated Pool: Partial
  • Items Updated Pool Yr Updated: 2019
  • Updated Wiring: Partial
  • Items Updated Wiring Yr Updated: 2020
  • Parking Spaces Slab Parking Spaces: 4.0
  • Parking Spaces Total Covered Spaces: 3.0
  • Separate Den Office Sep Den Office: N
  • Year Built: 2005
  • Spa Private: Yes
  • Tax Year: 2024
  • Property Sub Type: Single Family Residence
  • Horses: No
  • Lot Size Acres: 0.53
  • Subdivision Name: MADRID
  • Property Attached Yn: No
  • General Property Description:PriceSqFt: 336.29
  • Association Fees:HOA Fee2: 434.61
  • Dining Area:Breakfast Bar: Yes
  • Cooling:Ceiling Fan(s): Yes
  • Technology:Cable TV Avail: Yes
  • Cooling:Central Air: Yes
  • Water Source City Water: Yes
  • Fireplace Features Fireplace Family Rm: Yes
  • Kitchen Features:Gas Cooktop: Yes
  • Kitchen Features:Built-In Electric Oven2: Yes
  • Technology:High Speed Internet: Yes
  • Technology:Smart Home: Yes
  • Special Features: None

Interior Features

  • Basement: Finished, Full
  • Flooring: Carpet, Tile
  • Basement YN: Yes
  • Spa Features: Heated, Private
  • Appliances: Gas Cooktop, Built-In Electric Oven
  • Total Bedrooms: 5
  • Fireplace Features: Family Room
  • Fireplaces: 1
  • Fireplace: Yes
  • Interior Amenities: High Speed Internet, Smart Home, Double Vanity, Breakfast Bar, 9+ Flat Ceilings, No Interior Steps, Kitchen Island, Pantry, Full Bth Master Bdrm
  • Living Area: 3940.0
  • Stories: 1
  • Window Features: Dual Pane
  • Kitchen Features:Built-in Microwave: Yes
  • Kitchen Features:Kitchen Island: Yes
  • Master Bathroom:Double Sinks: Yes
  • Kitchen Features Pantry: Yes
  • Other Rooms:Great Room: Yes
  • Kitchen Features:Non-laminate Counter: Yes
  • Kitchen Features:Reverse Osmosis: Yes
  • Community Features:Children_squote_s Playgrnd: Yes
  • Other Rooms:BonusGame Room: Yes
  • Basement Description:Finished2: Yes
  • Basement Description:Full: Yes
  • KitchenFeatures:Refrigerator: Yes
  • Community Features:Gated: Yes

Exterior Features

  • Fencing: Block, Wrought Iron
  • Exterior Features: Built-in Barbecue
  • Lot Features: Adjacent to Wash, North/South Exposure, Sprinklers In Rear, Sprinklers In Front, Desert Back, Desert Front, Cul-De-Sac, Synthetic Grass Back, Auto Timer H2O Front, Auto Timer H2O Back
  • Pool Features: Heated
  • Pool Private: Yes
  • View: City Lights, Mountain(s)
  • Disclosures: Agency Discl Req, Seller Discl Avail
  • Construction Type: Stucco, Wood Frame, Painted, Stone
  • Patio And Porch Features: Covered Patio(s)
  • Roof: Tile
  • Construction:Frame - Wood: Yes
  • Exterior Features:Covered Patio(s): Yes
  • Exterior Features:Built-in BBQ: Yes

Garage/Parking

  • Total Covered Spaces: 3.0
  • Parking Features: Tandem Garage, Garage Door Opener, Extended Length Garage, Direct Access, Attch'd Gar Cabinets
  • Attached Garage: No
  • Garage Spaces: 3.0
  • Open Parking Spaces: 4.0
  • Parking Features:Attch_squote_d Gar Cabinets: Yes
  • Parking Features:Tandem 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: Electric
  • Cooling Y N: Yes
  • Heating Yn: Yes
  • Water Source: City Water
  • Heating:Electric: Yes

Condo/Co-op/Association

  • Community Features: Gated, Playground
  • Association Fee: 434.61
  • Association Fee Frequency: Quarterly
  • Association Name: Madrid
  • Phone: 602-863-3600
  • 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:Prepaid Association Fees HOA: 434.61
  • Association Fees:Disclosure Fees HOA: 400.0
  • Association Fee Incl:Common Area Maint3: Yes
  • Association Fees:HOA Management Company: 360 Community Mngmt
  • Association Fees:HOA Management Phone: 602-863-3600

Fee Information

  • Association Fee Includes: Maintenance Grounds

Schools

  • Elementary School: Zaharis Elementary
  • High School: Red Mountain High School
  • Junior High Dist: Mesa Unified District
  • Middle Or Junior School: Fremont Junior High School

Lot Info

  • Land Lease: No
  • Lot Size Sq Ft: 23014.0
  • Parcel #: 219-31-115

Building Info

  • Builder Name: -

Tax Info

  • Tax Annual Amount: 5447.0
  • Tax Book Number: 219.00
  • Tax Lot: 40
  • Tax Map Number: 31.00

Ownership History

Date Name Owned For Owner Type

Purchase Details

Closed on
Aug 18, 2021
Sold by
Hammer Craig W and Hammer Ericka D
Bought by
Hammer Craig W and Hammer Ericka D

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$370,500
Outstanding Balance
$280,898
Interest Rate
2.1%
Mortgage Type
New Conventional
Estimated Equity
$1,043,155

Purchase Details

Listed on
Aug 7, 2014
Closed on
Apr 15, 2015
Sold by
Rosenau William S and Rosenau Linda Darlene
Bought by
Hammer Craig W
Seller's Agent
Scott Dawson
HomeSmart
Buyer's Agent
Kevin Houston
HomeSmart
List Price
$650,000
Sold Price
$540,000
Premium/Discount to List
-$110,000
-16.92%

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
8.84%
Original Mortgage
$420,000
Interest Rate
3.8%
Mortgage Type
New Conventional

Purchase Details

Closed on
Dec 30, 2010
Sold by
Hunsaker Chad P and Hunsaker Michelle L
Bought by
Rosenau William S and Rosenau Linda Darlene

Purchase Details

Closed on
Apr 28, 2006
Sold by
Schuler Homes Of Arizona Llc
Bought by
Hunsaker Chad P and Hunsaker Michelle L

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$419,932
Interest Rate
6.75%
Mortgage Type
Purchase Money Mortgage
Source: Public Records

Range of Values:

--
Value Increase
--
Percent Increase
--
Adjusted for Inflation
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 Type Sale Price Title Company
Interfamily Deed Transfer -- Accommodation
Warranty Deed $540,000 Stewart Title & Trust
Cash Sale Deed $500,000 Pioneer Title Agency Inc
Corporate Deed $524,915 Dhi Title Of Arizona Inc
Source: Public Records

Mortgage History

Date Status Loan Amount Loan Type
Open $370,500 New Conventional
Closed $420,000 New Conventional
Previous Owner $419,932 Purchase Money Mortgage
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft Prior Sale
11/20/2025 11/20/25 Sold $1,325,000 -1.9% $336 / Sq Ft
09/24/2025 09/24/25 For Sale $1,350,000 +150.0% $343 / Sq Ft
04/22/2015 04/22/15 Sold $540,000 -3.6% $137 / Sq Ft View Prior Sale
03/23/2015 03/23/15 Pending -- -- --
03/19/2015 03/19/15 Price Changed $560,000 -2.6% $142 / Sq Ft
02/20/2015 02/20/15 Price Changed $575,000 -4.2% $146 / Sq Ft
01/22/2015 01/22/15 Price Changed $600,000 -2.4% $152 / Sq Ft
01/06/2015 01/06/15 Price Changed $615,000 -2.4% $156 / Sq Ft
01/02/2015 01/02/15 Price Changed $630,000 -1.6% $160 / Sq Ft
12/10/2014 12/10/14 Price Changed $640,000 -1.5% $162 / Sq Ft
10/20/2014 10/20/14 For Sale $650,000 0.0% $165 / Sq Ft
09/26/2014 09/26/14 Pending -- -- --
08/07/2014 08/07/14 For Sale $650,000 -- $165 / 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 $5,478 $64,625 -- --
2024 $5,795 $61,548 -- --
2023 $5,795 $74,860 $14,970 $59,890
2022 $5,663 $61,770 $12,350 $49,420
2021 $5,740 $58,170 $11,630 $46,540
2020 $5,657 $55,600 $11,120 $44,480
2019 $5,246 $52,310 $10,460 $41,850
2018 $5,011 $49,530 $9,900 $39,630
2017 $4,843 $50,250 $10,050 $40,200
2016 $4,742 $51,510 $10,300 $41,210
2015 $4,421 $49,120 $9,820 $39,300
Source: Public Records

Agents Affiliated with this Home

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

Map

Source: Arizona Regional Multiple Listing Service (ARMLS)

MLS Number: 6923933

Arizona Regional Multiple Listing Service (ARMLS)

APN: 219-31-115