NOT LISTED FOR SALE

23510 S 201st Way Queen Creek, AZ 85142

Estimated Value: $970,000 - $1,035,000

4 Beds
3 Baths
3,256 Sq Ft
$310/Sq Ft Est. Value

Last Sold December 03, 2021

Last sale price $975,000 $299 Per Sq Ft

Est. 4% increase in value since last sale

Current estimated payment $5,768/month

14 Days on Market

Highlights

  • Private Pool
  • RV Access or Parking
  • Granite Countertops
  • Desert Mountain Elementary School Rated A-
  • Hydromassage or Jetted Bathtub
  • Private Yard

About This Home

As of December 2021

Gorgeous custom home in coveted Terra Ranch Custom Estates. Terra Ranch is a quiet & established hidden gem bordering well-known Circle G. Similar in appeal to Circle G, Terra Ranch also features fully custom homes w/ lush green lawns & tree-lined streets.

Sitting on just under a half-acre, this home features a private courtyard w/ a custom Italian Stone fountain, an open & spacious split floorplan w/ a gorgeous Chef's kitchen featuring a gas stove, double convection oven, built-in wine fridge & a Butler's Pantry.

Owner's suite is complete w/ large sitting area, a breathtaking master bath w/ a huge Roman shower specifically designed to keep you warm when showering.

Home has 4 bedrooms & a 5th bonus room for a home office, yoga studio, etc. 4th bedroom has an EXTERIOR ENTRY w/ its own full bath that serves as the perfect setup for Private Guest Quarters, a Mother-In-Law Suite, a Room Rental or a private space for the college kids coming home for the summer.

Private backyard is an entertainers dream w/ a pool featuring a large rockslide, TWO beautifully designed custom gazebos w/ full electric, fans, TV's & surround sound hookup. Large RV gated area off to the side is already HOA approved to build an RV GARAGE!

Oversized 3 car garage w/ epoxy flooring & addt'l storage space. Brand new $10K+ full HVAC system in 2020. This home is the ultimate retreat with no fine detail spared... the only home in Queen Creek w/ these luxury upgrades for under a million. ALL offers are welcome so get your showing in today.

Last Agent to Sell the Property

Jamie Heinz

HomeSmart License #SA686794000 Listed on: 10/22/2021

HomeSmart

Last Buyer's Agent

Shellece Strong

The Offer Company License #SA573476000

Home Details

Home Type

  • Single Family

Est. Annual Taxes

  • $3,993

Year Built

  • Built in 2004

Lot Details

  • 0.43 Acre Lot
  • Block Wall Fence
  • Front and Back Yard Sprinklers
  • Sprinklers on Timer
  • Private Yard
  • Grass Covered Lot

HOA Fees

  • $6 Monthly HOA Fees

Parking

  • 3 Car Garage
  • 8 Open Parking Spaces
  • Garage Door Opener
  • RV Access or Parking

Home Design

  • Wood Frame Construction
  • Tile Roof
  • Stucco

Interior Spaces

  • 3,256 Sq Ft Home
  • 1-Story Property
  • Ceiling height of 9 feet or more
  • Ceiling Fan
  • Fireplace
  • Double Pane Windows
  • Solar Screens
  • Tile Flooring
  • Security System Owned
  • Washer and Dryer Hookup

Kitchen

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

Bedrooms and Bathrooms

  • 4 Bedrooms
  • Primary Bathroom is a Full Bathroom
  • 3 Bathrooms
  • Dual Vanity Sinks in Primary Bathroom
  • Hydromassage or Jetted Bathtub
  • Bathtub With Separate Shower Stall

Accessible Home Design

  • Accessible Hallway
  • No Interior Steps
  • Multiple Entries or Exits
  • Raised Toilet
  • Hard or Low Nap Flooring

Pool

  • Private Pool
  • Pool Pump

Outdoor Features

  • Covered Patio or Porch
  • Fire Pit
  • Outdoor Storage
  • Built-In Barbecue

