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

12293 N Ross Creek Dr
Hideout, UT 84036

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $899,900
Beds: 3
Baths: Full: 2
Status: Active
SqFt: --
Agency: KW Utah Realtors Keller Williams
Agency Phone: (801) 858-0000

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Townhouse
Year Built: 2001
Notes: PRICE REDUCED! UNHINDERED PANORAMIC VIEWS! Nestled in a mainly single-family home neighborhood with a large open space right out your back door, this residence invites you to experience the allure of modernized mountain living with breathtaking views of Jordanelle and the surrounding mountains. Unlike all the new developments in the area, this townhome is in a neighborhood where the master plan was not - how many buildings can I fit into this one small piece of land. The homes are well spaced, with mature landscaping, and the majority of the lots have been built on already so you won't have to live in a construction zone. The welcoming living room is enhanced by a slate-tiled gas fireplace and soaring ceilings, creating an ambiance of warmth and spaciousness. From here you can enjoy the stunning vistas through the large sliding glass windows in the open concept kitchen and dining area, or step out onto the sunbathed private deck for some fresh mountain air. Retreat to the primary bedroom, where herringbone-patterned wood flooring meets private deck access, a walk-in closet, and a well-appointed full bath. The daylight lower level reveals a spacious family/rec room seamlessly connecting to a covered patio that offers panoramic views. Additional fine features include plenty of storage space, an outdoor closet for yard tools and games in the backyard, a finished attic storage space complete with shelves, and wired for an electric car charger. Residents will appreciate the dog-friendly neighborhood and the property's proximity to hiking/biking trails and recreation makes it an ideal haven, just minutes away from all the outdoor adventures you desire. Buyer to verify all.
MlsNumber: --
ListingId: 1994683


Listing Provided By: KW Utah Realtors Keller Williams, original listing
Phone: (801) 858-0000
Office Phone: (801) 858-0000
Agent Name: Joe Reardon
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.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App