Property Attributes
- MLS#6675157
- TypeSingle Family
- CountyMARICOPA
- CityQueen Creek
- NeighborhoodELLSWORTH SUBURBAN MINI-FARMS
- Zip85142
- StyleContemporary
- Year Built2024
- Taxes$ 3405
- Price$ 24,888,888
- Bedrooms14
- Full Bathrooms15
- Half Bathrooms0
- Sqr Footage30066
- Lot Size5.01 Acres
Data Source:
Arizona Regional MLS (ARMLSN)
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!
Elementary School | Middle School | High School |
---|---|---|
Jack Barnes Elementary School | Queen Creek Middle School | Queen Creek High School |
Price History | |
---|---|
3/22/2024 | Listed $24,888,888 |
General Features
Interior Features | Eat-in Kitchen,Elevator,Wet Bar,Kitchen Island,Pantry,2 Master Baths,Double Vanity,Full Bth Master Bdrm,Separate Shwr & Tub |
---|---|
Sewer | Septic in & Cnctd,Septic Tank |
Heating | Electric,Ceiling |
Cooling | Refrigeration |
Utilities | SRP |
Possession | By Agreement,Close Of Escrow |
Roof | Tile |
Exterior Features | Private Pickleball Court(s),Balcony,Circular Drive,Covered Patio(s),Patio,Built-in Barbecue |
Garage Spaces | 18.0 |
Association Fee Includes | No Fees |
Architectural Style | Contemporary |
Pool Features | Diving Pool,Heated,Private,Indoor |
Construction Materials | Painted,Stucco,Frame - Wood |
Year Built | 2024 |
View | Mountain(s) |
Township | 2S |
Property SubType | Single Family - Detached |
Tax Year | 2023 |
Percent Ownership | Fee Simple |
County | Maricopa |
New Construction | No |
Property Type | Residential |
Association Amenities | None |
HOA / Comm Assn | No |
Attached Garage | No |
Subdivision Name | ELLSWORTH SUBURBAN MINI-FARMS |
Other Structures | Guest House |
Special Listing Conditions | N/A |
Status | Active |
Directions | From Germann Rd & Ellsworth Rd,go West on Germann Rd,then South on 204th St to the property on the left. |
High School | Queen Creek High School |
City | Queen Creek |
Buyer Agent Compensation | 3.00 |
Disclosures | Agency Discl Req |
View Y/N | Yes |
High School District | Queen Creek Unified District |
Open Parking Spaces | 40.0 |
Lot Size Square Feet | 218213.0 |
Waterfront Y/N | No |
Carport Spaces | 0.0 |
Carport Y/N | No |
Street Name | GERMANN |
Spa Features | Heated,Private |
Elementary School | Jack Barnes Elementary School |
Property Attached Y/N | No |
Land Lease Y/N | No |
Tax Annual Amount | 3405.0 |
Home Warranty Y/N | No |
Current Financing | Conventional |
Middle/Junior High School | Queen Creek Middle School |
Property Condition | Under Construction |
Lease Renewal Y/N | No |
Lease Considered Y/N | No |
Rent Control Y/N | No |
Days on Market | 57 |
Builder Name | Luxury Living Homes |
Standard Status | Active |
Occupancy Type | Interim Occupant |
Elementary School District | Queen Creek Unified District |
Tax Lot | 8 |
MobileHomeRemainsYN | No |
Buyer Agent Compensation Type | % |
New_sp_Financing_co_Conventional5 | True |
Other_sp_Rooms_co_ExerciseSauna_sp_Room | True |
Senior Community | No |
Ttl Monthly Fee Equiv | 0.0 |
Interior Features
Flooring | Stone,Tile,Wood |
---|---|
Fireplace Features | 3+ Fireplace,Two Way Fireplace,Exterior Fireplace,Fire Pit,Family Room,Living Room,Master Bedroom |
Total Stories | 3 |
Fireplace Y/N | Yes |
Street Suffix | Road |
Total Bedrooms | 14 |
Electric On Property Y/N | No |
LivingAreaSource | Architect |
Total Baths | 15 |
Bedrooms Possible | 17 |
Other_sp_Rooms_co_Guest_sp_Qtrs_hyphen_Sep_sp_Entrn | True |
Other_sp_Rooms_co_BonusGame_sp_Room | True |
Other_sp_Rooms_co_Loft | True |
Other_sp_Rooms_co_Media_sp_Room | True |
Built-in Microwave | True |
Cook Top Gas | True |
Kitchen Island | True |
Multiple Ovens | True |
Pantry | True |
Range/Oven Gas | True |
Walk-in Pantry | True |
Wall Oven(s) | True |
Exterior Features
Fencing | Block,Wrought Iron |
---|---|
Parking Features | Dir Entry frm Garage,Electric Door Opener,Extnded Lngth Garage,Over Height Garage,Tandem,RV Garage |
Lot Features | Corner Lot,Grass Front,Grass Back,Flood Irrigation |
Water Source | City Water |
Lot Size Area | 218213.0 |
Spa | Yes |
Lot Size Acres | 5.01 |
Lot Size Units | Square Feet |
Lot Size Source | Assessor |
Covered Spaces | 18.0 |
Crops Included Y/N | No |
Open Parking Y/N | No |
Horse Y/N | Yes |
Irrigation Water Rights Y/N | No |
Amenities
- Foreclosure
- Views
- Short Sale
- New Construction
- Adult 55+
- Lease To Own
- No HOA Fees
- Furnished
- Primary On Main
- Air Conditioning
- Seller Finance
- Green
- Fixer Upper
- Horse
- Golf
- Fireplace
- Deck
- Garage
- Basement
- Pool