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;

3400 Mountain Side
Oakley, UT 84055
David M. Croft with Chapman-Richards & Associates, Inc., original listing - (801) 278-4414

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $2,895,000
Beds: 2
Baths: ½: 1
Status: Active
SqFt: --
Agency: Chapman-Richards & Associates, Inc.
Agency Phone: (801) 278-4414

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 8 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2012
Notes: Weber River Frontage, Water Frontage, River Access, Location, Location, Weber River, Flat acreage ready for your enjoyment. Located approximately 6.4 miles up Weber Canyon Road from the Oakley Diner to the Hidden Lakes Subdivision gates, this approx. 9-acre parcel (8.85 acres) is situated up Weber Canyon Road within the Hidden Lakes Gated Subdivision (but not a part of the subdivision). The property features extensive river frontage, privacy, and a tranquil setting for years of playing and quiet enjoyment. There is already a fairly new custom carriage house (or guest house) as well as an awesome large 6+ car garage below the carriage house. The guest house is a custom log built structure that features vaulted wood ceilings, large windows, beautiful views, built in bunk beds, custom finishes and incredible quality with 2 bedrooms and 2.5 bathrooms, a living area with beautiful fireplace, custom kitchen with gorgeous cabinets and granite counter tops, and lots of garage space for all your toys. The property has plenty of acreage and is perfectly situated for wonderful recreational activities along the weber river as well as very convenient access within minutes to forest lands and recreational uses. The acreage and the property's pristine setting are the perfect spot for a new home to be built on that will complement the custom guest home that is already in place. The guest home is quite custom in its construction and quality and features commercial grade stainless steel appliance and was custom designed by Fred Babcock as the architect and Doran Taylor as the Interior Designer. It is absolutely gorgeous and can sleep up to 10+ people if needed. The property is exceptional as is the perfect getaway that is so close to Park City, Kamas, Oakley and Salt Lake City as well as numerous recreational opportunities. Buyer to verify all information including square footage, acreage, and utilities prior to closing. All information is deemed reliable but is not guaranteed and should be independently verified.
MlsNumber: --
ListingId: 2028415


Listing Provided By: Chapman-Richards & Associates, Inc., original listing
Phone: (801) 278-4414
Office Phone: (801) 278-4414
Agent Name: David M. Croft
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