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 = 2802 AND i.igate IN ('usahud','cihud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'cihud', 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 = 2802 AND i.igate IN ('usahud','cihud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'cihud', 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 = 2802 AND i.igate IN ('usahud','cihud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'cihud', 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;

499 E Homespun Cir
Leeds, UT 84746

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,800,000
Beds: 5
Baths: 3
Status: Active
SqFt: 5946
Agency: WOODBRIDGE REALTY LLC

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Property Type: Residential
Year Built: 2018
Notes: Incredible modern home with almost everything you could want in a home. Salt Water Swimming pool, 30'x50' RV garage, Views , Views, Views, office that could be another bedroom. Open great room with ton's of room for entertaining. An art studio to top it all off. The 1.69 acre lot is mostly hillside and natural. The yard is very well manicured with just enough to not be a burden. The modern kitchen has commercial grade appliances and is very well though out. Plenty of space downstairs for entertaining as well. This home was very well built and exuded quality without opulence. It is has lots of storage upstairs and down stairs. The upper level is an art studio and has windows and views in every direction. PANORAMA VIEWS<br /> " View the vista from huge windows, 3 Covered Decks and Patio<br /> " Eye-level with the birds<br /> " Radiant sunsets and breathtaking sunrises<br /> " Watch the clouds and storms roll in<br /> " Layers of red cliffs and hills against a backdrop of looming Pine Valley Mountains.<br /> " Constant movement of the freeway from a distance<br /> " A whole new world away from the city lights where brilliant stars freckle the sky<br /> " Access door to rooftop observation deck<br /> " Privacy, Peace, Safety, Security<br /> THE GREAT OUTDOORS<br /> " Direct access to BLM from back yard with miles and miles of trails for walking, hiking, biking, ATV's<br /> " Walking distance to the new Toquerville Reservoir now in progress.<br /> RELAX BY THE POOL<br /> " 20x40 swimming pool with 9' jumping platform and inset rocks to leap from.<br /> " Outdoor bathroom, outdoor shower<br /> " In-ground trampoline.<br /> STORAGE GALORE!<br /> " 30x50 Metal storage shed to store motorhome, ATV's, motorcycles, Kayak's etc. with workbench and storage space<br /> " Enormous walk-in pantry with sink and prep counters to keep appliances out but hidden<br /> " 2 Walk-in storage rooms, multiple storage closets<br /> " Built-in drawers/cubbies in Master Closet<br /> <br /> STUDIO IN THE SKY<br /> " Office or studio with windows in every direction,<br /> " Built-in counter, drawers and cabinets and sink.<br /> <br /> EXTRA EXTRA<br /> " 4 separate HVAC systems to control temperature<br /> " Walk-in fire-proof gun safe<br /> " Reloading or craft room<br /> " Modern design<br /> " Efficient route from master bedroombathclosetlaundrymudroomgarage without walking through the main house.
MlsNumber: 24-250481


Listing Provided By: WOODBRIDGE REALTY LLC, original listing
Name: WOODBRIDGE REALTY LLC
Phone: (801) 599-1206
Office Name: ERA BROKERS CONSOLIDATED SG
Office Phone: (435) 628-1606
Agent Name: RYAN ANDERSEN
Disclaimer: Copyright © 2024 Washington County Board of Realtors. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


Local Real Estate Expert

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 = 2802 AND i.igate IN ('usahud','cihud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'cihud', 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;
Tim Andrus
ASCIIERA Brokers Real Estate Consolidated
Call Today!: (435) 574-4663

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App