NOT LISTED FOR SALE

Estimated Value: $2,116,000 - $2,312,000

5 Beds
5 Baths
6,032 Sq Ft
$364/Sq Ft Est. Value

Last Sold December 29, 2023

Last sale price $2,400,000 $398 Per Sq Ft

Est. 9% decrease in value since last sale

Current estimated payment $12,086/month

10 Days on Market

Highlights

  • Heated Spa
  • RV Garage
  • Two Primary Bathrooms
  • Hermosa Vista Elementary School Rated A-
  • 0.47 Acre Lot
  • Fireplace in Primary Bedroom

About This Home

As of December 2023

This elegant yet casual home is perfect for those looking to live in luxury- both inside & out. Expansive living space provides optimal living & entertaining possibilities. This 6,000+ sq ft home features 5 bedrooms 5 full bathrooms & over 2000 square feet in basement space complete with recreational room and three bedrooms. Master suite features a sauna, steam shower, laundry & private flex room. Additional bdrms are large too! The backyard is perfect for active individuals looking to perfect their pickleball skills AND those looking to lounge in the oversized saltwater pool. The space out back features a gazebo, covered patio, outdoor fireplace and cascading water features. Toys? PLENTY of room for all kinds & sizes; room for 7! 3car attached garage and 31'x35' temp controlled garage. If you've been searching for a truly custom home, this one is it- do not let it pass you by

Last Agent to Sell the Property

Sierra Allegretto

Russ Lyon Sotheby's International Realty License #BR677985000 Listed on: 11/02/2023

Russ Lyon Sotheby's International Realty

Last Buyer's Agent

Yvonne Matejka

Real Broker License #BR663616000

Real Broker

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $8,929

Year Built

  • Built in 2002

Lot Details

  • 0.47 Acre Lot
  • Desert faces the front of the property
  • Block Wall Fence
  • Artificial Turf
  • Misting System
  • Sprinklers on Timer
  • Grass Covered Lot

Parking

  • 7 Car Garage
  • 4 Open Parking Spaces
  • Garage ceiling height seven feet or more
  • Side or Rear Entrance to Parking
  • Tandem Garage
  • Garage Door Opener
  • Circular Driveway
  • RV Garage

Home Design

  • Contemporary Architecture
  • Brick Exterior Construction
  • Wood Frame Construction
  • Tile Roof
  • Concrete Roof
  • Stone Exterior Construction
  • Stucco

Interior Spaces

  • 6,032 Sq Ft Home
  • 1-Story Property
  • Ceiling height of 9 feet or more
  • Ceiling Fan
  • Two Way Fireplace
  • Gas Fireplace
  • ENERGY STAR Qualified Windows
  • Family Room with Fireplace
  • 3 Fireplaces
  • Living Room with Fireplace
  • Finished Basement
  • Basement Fills Entire Space Under The House
  • Smart Home

Kitchen

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

Flooring

  • Wood
  • Carpet
  • Concrete

Bedrooms and Bathrooms

  • 5 Bedrooms
  • Fireplace in Primary Bedroom
  • Remodeled Bathroom
  • Two Primary Bathrooms
  • Primary Bathroom is a Full Bathroom
  • 5 Bathrooms
  • Dual Vanity Sinks in Primary Bathroom

Pool

  • Pool Updated in 2022
  • Heated Spa
  • Heated Pool
  • Pool Pump

Outdoor Features

  • Covered Patio or Porch
  • Outdoor Fireplace
  • Built-In Barbecue

Schools

  • Hermosa Vista Elementary School
  • Stapley Junior High School
  • Mountain View High School

Utilities

  • Central Air
  • Heating System Uses Natural Gas
  • High Speed Internet
  • Cable TV Available

Listing and Financial Details

  • Tax Lot 12
  • Assessor Parcel Number 141-06-236

Community Details

Overview

  • No Home Owners Association
  • Association fees include no fees
  • Built by custom
  • Hermosa Vistas Subdivision