Schools

  • Queen Creek Elementary School
  • Newell Barney Middle School
  • Queen Creek High School

Utilities

  • Central Air
  • Heating System Uses Natural Gas
  • Water Purifier
  • High Speed Internet

Listing and Financial Details

  • Tax Lot 39
  • Assessor Parcel Number 304-67-240

Community Details

Overview

  • Association fees include ground maintenance
  • Terra Ranch At Qc Association, Phone Number (602) 863-3600
  • Built by Custom
  • Terra Ranch Custom Estates Subdivision, Custom Build Floorplan

Recreation

  • Racquetball
  • Community Playground

Home Details

Home Type

Single Family

Est. Annual Taxes

$3,993

Year Built

Built in 2004

Lot Details

0

HOA Fees

$6 per month

Parking

3

Listing Details

  • Cross Street: Chandler Heights and Hawes
  • Legal Info Range: 7E
  • Property Type: Residential
  • Ownership: Fee Simple
  • HOA #2: N
  • Association Fees Land Lease Fee: N
  • Recreation Center Fee: N
  • Total Monthly Fee Equivalent: 6.46
  • Basement: N
  • Parking Spaces Slab Parking Spaces: 8.0
  • Parking Spaces Total Covered Spaces: 3.0
  • Separate Den Office Sep Den Office: N
  • Year Built: 2004
  • Tax Year: 2021
  • Master Model: Custom Build
  • Property Sub Type: Single Family Residence
  • Horses: No
  • Lot Size Acres: 0.43
  • Subdivision Name: TERRA RANCH CUSTOM ESTATES
  • Architectural Style: Ranch
  • Property Attached Yn: No
  • Association Fees:HOA Fee2: 77.5
  • Dining Area:Breakfast Bar: Yes
  • Windows:Dual Pane: Yes
  • Cooling:Ceiling Fan(s): Yes
  • Cooling:Central Air: Yes
  • Features:Water Purifier: Yes
  • Windows:Solar Screens: Yes
  • Water Source City Water: Yes
  • Kitchen Features:Gas Cooktop: Yes
  • Technology:High Speed Internet: Yes
  • Special Features: None

Interior Features

  • Flooring: Tile
  • Basement YN: No
  • Possible Use: None
  • Spa Features: None
  • Appliances: Gas Cooktop, Water Purifier
  • Accessibility Features: Mltpl Entries/Exits, Hard/Low Nap Floors, Bath Raised Toilet, Accessible Hallway(s)
  • Possible Bedrooms: 5
  • Total Bedrooms: 4
  • Fireplace Features: Fire Pit
  • Fireplace: Yes
  • Interior Amenities: High Speed Internet, Granite Counters, Double Vanity, Master Downstairs, Eat-in Kitchen, Breakfast Bar, 9+ Flat Ceilings, No Interior Steps, Kitchen Island, Pantry, Full Bth Master Bdrm, Separate Shwr & Tub, Tub with Jets
  • Living Area: 3256.0
  • Stories: 1
  • Window Features: Solar Screens, Dual Pane
  • 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
  • Community Features:HandballRacquetball: Yes
  • Kitchen Features:Reverse Osmosis: Yes
  • Kitchen Features:Wall Oven(s): Yes
  • Community Features:Children_squote_s Playgrnd: Yes
  • Other Rooms:BonusGame Room: Yes
  • Other Rooms:Guest Qtrs-Sep Entrn: Yes
  • Kitchen Features:Multiple Ovens: Yes
  • Other Rooms:Separate Workshop: Yes
  • Other Rooms:ExerciseSauna Room: Yes
  • KitchenFeatures:Refrigerator: Yes
  • Fireplace Features:Fire Pit: Yes
  • Kitchen Features:Granite Counters: Yes

