NOT LISTED FOR SALE

Estimated Value: $1,796,000 - $2,484,678

5 Beds
5.5 Baths
7,041 Sq Ft
$319/Sq Ft Est. Value

Last Sold August 21, 2013

Last sale price $1,475,000 $209 Per Sq Ft

Est. 52% increase in value since last sale

Current estimated payment $12,745/month

12 Days on Market

Highlights

  • Guest House
  • Heated Spa
  • Sitting Area In Primary Bedroom
  • Ishikawa Elementary School Rated A-
  • RV Garage
  • Fireplace in Primary Bedroom

About This Home

As of August 2013

Beyond Spectacular! This incredible home offers 4 bedrooms, 4,5 baths + 500 sq, ft, casita with kitchenette, bathroom and separate entrance from the main house. Granite counter tops and 12'-14' ceilings throughout, wood flooring, top of the line appliances, incredible chef's kitchen, theater plus game room with wet bar. Each bedroom has it's own bathroom plus walk-in closet. 1500 sq. ft. Master suite with fireplace and steam shower. Resort like grounds include an outdoor kitchen heated pool & spa, fire columns, misting system, patios, balconies, multiple water features, meticulous landscaping with citrus trees, shrubs and beautiful palms. Parking for up to 9 vehicles including an RV garage. All garages are heated and cooled. Please see documents section for more details!!!

Last Agent to Sell the Property

Charles Randall

TreeHouse Realty, LLC License #SA032747000 Listed on: 07/22/2013

Co-Listed By

Valerie Randall

Keller Williams Integrity First License #SA105726000

Last Buyer's Agent

Renee Merritt

Keller Williams Arizona Realty License #SA572109000

Keller Williams Arizona Realty

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $7,222

Year Built

  • Built in 2004

Lot Details

  • 0.83 Acre Lot
  • Private Streets
  • Block Wall Fence
  • Misting System
  • Front and Back Yard Sprinklers
  • Grass Covered Lot

Parking

  • 9 Car Direct Access Garage
  • Garage ceiling height seven feet or more
  • Garage Door Opener
  • RV Garage

Home Design

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

Interior Spaces

  • 7,041 Sq Ft Home
  • 1-Story Property
  • Ceiling height of 9 feet or more
  • Ceiling Fan
  • Gas Fireplace
  • Double Pane Windows
  • Family Room with Fireplace
  • 2 Fireplaces
  • Laundry in unit

Kitchen

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

Flooring

  • Wood
  • Stone
  • Concrete

Bedrooms and Bathrooms

  • 5 Bedrooms
  • Sitting Area In Primary Bedroom
  • Fireplace in Primary Bedroom
  • Walk-In Closet
  • Primary Bathroom is a Full Bathroom
  • 5.5 Bathrooms
  • Dual Vanity Sinks in Primary Bathroom
  • Bidet
  • Hydromassage or Jetted Bathtub
  • Bathtub With Separate Shower Stall

Home Security

  • Security System Owned
  • Smart Home

Pool

  • Heated Spa
  • Heated Pool

Outdoor Features

  • Covered Patio or Porch
  • Fire Pit
  • Gazebo
  • Built-In Barbecue

Schools

  • Ishikawa Elementary School
  • Stapley Junior High School
  • Mountain View - Waddell High School

Utilities

  • Refrigerated Cooling System
  • Zoned Heating
  • Heating System Uses Natural Gas
  • Water Softener
  • High Speed Internet
  • Cable TV Available

Additional Features

  • No Interior Steps
  • Guest House

Listing and Financial Details

  • Home warranty included in the sale of the property
  • Tax Lot 4
  • Assessor Parcel Number 141-87-562

Community Details

Overview

  • Property has a Home Owners Association
  • Hermosa Estates Association
  • Built by Custom
  • Hermosa Estates Subdivision

Recreation

  • Community Playground

Home Details

Home Type

Single Family

Est. Annual Taxes

