NOT LISTED FOR SALE

Estimated Value: $1,186,000 - $1,279,123

5 Beds
3.5 Baths
3,940 Sq Ft
$312/Sq Ft Est. Value

Last Sold April 22, 2015

Last sale price $540,000 $137 Per Sq Ft

Est. 120% increase in value since last sale

Current estimated payment $7,036/month

228 Days on Market

Highlights

  • Heated Pool
  • Gated Community
  • Mountain View
  • Franklin at Brimhall Elementary School Rated A
  • 0.53 Acre Lot
  • Santa Barbara Architecture

About This Home

As of April 2015

Entertainers Dream!Beautifully upgraded home. Main floor 3bd./2.5ba. Split floor plan. Open Kitchen with all S/S appl. 6 burner gas stove top. R/O water softner. Sun Shades , N/S exposure. Security System. Big lot with great views. Fantastic Pool and spa with fire features. Putting Green. Basement approx. 1200sq.ft. 2bd/1ba. and rec. area. Please see Supplement/Doc section for list of all upgrades to home as well as furniture and personal items staying with the home. Don't miss out on owning this amazing home. Barely lived in.

Last Agent to Sell the Property

Scott Dawson

HomeSmart License #SA559911000 Listed on: 08/07/2014

HomeSmart

Last Buyer's Agent

Kevin Houston

HomeSmart License #SA575371000

HomeSmart

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $4,195

Year Built

  • Built in 2005

Lot Details

  • 0.53 Acre Lot
  • Wrought Iron Fence
  • Block Wall Fence
  • Artificial Turf
  • Front and Back Yard Sprinklers

HOA Fees

  • $83 Monthly HOA Fees

Parking

  • 3 Car Garage
  • Tandem Garage
  • Garage Door Opener

Home Design

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

Interior Spaces

  • 3,940 Sq Ft Home
  • 1-Story Property
  • Ceiling height of 9 feet or more
  • Ceiling Fan
  • Double Pane Windows
  • Solar Screens
  • Tile Flooring
  • Mountain Views
  • Finished Basement
  • Basement Fills Entire Space Under The House
  • Security System Owned

Kitchen

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

Bedrooms and Bathrooms

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

Pool

  • Heated Pool
  • Spa
  • Fence Around Pool

Outdoor Features

  • Covered patio or porch
  • Built-In Barbecue

Schools

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

Utilities

  • Central Air
  • Heating Available
  • High Speed Internet
  • Cable TV Available

Listing and Financial Details

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

Community Details

Overview

  • Association fees include ground maintenance, street maintenance
  • Tri City Association, Phone Number (480) 844-2224
  • Built by Schuller
  • Madrid Subdivision

Security

  • Gated Community

Home Details

Home Type

Single Family

Est. Annual Taxes

$4,195

Year Built

Built in 2005

Lot Details

0

HOA Fees

$83 per month

Parking

3

Listing Details

  • Cross Street: Power Rd. & McDowell
  • Legal Info Range: 7E
  • Property Type: Residential
  • Ownership: Fee Simple
  • HOA #2: N
  • Association Fees Land Lease Fee: N
  • Recreation Center Fee 2: N
  • Recreation Center Fee: N
  • Total Monthly Fee Equivalent: 83.33
  • Basement: Y
  • Parking Spaces Total Covered Spaces: 3.0
  • Separate Den Office Sep Den Office: N
  • Year Built: 2005
  • Spa Private: Yes
  • Tax Year: 2013
  • Directions: McDowell east about 1.5 miles. Madrid subdivision on south side of the rd. Right on 88th. st. Go thru gate. stay on main rd. curves to the right following into culdesac. Home is 3rd. on the right
  • Property Sub Type: Single Family Residence
  • Horses: No
  • Lot Size Acres: 0.53
  • Subdivision Name: Madrid
  • Architectural Style: Santa Barbara/Tuscan
  • Property Attached Yn: No
  • ResoBuildingAreaSource: Assessor
  • Association Fees:HOA Fee2: 250.0
  • Windows:Dual Pane: Yes
  • Cooling:Ceiling Fan(s): Yes
  • Technology:Cable TV Avail: Yes
  • Cooling:Central Air: Yes
  • Windows:Solar Screens: Yes
  • Water Source City Water: Yes
  • Kitchen Features:Gas Cooktop: Yes
  • Technology:High Speed Internet: Yes
  • Special Features: None