Exterior Features

  • Fencing: Block
  • Exterior Features: Private Yard, Storage, Built-in Barbecue
  • Lot Features: Sprinklers In Rear, Sprinklers In Front, Gravel/Stone Front, Gravel/Stone Back, Grass Front, Grass Back, Auto Timer H2O Front, Auto Timer H2O Back
  • Pool Features: Variable Speed Pump, Private
  • Disclosures: Agency Discl Req, Seller Discl Avail
  • Construction Type: Stucco, Wood Frame
  • Other Structures: Gazebo
  • Patio And Porch Features: Covered Patio(s)
  • Roof: Tile
  • Construction:Frame - Wood: Yes
  • Exterior Features:Covered Patio(s): Yes
  • Exterior Features:Built-in BBQ: Yes
  • Exterior Features:Pvt Yrd(s)Crtyrd(s): Yes
  • Exterior Features:Storage: Yes
  • Exterior Features:GazeboRamada: Yes

Garage/Parking

  • Total Covered Spaces: 3.0
  • Parking Features: RV Access/Parking, RV Gate, Garage Door Opener, Extended Length Garage, Separate Strge Area
  • Attached Garage: No
  • Garage Spaces: 3.0
  • Open Parking Spaces: 8.0
  • Parking Features:RV Gate: Yes
  • Parking Features:Separate Strge Area: Yes
  • Parking Features:Garage Door Opener: Yes
  • Parking Features:Extended Length Garage: Yes
  • Parking Features:RV AccessParking: Yes

Utilities

  • Cooling: Central Air, Ceiling Fan(s), Programmable Thmstat
  • Heating: Natural Gas
  • Laundry Features: Wshr/Dry HookUp Only
  • Security: Security System Owned
  • Cooling Y N: Yes
  • Heating Yn: Yes
  • Water Source: City Water
  • Heating:Natural Gas: Yes

Condo/Co-op/Association

  • Community Features: Racquetball, Playground
  • Association Fee: 77.5
  • Association Fee Frequency: Annually
  • Association Name: Terra Ranch at QC
  • Phone: 602-863-3600
  • Association: Yes

Association/Amenities

  • Association Fees:HOA YN2: Y
  • Association Fees:HOA Paid Frequency: Annually
  • Association Fees:HOA Name4: Terra Ranch at QC
  • Association Fees:HOA Telephone4: 6028633600
  • Association Fees:PAD Fee YN2: N
  • Association Fees:Cap ImprovementImpact Fee _percent_: $
  • Association Fee Incl:Common Area Maint3: Yes

Fee Information

  • Association Fee Includes: Maintenance Grounds

Schools

  • Elementary School: Queen Creek Elementary School
  • High School: Queen Creek High School
  • Junior High Dist: Queen Creek Unified District
  • Middle Or Junior School: Newell Barney Middle School

Lot Info

  • Land Lease: No
  • Lot Size Sq Ft: 18744.0
  • Parcel #: 304-67-240

Green Features

  • Green Water Conservation: Recirculation Pump

Building Info

  • Builder Name: Custom

Tax Info

  • Tax Annual Amount: 3993.0
  • Tax Book Number: 304.00
  • Tax Lot: 39
  • Tax Map Number: 67.00

Ownership History

Date Name Owned For Owner Type

Purchase Details

Listed on
Oct 22, 2021
Closed on
Nov 28, 2021
Sold by
Ibarra John and Ibarra Kamron
Bought by
Bauernfeind Jeremy and King Rheannon
Seller's Agent
Jamie Heinz
HomeSmart
Buyer's Agent
Shellece Strong
The Offer Company
List Price
$979,000
Sold Price
$975,000
Premium/Discount to List
-$4,000
-0.41%
Current Estimated Value
$1,009,261

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Estimated Appreciation
$34,261
Avg. Annual Appreciation
0.92%
Original Mortgage
$734,000
Outstanding Balance
$676,295
Interest Rate
3.09%
Mortgage Type
New Conventional
Estimated Equity
$332,966

Purchase Details

