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

25 Desperado Drive
Laramie, WY 82070

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $995,000
Beds: 4
Baths: 3
Status: Active
SqFt: 5200
Agency: Hayden Outdoors, LLC

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 39 acre(s)
Property Type: Farm And Agriculture
Year Built: 2022
Notes: WHAT A DEAL! This newly built home is a spacious 5,200 finished square feet of comfortable living space complimented by a heated garage and shop that offer ample space for parking, working, and playing. Located west of Laramie, WY, in Wild Horse Ranch, this property consists of vast rolling hills at the base of Sheep Mountain. This property is 39 deeded acres on the foothills of the Snowy Range Mountains and borders 500 acres of state-owned land. Located within the Wild Horse Ranch, this property offers a private lot within a safe, gated community. You can hunt, target shoot, hike, and explore your acreage as well as the state-owned land. Wild Horse Ranch offers private lake access to Lake Hattie and is 25 miles drive to the Snowy Range Mountains and Snowy Range Ski area. This spacious home was built in 2022-2023 and is complimented by a heated workshop and 3-car garage that are both conveniently attached allowing for more than enough parking and storage space for large vehicles and other toys. The two- level home has a full kitchen, full bath, laundryand a master suite on both levels with separate entrances making the property ideal for multi-general living, a private guest suite, or for renting out part of the property. The seller, a contractor by trade, built gorgeous barn doors that demand attention and efficiency save space throughout the home. Other updates and upgrades include 2 wood fireplaces, granite countertops, stainless steel appliances, and perhaps the most fun space in the house, the loft. The loft sits above the heated shop and is complete with a custom wood bar, a pool table, a tv, and a poker table! Wild Horse Ranch offers a private access recreational area on Lake Hattie with a brand-new community boat ramp only 2 miles from the property. Lake Hattie is a popular lake in the area where you can catch Browns, Cutthroats, Rainbow Trout, Kokanee salmon, and Yellow Perch. Prairie dogs and coyotes are plentiful and can be hunted without tags. Elk tags can be purchased over the counter for this area. Area 9 for elk, 45 for antelope, and 76 for deer. Located 20 miles from Centennial, WY, where many visit to hike and bike mountain trails, trout fish, hunt, ATV, and visit our local ski area. Albany County, WY, is one of the most temperate counties in Wyoming. It is known for its moderate summers with 70-75 degree average temperatures. July is Laramie's hottest month with an average high temperature of 80 degrees. Laramie averages around 64 inches of snow per year and its heaviest snow months are March and April. The estate is in the gated Wild Horse Ranch between the Medicine Bow National Forest and the lively college town of Laramie, Wyoming. The property is approximately 2 miles from the Wild Horse Ranch East Entrance and 20 miles to Laramie. Laramie offers an awesome restaurant and bar scene, college football and tailgating, museums, shopping, and more. Laramie is a safe family town, with crime rates being 51% below the national average. Do not miss this unique opportunity to own this property in southeastern Wyoming. Call today to schedule your private tour. Buyer's must be prequalified before showings.  
MlsNumber: 11195397


Listing Provided By: Hayden Outdoors, LLC, original listing
Name: Hayden Outdoors, LLC
Phone: (970) 674-1990
Office Name: Hayden Outdoors Real Estate
Office Phone: (970) 674-1990
Agent Name: Jaci Cole
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.


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 = 3094 AND i.igate IN ('usahud','txhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'txhud', 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;
Brenda Whitman
ASCIILive in Laramie Real Estate
Call Today!: (307) 399-5477

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App