Powered by 
- 0
- 5
- Overview
- Description
- Property Details
- Location
- HOA Management
- Facts & Features
- Getting Around
- Nearby Homes
Street View
$2,895,000
Monthly Est:$14,409
5 Beds
4 Baths4 full baths
5,144sqft
15418 E Stardust Dr, Fountain Hills, AZ 85268
$2,895,000
$14,409/moEst:
Get Pre-Approved
Single Family Residence
Built in 2004
$26.25/mo HOA
1.02 acres lot
$563/sq.ft
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.
- Houzeo last checked: 6 minutes ago
- Listing updated: October 2, 2026 at 8:44 pm
- Listing Provided by: Ulyses Castillo (602) 575-7028 , Jasmyne Kaur (623) 363-3368 | A.Z. & Associates (602) 456-7600
- Source: Arizona Regional Multiple Listing Service-AZ | MLS#: 7076117
Property Details
Status
Active
Type
Single Family Residence
No. of Stories
2
County
City
Neighborhood
--
Year Built
2004
HOA Fees
$26.25/mo
Finished Area
5,144 sqft
Lot Size
1.02 acres lot
Basement Area
- sqft
MLS Name
Arizona Regional Multiple Listing Service
MLS Number
7076117
MLS Status
Active
Days on Market
31
Continue Your Journey in App
Find your dream home, receive real-time updates, and many more!
Download App
Continue Your Journey in App
Find your dream home, receive real-time updates, and many more!
Location
HOA Management
Ogden
HOA Fees
$315/ Annually
Amenities
Amenities and services may be covered by one or multiple associations and service providers.
Maintenance
Disclaimer: Amenities are based on third-party information and may vary; buyers must independently verify all amenities, as information is deemed reliable but not guaranteed.
Facts & Features
Rooms
Bedrooms & bathrooms
Bedrooms: 5
Bathrooms: 4
Interior
Exterior Features
Balcony, Built In Barbecue, Rain Gutters
Window Features
Dual Pane
Interior Features
Full Bth Master Bdrm, Separate Shwr & Tub, Double Vanity, Tub With Jets, Bidet, Eat In Kitchen, Breakfast Bar, Pantry, Kitchen Island, Walk In Pantry, Granite Counters, Master Downstairs, 9+ Flat Ceilings, Wet Bar, Furnished(see Rmrks)
Cooling
Ceiling Fan(s), Central Air, Programmable Thmstat
Appliances
Dishwasher, Disposal, Refrigerator, Gas Cooktop, Microwave, Reverse Osmosis, Built In Gas Oven, Induction Cooktop, Washer, Dryer, Water Softener Owned, Water Purifier
Heating
Natural Gas
Sewer
Public Sewer, Sewer In & Connected
Construction
Year Built
Year Built: 2004
Home type
Single Family Residence
Construction Materials
Wood Frame, Painted, Stucco
Roof
Foam
Utilities & Energy
Parking Features
Rv Access/parking, Rv Gated, Over Height Garage, Extended Length Garage, Garage Door Opener, Separate Strge Area, Attached Garage, Off Street
Laundry Features
Inside
Electric
220 Volts In Kitchen
Fireplace Features
Family Room, Living Room, Gas, See Remarks
Pool Features
Diving Pool, Variable Speed Pump, Outdoor
Water Source
Pvt Water Company
Other Features
Subdivision Name
Fountain Hills Plat 606 A
Patio And Porch Features
Patio, Covered Patio(s), Covered Deck
Lot Features
Hillside Lot, Corner Lot, North/south Exposure, Desert Front, Desert Back, Sprinklers In Front, Sprinklers In Rear, Auto Timer H2o Front, Auto Timer H2o Back
Disclosures
None
Price History
| Date | Event | Price |
|---|---|---|
10/02/2026 Source: | Listed for Sale | $2,895,000 +56.49% $563/sqft |
01/07/2025 Source: | Sold | $1,850,000 +13.33% $360/sqft |
01/07/2025 Source: | Price Decreased | $1,632,470 -11.76% $317/sqft |
09/26/2024 Source: | Listed for Sale | $1,850,000 +101.09% $360/sqft |
11/15/2011 Source: | Price Decreased | $920,000 -5.15% $179/sqft |
Show more
Nearby Homes
Find Homes by Property Features in Fountain Hills, AZ
Nearby New Homes For Sale
Based on information from the Arizona Regional Multiple Listing Service through Oct 06, 2026, 05:15AM. All information should be verified by the recipient and none is guaranteed as accurate by ARMLS. Listing Information presented by local MLS brokerage: Sell Your Home Services, local REALTOR®- Dan Demers (774) 265-0879. Information is provided exclusively for personal, non-commercial use. It may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. This website may not include listings or property addresses of sellers who have directed their listing brokers to withhold their listing or their property address from display on the Internet. © 2026 Arizona Regional Multiple Listing Service, Inc. All rights reserved.
Advertising Broker: Daniel Demers (267) 341-8337 | Sell Your Home Services