$7,222

Year Built

Built in 2004

Lot Details

0

Parking

9

Listing Details

  • Cross Street: Val Vista/McKellips
  • Property Type: Residential
  • HOA #2: N
  • HOA #3 Fee: N
  • Association Fees Land Lease Fee: N
  • Recreation Center Fee 2: N
  • Recreation Center Fee: N
  • Total Monthly Fee Equivalent: 200.0
  • Basement: N
  • Parking Spaces Total Covered Spaces: 9.0
  • Separate Den Office Sep Den Office: Y
  • Year Built: 2004
  • Spa Private: Yes
  • Tax Year: 2012
  • Directions: North on Val Vista, West into the community of Hermosa Estates.
  • Property Sub Type: Single Family - Detached
  • Lot Size Acres: 0.83
  • Co List Office Mls Id: lyon18
  • Co List Office Phone: 480-325-1000
  • Subdivision Name: Hermosa Estates
  • Architectural Style: Santa Barbara/Tuscan
  • Efficiency: Multi-Zones
  • ResoBuildingAreaSource: Assessor
  • Association Fees:HOA Fee2: 600.0
  • Dining Area:Breakfast Bar: Yes
  • Windows:Dual Pane: Yes
  • Cooling:Ceiling Fan(s): Yes
  • Technology:Cable TV Avail: Yes
  • Technology:High Speed Internet Available: Yes
  • Technology:Smart Home System: Yes
  • Special Features: VirtualTour

Interior Features

  • Basement: None
  • Flooring: Stone, Wood, Concrete
  • Spa Features: Heated, Private
  • Possible Bedrooms: 8
  • Total Bedrooms: 5
  • Fireplace Features: 2 Fireplace, Fire Pit, Family Room, Master Bedroom, Gas
  • Fireplace: Yes
  • Interior Amenities: Mstr Bdrm Sitting Rm, Walk-In Closet(s), Eat-in Kitchen, Breakfast Bar, 9+ Flat Ceilings, No Interior Steps, Soft Water Loop, Kitchen Island, Pantry, Bidet, Double Vanity, Full Bth Master Bdrm, Separate Shwr & Tub, Tub with Jets, High Speed Internet, Smart Home, Granite Counters
  • Living Area: 7041.0
  • Stories: 1
  • Window Features: Double Pane Windows
  • Kitchen Features:Dishwasher2: Yes
  • Kitchen Features:Built-in Microwave: Yes
  • Kitchen Features:Granite Countertops: Yes
  • Kitchen Features:Kitchen Island: Yes
  • Master Bathroom:Double Sinks: Yes
  • Kitchen Features:Disposal2: Yes
  • Kitchen Features:Refrigerator2: Yes
  • Kitchen Features Pantry: Yes
  • Fireplace:_two_ Fireplace: Yes
  • Fireplace:Fireplace Family Rm: Yes
  • Other Rooms:Family Room: Yes
  • Fireplace:Gas Fireplace: Yes
  • Kitchen Features:Wall Oven(s): Yes
  • Community Features:Children_squote_s Playgrnd: Yes
  • Kitchen Features:Walk-in Pantry: Yes
  • Other Rooms:BonusGame Room: Yes
  • Kitchen Features:Cook Top Gas: Yes
  • Fireplace:Firepit: Yes
  • Other Rooms:Guest Qtrs-Sep Entrn: Yes
  • Kitchen Features:Multiple Ovens: Yes
  • Fireplace:Fireplace Master Bdr: Yes
  • Other Rooms:Library-Blt-in Bkcse: Yes
  • Other Rooms:Separate Workshop: Yes
  • Other Rooms:Media Room: Yes

