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

630 E Bullberry Ln
Teasdale, UT 84773

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,050,000
Beds: 3
Baths: 3
Status: Active
SqFt: 3913
Agency: RED ROCK REAL ESTATE

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 12 acre(s)
Property Type: Residential
Year Built: 2013
Notes: Nestled on 12.34 acres of natural landscape in the serene and picturesque Teasdale, Utah, this stunning log home offers the perfect blend of rustic charm and modern comfort.<br /> With three spacious bedrooms and three well-appointed bathrooms, this residence is ideal for those seeking a tranquil retreat or a luxurious primary residence. The home boasts huge vaulted ceilings that create an open, airy ambiance throughout the living areas. The large windows let in abundant natural light and offer breathtaking views of the surrounding landscape. A huge deck spans the back of the home, providing ample space for outdoor entertaining, relaxing, and soaking in the stunning views. Additionally, a private hot tub offers the perfect spot to unwind after a long day.<br /> The oversized kitchen is a chef's dream, featuring modern appliances, ample counter space, and custom cabinetry. It's designed to accommodate both everyday meals and large gatherings. The master bedroom is a true retreat with its own private balcony offering privacy and comfort. The basement has a double glass garage door to store all your toys. <br /> This remarkable log home combines the best of rustic and contemporary living, making it a unique find in Teasdale. Whether you're enjoying a quiet evening on the deck, entertaining friends in the spacious kitchen, or exploring the vast acreage, this property promises an unparalleled lifestyle. The property is surrounded by a pristine natural landscape, offering peace, privacy, and the opportunity to enjoy the great outdoors right at your doorstep. Close to great fishing, hunting, ATV trails, and hiking.<br /> Don't miss the chance to own this exquisite piece of paradise. Schedule a viewing today and experience the magic of this log home for yourself!
MlsNumber: 24-251291


Listing Provided By: RED ROCK REAL ESTATE, original listing
Name: RED ROCK REAL ESTATE
Phone: (801) 859-3232
Office Name: RED ROCK REAL ESTATE CENTRAL
Office Phone: (435) 275-2775
Agent Name: JAIMI PAYNE
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.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App