AZ > Queen Creek > Terraranch At Queen Creek
Queen Creek, AZ 85142,23465 S 202ND Street
Queen Creek, AZ 85142,23465 S 202ND Street
Queen Creek, AZ 85142,23465 S 202ND Street
REQUEST A TOUR If you would like to see this home without being there in person, select the "Virtual Tour" option and your agent will contact you to discuss available opportunities.
In-PersonVirtual Tour
Thu
5
Jun
Fri
6
Jun
Sat
7
Jun
Molly Fredrick

Molly Fredrick

+1(602) 451-8464
$1,549,000
Est. payment /mo
6 Beds
4 Baths
4,353 SqFt
Save

UPDATED:

Key Details

Property Type Single Family Home

Sub Type Single Family Residence

Listing Status Active

Purchase Type For Sale

Square Footage 4,353 sqft

Price per Sqft $355

Subdivision Terraranch At Queen Creek

MLS Listing ID 6873236

Style Ranch

Bedrooms 6

HOA Y/N Yes

Year Built 2005

Annual Tax Amount $4,617

Tax Year 2024

Lot Size 0.423 Acres

Acres 0.42

Property Sub-Type Single Family Residence

Source Arizona Regional Multiple Listing Service (ARMLS)

Property Description

Welcome to this One of a Kind Luxury Estate. This stunning property features 6BD, 4 BA, 5 Car Garage on 3,467 SF custom home plus an additional 886 SF detached guest house with attached 2 car tandem garage. As you approach the home you are greeted by a paved circular driveway, accent lighting and impeccable landscaping. Extra large Custom Iron and Glass front doors let you know you've arrived. Pride of ownership surround this extra ordinary property. The interiors are flooded with natural light that dance off the hand textured and freshly painted walls. Details abound with Exposed Wood Beams, Travertine Flooring, Alder Doors along with Wood Shutters. The large Open-Concept Chef's Kitchen is perfect for entertaining as it is surrounded by a large bar with beautiful high grade granite. Gas Range, Large Stone Hood, Built in Refrigerator and Custom Cabinetry flows seamlessly into a spacious great room. 5 bedrooms in the main home plus an office allows for plenty of elbow room. As you enter the backyard you quickly realize you are entering your own Private Oasis. Two covered patios, refreshing pool with slide, hot tub, sport court, artificial turf and mature landscaping for privacy. The Outdoor kitchen which includes custom built Santa Maria style wood-burning grill, gas grill, sink and large bar is perfect for gatherings. Other details include a Large fire pit, travertine decking, misters and pool's water feature helps set the mood. As you walk by the Sport court you will find an outdoor water drinking fountain which is attached to the Large Guest home. Your guests or extended family will adore the private quarters, complete with its own living room, full size kitchen, walk-in closet/storage room, bathroom with oversized walk in shower, and a large bedroom that easily doubles as a home office or studio. This is also a nice rental opportunity as it has its own attached garage and separate entrance.

This is more than just a residence, it's an experience. A love letter to timeless design, superior craftsmanship and the luxury of truly intentional living. Come and see this beautiful home before it's gone.

Location

State AZ

County Maricopa

Community Terraranch At Queen Creek

Direction From AZ-202 Loop E take exit 41, Head SE onto S Santan Village Pkwy, Continue onto S Greenfield Rd, Turn left onto E Chandler Heights Rd, Turn left onto S 201st Way, Turn right onto S 202nd St.

Rooms

Other Rooms Great Room

Guest Accommodations 858.0

Master Bedroom Split

Den/Bedroom Plus 7

Separate Den/Office Y

Interior

Interior Features High Speed Internet, Granite Counters, Double Vanity, Eat-in Kitchen, Breakfast Bar, Vaulted Ceiling(s), Kitchen Island, Pantry, Full Bth Master Bdrm, Separate Shwr & Tub, Tub with Jets

Heating Natural Gas

Cooling Central Air, Ceiling Fan(s), Programmable Thmstat

Flooring Carpet, Stone, Tile

Fireplaces Type Fire Pit, 1 Fireplace, Living Room, Gas

Fireplace Yes

Window Features Dual Pane

SPA Private

Laundry Wshr/Dry HookUp Only

Exterior

Exterior Feature Private Yard, Sport Court(s), Built-in Barbecue, Separate Guest House

Parking Features Garage Door Opener, Direct Access, Circular Driveway

Garage Spaces 5.0

Garage Description 5.0

Fence Block, Wrought Iron

Pool Play Pool, Variable Speed Pump, Heated, Private

Community Features Biking/Walking Path

View Mountain(s)

Roof Type Tile

Porch Patio

Private Pool Yes

Building

Lot Description Desert Back, Desert Front, Synthetic Grass Frnt, Synthetic Grass Back

Story 1

Builder Name Custom

Sewer Sewer in & Cnctd

Water City Water

Architectural Style Ranch

Structure Type Private Yard,Sport Court(s),Built-in Barbecue, Separate Guest House

New Construction No

Schools

Elementary Schools Desert Mountain Elementary

Middle Schools Newell Barney College Preparatory School

High Schools Queen Creek High School

School District Queen Creek Unified District

Others

HOA Name Terra Ranch

HOA Fee Include Maintenance Grounds

Senior Community No

Tax ID 304-67-235

Ownership Fee Simple

Acceptable Financing Cash, Conventional

Horse Property N

Listing Terms Cash, Conventional

Read Less Info
Arizona Regional MLS (ARMLS)

Copyright 2025 Arizona Regional Multiple Listing Service, Inc. All rights reserved.

Listed by Realty ONE Group

Get More Information

agent

Molly Fredrick

+1(602) 451-8464

Agent | BRE#: 561239000

Agent BRE#: 561239000

Name

Phone*

Message

I agree by electronic signature to the Electronic Disclosure Consent; to receive recurring marketing communication from or on behalf of Molly Fredrick, including auto-dialed calls, texts, and artificial/prerecorded voice messages (consent not required to make a purchase; data rates may apply; reply “STOP” to opt-out of texts or ‘HELP” for help); and to the Terms of Service and Privacy Policy of this website. I understand that I can call to obtain direct assistance.
Quick Search