Recreation

  • Pickleball Courts
  • Sport Court

Home Details

Home Type

Single Family

Est. Annual Taxes

$8,929

Year Built

Built in 2002

Lot Details

0

Parking

7

Listing Details

  • Cross Street: Gilbert Rd and McKellips
  • Legal Info Range: 6E
  • Property Type: Residential
  • Ownership: Fee Simple
  • Association Fees Land Lease Fee: N
  • Basement: Y
  • Updated Partial or Full Bathrooms: Full
  • Bathrooms Year Updated: 2019
  • Updated Floors: Full
  • Items Updated Floor Yr Updated: 2019
  • Items Updated Ht Cool Yr Updated: 2019
  • Items Updated Kitchen Yr Updated: 2019
  • Updated Pool: Partial
  • Items Updated Pool Yr Updated: 2022
  • Updated Roof: Full
  • Items Updated Roof Yr Updated: 2019
  • Parking Spaces Slab Parking Spaces: 4.0
  • Parking Spaces Total Covered Spaces: 7.0
  • Separate Den Office Sep Den Office: Y
  • Year Built: 2002
  • Spa Private: Yes
  • Tax Year: 2023
  • Property Sub Type: Single Family Residence
  • Horses: No
  • Lot Size Acres: 0.47
  • Subdivision Name: HERMOSA VISTAS
  • Architectural Style: Contemporary
  • Property Attached Yn: No
  • General Property Description:PriceSqFt: 397.87
  • Cooling:Ceiling Fan(s): Yes
  • Technology:Cable TV Avail: Yes
  • Cooling:Central Air: Yes
  • Water Source City Water: Yes
  • Fireplace Features Fireplace Living Rm: Yes
  • Fireplace Features Fireplace Family Rm: Yes
  • Fireplace Features Gas Fireplace: Yes
  • Fireplace Features Fireplace Master Bdr: Yes
  • Fireplace Features Two Way Fireplace: Yes
  • Technology:High Speed Internet: Yes
  • Technology:Smart Home: Yes
  • Special Features: None

Interior Features

  • Basement: Finished, Full
  • Flooring: Carpet, Wood, Concrete
  • Basement YN: Yes
  • Spa Features: Heated, Private
  • Total Bedrooms: 5
  • Fireplace Features: 3+ Fireplace, Two Way Fireplace, Exterior Fireplace, Family Room, Living Room, Master Bedroom, Gas
  • Fireplace: Yes
  • Interior Amenities: High Speed Internet, Smart Home, Granite Counters, Double Vanity, Eat-in Kitchen, 9+ Flat Ceilings, Kitchen Island, Pantry, 2 Master Baths, Full Bth Master Bdrm
  • Living Area: 6032.0
  • Stories: 1
  • Window Features: ENERGY STAR Qualified Windows
  • Kitchen Features:RangeOven Gas: Yes
  • 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
  • Other Rooms:Family Room: Yes
  • Kitchen Features:Reverse Osmosis: Yes
  • Kitchen Features:Wall Oven(s): Yes
  • Kitchen Features:Walk-in Pantry: Yes
  • Other Rooms:BonusGame Room: Yes
  • Kitchen Features:Multiple Ovens: Yes
  • Other Rooms:Library-Blt-in Bkcse: Yes
  • Other Rooms:Separate Workshop: Yes
  • Other Rooms:ExerciseSauna Room: Yes
  • Basement Description:Finished2: Yes
  • Basement Description:Full: Yes
  • KitchenFeatures:Refrigerator: Yes
  • Kitchen Features:Granite Counters: Yes