Exterior Features

  • Fencing: Block
  • Exterior Features: Covered Patio(s), Gazebo/Ramada, Misting System, Private Street(s), Built-in Barbecue
  • Lot Features: Sprinklers In Rear, Sprinklers In Front, Grass Front, Grass Back, Irrigation Back
  • Pool Features: Heated, Private
  • Disclosures: Agency Discl Req, Seller Discl Avail
  • Home Warranty: Yes
  • Construction Type: Painted, Stucco, Stone, Frame - Wood
  • Other Structures: Guest House
  • Roof: Tile
  • Construction:Frame - Wood: Yes
  • Exterior Features:Covered Patio(s): Yes
  • Exterior Features:Built-in BBQ: Yes
  • Exterior Features:Separate Guest House: Yes
  • Exterior Features:GazeboRamada: Yes
  • Exterior Features:Misting System: Yes
  • Exterior Features:Private Street(s): Yes

Garage/Parking

  • Total Covered Spaces: 9.0
  • Parking Features: Attch'd Gar Cabinets, Dir Entry frm Garage, Electric Door Opener, Extnded Lngth Garage, Over Height Garage, RV Access/Parking, RV Garage
  • Attached Garage: No
  • Garage Spaces: 9.0
  • Parking Features:Dir Entry frm Garage: Yes
  • Parking Features:Electric Door Opener: Yes
  • Parking Features:Attch_squote_d Gar Cabinets: Yes
  • Parking Features:Extnded Lngth Garage: Yes
  • Parking Features:RV Parking: Yes
  • Parking Features:Over Height Garage: Yes
  • Parking Features:RV Garage: Yes

Utilities

  • Cooling: Refrigeration, Ceiling Fan(s)
  • Heating: Natural Gas
  • Laundry Features: Inside
  • Security: Security System Owned
  • Water Source: City Water
  • Heating:Natural Gas: Yes

Condo/Co-op/Association

  • Community Features: Playground
  • Amenities: Management
  • Association Fee Frequency: Quarterly
  • Association Name: Hermosa Estates
  • Phone: 000-0000
  • Association: Yes

Association/Amenities

  • Association Fees:HOA YN2: Y
  • Association Fees:HOA Transfer Fee2: 300.0
  • Association Fees:HOA Paid Frequency: Quarterly
  • Association Fees:HOA Name4: Hermosa Estates
  • Association Fees:HOA Telephone4: 000-0000
  • 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_: $

Schools

  • Elementary School: Ishikawa Elementary School
  • High School: Mountain View - Waddell
  • Middle Or Junior School: Stapley Junior High School

Lot Info

  • Land Lease: No
  • Lot Size Sq Ft: 36175.0
  • Parcel #: 141-87-562
  • ResoLotSizeUnits: SquareFeet

Green Features

  • Green Water Conservation: Recirculation Pump

Building Info

  • Builder Name: Custom

Tax Info

  • Tax Annual Amount: 7221.82
  • Tax Book Number: 141.00
  • Tax Lot: 4
  • Tax Map Number: 87.00

Ownership History

Date Name Owned For Owner Type

Purchase Details

Closed on
May 1, 2018
Sold by
Billings Anthony C and The Anthony C Billings Trust
Bought by
Billings Anthony C and Billings Dawn L
Current Estimated Value
$2,246,893

Purchase Details

Closed on
Dec 21, 2015
Sold by
Billings Anthony C
Bought by
Billings Anthony C and The Anthony C Billings Trust

Purchase Details

Listed on
Jul 22, 2013
Closed on
Aug 13, 2013
Sold by
Bardwell Jeffrey and Bardwell Fabiola
Bought by
Billings Anthony C
Seller's Agent
Charles Randall
TreeHouse Realty, LLC
Buyer's Agent
Renee Merritt
Keller Williams Arizona Realty
List Price
$1,650,000
Sold Price
$1,475,000
Premium/Discount to List
-$175,000
-10.61%

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.11%

Purchase Details

