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 = 2802 AND i.igate IN ('usahud','uthud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'uthud', 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 = 2802 AND i.igate IN ('usahud','uthud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'uthud', 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 = 2802 AND i.igate IN ('usahud','uthud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'uthud', 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;

2399 N Kiva Trail
St George, UT 84770

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $7,950,000
Beds: 7
Baths: 8
Status: Active
SqFt: 8770
Agency: SPLIT ROCK AT ENTRADA REAL ESTATE CO.

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Property Type: Residential
Year Built: 2021
Notes: On top of the World! A Truly One-of-a-Kind Contemporary Estate featuring endless modern conveniences, sitting atop your own private Lava Plateau. One of The Premiere homesites in The Entrada at Snow Canyon Country Club. The home sits 28 feet above the street below, offers 360 degree views, including a picture perfect framing of Snow Canyon, Red Mountain, Pine Valley Mtn, Movie Rock, and the<br /> <br /> Kachina Cliffs.<br /> <br /> A Palm Springs-inspired design, includes 100' of glass windows opening up North into the Canyon and surrounding views. Inside/out living with ease as big sections of the windows retract to provide the ultra expansive entertaining space. Nearly 9,000 square feet on 1.4 Acres, overlooking all of the homes in the valley below.<br /> <br /> AMENITIES: Visit https://www.golfentrada.com/ Features an Oversized Kitchen/Bar with Butler's Pantry, adorned with natural quartzite countertops and LED backlighting. Total there are 3 dishwashers, 2 Wolf Ovens, 2 Microwaves, Oversized Sub Zero Fridge/Freezer, separate Scotsman Ice Maker. Generous Kitchen Bar seating, as well as 2 Large Dining areas (each seating 10-12)!<br /> <br /> Luxury accommodations for everyone, with most rooms being en suite. 3 Master Suites with fine wall finishes and spa-like bathing areas. No detail has been overlooked in any bedroom, as each has its own unique style and ambience while capturing the outside vistas and providing an overall tranquil space to relax.<br /> <br /> Entertainment for all ages from Black and Silver Tile wet edge reflective pool/hot tub, Movie Theater, Arcade that can be closed off for noise with full glass retractable wall, multiple recreation rooms with multiple large screen TV's, including an inspiring partial walkout featuring a fun and elegant lighted stairwell. Throughout the home inside and out are a plethora of spaced out seating areas. Enjoy some competition playing table tennis, digital darts, or tossing it on the regulation-size double cornhole court. Two large outdoor fire features will invite you outside on those chilly desert nights, and on those summer days the natural water features front and back offer a soothing alternative.<br /> <br /> Enjoy awe inspiring natural artistic features throughout the home, including a 15' high 14,000lb black and white granite wall imported from Brazil which adorns the great room fireplace. Backlit Cristallo Quartzite walls highlight the front and back entry ways. No expense was spared with Moooi lights, Kohler plumbing fixtures, Sub-zero and Wolf appliances throughout. Smart Home automation for everything from blinds, water features, to lighting, audio, television, and security.<br /> <br /> Associate Membership to the Entrada Country Club.<br /> is required. See Listing Agent about fees and food minimums.
MlsNumber: 23-246763


Listing Provided By: SPLIT ROCK AT ENTRADA REAL ESTATE CO., original listing
Name: SPLIT ROCK AT ENTRADA REAL ESTATE CO.
Phone: (435) 773-7702
Office Name: REAL ESTATE COLLECTIVE LLC, TH
Office Phone: (435) 652-9298
Agent Name: Brady Platt
Disclaimer: Copyright © 2024 Washington County Board of Realtors. 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 = 2802 AND i.igate IN ('usahud','uthud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'uthud', 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;
Tim Andrus
ASCIIERA Brokers Real Estate Consolidated
Call Today!: (435) 574-4663

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App