Exterior Features

  • Fencing: Block
  • Exterior Features: Private Pickleball Court(s), Misting System, Sport Court(s), Built-in Barbecue
  • Lot Features: Desert Front, Gravel/Stone Front, Grass Front, Synthetic Grass Back, Auto Timer H2O Front, Auto Timer H2O Back
  • Pool Features: Heated
  • Disclosures: Agency Discl Req, Seller Discl Avail
  • Construction Type: Brick Veneer, Stucco, Wood Frame, Painted, Stone
  • Other Structures: Gazebo
  • Patio And Porch Features: Covered Patio(s), Patio
  • Roof: Tile, Concrete
  • Construction:Frame - Wood: Yes
  • Exterior Features:Covered Patio(s): Yes
  • Exterior Features:Built-in BBQ: Yes
  • Exterior Features:Patio: Yes
  • Exterior Features:GazeboRamada: Yes
  • Exterior Features:Misting System: Yes
  • Exterior Features:Sport Court(s): Yes
  • Exterior Features:Private Pickleball Court(s): Yes
  • Fireplace Features Exterior Fireplace: Yes

Garage/Parking

  • Total Covered Spaces: 7.0
  • Parking Features: Tandem Garage, RV Access/Parking, Garage Door Opener, Extended Length Garage, Direct Access, Circular Driveway, Attch'd Gar Cabinets, Over Height Garage, Rear Vehicle Entry, Temp Controlled, Detached, RV Garage
  • Attached Garage: No
  • Garage Spaces: 7.0
  • Open Parking Spaces: 4.0
  • Parking Features:Attch_squote_d Gar Cabinets: Yes
  • Parking Features:Rear Vehicle Entry: Yes
  • Parking Features:Temp Controlled: Yes
  • Parking Features:Detached: Yes
  • Parking Features:Tandem Garage: Yes
  • Parking Features:Over Height Garage: Yes
  • Parking Features:RV Garage: Yes
  • Parking Features:Garage Door Opener: Yes
  • Parking Features:Direct Access: Yes
  • Parking Features:Extended Length Garage: Yes
  • Parking Features:Circular Drive: Yes
  • Parking Features:RV AccessParking: Yes

Utilities

  • Cooling: Central Air, Ceiling Fan(s), Programmable Thmstat
  • Heating: Natural Gas
  • Cooling Y N: Yes
  • Heating Yn: Yes
  • Water Source: City Water
  • Heating:Natural Gas: Yes

Condo/Co-op/Association

  • Association: No

Association/Amenities

  • Association Fees:HOA YN2: N
  • Association Fees:PAD Fee YN2: N
  • Association Fee Incl:No Fees: Yes

Fee Information

  • Association Fee Includes: No Fees

Schools

  • Elementary School: Hermosa Vista Elementary School
  • High School: Mountain View High School
  • Junior High Dist: Mesa Unified District
  • Middle Or Junior School: Stapley Junior High School

Lot Info

  • Land Lease: No
  • Lot Size Sq Ft: 20408.0
  • Parcel #: 141-06-236

Building Info

  • Builder Name: custom

Tax Info

  • Tax Annual Amount: 8929.0
  • Tax Book Number: 141.00
  • Tax Lot: 12
  • Tax Map Number: 6.00

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Nov 2, 2023
Closed on
Dec 29, 2023
Sold by
Var Stilla Properties Llc and Hd Investments Llc
Bought by
Warraich Sheraz and Warraich Sarah
Seller's Agent
Sierra Allegretto
Russ Lyon Sotheby's International Realty
Buyer's Agent
Yvonne Matejka
Real Broker
List Price
$2,375,000
Sold Price
$2,400,000
Premium/Discount to List
$25,000
1.05%
Views
23
Current Estimated Value
$2,194,267

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
-$205,733
Avg. Annual Appreciation
-4.10%
Original Mortgage
$1,680,000
Outstanding Balance
$1,645,991
Interest Rate
7.44%
Mortgage Type
New Conventional
Estimated Equity
$548,276

Purchase Details

