31696 N MILDRED Road, Queen Creek, AZ 85144

$680,000
Property Type: Residential Bedrooms: 5 Baths: 3 Lot Size (sq. ft.): 152,460 Status: Closed
Current Price: $680,000 List Date: 8/16/2018 Last Modified: 1/13/2025

Overview

Description

MUST SEE!!! Absolutely GORGEOUS inside, 5,216 Sq Ft custom home with finished basement on 3.5 acres of horse property with mountain views, minutes from the San Tan Regional Park. PRICED $45K below appraisal. This home features a gourmet kitchen with SS appliances, large walk-in pantry, plethora of custom cabinets/granite counter tops. Italian made porcelain wood floors. There are 5 large bedrooms/3 bathrooms with travertine showers. The basement features a theater rm, large den/game rm with kitchenette and bonus rm for hobbies. This home was constructed to be energy efficient, it has spray foam insulation throughout and a 19 SEER energy efficient heating and cooling system. Oversized 3 car garage and 6 covered horse stalls with automatic waterers. Once in a life time opportunity!!! HURRY

Listing Details MLS# 5807945

Location, Tax & Legal

Map Code/Grid
W42
House Number
31696
Compass
N
Street Name
MILDRED
St Suffix
Road
City/Town Code
Queen Creek
State/Province
AZ
Zip Code
85144
Zip4
9496
Country
US
County Code
Pinal
Assessor Number
509-15-060
Subdivision
SANTAN RANCHES UNIT 5
Tax Year
2017

Contract Information

Type
Exclusive Right To Sell
Ownership
Fee Simple

General Property Description

Dwelling Type
Single Family Residence
Dwelling Styles
Detached
Exterior Stories
Yes
# of Interior Levels
Yes
# Bedrooms
5
Total Bathrooms
3
Approx SQFT
5216
Price/SqFt
130.37
Horses
Y
Builder Name
Custom
Year Built
2014
Approx Lot SqFt
152460
Community Pool Y/N
No
Private Pool Y/N
No
Fireplace YN
No
Elementary School District
Coolidge Unified District
High School District
Coolidge Unified District
Elementary School
San Tan Heights Elementary
Jr. High School
Mountain Vista School
High School
San Tan Foothills High School

Remarks Misc

Cross Street
Hunt Highway and Thompson Road
Directions
From Hunt Highway go to Thompson Rd, take Thompson Rd south to stop sign at Phillips Rd. Turn left on Phillips Rd to Mildred Rd. Turn right on Mildred Rd, house is the 3rd house on right

Status Change Info

Off Market Date
2018-10-12
Under Contract Date
2018-10-11
Close of Escrow Date
2018-10-22

Legal Info

Township
03S
Range
07E
Section
14
Lot Number
18

More Information

Basement

Basement Y/N
Y

Parking Spaces

Garage Spaces
3
Total Covered Spaces
3

Cooling

HVAC SEER Rating
19

Contact Info

List Agent Home Phn
623-249-9380

Sold Info

Loan Type
Cash
Payment Type
Other
Closing Cost Split
Normal - N
Buyer Concession $/%
%
Seller Concession $/%
%

Property Features

Special Listing Cond: N/A Add'l Property Use: Farm; Ranch; Res/Business Use Ok Architecture: Ranch View: Mountain(s) Master Bathroom: Full Bth Master Bdrm; Separate Shwr & Tub; Double Vanity; Private Toilet Room Master Bedroom: Upstairs Additional Bedroom: Other Bedroom Downstairs; Master Bedroom Walk-in Closet; Other Bedroom Walk-in Closet Flooring: Carpet; Stone; Tile Window Features: Solar Screens; Dual Pane; ENERGY STAR Qualified Windows; Low-Emissivity Windows; Vinyl Frame Spa: None Community Features: Horse Facility Dining Area: Formal; Eat-in Kitchen; Breakfast Bar Kitchen Features: Gas Cooktop; Disposal; Built-in Microwave; Refrigerator; Engy Star (See Rmks); Reverse Osmosis; Wall Oven(s); Walk-in Pantry; Granite Counters; Kitchen Island Laundry: Washer Hookup; 220 V Dryer Hookup; Inside Basement Description: Finished; Full Other Rooms: Family Room; Bonus/Game Room; Media Room Interior Features: 9+ Flat Ceilings; Water Softener Owned; Soft Water Loop; Water Purifier Technology: 3+ Exist Tele Lines; Pre-Wire Srnd Snd; Pre-Wire Sat Dish; Cable TV Avail; High Speed Internet; Ntwrk Wrng Multi Rms Exterior Features: Covered Patio(s); Patio Parking Features: Direct Access; Extended Length Garage; Garage Door Opener; Over Height Garage; RV Access/Parking Construction: Wood Frame; Spray Foam Insulation Const - Finish: Painted; Stucco; Stone Roofing: Composition Cooling: Central Air; Ceiling Fan(s); Programmable Thmstat Heating: Natural Gas Plumbing: Tankless Ht Wtr Heat; Engy Star Ht Wtr Htr; Propane Hot Wtr Htr Utilities: SRP; Propane Water Source: Private Well Sewer: Septic Tank Services: County Services Fencing: Wire; See Remarks Landscaping: Gravel/Stone Front; Gravel/Stone Back Horse Features: Corral(s); Stall; Arena; Auto Water Possession: Close of Escrow Association Fee Incl: No Fees Existing 1st Loan: Conventional Existing 1st Loan Terms: Non Assumable New Financing: Cash; VA; Conventional Disclosures: Seller Discl Avail; Agency Discl Req
IDX
Listing Office: HomeSmart
Office Phone: 602-230-7600
Office Email: rlarue@hsmove.com
Last Updated: January - 13 - 2025
Copyright 2026 Arizona Regional Multiple Listing Service, Inc. All rights reserved. Information Not Guaranteed and Must Be Confirmed by End User. Site contains live data.

Connect With Our Financial Experts

Let's have a chat