Title Page Background
DEBUG FN args: Array ( [0] => 3425 [1] => [2] => [3] => agent ) BEFORE: Site: 3425 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 3425 Igate: njhud LocID: 3425 Region: State: Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 3425 AND i.igate IN ('azhud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'azhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 3425 [1] => [2] => [3] => lender ) BEFORE: Site: 3425 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 3425 Igate: njhud LocID: 3425 Region: State: Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 3425 AND i.igate IN ('azhud','ushud') AND m.expertType = 'lender' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'azhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 3425 [1] => [2] => [3] => other ) BEFORE: Site: 3425 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 3425 Igate: njhud LocID: 3425 Region: State: Experttype: other Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 3425 AND i.igate IN ('azhud','ushud') AND m.expertType = 'other' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'azhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

9440 N Sunset Ridge
Fountain Hills, AZ 85268
Diana Mettille with Realty ONE Group, original listing - (888) 461-0101

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,849,000
Beds: 4
Baths: Full: 3
Status: Active
SqFt: 3622 Square Feet
Agency: Realty ONE Group
Agency Phone: (888) 461-0101

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1997
Notes: EXPANSIVE ELEVATED VIEWS OF EAGLE MT GOLF COURSE, SURROUNDED BY MOUNTAINS & CITY LIGHTS. THIS IS THE HOUSE THAT YOU HAVE BEEN WAITING FOR. <br /> THIS REMODELED MONTEREY SINGLE LEVEL HOME FEATURES RESORT BACKYARD W/50 FT PEBBLE TEC LAP POOL, PUTTING GREEN, NEW LANDSCAPING, GUTTERS, & DRAINS, <br /> THE NEW CUSTOM GLASS FRONT ENTRANCE WAS ADDED TO EMBELLISH ALL OF THE VIEWS. CHEF'S KITCHEN MONOGRAM DW, OVEN, GAS RANGE, DOUBLE ELECTROLUX REFRIG, BEV COOLERS IN BAR, PULL OUT DRAWERS, GRANITE COUNTERS, CONTROL 4 AUTOMATION. PLANTATION SHUTTERS, AUTOMATED BLINDS/DRAPES/DUET SHADES. ROMANTIC SPLIT PRIMARY W/STONE FIREPLACE/LUX BATH. 3 CAR GAR WIRED FOR ELECTRIC CAR, EPOXY FLOOR. EAGLE MOUNTAIN IS GUARD GATED ENTRY AND SUNSET RIDGE AREA HAS AN ADDITIONAL KEYPAD ENTRANCE. <br /> <br /> Family Room<br /> Window Treatments: Plantation shutters, duet shades, automated blinds/drapes, and an electric patio awning for customizable light and privacy control.<br /> Lighting & Comfort: Upgraded can lighting, ceiling fans, chandeliers (2), and floor outlets for added functionality.<br /> Front Entrance<br /> Custom Front Door: Stunning custom glass front door and surround<br /> Bedrooms 2 & 3<br /> Storage: Closet shelving, hall closet, and a walk-in closet for ample organization.<br /> Bathrooms<br /> Medicine cabinets for extra storage.<br /> New Toto toilets <br /> Kitchen<br /> Appliances: Top-tier setup with a Wolf microwave, Monogram dishwasher, oven, and gas range, Wolf vent hood, and Electrolux refrigerator.<br /> Storage & Counters: Hayfle pull-out cabinet drawers, garbage pull-out, and granite countertops.<br /> Entertainment <br /> Media cabinets with Control 4 automation, plus a beverage cooler and wine cooler at the bar.<br /> Office<br /> Customization: Fireplace removed and replaced with built-in cabinets and filing drawers for a sleek, functional workspace.<br /> Laundry Room<br /> Storage: New cabinetry and pull-out drawers for practicality.<br /> Primary Suite<br /> Luxury Features: Automated blinds and shutters, fireplace, soaking tub, walk-in shower.<br /> Bathroom: Upgraded cabinets, laundry basket pull outs, and a large walk-in closet with an island, vanity bar (2), and a built-in safe bolted to the floor.<br /> Garage<br /> Utilities <br /> Tankless water heater, water softener, reverse osmosis (R/O) system, and LED light fixtures.<br /> EV Ready: Wired for electric cars with 50 amp/30 amp outlets, Liftmaster direct-drive self-locking space-saver openers, and an epoxy floor.<br /> Insulation<br /> Attic with 50-grade cellulose insulation for energy efficiency.<br /> Outdoor Features<br /> Front Yard <br /> New landscaping, pots, travertine walkway, and a shed that conveys.<br /> Trellis: Installed on east and west sides (2).<br /> BBQ: Built-in with rotisserie and infrared lights.<br /> Pool: 50-foot lap pool with Pebble Tec finish, new tile, and a Hayward pool cleaner.<br /> Yard Enhancements: Putting green, landscape lights, water on a timer, new gutters, and drains.<br /> Two new Train Air Conditioners with UV Filters
MlsNumber: --
ListingId: 6833897


Listing Provided By: Realty ONE Group, original listing
Phone: (888) 461-0101
Office Phone: (888) 461-0101
Agent Name: Diana Mettille
Disclaimer: Copyright © 2025 Arizona Regional Multiple Listing Service, Inc. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


Local Real Estate Expert

DEBUG FN args: Array ( [0] => njhud [1] => 0 [2] => maricopa-county-northeast [3] => AZ [4] => agent [5] => 1 ) BEFORE: Site: njhud LocID: 0 Region: maricopa-county-northeast State: AZ Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 IFELSE else AFTER: Site: njhud Igate: njhud LocID: 0 Region: maricopa-county-northeast State: AZ Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 3425 AND i.igate IN ('azhud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'azhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
Real Estate Expert Photo for Asher Lutz
Asher Lutz
ASCIIThe Medrano Group HomeSmart
Call Today!: (480) 310-0079

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App