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

196 S Holly Dr
Alpine, UT 84004

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $7,900,000
Beds: 8
Baths: 7
Status: Active
SqFt: --
Agency: BHHS Elite Real Estate

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 7 acre(s)
Property Type: Residential
Year Built: 2001
Notes: *Huge Pricing Correction. Don't miss out on this Estate Luxury property* Welcome to the epitome of luxury and estate living! Nestled on a sprawling 7.58-acre private estate, this magnificent residence spans over 10,000 total square feet and offers unparalleled sophistication and comfort. Fully furnished, this opulent property boasts 8 bedrooms and 6.5 bathrooms, ensuring ample space for family and guests. Indulge in the pinnacle of relaxation with an indoor pool and spa, accompanied by a detached fitness center for those seeking an active lifestyle. As you enter through the fully fenced and gated private drive, you will be captivated by the breathtaking views of the valley, providing a sense of tranquility and serenity. Immerse yourself in luxury amenities as you explore the sauna, theater room, and the rare and coveted walk-in vault for securing your valuables. Additionally, a generator ensures uninterrupted power supply, and the underground propane storage guarantees a seamless experience. For the enthusiasts, an impressive fish tank brings a touch of aquatic wonder to your living space. Embrace your competitive spirit on the tennis courts, or simply revel in the meticulously crafted custom finishes that adorn every inch of this masterpiece. Entertaining becomes an art form with the expansive gathering and dining space, perfect for hosting lavish gatherings and creating cherished memories. The chef's kitchen is a dream come true for culinary enthusiasts, equipped with state-of-the-art appliances and top-tier features. Comfort and luxury go hand in hand with radiant heated floors, keeping you warm during colder months. Outside, mature landscaping surrounds the property, complemented by a greenhouse for the avid gardener. Indulge in year-round outdoor living with a covered patio and deck, where you can relish in the picturesque views while savoring the fresh air. Whether it's a sun-drenched afternoon or a starlit evening, this private estate ensures an experience like no other. The combination of elegance, privacy, and exclusivity sets this property apart from the rest. It is a once-in-a-lifetime opportunity to embrace a lifestyle of extraordinary luxury, sophistication, and comfort. Don't miss this chance to make this private estate your very own oasis of indulgence and refinement. Agent related to seller.
MlsNumber: 1893106


Listing Provided By: BHHS Elite Real Estate, original listing
Name: BHHS Elite Real Estate
Phone: (801) 224-9011
Office Name: Berkshire Hathaway HomeServices Elite Real Es
Office Phone: (801) 224-9011
Agent Name: Ammon Childs
Disclaimer: Copyright © 2024 UtahRealEstate.com. 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 = 3407 AND i.igate IN ('usahud','pahud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'pahud', 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 Whitney Aldrich
Whitney Aldrich
ASCIIEquity Real Estate
Call Today!: (801) 864-5950

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App