15418 E STARDUST Drive, Fountain Hills, AZ 85268

New Listing
$2,895,000
Property Type: Residential Bedrooms: 5 Baths: 4 Square Footage: 5,144 Lot Size (sq. ft.): 44,465 Status: Active
Current Price: $2,895,000 List Date: 10/02/2026 Last Modified: 10/02/2026

Overview

Description

Resort style luxury w/ 9.5 car garage (lift's required, without lift's holds 5.5 cars), 1+ acre premium view lot on canyon, room for tennis court/guest house. Tropical resort backyard & REAL boulder beach entry pebble tech pool, grotto waterfall, tunnel water slide thru boulders, hot tub. Insane $60K theater w/ the best audio visual components! SECRET ROOM w/ invisible door. Incredible primary bedroom w/ his/her huge walk in closet's, his/her big walk in shower. 2 Sub Zero's, dual dishwasher, loaded bar w 100 bottle wine fridge, icemaker, beer fridge. $200K throughout in matching cab's & 3 desk built in's, big walk in closets w/ built in's in EVERY bedroom, huge RV area. $316K in 2026 upgrades. In prestigious STONERIDGE. Previous owner president of Porsche USA kept 8 sport car's in garage.

Listing Details MLS# 7076117

Location, Tax & Legal

House Number
15418
Compass
E
Street Name
STARDUST
St Suffix
Drive
City/Town Code
Fountain Hills
State/Province
AZ
Zip Code
85268
Zip4
3301
Country
US
County Code
Maricopa
Assessor Number
176-15-184
Subdivision
FOUNTAIN HILLS PLAT 606-A
Tax Year
2025
Assessor's Map #
15
Legal Description (Abbrev)
LOT 52 FOUNTAIN HILLS PLAT 606-A MCR 042850
Assessor's Parcel #
184
Tax Municipality
Fountain Hills
Taxes
5362

Contract Information

Type
Exclusive Right To Sell
Ownership
Fee Simple
Co-Ownership (Fractional) Agreement YN
No

General Property Description

Dwelling Type
Single Family Residence
Dwelling Styles
Detached
Exterior Stories
2
# of Interior Levels
2
# Bedrooms
5
Full Bathrooms
4
Total Bathrooms
4
Approx SQFT
5144
Price/SqFt
562.79
Horses
N
Builder Name
Stoneridge Custom Homes
Year Built
2004
Approx Lot SqFt
44465
Approx Lot Acres
1.021
Community Pool Y/N
No
Private Pool Y/N
Yes
Fireplace YN
Yes
Fireplaces Total
Yes
Elementary School District
Fountain Hills Unified District
High School District
Fountain Hills Unified District
Elementary School
McDowell Mountain Elementary School
Jr. High School
Fountain Hills Middle School
High School
Fountain Hills High School
Half Bathrooms
0

Remarks Misc

Cross Street
Palisades Blvd & Sunburst Dr
Directions
From Palisades Blvd, turn onto Sunburst Dr, then left on Greystone Dr. Continue to Stardust Dr. Property is located on the corner of Stardust Dr & Greystone Dr.

Legal Info

Township
3N
Range
6E
Section
16
Lot Number
52

Basement

Basement Y/N
N

More Information

Parking Spaces

Garage Spaces
8
Slab Parking Spaces
6
Total Covered Spaces
8

Showing Notification Methods

Showing Service
Aligned Showings

DPR Eligible

DPR Eligible
No

Special Listing Cond

N/A
Yes

Construction

Wood Frame
Yes

Const - Finish

Painted
Yes
Stucco
Yes

Roofing

Foam
Yes

Association & Fees

HOA Y/N
Y
HOA Disclosure/Addendum Affirmation
No
HOA Transfer Fee
0
HOA Fee
315
HOA Paid Frequency
Annually
HOA Name
Ogden
HOA Telephone
480-641-6300
Special Assessment HOA
No
HOA 2 Y/N
N
PAD Fee Y/N
N
Cap Improvement/Impact Fee
0
Cap Improvement/Impact Fee $/%
$
Prepaid Association Fees HOA
315
Disclosure Fees HOA
400
Other Fees HOA
0
Land Lease Fee Y/N
N
Rec Center Fee Y/N
N
Ttl Mthly Fee Equiv
26.25

Lockbox Type

See Private Remarks
Yes

Master Bathroom

Full Bth Master Bdrm
Yes
Separate Shwr & Tub
Yes
Double Vanity
Yes
Private Toilet Room
Yes
Tub with Jets
Yes
Bidet
Yes

Master Bedroom

Split
Yes
Downstairs
Yes

Additional Bedroom

Other Bedroom Split
Yes
Other Bedroom Downstairs
Yes
Separate Bedroom Exit
Yes
Master Bedroom Walk-in Closet
Yes
Other Bedroom Walk-in Closet
Yes
Master Bedroom Sitting Room
Yes

Fireplace Features

Fireplace Family Rm
Yes
Fireplace Living Rm
Yes
Gas Fireplace
Yes
See Remarks
Yes

Window Features

Dual Pane
Yes

Private Pool Features

Outdoor
Yes
Diving Pool
Yes
Variable Speed Pump
Yes

Dining Area

Formal
Yes
Eat-in Kitchen
Yes
Breakfast Bar
Yes
Dining in LR/GR
Yes

Heating

Natural Gas
Yes

View

City
Yes
Creek/Stream
Yes
Panoramic
Yes
Red Rocks/Boulders
Yes
City Lights
Yes
Mountain(s)
Yes

