NOT LISTED FOR SALE

Estimated Value: $1,911,000 - $2,474,000

5 Beds
4.5 Baths
7,011 Sq Ft
$327/Sq Ft Est. Value

Last Sold November 16, 2017

Last sale price $1,420,000 $203 Per Sq Ft

Est. 61% increase in value since last sale

Current estimated payment $13,476/month

117 Days on Market

Highlights

  • Guest House
  • Play Pool
  • City Lights View
  • Franklin at Brimhall Elementary School Rated A
  • RV Gated
  • 1.15 Acre Lot

About This Home

As of November 2017

Spectacular custom home with stunning panoramic mountain and city views situated on over 1 acre. This sprawling 5 bedroom custom estate includes guest house, theater room, formal dining room, game room, stylish architecture w/circular family room, wet bar and over-sized 5-car garage. Recent upgrades include brand new designer interior and exterior paint and new HVAC units. Gourmet kitchen showcases high grade granite counters with stone backsplash, Wolf range, SubZero fridge and wet bar. Master retreat highlights include fireplace, separate balcony exit, his-and-her closets, dual vanities and large jetted tub. Breathtaking rooftop patio views overlook amazing backyard complete with gazebo covered fireplace, sparkling blue pool and lush green grass! Make your appointment today. Be sure to check out video.

Last Agent to Sell the Property

Brian Bair

OfferPad Brokerage, LLC License #SA569401000 Listed on: 06/09/2017

Last Buyer's Agent

Christine Anthony

Russ Lyon Sotheby's International Realty License #SA631831000

Russ Lyon Sotheby's International Realty

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $9,141

Year Built

  • Built in 2007

Lot Details

  • 1.15 Acre Lot
  • Desert faces the front of the property
  • Private Streets
  • Wrought Iron Fence
  • Block Wall Fence
  • Front and Back Yard Sprinklers
  • Sprinklers on Timer
  • Private Yard
  • Grass Covered Lot

Parking

  • 5 Car Direct Access Garage
  • Garage ceiling height seven feet or more
  • Side or Rear Entrance to Parking
  • Garage Door Opener
  • Circular Driveway
  • RV Gated

Property Views

  • City Lights
  • Mountain

Home Design

  • Santa Barbara Architecture
  • Tile Roof
  • Built-Up Roof
  • Foam Roof
  • Stone Exterior Construction
  • Stucco

Interior Spaces

  • 7,011 Sq Ft Home
  • 2-Story Property
  • Wet Bar
  • Central Vacuum
  • Vaulted Ceiling
  • Ceiling Fan
  • Gas Fireplace
  • Living Room with Fireplace
  • 3 Fireplaces
  • Security System Owned

Kitchen

  • Eat-In Kitchen
  • Breakfast Bar
  • Gas Cooktop
  • <<builtInMicrowave>>
  • Kitchen Island
  • Granite Countertops

Flooring

  • Carpet
  • Stone

Bedrooms and Bathrooms

  • 5 Bedrooms
  • Fireplace in Primary Bedroom
  • Primary Bathroom is a Full Bathroom
  • 4.5 Bathrooms
  • Dual Vanity Sinks in Primary Bathroom
  • <<bathWSpaHydroMassageTubToken>>
  • Bathtub With Separate Shower Stall

Outdoor Features

  • Play Pool
  • Balcony
  • Covered patio or porch
  • Outdoor Fireplace
  • Gazebo

Additional Homes

  • Guest House

Schools

  • Las Sendas Elementary School
  • Fremont Junior High School
  • Red Mountain High School

Utilities

  • Refrigerated Cooling System
  • Zoned Heating
  • Propane
  • Shared Well
  • Water Softener
  • Septic Tank
  • High Speed Internet
  • Cable TV Available

Community Details

  • No Home Owners Association
  • Association fees include no fees
  • Built by Custom
  • County Island To Be Provided In Escrow Subdivision

Listing and Financial Details

  • Assessor Parcel Number 219-24-214-F

