NOT LISTED FOR SALE

Estimated Value: $1,037,000 - $1,208,000

5 Beds
3.5 Baths
5,066 Sq Ft
$220/Sq Ft Est. Value

Highlights

  • Private Pool
  • RV Gated
  • Mountain View
  • Stetson Hills Elementary School Rated A
  • 0.37 Acre Lot
  • Family Room with Fireplace

About This Home

As of September 2020

Stunning T.W. Lewis home in Stetson Ranch. The elegant tile entry is flanked by a formal dining room and spacious office. The great room features a gas fireplace and is open to the well-equipped kitchen and breakfast room. The master suite has a huge private bath with jetted tub, spacious rain shower, 2 separate sinks, and an extra large walk-in closet. The main level has two additional bedrooms, a full bath, powder room, laundry room, and three car garage. The lower level has two large bedrooms, one full bath, a large family room, and bonus room/office. A large covered patio with misting system open to a pebble-tec pool, outdoor kitchen, and wood burning fireplace. Lush landscaping with citrus and fruit trees complete this incomparable home.

Last Agent to Rent the Property

Glen Schneider

Reiss Realty License #BR116392000 Listed on: 07/29/2020

Last Renter's Agent

Glen Schneider

Reiss Realty License #BR116392000 Listed on: 07/29/2020

Property Details

Home Type

  • Multi-Family

Est. Annual Taxes

  • $4,382

Year Built

  • Built in 2003

Lot Details

  • 0.37 Acre Lot
  • Block Wall Fence
  • Misting System
  • Grass Covered Lot

Parking

  • 3 Car Garage
  • RV Gated

Home Design

  • Property Attached
  • Wood Frame Construction
  • Tile Roof
  • Stucco

Interior Spaces

  • 5,066 Sq Ft Home
  • 1-Story Property
  • Central Vacuum
  • Ceiling height of 9 feet or more
  • Ceiling Fan
  • Gas Fireplace
  • Family Room with Fireplace
  • 2 Fireplaces
  • Mountain Views
  • Finished Basement
  • Basement Fills Entire Space Under The House
  • Fire Sprinkler System
  • Washer Hookup

Kitchen

  • Eat-In Kitchen
  • Breakfast Bar
  • Built-In Microwave
  • Kitchen Island

Flooring

  • Carpet
  • Tile

Bedrooms and Bathrooms

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

Outdoor Features

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

Schools

  • Stetson Hills Elementary
  • Sandra Day O'connor High School

Utilities

  • Zoned Heating and Cooling System
  • Heating System Uses Natural Gas
  • High Speed Internet

Listing and Financial Details

  • Property Available on 7/29/20
  • 12-Month Minimum Lease Term
  • Tax Lot 11
  • Assessor Parcel Number 201-33-768

Community Details

Overview

  • Property has a Home Owners Association
  • Associated Asset Mgt Association, Phone Number (602) 957-9191
  • Built by T.W. Lewis
  • Stetson Hills Subdivision

Pet Policy

  • No Pets Allowed

Property Details

Home Type

Multi-Family

Est. Annual Taxes

$4,382

Year Built

Built in 2003

Lot Details

0

Parking

3

Rental Info

  • HOA Paid By: Landlord
  • Available Date: 2020-07-29

Listing Details

  • Cross Street: 43rd Ave & Happy Valley Road
  • Property Type: Residential Lease
  • Basement: Y
  • Parking Spaces Total Covered Spaces: 3.0
  • Separate Den Office Sep Den Office: Y
  • Year Built: 2003
  • Rental Info H O A Name: Associated Asset Mgt
  • Non Assistive Animals: No
  • Lease Term Minimum Lease Term Months: 12
  • Directions: Head North on 43rd Ave * Turn Left on Deem Hills Parkway * Turn left on Range Mule * Turn Right on Moon Blossom * Turn right on Lawler Loop* Home is second house on the right.
  • Property Sub Type: Single Family Residence
  • Horses: No
  • Lot Size Acres: 0.37
  • Subdivision Name: Stetson Hills
  • Efficiency: Multi-Zones
  • Property Attached Yn: Yes
  • Dining Area:Breakfast Bar: Yes
  • Cooling:Ceiling Fan(s): Yes
  • Technology:High Speed Internet Available: Yes
  • Laundry Features Washer Hookup: Yes
  • Construction:Wood Frame: Yes
  • Security Features:Fire Sprinkler System: Yes
  • Water Source City Water2: Yes
  • Fireplace Features Fireplace Family Rm2: Yes
  • Fireplace Features Gas Fireplace2: Yes
  • Special Features: None

Interior Features

  • Basement: Finished, Full
  • Flooring: Carpet, Tile
  • Basement YN: Yes
  • Furnished: Unfurnished
  • Spa Features: None
  • Appliances: Water Softener
  • Possible Bedrooms: 7
  • Total Bedrooms: 5
  • Fireplace Features: Exterior Fireplace, Gas Fireplace, Fireplace Family Rm, 2 Fireplaces
  • Fireplace: Yes
  • Interior Amenities: High Speed Internet, Double Vanity, Eat-in Kitchen, Breakfast Bar, 9+ Flat Ceilings, Central Vacuum, Kitchen Island, Pantry, Full Bth Master Bdrm, Separate Shwr & Tub
  • Living Area: 5066.0
  • Stories: 1
  • Kitchen Features:Built-in Microwave: Yes
  • Kitchen Features:Kitchen Island: Yes
  • Kitchen Features Pantry: Yes
  • Other Rooms:Family Room: Yes
  • Other Rooms:BonusGame Room: Yes
  • Basement Description:Finished2: Yes
  • Basement Description:Full: Yes
  • Master Bathroom:Double Vanity: Yes