Listed on
Jul 24, 2020
Closed on
Aug 24, 2020
Sold by
Weinland Joshua M and Weinland Jessica
Bought by
Ibarra John and Ibarra Kamron
Seller's Agent
Joshua Weinland
LPT Realty, LLC
Buyer's Agent
Jamie Heinz
HomeSmart
List Price
$699,000
Sold Price
$720,000
Premium/Discount to List
$21,000
3%

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
26.96%
Original Mortgage
$720,000
Interest Rate
2.9%
Mortgage Type
VA

Purchase Details

Listed on
May 7, 2018
Closed on
Jul 3, 2018
Sold by
Fields Jeffrey G
Bought by
Weinland Joshua M and Weinland Jessica
Seller's Agent
Amber Eilers
Original Realty Co
Buyer's Agent
Non-MLS Agent
Non-MLS Office
List Price
$529,900
Sold Price
$520,000
Premium/Discount to List
-$9,900
-1.87%

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
16.51%
Original Mortgage
$503,275
Interest Rate
4.6%
Mortgage Type
VA

Purchase Details

Listed on
Jan 9, 2016
Closed on
Feb 29, 2016
Sold by
Orlandi Clifton and Orlandi Elizabeth
Bought by
Fields Jeffrey G
Seller's Agent
Brian Cunningham
eXp Realty
Buyer's Agent
Laura Mier
Realty ONE Group
List Price
$479,450
Sold Price
$475,000
Premium/Discount to List
-$4,450
-0.93%

Home Financials for this Owner

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

Purchase Details

Listed on
Mar 18, 2014
Closed on
Aug 26, 2014
Sold by
Surwald Lynette A and Surwald Gregory J
Bought by
Orlandi Clifton and Orlandi Elizabeth
Seller's Agent
Lynette Surwald
West USA Realty
Buyer's Agent
Lynette Surwald
West USA Realty
List Price
$420,000
Sold Price
$405,000
Premium/Discount to List
-$15,000
-3.57%

Home Financials for this Owner

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

Purchase Details

Closed on
May 10, 2010
Sold by
Reyes Cindy I
Bought by
Surwald Lynette A and Surwald Gregory J

Home Financials for this Owner

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

Purchase Details

Closed on
Oct 10, 2006
Sold by
Reyes Deabel
Bought by
Reyes Cindy I

Home Financials for this Owner

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

Purchase Details

Closed on
Mar 3, 2006
Sold by
Reyes Deable
Bought by
Reyes Cindy I

Home Financials for this Owner

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

Purchase Details

Closed on
Aug 25, 2005
Sold by
Reyes Cindy I
Bought by
Reyes Deable

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.95%
Mortgage Type
Fannie Mae Freddie Mac

Purchase Details

Closed on
Oct 5, 2004
Sold by
Reyes Deabel
Bought by
Reyes Cindy I

Home Financials for this Owner

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

Purchase Details

Closed on
Sep 16, 2004
Sold by
Sanctuary Design Llc
Bought by
Reyes Cindy I

Home Financials for this Owner

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

Purchase Details

Closed on
Mar 30, 2004
Sold by
Digiovanni Joseph N and Johnston Rhett
Bought by
Sanctuary Design Llc

Home Financials for this Owner

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

Purchase Details

Closed on
Feb 4, 2004
Sold by
Digiovanni Alice M
Bought by
Digiovanni Joseph N

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$242,200
Interest Rate
5.25%
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
Bauernfeind Jeremy $975,000 Magnus Title Agency
Ibarra John $720,000 Empire West Title Agency Llc
Weinland Joshua M $520,000 Pioneer Title Agency Inc
Fields Jeffrey G $475,000 Stewart Title
Orlandi Clifton $405,000 Chicago Title Agency Inc
Surwald Lynette A $268,000 Pioneer Title Agency Inc
Reyes Cindy I -- Fidelity National Title
Reyes Cindy I -- Fidelity National Title
Reyes Deable -- --
Reyes Cindy I -- Security Title Agency
Reyes Cindy I $375,414 Security Title Agency
Sanctuary Design Llc $87,500 Security Title Agency
Digiovanni Joseph N -- Lawyers Title Insurance Corp
Digiovanni Joseph N $82,000 Lawyers Title Insurance Corp
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Closed Bauernfeind Jeremy $115,000
Open Bauernfeind Jeremy $734,000
Previous Owner Ibarra John $720,000
Previous Owner Weinland Joshua M $504,735
Previous Owner Weinland Joshua M $503,275
Previous Owner Fields Jeffrey G $417,000
Previous Owner Fields Jeffrey G $380,000
Previous Owner Fields Jeffrey G $47,500
Previous Owner Orlandi Clifton $340,000
Previous Owner Surwald Lynette A $214,400
Previous Owner Reyes Cindy I $711,000
Previous Owner Reyes Cindy I $612,000
Previous Owner Reyes Deable $500,000
Previous Owner Reyes Cindy I $337,500
Previous Owner Reyes Cindy I $337,500
Previous Owner Sanctuary Design Llc $242,200
Closed Sanctuary Design Llc $87,500
Source: Public Records

