23415 S 202nd Street
Queen Creek, AZ 85142
- 5 beds
- 5 baths
- 4,036 sqft
- ~1/2 acre lot
- $297 per sqft
- 2006 build
- – on site
More homes
Stunning home with Resort-Style Amenities! Welcome to your dream home, a true masterpiece that seamlessly blends classic architectural tones with modern luxury. As you approach this exquisite residence, the high-pitched roofs and charming façade will captivate your senses, inviting you to explore the remarkable details within. As you enter you will be greeted by soaring ceilings adorned with intricate coffered and tray-lit designs that reach heights of 12' and 16'. The Groin Arch adds an architectural flourish that sets this home apart from the rest. With multiple living areas including a spacious living room, a cozy family room featuring a stunning gas fireplace, and a versatile loft complete with its own half bathroom, this layout is perfect for both relaxation and entertaining. This stately abode boasts five generously sized bedrooms alongside three full bathrooms and two convenient half bathrooms, providing ample space for you and guests alike. Nestled on nearly half an acre of picturesque grounds, the scenic surroundings enhance the tranquility of this enchanting property. Emphasizing sustainability without compromising comfort, this home features energy-efficient elements such as extra insulation and robust 2x6 construction. Enjoy peace of mind knowing that your new sanctuary is both environmentally friendly and designed for modern living. Venture outside into your private paradisea resort-style backyard that promises endless enjoyment. Dive into the illuminated pool with waterfall feature or relax under the commercial grade misting system fed by soft water, perfect for those warm summer days. This outdoor oasis is ideal for hosting gatherings or simply unwinding in serene solitude. Additional conveniences include a central vacuum system, state-of-the-art alarm system, and remote-controlled sunscreen shades, all thoughtfully integrated to enhance your lifestyle without sacrificing elegance. The expansive 4½ car garage provides not only practical storage solutions but also ample space for recreational toys, ensuring you have everything you need at your fingertips. This exceptional home is truly perfect for anyone who appreciates craftsmanship paired with unique features. Don't miss out on the opportunity to make it yours! **Schedule your private tour today! Experience firsthand the beauty and sophistication this remarkable property has to offer. Your future awaits!**
Last checked:
As a licensed real estate brokerage, Estately has access to the same database professional Realtors use: the Multiple Listing Service (or MLS). That means we can display all the properties listed by other member brokerages of the local Association of Realtors—unless the seller has requested that the listing not be published or marketed online.
The MLS is widely considered to be the most authoritative, up-to-date, accurate, and complete source of real estate for-sale in the USA.
Estately updates this data as quickly as possible and shares as much information with our users as allowed by local rules. Estately can also email you updates when new homes come on the market that match your search, change price, or go under contract.
Checking…
•
Last updated Apr 29, 2025
•
MLS# 6824514 —
The Building
-
Year Built:2006
-
New Construction:No
-
Construction Materials:Stucco, Wood Frame, Painted, Stone
-
Builder Name:Na
-
Roof:Tile, Concrete
-
Stories Total:1
-
Basement:false
-
Basement:No
-
Exterior Features:Misting System, Private Yard
-
Window Features:Solar Screens
-
Security Features:Security System Owned
-
Direction Faces:None
-
Patio And Porch Features:Covered Patio(s), Patio
Interior
-
Interior Features:Eat-in Kitchen, Breakfast Bar, 9+ Flat Ceilings, Central Vacuum, Kitchen Island, Pantry, Double Vanity, Full Bth Master Bdrm, Separate Shwr & Tub, High Speed Internet, Granite Counters
-
Furnished:None
-
Flooring:Carpet, Tile
-
Fireplaces Total:None
-
Fireplace:true
-
Fireplace Features:Living Room, Gas
Room Dimensions
-
Living Area:4036.0
-
Living Area Units:None
-
Living Area Source:Appraiser
Financial & Terms
-
Possession:By Agreement, Close Of Escrow
Location
-
Latitude:33.236217
-
Longitude:-111.647771
-
Cross Street:East of Hawes Rd, North of E Chandler Heights Rd
The Property
-
Property Type:Residential
-
Property Subtype:Single Family Residence
-
Possible Use:None
-
Parcel Number:304-67-223
-
Lot Features:Sprinklers In Rear, Sprinklers In Front, Grass Front, Grass Back
-
Lot Size Area:18421.0
-
Lot Size Acres:0.42
-
Lot Size SqFt:18,421 Sqft
-
Lot Size Dimensions:None
-
Lot Size Units:Square Feet
-
Lot Size Source:Assessor
-
Land Lease:false
-
Fencing:Block, Wrought Iron
-
Horse:false
Listing Agent
- Contact info:
- Agent phone:
- (313) 209-8085
- Office phone:
- (800) 980-5022
Taxes
-
Tax Year:2024
-
Tax Annual Amount:4110.0
-
Tax Lot:22
-
Tax Map Number:67.00
-
Tax Book Number:304.00
-
Tax Legal Description:LOT 22 TERRARANCH AT QUEEN CREEK MCR 055440
Beds
-
Bedrooms Total:5
Baths
-
Total Baths:5.0
-
Total Baths:5
-
Full Baths:None
-
Half Baths:None
-
Partial Baths:None
-
Three Quarter Baths:None
-
Quarter Baths:None
The Listing
Heating & Cooling
-
Heating:Electric
-
Heating:true
-
Cooling:Central Air, Ceiling Fan(s)
-
Cooling:true
-
Central Air:true
Utilities
-
Sewer:Public Sewer
-
Water Source:City Water
Appliances
-
Gas Range:true
-
Water Purifier:true
-
Appliances:Water Purifier
Schools
-
Elementary School:Desert Mountain Elementary
-
Elementary School District:Queen Creek Unified District
-
Middle Or Junior School:Newell Barney College Preparatory School
-
High School:Crismon High School
-
High School District:Queen Creek Unified District
The Community
-
Subdivision Name:TERRARANCH AT QUEEN CREEK
-
Senior Community:No
-
Community Features:Playground, Biking/Walking Path
-
Association:true
-
Association Amenities:Management
-
Association Fee:$977.32
-
Association Fee Frequency:Annually
-
Association Fee Includes:Maintenance Grounds
-
Pool Private:true
-
Pool Features:Diving Pool, Fenced, Heated, Private
-
Spa Private:true
-
Spa Heated:true
-
Spa Features:Heated, Private
-
Pets Allowed:None
Parking
-
Parking Total:None
-
Garage:No
-
Garage Spaces:4.5
-
Covered Spaces:4.5
-
Parking Features:RV Gate, Garage Door Opener, Extended Length Garage, Direct Access, Over Height Garage, Separate Strge Area, RV Access/Parking
-
Open Parking Spaces:4.0
-
Garage Door Opener:true
Walk Score®
Provided by WalkScore® Inc.
Walk Score is the most well-known measure of walkability for any address. It is based on the distance to a variety of nearby services and pedestrian friendliness. Walk Scores range from 0 (Car-Dependent) to 100 (Walker’s Paradise).
Bike Score®
Provided by WalkScore® Inc.
Bike Score evaluates a location's bikeability. It is calculated by measuring bike infrastructure, hills, destinations and road connectivity, and the number of bike commuters. Bike Scores range from 0 (Somewhat Bikeable) to 100 (Biker’s Paradise).
Soundscore™
Provided by HowLoud
Soundscore is an overall score that accounts for traffic, airport activity, and local sources. A Soundscore rating is a number between 50 (very loud) and 100 (very quiet).
Air Pollution Index
Provided by ClearlyEnergy
The air pollution index is calculated by county or urban area using the past three years data. The index ranks the county or urban area on a scale of 0 (best) - 100 (worst) across the United Sates.
Sale history
Date | Event | Source | Price | % Change |
---|---|---|---|---|
4/28/25
Apr 28, 2025
|
Pending | ARMLS | $1,200,000 | |
4/28/25
Apr 28, 2025
|
Sold | ARMLS | $1,200,000 | -4.0% |
3/12/25
Mar 12, 2025
|
Sold Subject To Contingencies | ARMLS | $1,250,000 |