Exterior Features

  • Fencing: Block
  • Exterior Features: Other, Built-in BBQ, Misting System
  • Lot Features: Grass Front, Grass Back
  • View: Mountain(s)
  • Disclosures: Agency Discl Req
  • Construction Type: Stucco, Wood Frame, Painted
  • Patio And Porch Features: Covered Patio(s)
  • Roof: Tile
  • Exterior Features:Covered Patio(s): Yes
  • Exterior Features:Built-in BBQ2: Yes
  • Exterior Features:Misting System: Yes
  • Exterior Features:Other6: Yes
  • Fireplace Features Exterior Fireplace2: Yes

Garage/Parking

  • Total Covered Spaces: 3.0
  • Parking Features: RV Access/Parking, Garage Door Opener, RV Gate, Extended Length Garage
  • Attached Garage: No
  • Garage Spaces: 3.0
  • Parking Features:Electric Door Opener: Yes
  • Parking Features:RV Gate: Yes
  • Parking Features:Extnded Lngth Garage: Yes
  • Parking Features:RV Parking: Yes

Utilities

  • Cooling: Central Air, Ceiling Fan(s)
  • Heating: Natural Gas
  • Laundry Features: Washer Hookup
  • Security: Fire Sprinkler System
  • Cooling Y N: Yes
  • Heating Yn: Yes
  • Water Source: City Water
  • Heating:Natural Gas: Yes

Condo/Co-op/Association

  • Association Name: Associated Asset Mgt
  • Phone: 602-957-9191
  • Association: Yes
  • Pets Allowed: No

Schools

  • Elementary School: Stetson Hills Elementary
  • High School: Sandra Day O'Connor High School
  • Junior High Dist: Deer Valley Unified District
  • Middle Or Junior School: Stetson Hills Elementary

Lot Info

  • Lot Size Sq Ft: 16320.0
  • Parcel #: 201-33-768

Building Info

  • Builder Name: T.W. Lewis

Tax Info

  • Tax Book Number: 201.00
  • Tax Lot: 11
  • Tax Map Number: 33.00

Ownership History

Date Name Owned For Owner Type

Purchase Details

Closed on
Jan 31, 2023
Sold by
Esguerra Anthony John D and Esguerra Sherrie Lynn
Bought by
As Esguerra Trust
Current Estimated Value
$1,116,596

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$145,000
Interest Rate
6.27%
Mortgage Type
Credit Line Revolving

Purchase Details

Closed on
Jan 17, 2023
Sold by
Esguerra Anthony John D and Esguerra Sherrie Lynn
Bought by
As Esguerra Trust and Esguerra

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$145,000
Interest Rate
6.27%
Mortgage Type
Credit Line Revolving

Purchase Details

Closed on
Aug 26, 2021
Sold by
Esguerra Anthony John D and Esguerra Sherrie Lynn
Bought by
As Esguerra Trust and Esguerra

Home Financials for this Owner

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

Purchase Details

Closed on
Aug 24, 2021
Sold by
Boschee Bradley John and Boschee Lorraine Kaye
Bought by
Esguerra Anthony John D and Esguerra Sherrie Lynn

Home Financials for this Owner

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

Purchase Details

Closed on
Jul 12, 2013
Sold by
Boschee Bradley J and Boschee Lorraine
Bought by
Boschee Bradley John and Boschee Lorraine Kaye

Purchase Details

Closed on
Oct 14, 2003
Sold by
T W Lewis Co
Bought by
Boschee Bradley J and Boschee Lorraine

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$400,000
Interest Rate
6.4%
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
As Esguerra Trust -- --
As Esguerra Trust -- None Listed On Document
Esguerra Anthony John D -- None Listed On Document
As Esguerra Trust -- Accommodation
Esguerra Anthony John D $900,000 Magnus Title Agency Llc
Boschee Bradley John -- None Available
Boschee Bradley J $551,418 Chicago Title Insurance Co
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Previous Owner Esguerra Anthony John D $696,000
Previous Owner Boschee Bradley J $400,000
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
09/01/2020 09/01/20 Rented $3,995 0.0% --
08/30/2020 08/30/20 Under Contract -- -- --
07/29/2020 07/29/20 For Rent $3,995 +5.8% --
03/16/2019 03/16/19 Rented $3,775 -3.1% --
02/23/2019 02/23/19 For Rent $3,895 +30.1% --
06/20/2012 06/20/12 Rented $2,995 -6.4% --
06/20/2012 06/20/12 Under Contract -- -- --
05/25/2012 05/25/12 For Rent $3,200 -- --
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 $4,382 $49,207 -- --
2024 $6,517 $46,864 -- --
2023 $6,517 $81,080 $16,210 $64,870
2022 $6,278 $62,510 $12,500 $50,010
2021 $7,061 $58,770 $11,750 $47,020
2020 $6,991 $59,530 $11,900 $47,630
2019 $6,790 $59,050 $11,810 $47,240
2018 $6,576 $59,010 $11,800 $47,210
2017 $6,363 $55,720 $11,140 $44,580
2016 $6,037 $56,450 $11,290 $45,160
2015 $5,410 $58,500 $11,700 $46,800
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: 6109732

Arizona Regional Multiple Listing Service (ARMLS)

APN: 201-33-768