Title Page Background
DEBUG FN args: Array ( [0] => 3109 [1] => [2] => [3] => agent ) BEFORE: Site: 3109 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 3109 Igate: njhud LocID: 3109 Region: State: Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 3109 AND i.igate IN ('alhud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'alhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 3109 [1] => [2] => [3] => lender ) BEFORE: Site: 3109 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 3109 Igate: njhud LocID: 3109 Region: State: Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 3109 AND i.igate IN ('alhud','ushud') AND m.expertType = 'lender' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'alhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 3109 [1] => [2] => [3] => other ) BEFORE: Site: 3109 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 3109 Igate: njhud LocID: 3109 Region: State: Experttype: other Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 3109 AND i.igate IN ('alhud','ushud') AND m.expertType = 'other' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'alhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

60 Sleeping Spirt Ln.
Garrett, WY 82201

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $850,000
Beds: 3
Baths:
Status: Active
SqFt: 2030 Square Feet
Agency: Hayden Outdoors Real Estate

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 40 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2009
Notes: Nestled serenely at the foothills of the majestic Laramie Mountains, 60 Sleeping Spirit Lane in Wheatland, Wyoming, offers an unparalleled escape into nature's embrace. This exquisite property, spanning 40 acres of pristine wilderness, is a sanctuary of tranquility and natural beauty.LandThe home itself is a charming retreat, boasting 3 bedrooms and 2.5 baths, fully furnished and turn key, ready to enjoy. The architecture blends seamlessly with the surrounding landscape, and the interior exudes elegance, making it a cozy and inviting place to call home. Large windows throughout the house provide breathtaking vistas of the Laramie Mountains, creating a sense of being one with the wilderness. One of the most remarkable features of this property is its full walk-out unfinished basement, which holds immense potential for customization and expansion to suit your specific needs and desires. The possibilities are limited only by your imagination. As you step outside, you'll find yourself immersed in a world of natural wonder. The entire property is enclosed by a sturdy fence, ensuring privacy and security, while the landscape is adorned with stately Pine and Aspen trees. This enchanting forested setting provides a haven for wildlife, with elk, mule deer, bears, mountain grouse, antelope, and various other species calling this area home. Nature enthusiasts and photographers will delight in the frequent opportunities to observe these creatures in their natural habitat. For those seeking a self-sufficient lifestyle, this property is off the grid and self-contained. A modern solar system, complemented by a generator, ensures a reliable and sustainable power supply. This means you can enjoy all the modern comforts and conveniences while living harmoniously with nature. Whether you're relaxing on the porch, exploring the surrounding wilderness, or gazing at the starlit Wyoming skies, 60 Sleeping Spirit Lane offers a rare and extraordinary opportunity to savor the serenity and beauty of the Laramie Mountains. It's not just a home; it's a retreat from the hustle and bustle of everyday life, a place where you can truly connect with the natural world, and a haven for those seeking an authentic off-grid living experience.
MlsNumber: --


Listing Provided By: Hayden Outdoors Real Estate, original listing
Phone: (970) 674-1990
Office Phone: (970) 674-1990
Agent Name: John Wood
Disclaimer: Copyright © 2024 My State MLS. 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