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

6462 Summit Cv
Huntsville, UT 84317

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $3,387,888
Beds: 8
Baths: 7
Status: Active
SqFt: --
Agency: Sold By An Angel Real Estate

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Property Type: Residential
Year Built: 2020
Notes: This stunning one-of-a-kind Huntsville mansion features an indoor basketball court, movie theater, kids area with rock wall and foam pit, outdoor playground, a pet station for washing your dog, drinking fountain next to the sports court, and more! Nestled in the Summit at Ski Lake subdivision, you will have the perfect views from any angle, and you will be within minutes of the Winter's Grove Trailhead, offering a plethora of hiking trails boasting even more breathtaking views! Enjoy the summer evenings barbecuing on your built-in barbecue! The kids can enjoy skipping the stairs and taking the built-in slide down to the backyard! This home also has two 200 amp panel automated backup generator, a water softener, high recovery high efficiency water heater, two stage high efficiency furnaces, 16 channel security camera, as well as hard wired home security and central audio throughout the entire home. There are 4 furnaces, 4 HVAC systems, and 4 Air Conditioning units in the entire home. The kitchenette in the basement includes the refrigerator and microwave. Enjoy the ultimate movie nights in a TRUE theater room! This theater has a 150 inch screen, 4K UHD projector, 7.2 surround sound speakers, and get this - an LED twinkling lighted ceiling that changes color! The Receiver and all AV equipment are included with your purchase! The seller is also including the three bean bag chairs, sofa, love seat, and 6 bar stools located in the theater room. The Basketball hoop will stay as well as the custom Utah Jazz logo and pickle ball net. That's not all! The amazing foam pit, rock wall, and swings will also stay. Patio furniture included. All other furniture is negotiable. 4 smart thermostats are included. 1 thermostat is regular and is located in the garage. Gym TV, family room TV in basement, great room TV, master bedroom TV, water-slide, sledding hill, utility sink in garage, retractable hose reel, hot and cold water hose bib in backyard for filling up the kids pool, both washer and dryers are included. The suspended garage in the basement could fit a 6th car, an ATV, or whatever outdoor toy you can think of! Keep in mind, although RV parking is not allowed, the garage door to the house would allow RV parking depending on the size of your RV. The seller is ALSO buying you a $770 SilverBack Home Warranty! Schedule your showing today! Square footage figures are provided as a courtesy estimate only. Buyer is advised to obtain an independent measurement.
MlsNumber: 1996488


Listing Provided By: Sold By An Angel Real Estate, original listing
Name: Sold By An Angel Real Estate
Phone: (801) 294-7806
Office Name: Sold By An Angel Real Estate
Office Phone: (801) 294-7806
Agent Name: Angelina Feichko
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 = 2804 AND i.igate IN ('usahud','lahud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'lahud', 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