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

54 Wimsatt Loop
Cloudcroft, NM 88317
TABITHA FOSTER with Future Real Estate, original listing - (575) 415-4039

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $409,000
Beds: 5
Baths: Full: 3
Status: Active
SqFt: 2591 Square Feet
Agency: Future Real Estate
Agency Phone: (575) 415-4039

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Garage: Garage
Property Type: Residential-Mobile Home
Year Built: 2003
Notes: Stunning Mountain Retreat with Established Income Potential! Nestled in the serene Sacramento Mountains, this enchanting 5-bedroom, 3-bathroom home offers a perfect blend of cozy comfort and breathtaking natural beauty. Situated on a large .89-acre lot, this property is a true gem in a quiet neighborhood, providing the ultimate escape from the hustle and bustle of everyday life. Step inside to discover a spacious layout that embraces family living and entertaining. The heart of the home features a large kitchen and dining room, perfect for gatherings, while the two inviting living areas provide ample space to relax and unwind. Enjoy the warmth of the cozy pellet stove on chilly mountain evenings as you soak in the stunning mountain views from every window. Flex space offers versatility for your lifestyle—whether you need a playroom, craft area, or a quiet place to work from home. With five generously sized bedrooms, there’s plenty of room for family, friends, and guests alike. Wander outside to your covered deck where you can sip your morning coffee while taking in awe-inspiring views, or bask in the beauty of the surrounding wildlife, including majestic elk and deer that roam freely. Embrace the crisp, fresh mountain air and make the most of the outdoor space on this expansive lot. This property isn’t just a dream home; it’s an established nightly rental with a stellar reputation! As a guest favorite and a 5-star Airbnb, you’ll enjoy the benefit of immediate income potential or the option to keep it as your own private getaway. The property is being offered mostly furnished for a turn-key nightly rental with the exception of some personal items that will be removed. Located just 7 miles from the quaint village of Cloudcroft, you’ll have access to charming shops, dining, and outdoor activities, while still enjoying the privacy of your own mountain sanctuary. Don’t miss out on this rare opportunity to own a slice of mountain paradise, with the added appeal of a proven rental income. Whether you’re seeking a serene family retreat or an investment property, this home checks all the boxes! Schedule your private showing today and step into your dream lifestyle!
MlsNumber: --
ListingId: 170017


Listing Provided By: Future Real Estate, original listing
Phone: (575) 415-4039
Office Phone: (575) 415-4039
Agent Name: TABITHA FOSTER
Disclaimer: Copyright © 2024 Otero 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