Listed on
Feb 9, 2012
Closed on
Mar 1, 2012
Sold by
American Pacific Holdings Llc
Bought by
Bardwell Jeffrey and Bardwell Fabiola
Seller's Agent
David Jarvis
Gentry Real Estate
Buyer's Agent
Kathy Forger
Russ Lyon Sotheby's International Realty
List Price
$1,100,000
Sold Price
$950,000
Premium/Discount to List
-$150,000
-13.64%

Home Financials for this Owner

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

Purchase Details

Listed on
Feb 9, 2012
Closed on
Jan 24, 2012
Sold by
Frandsen Ronald K
Bought by
American Pacific Holdings Llc
Seller's Agent
David Jarvis
Gentry Real Estate
Buyer's Agent
Kathy Forger
Russ Lyon Sotheby's International Realty
List Price
$1,100,000
Sold Price
$950,000
Premium/Discount to List
-$150,000
-13.64%

Home Financials for this Owner

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

Purchase Details

Closed on
May 5, 2011
Sold by
Fitzsimmons Nancy H
Bought by
Frandsen Ronald K

Home Financials for this Owner

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

Purchase Details

Closed on
Apr 21, 2011
Sold by
Potomac Asset Management Llc
Bought by
Frandsen Ronald K

Home Financials for this Owner

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

Purchase Details

Closed on
Apr 6, 2009
Sold by
Robinson David R
Bought by
Potomac Asset Management Llc

Purchase Details

Closed on
May 18, 2006
Sold by
Robinson Chellee C
Bought by
Robinson David R

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$200,000
Interest Rate
6.63%
Mortgage Type
Unknown

Purchase Details

Closed on
Apr 26, 2004
Sold by
Trimark Development Llc
Bought by
Robinson David R and Robinson Chellee C

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$1,180,000
Interest Rate
5.77%
Mortgage Type
New Conventional
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
Billings Anthony C -- None Available
Billings Anthony C -- None Available
Billings Anthony C $1,475,000 Equity Title Agency Inc
Bardwell Jeffrey $950,000 Great American Title Agency
American Pacific Holdings Llc $700,000 Great American Title Agency
Frandsen Ronald K -- North American Title Company
Frandsen Ronald K -- North American Title Company
Potomac Asset Management Llc $875,000 Lawyers Title Of Arizona Inc
Robinson David R -- Security Title Agency Inc
Robinson David R $300,000 Lawyers Title Ins
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Previous Owner Bardwell Jeffrey $600,000
Previous Owner American Pacific Holdings Llc $560,000
Previous Owner Frandsen Ronald K $425,000
Previous Owner Frandsen Ronald K $425,000
Previous Owner Robinson David R $200,000
Previous Owner Robinson David R $1,352,400
Previous Owner Robinson David R $1,180,000
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
08/21/2013 08/21/13 Sold $1,475,000 -10.6% $209 / Sq Ft
08/03/2013 08/03/13 Pending -- -- --
07/22/2013 07/22/13 For Sale $1,650,000 +73.7% $234 / Sq Ft
03/15/2012 03/15/12 Sold $950,000 -13.6% $146 / Sq Ft
02/15/2012 02/15/12 Pending -- -- --
02/09/2012 02/09/12 For Sale $1,100,000 -- $169 / 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 $10,564 $112,045 -- --
2024 $10,654 $106,710 -- --
2023 $10,654 $128,470 $25,690 $102,780
2022 $10,425 $109,780 $21,950 $87,830
2021 $10,530 $92,180 $18,430 $73,750
2020 $10,711 $90,460 $18,090 $72,370
2019 $11,337 $101,770 $20,350 $81,420
2018 $10,850 $95,880 $19,170 $76,710
2017 $10,512 $106,560 $21,310 $85,250
2016 $10,261 $104,350 $20,870 $83,480
2015 $9,640 $105,670 $21,130 $84,540
Source: Public Records

Agents Affiliated with this Home

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

Map

Source: Arizona Regional Multiple Listing Service (ARMLS)

MLS Number: 4971514

Arizona Regional Multiple Listing Service (ARMLS)

APN: 141-87-562