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

774 W Cherry Orchard Lane #222
Grantsville, UT 84029
Lauryn Birkeland-Robison with D.R. Horton - Salt Lake City, original listing -

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $729,990
Beds: 4
Baths: Full: 2, ½: 1
Status: Active
SqFt: 4809 Square Feet
Agency: D.R. Horton - Salt Lake City
Agency Phone:

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 sqft
Property Type: Residential-Single Family Residence
Year Built: --
Notes: Explore Cherry Wood, a new home community tucked away from the main streets of Grantsville, Utah. Here youll find a unique blend of tranquility and vibrancy, with an active outdoor lifestyle coupled with plenty of quiet places to retreat and recharge. Cherry Wood features a variety of beautiful single-family homes, including single-level ramblers and two-story floorplans at competitive prices. Each home is crafted with exceptional finishes, and a commitment to quality, using energy-efficient building materials. Our Smart Home technology package comes with every home, so youre always connected. The homes are situated on larger half acre or more lots, giving you plenty of space to call home. Cherry Wood residents enjoy close proximity to world-class recreation, such as the nearby Deseret Peak Complex and the Utah Motorsports Campus, as well as trails easily accessible directly from your home. Grantsville is also home to excellent local schools and community parks, complete with baseball diamonds, soccer fields, tennis courts, trails, and more. Whether youre enchanted by the scenic surroundings or the range of recreational options, Grantsville offers a welcoming and enriching environment. City life is also within easy reach. Cherry Wood is conveniently located within an easy 30-minute commute on nearby I-80 to the Salt Lake City International Airport or downtown Salt Lake City. Ready for a tour? Contact us today to see if Cherry Wood is right for you.
MlsNumber: --
ListingId: 26277+260-26277-262770000-0222


Listing Provided By: D.R. Horton - Salt Lake City, original listing
Phone: (801) 872-8718
Agent Name: Lauryn Birkeland-Robison
Disclaimer: Copyright © 2025 D.R. Horton. 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