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

1663 E Airport
Manila, UT 84046
Christina Hakala with Real Estate by Referral, original listing - (801) 694-1597

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $350,000
Beds: 4
Baths: Full: 3
Status: Active
SqFt: --
Agency: Real Estate by Referral
Agency Phone: (801) 694-1597

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1999
Notes: Nestled in the serene and picturesque town of Manila, Utah, just approximately 2 miles from the stunning Flaming Gorge, lies an incredible opportunity to own a piece of paradise. This 4-bedroom, 3-bathroom modular home is set on a sprawling 1/2 acre of pristine land, offering endless possibilities for those with a vision. This home, while in need of some TLC, is a canvas waiting for your creative touch. Imagine transforming this property into the ultimate vacation rental on Airbnb, drawing guests from all over the world to experience the breathtaking beauty and adventure that Flaming Gorge has to offer. Located just a short drive from the reservoir, this property is a haven for outdoor enthusiasts. Explore numerous hiking trails, embark on thrilling ATV and UTV adventures, or simply bask in the tranquility of the great outdoors. Flaming Gorge is renowned for its fishing, boating, and scenic vistas, making it a sought-after destination for recreation lovers. Whether you're looking to create a stunning family retreat, a lucrative rental property, or a combination of both, this home offers the perfect foundation. Envision cozy evenings by the fire after a day of adventure, hosting family gatherings, or providing an unforgettable stay for your guests. Don't miss your chance to own this slice of heaven in Manila, Utah. With a bit of work and a lot of imagination, you can turn this modular home into a dream come true. Embrace the potential, and let your vision take flight in this idyllic location. With the large garage, you can store all your toys so they are ready to be used. Ready to make this dream property your own? Contact me now to schedule a viewing and start your journey toward owning a piece of Utah's natural wonderland. Agent related to Sellers. Square footage figures are provided as a courtesy estimate only and were obtained from an appraisal. Buyer is advised to obtain an independent measurement.
MlsNumber: --
ListingId: 2014137


Listing Provided By: Real Estate by Referral, original listing
Phone: (801) 694-1597
Office Phone: (801) 694-1597
Agent Name: Christina Hakala
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