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 = 2788 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 = 2788 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 = 2788 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;

Foreclosure: 1103 E Spring Hollow Rd
Duck Creek Village, UT 84762
Alonzo Ashworth with Coldwell Banker Majestic Mountain Realty, original listing - (435) 682-3688

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $999,999
Beds: 5
Baths: Full: 3, ½: 1
Status: Active
SqFt: 4943 Square Feet
Agency: Coldwell Banker Majestic Mountain Realty
Agency Phone: (435) 682-3688

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2007
Notes: Open the windows and enjoy the beautiful sounds of Mammoth Creek. This 4943 sq ft custom log home sits on 2 lots boarding Mammoth Creek. The majestic home has 12" logs on the outside and 22" log trusses on the inside. The home includes 5 bedrooms, 3.5 baths, great room, gourmet kitchen, theater room, game room, and detached 3 car garage. The cabin is loaded with top-of-the-line upgrades throughout including custom cabinets, granite counter-tops, solid copper sinks, Siberian pine distressed wood floors, slate, and carpet. The Casement Windows are wrapped with authentic half-log and trimmed with granite window sills. The living area is open and inviting to all that come through the front door. Everyone will enjoy the wall of windows and decks that overlooks the Mammoth Creek. Recreation all around includes hunting, fishing, biking, hiking, and ATV trails in the Dixie National Forest. It is a short drive to Zion National Park, Bryce Canyon National Park, Cedar Breaks National Monument, and the North Rim of the Grand Canyon. Call for more information. The listing Broker's offer of compensation is made only to participants of the MLS where the listing is filed.
MlsNumber: --
ListingId: 2808094


Listing Provided By: Coldwell Banker Majestic Mountain Realty, original listing
Phone: (435) 682-3688
Office Phone: (435) 682-3688
Agent Name: Alonzo Ashworth
Disclaimer: Copyright © 2024 Duck Creek MLS. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App