Home Details

Home Type

Single Family

Est. Annual Taxes

$9,141

Year Built

Built in 2007

Lot Details

0

Parking

5

Listing Details

  • Cross Street: N Hawes Rd & E Range Rider Trl
  • Legal Info Range: 7E
  • Property Type: Residential
  • Ownership: Fee Simple
  • Association Fees Land Lease Fee: N
  • Recreation Center Fee 2: N
  • Recreation Center Fee: N
  • Basement: N
  • Parking Spaces Total Covered Spaces: 5.0
  • Separate Den Office Sep Den Office: Y
  • Year Built: 2007
  • Tax Year: 2016
  • Directions: From N Hawes Rd head East on Oak St, turn Left on N 88th St, turn Right on E Quill St, turn Left on N 88th Pl, first home on Right.
  • Property Sub Type: Single Family - Detached
  • Horses: No
  • Lot Size Acres: 1.15
  • Subdivision Name: County Island - TO BE PROVIDED IN ESCROW
  • Architectural Style: Santa Barbara/Tuscan
  • Efficiency: Multi-Zones
  • Property Attached Yn: No
  • Tax Parcel Letter: F
  • ResoBuildingAreaSource: Appraiser
  • Dining Area:Breakfast Bar: Yes
  • Cooling:Ceiling Fan(s): Yes
  • Technology:Cable TV Avail: Yes
  • Technology:High Speed Internet Available: Yes
  • Utilities Butane Propane: Yes
  • Special Features: None

Interior Features

  • Flooring: Carpet, Stone
  • Basement YN: No
  • Spa Features: None
  • Possible Bedrooms: 7
  • Total Bedrooms: 5
  • Fireplace Features: 3+ Fireplace, Exterior Fireplace, Living Room, Master Bedroom, Gas
  • Fireplace: Yes
  • Interior Amenities: Upstairs, Eat-in Kitchen, Breakfast Bar, Central Vacuum, Soft Water Loop, Vaulted Ceiling(s), Wet Bar, Kitchen Island, Double Vanity, Full Bth Master Bdrm, Separate Shwr & Tub, Tub with Jets, High Speed Internet, Granite Counters
  • Living Area: 7011.0
  • Stories: 2
  • ResoLivingAreaSource: Appraiser
  • Kitchen Features:RangeOven Gas: Yes
  • Kitchen Features:Built-in Microwave: Yes
  • Kitchen Features:Granite Countertops: Yes
  • Kitchen Features:Kitchen Island: Yes
  • Master Bathroom:Double Sinks: Yes
  • Other Rooms:Great Room: Yes
  • Fireplace:Exterior Fireplace: Yes
  • Fireplace:Gas Fireplace: Yes
  • Kitchen Features:Walk-in Pantry: Yes
  • Other Rooms:Loft: Yes
  • Kitchen Features:Cook Top Gas: Yes
  • Kitchen Features:Gas Stub for Range: Yes
  • Fireplace:Fireplace Living Rm: Yes
  • Other Rooms:Guest Qtrs-Sep Entrn: Yes
  • Kitchen Features:Multiple Ovens: Yes
  • Fireplace:Fireplace Master Bdr: Yes
  • Other Rooms:Media Room: Yes
  • KitchenFeatures:Refrigerator: Yes

Exterior Features

  • Fencing: Block, Wrought Iron
  • Exterior Features: Balcony, Circular Drive, Covered Patio(s), Gazebo/Ramada, Patio, Private Street(s), Private Yard
  • Lot Features: Sprinklers In Rear, Sprinklers In Front, Desert Front, Grass Back, Auto Timer H2O Front, Auto Timer H2O Back
  • Pool Features: Play Pool, Private
  • Pool Private: Yes
  • View: City Lights, Mountain(s)
  • Disclosures: Agency Discl Req
  • Construction Type: See Remarks, Painted, Stucco, Stone
  • Other Structures: Guest House
  • Roof: Tile, Built-Up, Foam
  • Construction:Other (See Remarks)23: Yes
  • Exterior Features:Covered Patio(s): Yes
  • Exterior Features:Circular Drive: Yes
  • Exterior Features:Patio: Yes
  • Exterior Features:Pvt Yrd(s)Crtyrd(s): Yes
  • Exterior Features:Balcony: Yes
  • Exterior Features:Separate Guest House: Yes
  • Exterior Features:GazeboRamada: Yes
  • Exterior Features:Private Street(s): Yes

