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;

5650 N Franson Ln
Oakley, UT 84055
Dane McDermott with Realtypath LLC (Preferred), original listing - (801) 386-5908

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $2,900,000
Beds: 7
Baths: Full: 6, ½: 2
Status: Active
SqFt: --
Agency: Realtypath LLC (Preferred)
Agency Phone: (801) 386-5908

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 4 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2000
Notes: Fully furnished cabin in Oakley! Discover the charm of this fully furnished, hand-hewn log estate, nestled on nearly 5 acres of beautifully landscaped grounds with panoramic views. Upon entering, you are welcomed by the breathtaking craftsmanship of hand-chinked logs, which frame a spacious gathering area-ideal for hosting family and friends. Enjoy the comfort of radiant heated floors that maintain a consistent warmth across the expansive vaulted spaces. The foyer and kitchen feature elegant travertine tile flooring. Adjacent to the great room and dining area, you'll find a private office with its own entrance. The residence also includes a cozy hot tub room, a convenient half bath, and a luxurious primary suite with high vaulted ceilings and a fireplace. The primary bath offers a large spa tub and walk-in shower. The functional layout continues with a large laundry and mudroom behind the kitchen, another half bathroom. Ascend the graceful curved staircase to a balcony that overlooks both the great room and the foyer. Two generously sized bedrooms each come with private bathrooms; one is designed as a bunk room featuring a charming built-in miniature cabin. The lower level houses a game room, a home theater with a second kitchen, and four additional bedrooms accompanied by three bathrooms. A substantial three-car garage includes a deep 1,120 square foot storage area below, accessible via its own garage door and a staircase in the garage. Completed with a new back deck in 2021 and exterior staining in 2022, this estate is truly a one-of-a-kind sanctuary for making lifelong memories. Note: Square footage figures are provided as a courtesy estimate based on building plans and should be independently verified by the buyer.
MlsNumber: --
ListingId: 1999318


Listing Provided By: Realtypath LLC (Preferred), original listing
Phone: (801) 386-5908
Office Phone: (801) 386-5908
Agent Name: Dane McDermott
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