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

1872 S Maple Hills Dr
Perry, UT 84302
Jenny Nelson with KW South Valley Keller Williams, original listing - (801) 809-7983

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,190,000
Beds: 5
Baths: Full: 4
Status: Active
SqFt: --
Agency: KW South Valley Keller Williams
Agency Phone: (801) 809-7983

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2019
Notes: Grand Open House Saturday, July 27th from 12pm-3pm! Welcome to your scenic beauty dream home, where breathtaking views greet you from every angle. This custom-built masterpiece offers an unparalleled living experience, combining luxurious upgrades with the natural beauty of its surroundings. Step onto the covered deck and immerse yourself in the stunning vistas that stretch across the bay, the mountains, and the valley. Whether you're enjoying a morning coffee or an evening sunset, the scenery is nothing short of spectacular. Every detail in this home speaks of quality and elegance. Timber framing provides a sturdy and beautiful structure, while quartzite countertops in the kitchen and bathrooms add a touch of sophistication. The exterior is adorned with real stone, creating a timeless and durable facade. Unique Features: *Live Edge Walnut Window Slabs: These bespoke window ledges add a rustic charm and are a testament to the home's custom craftsmanship. *Cedar Tongue and Groove Ceilings: The warm, natural wood ceilings enhance the home's cozy and inviting atmosphere. *Locke Wood Burning Stove: This stylish and efficient stove not only provides warmth but also serves as a stunning focal point in the living area. From the moment you step inside, you'll be captivated by the blend of modern luxury and natural beauty. This home is more than just a place to live; it's a sanctuary where you can relax, entertain, and create lasting memories. Discover the perfect harmony of elegance and nature in this exceptional property. Schedule a viewing and experience the magic for yourself. Square footage figures are provided as a courtesy estimate only and were obtained from building plans. Buyer is advised to obtain an independent measurement.
MlsNumber: --
ListingId: 2012383


Listing Provided By: KW South Valley Keller Williams, original listing
Phone: (801) 676-5700
Office Phone: (801) 809-7983
Agent Name: Jenny Nelson
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