Garage/Parking

  • Total Covered Spaces: 5.0
  • Parking Features: Attch'd Gar Cabinets, Dir Entry frm Garage, Electric Door Opener, Extnded Lngth Garage, Over Height Garage, RV Gate, Separate Strge Area, Side Vehicle Entry, RV Access/Parking
  • Attached Garage: No
  • Garage Spaces: 5.0
  • Parking Features:Dir Entry frm Garage: Yes
  • Parking Features:Electric Door Opener: Yes
  • Parking Features:Attch_squote_d Gar Cabinets: Yes
  • Parking Features:RV Gate: Yes
  • Parking Features:Extnded Lngth Garage: Yes
  • Parking Features:RV Parking: Yes
  • Parking Features:Separate Strge Area: Yes
  • Parking Features:Side Vehicle Entry: Yes
  • Parking Features:Over Height Garage: Yes

Utilities

  • Utilities: Propane
  • Cooling: Refrigeration, Programmable Thmstat, Ceiling Fan(s)
  • Heating: Electric
  • Security: Security System Owned
  • Water Source: Shared Well
  • Heating:Electric: Yes
  • Sewer Septic Tank: Yes

Condo/Co-op/Association

  • Amenities: None
  • Association: No

Association/Amenities

  • Association Fees:HOA YN2: N
  • Association Fees:PAD Fee YN2: N
  • Association Fees:Cap ImprovementImpact Fee _percent_: $
  • Association Fees:Cap ImprovementImpact Fee 2 _percent_: $
  • Association Fee Incl:No Fees: Yes

Fee Information

  • Association Fee Includes: No Fees

Schools

  • Elementary School: Las Sendas Elementary School
  • 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: 50160.0
  • Parcel #: 219-24-214-F
  • ResoLotSizeUnits: SquareFeet

Building Info

  • Builder Name: Custom

Tax Info

  • Tax Annual Amount: 9141.0
  • Tax Book Number: 219.00
  • Tax Lot: N/A
  • Tax Map Number: 24.00

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Jun 9, 2017
Closed on
Oct 5, 2017
Sold by
First International Bank & Trust
Bought by
Bodrero Daniel G and Bodrero Suzanne
Seller's Agent
Brian Bair
OfferPad Brokerage, LLC
Buyer's Agent
Christine Anthony
Russ Lyon Sotheby's International Realty
List Price
$1,600,000
Sold Price
$1,420,000
Premium/Discount to List
-$180,000
-11.25%
Current Estimated Value
$2,292,324

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$872,324
Avg. Annual Appreciation
6.50%
Original Mortgage
$720,000
Outstanding Balance
$607,617
Interest Rate
3.85%
Mortgage Type
New Conventional
Estimated Equity
$1,693,348

Purchase Details

Closed on
May 13, 2015
Sold by
Millington Terrance
Bought by
Millington Terrance and Watwood Millington Rebecca

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$1,360,000
Interest Rate
5.75%
Mortgage Type
Adjustable Rate Mortgage/ARM

Purchase Details

Listed on
Dec 11, 2013
Closed on
Mar 18, 2014
Sold by
Diamond Tamara
Bought by
Hagan Donald L
Seller's Agent
Mario Espinoza
Scottsdale Luxury Properties
Buyer's Agent
Tony Martin
Long Realty Partners
List Price
$1,699,000
Sold Price
$1,400,000
Premium/Discount to List
-$299,000
-17.6%

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
4.51%
Original Mortgage
$800,000
Interest Rate
4.32%
Mortgage Type
Purchase Money Mortgage