Property History

Date Event Price Change Sq Ft Price
12/03/2021 12/03/21 Sold $975,000 +0.1% $299 / Sq Ft
11/05/2021 11/05/21 Pending -- -- --
11/03/2021 11/03/21 Price Changed $974,500 -0.4% $299 / Sq Ft
10/22/2021 10/22/21 Price Changed $978,500 -0.1% $301 / Sq Ft
10/22/2021 10/22/21 For Sale $979,000 +36.0% $301 / Sq Ft
08/27/2020 08/27/20 Sold $720,000 +6.0% $223 / Sq Ft
08/03/2020 08/03/20 Pending -- -- --
07/30/2020 07/30/20 Price Changed $679,000 -2.9% $211 / Sq Ft
07/24/2020 07/24/20 For Sale $699,000 +34.4% $217 / Sq Ft
07/10/2018 07/10/18 Sold $520,000 -1.9% $160 / Sq Ft
06/11/2018 06/11/18 Pending -- -- --
05/07/2018 05/07/18 For Sale $529,900 +11.6% $163 / Sq Ft
03/02/2016 03/02/16 Sold $475,000 -0.9% $149 / Sq Ft
01/18/2016 01/18/16 Pending -- -- --
01/09/2016 01/09/16 For Sale $479,450 +18.4% $150 / Sq Ft
08/28/2014 08/28/14 Sold $405,000 -3.6% $126 / Sq Ft
07/10/2014 07/10/14 Pending -- -- --
06/12/2014 06/12/14 For Sale $420,000 +3.7% $131 / Sq Ft
06/03/2014 06/03/14 Off Market $405,000 -- --
04/18/2014 04/18/14 Price Changed $420,000 -3.4% $131 / Sq Ft
04/03/2014 04/03/14 Price Changed $435,000 -2.2% $135 / Sq Ft
03/27/2014 03/27/14 Price Changed $445,000 -3.2% $139 / Sq Ft
03/18/2014 03/18/14 For Sale $459,900 0.0% $143 / Sq Ft
04/01/2012 04/01/12 Rented $2,200 -15.4% --
03/08/2012 03/08/12 Under Contract -- -- --
02/21/2012 02/21/12 For Rent $2,600 -- --
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 $3,668 $43,121 -- --
2024 $4,073 $41,068 -- --
2023 $4,073 $64,330 $12,860 $51,470
2022 $3,933 $48,550 $9,710 $38,840
2021 $3,993 $46,470 $9,290 $37,180
2020 $3,866 $42,210 $8,440 $33,770
2019 $3,751 $37,900 $7,580 $30,320
2018 $3,605 $35,620 $7,120 $28,500
2017 $3,416 $34,300 $6,860 $27,440
2016 $3,361 $33,560 $6,710 $26,850
2015 $3,209 $32,000 $6,400 $25,600
Source: Public Records

Agents Affiliated with this Home

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

Map

Source: Arizona Regional Multiple Listing Service (ARMLS)

MLS Number: 6310851

Arizona Regional Multiple Listing Service (ARMLS)

APN: 304-67-240