NOT LISTED FOR SALE

Estimated Value: $1,942,000 - $2,432,000

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

Last Sold November 16, 2017

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

Est. 58% increase in value since last sale

Current estimated payment $13,218/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 Listed By

Brian Bair

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

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
  • Built-In Microwave
  • 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
  • Hydromassage or Jetted Bathtub
  • 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
  • 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
  • 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%
Total Days on Market
117
Current Estimated Value
$2,236,968

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$816,968
Avg. Annual Appreciation
6.25%
Original Mortgage
$720,000
Outstanding Balance
$609,039
Interest Rate
3.85%
Mortgage Type
New Conventional
Estimated Equity
$1,627,929

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.31%
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
Stand Alone Refi Refinance Of Original Loan

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

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

Similar Homes in Mesa, AZ

  • 3937 E Norcroft Cir, Mesa, AZ 85215

    $2,450,000

    • 5 Beds
    • 4.5 Baths
    • 6,458 Sq Ft
    • 3937 E Norcroft Cir
    • Mesa, AZ

    CAPTIVATING UPDATED CUSTOM WITH 42' X 30' RV GARAGE!! Experience stately elegance and elevated design in Northeast Mesa's exclusive gated enclave of Rosewood Estates. This masterfully crafted, amenity-packed estate spans nearly 6,500 square feet, seamlessly blending superior craftsmanship with timeless sophistication for a space that is both stunning and livable. Perfectly positioned on a private

    Christine Anthony Russ Lyon Sotheby's International Realty

    Section Image
  • 2440 N Maple, Mesa, AZ 85215

    $2,270,000

    • 5 Beds
    • 4.5 Baths
    • 5,625 Sq Ft
    • 2440 N Maple
    • Mesa, AZ

    Indulge in a METICULOUSLY-CRAFTED CUSTOM ESTATE offering TIMELESS ELEGANCE in a lush citrus enclave. This AMAZINGLY ENERGY-EFFICIENT HOME is nestled in the privately-gated community of Vista Estancia, one of North Mesa's most coveted neighborhoods. Perfectly situated on a .81-acre lot, the home is surrounded by lush irrigated citrus, mature trees and features a paved circular driveway and huge

    Christine Anthony Russ Lyon Sotheby's International Realty

    Section Image
  • 1233 E Salado Cir, Mesa, AZ 85203

    $2,375,000

    • 5 Beds
    • 4.5 Baths
    • 5,934 Sq Ft
    • 1233 E Salado Cir
    • Mesa, AZ

    Introducing 'The House on the Hill,' a one-of-a-kind, recently updated home reminiscent of a French Country Estate, nestled within a privately gated enclave of 24 custom homes. This extraordinary property, recently featured in Phoenix Home and Garden Magazine, is perfectly positioned at the end of its own cul-de-sac. Set on a pristine, one-acre manicured bluff, it offers sweeping views of the

    Christine Anthony Russ Lyon Sotheby's International Realty

    Section Image
  • 3312 N 89th Place, Mesa, AZ 85207

    $2,699,000

    • 6 Beds
    • 6 Baths
    • 6,470 Sq Ft
    • 3312 N 89th Place
    • Mesa, AZ

    This stunning custom-built luxury home offers breathtaking, panoramic - sunset, city lights, desert landscape, elevated mountain views. The Tuscan style features an open floor plan perfectly complemented by high end granite, travertine, rock and designer tiles. The decor exudes warmth, wrought iron details and all rooms are flooded with natural light. The gourmet kitchen is the heart of the

    Tannis McBean HomeSmart

    Section Image
  • 8157 E Sierra Morena St Unit 127, Mesa, AZ 85207

    $2,199,000

    • 3 Beds
    • 4 Baths
    • 4,685 Sq Ft
    • 8157 E Sierra Morena St
    • Unit 127
    • Mesa, AZ

    This 2 ACRE Estate Home is a rare find in beautiful Las Sendas. This stunning property offers the most incredible unobstructed south facing views of the surrounding mountains & city lights. Discover the luxury living at its finest with this captivating residence that boasts a circular foyer with water feature, 20+ ft soaring ceilings & a sliding glass wall that blends the interior with the

    Bob Dickinson RETSY

    Section Image
  • 2357 N Steele Cir, Mesa, AZ 85207

    $1,975,000

    • 4 Beds
    • 5 Baths
    • 4,354 Sq Ft
    • 2357 N Steele Cir
    • Mesa, AZ

    Luxury living with beautiful Mountain Views, Resort-Style Backyard Oasis. This beautiful 4 bedroom, 5 bath home. Large lot 20,411 sq.ft. Courtyard and 4 car garage. Casita offers a wet bar, walk in closet and full bathroom. Beautiful kitchen with alder wood cabinets, granite counters, built in ice maker, refrigerator, gas cooktop, double wall ovens. Breakfast Bar and Breakfast room. Large formal

    Tamra Yelavich West USA Realty

    Section Image
  • 3254 N Ladera Cir, Mesa, AZ 85207

    $1,720,000

    • 5 Beds
    • 4 Baths
    • 4,624 Sq Ft
    • 3254 N Ladera Cir
    • Mesa, AZ

    Unparalleled elegance within the gated Rock Canyon in Las Sendas. The gourmet kitchen boasts Sub-Zero and Bosch appliances, a spacious walk-in pantry, and high-end finishes. A private home theater, complete with reclining chairs and tiered seating, provides the ultimate media experience. Featuring a stunning heated saltwater pool and spa, firepit, and built-in BBQ. Private rooftop patio provides

    David Friedberg E & G Real Estate Services

    Section Image
  • 2224 N 83rd Cir, Mesa, AZ 85207

    $1,895,000

    • 4 Beds
    • 4.5 Baths
    • 5,506 Sq Ft
    • 2224 N 83rd Cir
    • Mesa, AZ

    Stunning Semi-Custom 4 Bed plus office, 4.5 Bath home on Over 3/4 Acre nestled in an upscale neighborhood. This expansive home is an entertainer's dream and features 4 bedrooms, all with en-suite baths and in their own wing of the home providing ultimate privacy and comfort. These huge bedrooms easily accommodate sitting areas, making them true individual retreats.Designed for seamless

    Lorraine Ryall KOR Properties

    Section Image
  • 8322 E Kael St, Mesa, AZ 85207

    $1,799,000

    • 5 Beds
    • 4 Baths
    • 5,180 Sq Ft
    • 8322 E Kael St
    • Mesa, AZ

    $100,000 PRICE ENHANCEMENT! This Blandford custom home combines elegance and functionality. The resort-style backyard features a heated pool, water slide, waterfalls, jacuzzi, firepit, and torch-lit water features. Two oversized RV/boat/toy/car garages provide ample storage. Inside, the chef's kitchen with premium appliances, gas stove, granite countertops, and seating for 6+ is perfect for

    Braden Fawcett 72SOLD

    Section Image

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