Kitchen Features

220 Volts in Kitchen
Yes
Built-In Gas Oven
Yes
Dishwasher
Yes
Disposal
Yes
Kitchen Island
Yes
Built-in Microwave
Yes
Multiple Ovens
Yes
Pantry
Yes
Refrigerator
Yes
Reverse Osmosis
Yes
Walk-in Pantry
Yes
Induction Cooktop
Yes
Gas Cooktop
Yes
Granite Counters
Yes

Cooling

Ceiling Fan(s)
Yes
Programmable Thmstat
Yes
Central Air
Yes

Interior Features

9+ Flat Ceilings
Yes
Wet Bar
Yes
Water Softener Owned
Yes
Water Purifier
Yes
Furnished(See Rmrks)
Yes

Laundry

Washer Included
Yes
Dryer Included
Yes
220 V Dryer Hookup
Yes
Inside
Yes

Other Rooms

Family Room
Yes
Great Room
Yes
Library-Blt-in Bkcse
Yes
Bonus/Game Room
Yes
Media Room
Yes

Separate Den/Office

Sep Den/Office Y/N
Y

Road Access Type

City Street
Yes

Road Surface Type

Asphalt
Yes

Road Responsibility

City Maintained Road
Yes

Fencing

Block
Yes

Water Source

Pvt Water Company
Yes

Exterior Features

Balcony
Yes
Built-in BBQ
Yes
Covered Deck
Yes
Covered Patio(s)
Yes
Patio
Yes
Rain Gutters
Yes

Spa

Private
Yes

Sewer

Sewer - Public
Yes
Sewer-In & Connected
Yes

Parking Features

Over Height Garage
Yes
RV Gate
Yes
Separate Strge Area
Yes
Attached Garage
Yes
Extended Length Garage
Yes
Garage Door Opener
Yes
Off Street
Yes
RV Access/Parking
Yes

New Financing

Cash
Yes
Conventional
Yes
Owner May Carry
Yes

Utilities

SRP
Yes
SW Gas
Yes

Existing 1st Loan

Treat as Free&Clear
Yes

Property Description

Hillside Lot
Yes
Corner Lot
Yes
North/South Exposure
Yes

Landscaping

Desert Front
Yes
Desert Back
Yes
Yrd Wtring Sys Front
Yes
Yrd Wtring Sys Back
Yes
Auto Timer H2O Front
Yes
Auto Timer H2O Back
Yes

Disclosures

None
Yes

Possession

Close of Escrow
Yes

Association Fee Incl

Common Area Maint
Yes

Assoc Rules/Info

Pets OK (See Rmrks)
Yes
Prof Managed
Yes

Property Features

Special Listing Cond: N/A View: Creek/Stream; Panoramic; Red Rocks/Boulders; City Lights; Mountain(s) Master Bathroom: Full Bth Master Bdrm; Separate Shwr & Tub; Double Vanity; Private Toilet Room; Tub with Jets; Bidet Master Bedroom: Split; Downstairs Additional Bedroom: Other Bedroom Split; Other Bedroom Downstairs; Separate Bedroom Exit; Master Bedroom Walk-in Closet; Other Bedroom Walk-in Closet; Master Bedroom Sitting Room Fireplace Features: Fireplace Family Rm; Fireplace Living Rm; Gas Fireplace; See Remarks Window Features: Dual Pane Private Pool Features: Outdoor; Diving Pool; Variable Speed Pump Spa: Private Dining Area: Formal; Eat-in Kitchen; Breakfast Bar; Dining in LR/GR Kitchen Features: Built-In Gas Oven; 220 Volts in Kitchen; Induction Cooktop; Gas Cooktop; Disposal; Dishwasher; Built-in Microwave; Refrigerator; Reverse Osmosis; Multiple Ovens; Pantry; Walk-in Pantry; Granite Counters; Kitchen Island Laundry: Washer Included; Dryer Included; 220 V Dryer Hookup; Inside Other Rooms: Family Room; Great Room; Library-Blt-in Bkcse; Bonus/Game Room; Media Room Interior Features: 9+ Flat Ceilings; Wet Bar; Water Softener Owned; Water Purifier; Furnished(See Rmrks) Exterior Features: Balcony; Built-in BBQ; Covered Deck; Covered Patio(s); Patio; Rain Gutters Parking Features: Attached Garage; Extended Length Garage; Garage Door Opener; Off Street; Over Height Garage; RV Access/Parking; RV Gate; Separate Strge Area Road Access Type: City Street Road Surface Type: Asphalt Road Responsibility: City Maintained Road Construction: Wood Frame Const - Finish: Painted; Stucco Roofing: Foam Cooling: Central Air; Ceiling Fan(s); Programmable Thmstat Heating: Natural Gas Utilities: SRP; SW Gas Water Source: Pvt Water Company Sewer: Sewer - Public; Sewer-In & Connected Fencing: Block Property Description: Hillside Lot; Corner Lot; North/South Exposure Landscaping: Desert Front; Desert Back; Yrd Wtring Sys Front; Yrd Wtring Sys Back; Auto Timer H2O Front; Auto Timer H2O Back Lockbox Type: See Private Remarks Possession: Close of Escrow Association Fee Incl: Common Area Maint Existing 1st Loan: Treat as Free&Clear New Financing: Cash; Conventional; Owner May Carry Disclosures: None
IDX
Listing Office: A.Z. & Associates
Office Phone: 602-456-7600
Office Email: db@azrealtyco.com
Last Updated: October - 02 - 2026
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.