Seller's Agent in 2026
Josiah Miller
West USA Realty
(480) 290-3239
54 Total Sales
Estimated Value: $1,161,000 - $1,278,733
Tucked away on a quiet cul-de-sac in the heart of the Orchards, this extraordinary modern farmhouse blends architectural beauty with thoughtful functionality and rustic elegance. Set on a sprawling 35,282 square foot irrigated equestrian lot, this custom-designed basement home invites you into a lifestyle where luxury meets tranquility. With over 20 mature citrus and fruit trees, the grounds are alive with natural beauty, and the expansive outdoor pavilion encourages year-round entertaining with its steel cantilever patio cover, lush landscaping, and spa-ready setup, complete with an outdoor shower. Graceful, sweeping lines of steel, glass, and wood create a seamless indoor-outdoor connection. Multiple walls of windows open to the lush backyard, where a large covered patio, spa, custom fencing, raised gardens, and a 20'x30' shade canopy extend the home's livable space. The resort-style pool is a true showstopper, offering a perfect blend of luxury and fun. A stunning grotto waterfall creates a serene, tropical ambiance, while the hidden waterslide behind it adds an element of excitement for all ages. The pool also features a luxurious swim-up bar, allowing guests to enjoy refreshing drinks and snacks without ever leaving the water. Adjacent to the pool is a sunken, covered outdoor kitchen, an entertainer's dream. Outfitted with a high-end grill and ample counter space, this area is designed for outdoor cooking and gatherings. Bar stools line the counter, providing casual seating for guests to relax and mingle while staying connected to the poolside fun. Surrounded by lush landscaping and expansive deck space, this backyard is the epitome of resort-style living, offering year-round enjoyment under the Arizona sun. The gourmet kitchen is a true showpiece remodeled in 2016 with custom concrete countertops, floating wood and steel shelving, Wolf appliances, and a pass-through steel window bar. Entertain guests in the adjacent dining and family rooms where hand-laid adobe brick, a steel I-beam mantel, and custom lighting deliver warm ambiance and bold character. Designed with flexibility and comfort in mind, the 5-bedroom, 5-bath floor plan includes a fully finished basement with a second family/game room, two large bedrooms with walk-in closets, a spa-like bathroom, and a potential second laundry. The primary suite is a retreat of its own, featuring romantic elements like a brick accent wall, crystal chandelier over a clawfoot tub, authentic barn wood, dual shower heads, and large walk-in closet with a built-in safe. Car enthusiasts, hobbyists, or remote workers will fall in love with the 57'x22' air-conditioned RV garage, featuring a 16'x14' WIFI-operated door, a steel floating staircase to a loft game room with additional storage, and a private office with frameless glass windows and its own bath. A separate 3-car garage and covered carport complete the motor court, all secured by a custom steel gate. This home is a rare fusion of form and function, where every upgrade, from the all-steel framing and spray foam insulation to the EcoBee thermostats, central vacuum system, and 20 SEER RV garage A/C, was selected with intention. Located minutes from the Town of Queen Creek's schools, shopping, and entertainment, and offering stunning San Tan Mountain views, this one-of-a-kind home brings modern luxury to a rural oasis. Adventure, serenity, and craftsmanship converge here, your dream lifestyle starts now!
Last Agent to Sell the Property
West USA Realty License #SA707699000 Listed on: 05/24/2025
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
| Date | Buyer | Sale Price | Title Company |
|---|---|---|---|
| $1,170,000 | Great American Title Agency | ||
| -- | Grand Canyon Title | ||
| $995,000 | Grand Canyon Title | ||
| -- | None Available | ||
| -- | Transnation Title Ins Co | ||
| -- | Lawyers Title Of Arizona Inc | ||
| $241,050 | Lawyers Title Of Arizona Inc |
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
| Date | Status | Borrower | Loan Amount |
|---|---|---|---|
| Open | $300,000 | ||
| Closed | $245,000 | ||
| Previous Owner | $150,000 | ||
| Previous Owner | $80,775 | ||
| Previous Owner | $276,000 | ||
| Previous Owner | $65,000 | ||
| Previous Owner | $307,500 | ||
| Previous Owner | $20,500 |
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
| Date | Event | Price | List to Sale | Price per Sq Ft | Prior Sale |
|---|---|---|---|---|---|
| 02/13/2026 02/13/26 | Sold | $1,170,000 | -6.4% | $305 / Sq Ft | |
| 01/07/2026 01/07/26 | Pending | -- | -- | -- | |
| 01/02/2026 01/02/26 | Off Market | $1,250,000 | -- | -- | |
| 12/31/2025 12/31/25 | For Sale | $1,250,000 | 0.0% | $326 / Sq Ft | |
| 11/12/2025 11/12/25 | Price Changed | $1,250,000 | -3.8% | $326 / Sq Ft | |
| 10/04/2025 10/04/25 | Price Changed | $1,299,000 | -3.8% | $339 / Sq Ft | |
| 09/06/2025 09/06/25 | Price Changed | $1,350,000 | -3.6% | $352 / Sq Ft | |
| 06/03/2025 06/03/25 | Price Changed | $1,400,000 | -6.7% | $365 / Sq Ft | |
| 05/24/2025 05/24/25 | For Sale | $1,500,000 | +28.2% | $391 / Sq Ft | |
| 05/24/2025 05/24/25 | Off Market | $1,170,000 | -- | -- | |
| 11/20/2020 11/20/20 | Sold | $995,000 | 0.0% | $237 / Sq Ft | View Prior Sale |
| 10/16/2020 10/16/20 | Pending | -- | -- | -- | |
| 09/22/2020 09/22/20 | For Sale | $995,000 | -- | $237 / Sq Ft |
We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.
| 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,137 | $50,929 | ||
| 2024 | $4,918 | $48,504 | ||
| 2023 | $4,918 | $78,110 | $15,620 | $62,490 |
| 2022 | $4,752 | $59,880 | $11,970 | $47,910 |
| 2021 | $4,816 | $55,380 | $11,070 | $44,310 |
| 2020 | $5,258 | $46,260 | $9,250 | $37,010 |
| 2019 | $6,811 | $43,900 | $8,780 | $35,120 |
| 2018 | $7,023 | $40,410 | $8,080 | $32,330 |
| 2017 | $5,883 | $38,770 | $7,750 | $31,020 |
| 2016 | $5,445 | $38,730 | $7,740 | $30,990 |
| 2015 | $4,565 | $38,320 | $7,660 | $30,660 |
Seller's Agent in 2026
Josiah Miller
West USA Realty
(480) 290-3239
54 Total Sales
Buyer's Agent in 2026
Karsten Colin
Real Broker
(602) 908-0635
159 Total Sales
S
Buyer Co-Listing Agent in 2026
Sydney Colin
Real Broker
(480) 747-0161
18 Total Sales
Seller's Agent in 2020
Frank C. Merlo III
SERHANT.
(480) 888-6133
136 Total Sales
Seller Co-Listing Agent in 2020
Deborah 'Debbie' Sapp
SERHANT.
(480) 797-6650
120 Total Sales
Buyer's Agent in 2020
Shannon Aspeslagh
Inteam Realty, LLC
(623) 466-2121
51 Total Sales
Source: Arizona Regional Multiple Listing Service (ARMLS)
MLS Number: 6864808
APN: 304-91-208
Ask me questions while you tour the home.