Interior Features

  • Basement: Finished, Full
  • Flooring: Tile
  • Basement YN: Yes
  • Spa Features: Private
  • Appliances: Gas Cooktop
  • Possible Bedrooms: 6
  • Total Bedrooms: 5
  • Fireplace Features: None
  • Fireplace: No
  • Interior Amenities: High Speed Internet, Granite Counters, Double Vanity, Eat-in Kitchen, 9+ Flat Ceilings, Kitchen Island, Full Bth Master Bdrm, Separate Shwr & Tub
  • Living Area: 3940.0
  • Stories: 1
  • Window Features: Solar Screens, Dual Pane
  • ResoLivingAreaSource: Assessor
  • Kitchen Features:RangeOven Gas: Yes
  • Kitchen Features:Built-in Microwave: Yes
  • Kitchen Features:Kitchen Island: Yes
  • Master Bathroom:Double Sinks: Yes
  • Other Rooms:Family Room: Yes
  • Kitchen Features:Reverse Osmosis: Yes
  • Kitchen Features:Walk-in Pantry: Yes
  • Other Rooms:BonusGame Room: Yes
  • Basement Description:Finished2: Yes
  • Basement Description:Full: Yes
  • KitchenFeatures:Refrigerator: Yes
  • Community Features:Gated: Yes
  • Kitchen Features:Granite Counters: Yes

Exterior Features

  • Fencing: Block, Wrought Iron
  • Exterior Features: Other, Built-in Barbecue
  • Lot Features: Sprinklers In Rear, Sprinklers In Front, Gravel/Stone Front, Gravel/Stone Back, Synthetic Grass Back
  • Pool Features: Fenced, Heated, Private
  • Pool Private: Yes
  • View: Mountain(s)
  • Disclosures: Seller Discl Avail
  • Construction Type: Stucco, Wood Frame, Painted
  • 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
  • Exterior Features:Other6: Yes

Garage/Parking

  • Total Covered Spaces: 3.0
  • Parking Features: Tandem Garage, Garage Door Opener, Attch'd Gar Cabinets
  • Attached Garage: No
  • Garage Spaces: 3.0
  • Parking Features:Attch_squote_d Gar Cabinets: Yes
  • Parking Features:Tandem Garage: Yes
  • Parking Features:Garage Door Opener: Yes

Utilities

  • Cooling: Central Air, Ceiling Fan(s), Programmable Thmstat
  • Heating: Electric
  • Security: 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: 250.0
  • Association Fee Frequency: Quarterly
  • Association Name: Tri City
  • Phone: 480-844-2224
  • Association: Yes

Association/Amenities

  • Association Fees:HOA YN2: Y
  • Association Fees:HOA Paid Frequency: Quarterly
  • Association Fees:HOA Name4: Tri City
  • Association Fees:HOA Telephone4: 480-844-2224
  • Association Fees:PAD Fee YN2: N
  • Association Fees:Cap ImprovementImpact Fee _percent_: $
  • Association Fee Incl:Common Area Maint3: Yes
  • Association Fees:Cap ImprovementImpact Fee 2 _percent_: $
  • Association Fee Incl:Street Maint: Yes

Fee Information

  • Association Fee Includes: Maintenance Grounds, Street Maint

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
  • ResoLotSizeUnits: SquareFeet

Building Info

  • Builder Name: Schuller

Tax Info

  • Tax Annual Amount: 4194.76
  • 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
Current Estimated Value
$1,187,039

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
$292,287
Interest Rate
2.1%
Mortgage Type
New Conventional
Estimated Equity
$938,244

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.32%
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:

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
Hammer Craig W -- Accommodation
Hammer Craig W $540,000 Stewart Title & Trust
Rosenau William S $500,000 Pioneer Title Agency Inc
Hunsaker Chad P $524,915 Dhi Title Of Arizona Inc
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Hammer Craig W $370,500
Closed Hammer Craig W $420,000
Previous Owner Hunsaker Chad P $480,000
Previous Owner Hunsaker Chad $145,000
Previous Owner Hunsaker Chad P $419,932
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
04/22/2015 04/22/15 Sold $540,000 -3.6% $137 / Sq Ft
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,447 $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
See All Agents

Map

Source: Arizona Regional Multiple Listing Service (ARMLS)

MLS Number: 5154861

Arizona Regional Multiple Listing Service (ARMLS)

APN: 219-31-115