$24,888,888
Queen Creek, AZ 85142
MLS# 6675157
14 beds | 15 baths
1 / 32
Property Description
Experience the stately life where Gilbert, Mesa & Queen Creek intersect! Where every family's dream home becomes reality! This 5 acre guard gated equestrian compound under construction for 3 years, completed in Q3, can still be customized and made your own. Main House:8 Bedrooms,10 Bathrooms | Guest House:4 Bedrooms,3 Bathrooms | Guard House:2 Bedrooms,2 Bathrooms. Amenities Include: NBA Indoor Basketball Court, Rock Climbing Wall, Bowling Alley, Aerial Silks, Indoor Scuba Diving Pool & Spa, 2 Pickle Ball Courts, Fishing Lake, Rooftop Hot Tub, Theater, Arcade, 9 Hole Put-Put Golf Course, Wellness Center w/Cold Plunge, Infrared & Dry Sauna, Card room, Hidden Rooms, Hidden Passages, Indoor Tree House, Full Size Football Field, Tesla Solar Panels, Commercial Catering Kitchen,& 18 Garages!
Details
Maps
Contract Information
Status Change Date: 2024-03-22
List Price: $24,888,888
Status: Active
Current Price: $24,888,888
List Date: 2024-03-09
Type: ER
Ownership: Fee Simple
Co-Ownership (Fractional) Agreement YN: No
Subagents: N
Buyer/Broker: Y
Buyer Broker $/%: %
Comp to Buyer Broker: 3
Variable Commission: N
Location, Tax & Legal
House Number: 20401
Compass: E
Street Name: GERMANN
St Suffix: Road
City/Town Code: Queen Creek
State/Province: AZ
Zip Code: 85142
Zip4: 9751
Country: USA
County Code: Maricopa
Assessor's Map #: 62
Assessor's Parcel #: 27
Assessor Number: 304-62-027
Legal Description (Abbrev): LOT 8 ELLSWORTH SUBURBAN MINI-FARMS MCR 014411
Subdivision: ELLSWORTH SUBURBAN MINI-FARMS
Tax Municipality: Queen Creek
Taxes: 3405
Tax Year: 2023
General Property Description
Dwelling Type: Single Family - Detached
Dwelling Styles: Detached
Exterior Stories: 3
# of Interior Levels: 3
# Bedrooms: 14
# Bathrooms: 15
Approx SQFT: 30066
Price/SqFt: 827.81
Horses: Y
Builder Name: Luxury Living Homes
Year Built: 2024
Approx Lot SqFt: 218213
Approx Lot Acres: 5.009
Pool: Private Only
Elementary School: Jack Barnes Elementary School
Jr. High School: Queen Creek Middle School
High School: Queen Creek High School
Elementary School District: Queen Creek Unified District
High School District: Queen Creek Unified District
Remarks & Misc
Cross Street: Germann Rd & Ellsworth Rd
Directions: From Germann Rd & Ellsworth Rd, go West on Germann Rd, then South on 204th St to the property on the left.
Geo Lat: 33.275948
Geo Lon: -111.642623
Legal Info
Township: 2S
Range: 7E
Section: 9
Lot Number: 8
Association & Fees
HOA Y/N: N
PAD Fee Y/N: N
Land Lease Fee Y/N: N
Basement
Basement Y/N: N
Separate Den/Office
Sep Den/Office Y/N: Y
Parking Spaces
Garage Spaces: 18
Slab Parking Spaces: 40
Total Covered Spaces: 18
Solar Panels
Ownership: Owned Outright
Showing Notification Methods
Showing Service: Aligned Showings
Contact Info
List Agent Home Phn: 480-788-7556
List Agent Hme Phn 2: 480-788-7556
List Agent Cell Phn2: 480-788-7556
Property Features
Special Listing Cond: N/A
Architecture: Contemporary
Master Bathroom: Full Bth Master Bdrm; Separate Shwr & Tub; Double Sinks; Private Toilet Room; 2 Master Baths
Master Bedroom: Split
Additional Bedroom: Other Bedroom Split; Master Bedroom Walk-in Closet; Other Bedroom Walk-in Closet
Fireplace: 3+ Fireplace; Fireplace Family Rm; Fireplace Living Rm; Fireplace Master Bdr; Two Way Fireplace; Exterior Fireplace; Firepit
Flooring: Stone; Tile; Wood
Pool Features: Private; Diving Pool; Heated; Indoor
Spa: Private; Heated
Dining Area: Formal; Eat-in Kitchen; Breakfast Room
Kitchen Features: Range/Oven Gas; Cook Top Gas; Disposal; Dishwasher; Built-in Microwave; Refrigerator; Wall Oven(s); Multiple Ovens; Pantry; Walk-in Pantry; Kitchen Island
Laundry: Washer Included; Dryer Included; Inside
Other Rooms: Bonus/Game Room; Loft; Guest Qtrs-Sep Entrn; Exercise/Sauna Room; Media Room
Features: Wet Bar; Elevator
Exterior Features: Balcony; Built-in BBQ; Circular Drive; Covered Patio(s); Patio; Private Pickleball Court(s); Separate Guest House
Parking Features: Dir Entry frm Garage; Electric Door Opener; Extnded Lngth Garage; Over Height Garage; RV Garage; Tandem Garage
Construction: Frame - Wood
Const - Finish: Painted; Stucco
Construction Status: Under Construction
Roofing: Tile
Cooling: Refrigeration
Heating: Ceiling; Electric
Utilities: SRP
Water: City Water
Sewer: Septic Tank; Septic in & Cnctd
Fencing: Wrought Iron; Block
Property Description: Corner Lot; Mountain View(s); North/South Exposure
Landscaping: Grass Front; Grass Back; Flood Irrigation
Showing Notification Methods: Text; Email; Phone Call
Lockbox Type: None
Possession: By Agreement; Close of Escrow
Association Fee Incl: No Fees
Assoc Rules/Info: None
Existing 1st Loan: Conventional
New Financing: Cash; Conventional
Disclosures: Agency Discl Req
Listing Office: Realty ONE Group
Last Updated: April - 09 - 2024
Copyright 2024 Arizona Regional Multiple Listing Service, Inc. All rights reserved. Information Not Guaranteed and Must Be Confirmed by End User. Site contains live data.
Saturday 27th of April 2024 11:07 PM