Listed on
Jun 23, 2022
Closed on
Sep 7, 2022
Sold by
Frost Living Trust and Frost Steven L
Bought by
Var Stilla Properties Llc and Xchange Solutions
Seller's Agent
Charles Maxwell
Realty ONE Group
Buyer's Agent
Sierra Allegretto
Russ Lyon Sotheby's International Realty
List Price
$2,250,000
Sold Price
$2,000,000
Premium/Discount to List
-$250,000
-11.11%
Views
12

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
15.06%

Purchase Details

Closed on
Dec 10, 2020
Sold by
Frost Steven L and Frost Rhonda R
Bought by
Frost Steven L and Frost Rhonda R

Purchase Details

Closed on
Mar 31, 2016
Sold by
Frost Rhonda and Frost Steve
Bought by
Frost Steve and Frost Rhonda

Purchase Details

Closed on
Nov 3, 2015
Sold by
Forst Rhonda R and Frost Steven
Bought by
Frost Steven

Purchase Details

Closed on
May 11, 2001
Sold by
Smith Wayne and Smith Kathryn
Bought by
Frost Steven L and Frost Rhonda R

Purchase Details

Closed on
Dec 19, 2000
Sold by
Smith Wayne B and Smith Kathryn
Bought by
Smith Wayne and Smith Kathryn

Purchase Details

Closed on
Nov 22, 2000
Sold by
Kempton Jayne K
Bought by
Smith Wayne B and Smith Kathryn

Purchase Details

Closed on
Jul 26, 1999
Sold by
Kempton A Newt
Bought by
Kempton Jayne K

Purchase Details

Closed on
Jul 22, 1999
Sold by
Brown Martin W and Brown Suzanne H
Bought by
Kempton Jayne K

Purchase Details

Closed on
May 5, 1999
Sold by
Sevey Family Ltd Partnership
Bought by
Brown Martin W and Brown Suzanne H
Source: Public Records
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
Warraich Sheraz $2,400,000 Old Republic Title Agency
Var Stilla Properties Llc $2,000,000 Premier Title
Frost Steven L -- None Available
Frost Steve -- Lawyers Title Of Arizona Inc
Frost Steven -- Lawyers Title Of Arizona Inc
Frost Steven -- Lawyers Title Of Arizona Inc
Frost Steven L $131,429 Security Title Agency
Smith Wayne -- --
Smith Wayne B $115,000 Lawyers Title Of Arizona Inc
Kempton Jayne K -- Lawyers Title Of Arizona Inc
Kempton Jayne K -- Lawyers Title Of Arizona Inc
Brown Martin W $77,000 Chicago Title Insurance Co
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Open Warraich Sheraz $1,680,000
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft Prior Sale
12/29/2023 12/29/23 Sold $2,400,000 +1.1% $398 / Sq Ft
11/02/2023 11/02/23 For Sale $2,375,000 +18.8% $394 / Sq Ft
09/09/2022 09/09/22 Sold $2,000,000 -7.0% $332 / Sq Ft View Prior Sale
06/30/2022 06/30/22 Price Changed $2,150,000 -4.4% $356 / Sq Ft
06/16/2022 06/16/22 For Sale $2,250,000 -- $373 / Sq Ft
Source: Arizona Regional Multiple Listing Service (ARMLS)

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 $8,302 $89,276 -- --
2024 $8,929 $67,104 -- --
2023 $8,929 $112,120 $22,420 $89,700
2022 $8,146 $77,120 $15,420 $61,700
2021 $8,594 $76,450 $15,290 $61,160
2020 $8,820 $75,620 $15,120 $60,500
2019 $8,257 $75,320 $15,060 $60,260
2018 $7,897 $76,830 $15,360 $61,470
2017 $7,646 $74,930 $14,980 $59,950
2016 $7,491 $73,650 $14,730 $58,920
2015 $7,000 $75,200 $15,040 $60,160
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: 6620617

Arizona Regional Multiple Listing Service (ARMLS)

APN: 141-06-236

Your Personal Tour Guide

Ask me questions while you tour the home.