Title Page Background
HFQUERY 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 ('usahud','cahud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'cahud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY 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 ('usahud','cahud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'cahud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY 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 ('usahud','cahud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'cahud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1;

17316 E Morning Vista Court
Rio Verde, AZ 85263
Irina Liakhovich with Realty ONE Group, original listing - (888) 461-0101

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $2,295,000
Beds: 3
Baths: Full: 4
Status: Pending
SqFt: 3238 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: 2024
Notes: Spectacular Custom home with Breathtaking Views and Guest Casita with separate entrance is ''Coming Soon'' at Trilogy at Verde River!! Smart home with WiFi lock, lights, AC, appliances, alarm, garage door openers and custom Hunter Douglas's PowerView remote control top down, bottom up energy efficient window treatments <br /> <br /> Kitchen<br /> Cabinet craft cabinets with soft close and dovetail drawers and doors<br /> Cabinets include pebble glass inlays and floor to ceiling custom stacked cabinetry<br /> Gourmet kitchen with stainless steel monogram appliances including advantium oven and 48" refrigerator<br /> Spacious Walk in pantry<br /> Wine bar with Monogram wine cooler<br /> Waterfall island with extended cabinets <br /> Dunes Wave custom back splash<br /> Custom Under cabinet kitchen lighting <br /> <br /> Kichler Crosby interior lighting.<br /> <br /> Soft water system<br /> <br /> Reverse osmosis system<br /> <br /> Casita with wet bar and refrigerator<br /> <br /> Famliy Room<br /> Four panel multi sliding expansive glass doors open to picturesque stunning Mountain View's and large green space<br /> <br /> Custom built in bookcases by fireplace<br /> <br /> Mezzo 60" Linear Gas Fireplace with remote control <br /> <br /> Outdoor<br /> Over $130k in landscaping including pergola, fire pit, sun deck and travertine walkways and patios,<br /> oasis of custom lighting, boulders and exquisite desert plants and fruitless olive trees<br /> Pool and outdoor kitchen design and plans available<br /> <br /> Den<br /> Custom built in bookcase in den,<br /> <br /> Custom smart-space by laundry with sliding barn door. <br /> <br /> Garage<br /> 50 amp 220 Volt car charger outlet in garage<br /> Oversized three car garage<br /> <br /> <br /> Bedrooms<br /> Three spaceous bedrooms with full ensuites.<br /> Master suite includes soaking tub, separate executive shower, dual custom vanities, expansive walk in closet<br /> <br /> Tile to the ceiling in all showers
MlsNumber: --
ListingId: 6844523


Listing Provided By: Realty ONE Group, original listing
Phone: (888) 461-0101
Office Phone: (888) 461-0101
Agent Name: Irina Liakhovich
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

HFQUERY 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 ('usahud','cahud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'cahud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1;
Real Estate Expert Photo for Kristina Perkins
Kristina Perkins
ASCIIBliss Realty & Investments
Call Today!: (602) 312-5876

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App