Purchase Details

Listed on
Dec 11, 2013
Closed on
Feb 25, 2014
Sold by
Diamond Tamara B
Bought by
Hagan Donald L
Seller's Agent
Mario Espinoza
Scottsdale Luxury Properties
Buyer's Agent
Tony Martin
Long Realty Partners
List Price
$1,699,000
Sold Price
$1,400,000
Premium/Discount to List
-$299,000
-17.6%

Home Financials for this Owner

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

Purchase Details

Closed on
Aug 23, 2011
Sold by
Diamond Tamara K Blin
Bought by
Diamond Tamara B and Tamara Blin Trust

Home Financials for this Owner

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

Purchase Details

Closed on
May 23, 2007
Sold by
Diamond Tamara and Diamond Gus
Bought by
Diamond Gus T and Diamond Tamara B

Home Financials for this Owner

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

Purchase Details

Closed on
May 13, 2004
Sold by
Anasazi Financial Corp
Bought by
Diamond Gus and Diamond Tamara

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$40,000
Interest Rate
5.77%
Mortgage Type
Seller Take Back

Purchase Details

Closed on
Mar 24, 2003
Sold by
Boa Sorte Lp
Bought by
Anasazi Financial Corp
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
Bodrero Daniel G $1,420,000 First American Title Insuran
Millington Terrance -- Accommodation
Millington Terrance -- Driggs Title Agency Inc
Millington Terrance $1,700,000 Driggs Title Agency Inc
Hagan Donald L -- Accommodation
Hagan Donald L $1,400,000 First American Title Ins Co
Diamond Tamara B -- Stewart Title & Trust Of Pho
Diamond Tamara K Blin -- Stewart Title & Trust Of Pho
Diamond Gus T -- Grand Canyon Title Agency In
Diamond Gus $200,000 Transnation Title
Anasazi Financial Corp $265,000 Capital Title Agency Inc
Anasazi Financial Corp $267,000 Capital Title Agency Inc
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Bodrero Daniel G $720,000
Previous Owner Millington Terrance R $50,000
Previous Owner Millington Terrance $1,360,000
Previous Owner Hagan Donald L $200,000
Previous Owner Hagan Donald L $800,000
Previous Owner Diamond Tamara K Blin $480,000
Previous Owner Diamond Tamara B $800,000
Previous Owner Diamond Gus T $500,000
Previous Owner Diamond Gus $1,400,000
Previous Owner Diamond Gus $40,000
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
11/16/2017 11/16/17 Sold $1,420,000 -11.3% $203 / Sq Ft
10/04/2017 10/04/17 Pending -- -- --
06/09/2017 06/09/17 For Sale $1,600,000 +14.3% $228 / Sq Ft
04/11/2014 04/11/14 Sold $1,400,000 -12.4% $194 / Sq Ft
02/24/2014 02/24/14 Pending -- -- --
01/22/2014 01/22/14 Price Changed $1,599,000 -5.9% $222 / Sq Ft
12/11/2013 12/11/13 For Sale $1,699,000 -- $235 / 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 $9,786 $121,556 -- --
2024 $10,483 $115,767 -- --
2023 $10,483 $150,960 $30,190 $120,770
2022 $10,219 $113,420 $22,680 $90,740
2021 $10,192 $107,580 $21,510 $86,070
2020 $10,105 $103,470 $20,690 $82,780
2019 $9,319 $103,330 $20,660 $82,670
2018 $9,072 $110,850 $22,170 $88,680
2017 $9,336 $110,280 $22,050 $88,230
2016 $9,141 $107,120 $21,420 $85,700
2015 $8,540 $99,020 $19,800 $79,220
Source: Public Records

Agents Affiliated with this Home

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

Map

Source: Arizona Regional Multiple Listing Service (ARMLS)

MLS Number: 5618061

Arizona Regional Multiple Listing Service (ARMLS)

APN: 219-24-214F