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

606 Zuni
Logan, NM 88426
Viola Terry with Terry Real Estate, original listing - (575) 403-8522

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $325,000
Beds: 3
Baths: Full: 2
Status: Active
SqFt: --
Agency: Terry Real Estate
Agency Phone: (575) 403-8522

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Garage: Garage
Property Type: Other-Mobile Home
Year Built: 2009
Notes: This is a lake-ready, almost no maintenance, move-in ready lake house that is spacious for one family, or several! There's plenty of room for everyone! The main house is a 2009 Solitaire, 3 bd, 2 ba, mobile home, all electric, open living /dining/kitchen floor plan, with all appliances included. The house is protected with 2 nice solidly built metal porches, with plenty of space for huge gatherings around the grill! The 12X24 bunkhouse has a full sized bathroom, and can house up to 3 nice big beds. The shop building, fully insulated is approximately 1550 sq. ft, with lots of storage space, fully heated and cooled with a couple of mini-split systems, and the perfect TV for catching all the ballgames going on! From the shop building is a 1074 sq. ft carport that creates more shade and lots of parking for other vehicles. Behind the house is a full RV hookup for more company, if needed! There is a 6 ft. privacy fence all around this property, plus a slider gate/lock for protection as well. Plenty of concrete all around is ideal for a "basketball court", or how about the beach sand created especially for some "beach volleyball". After a long hot day on the lake, how great to come to the lakehouse and eat, relax, and hang out with family and friends here at Ute Lake! This property has everything a person needs! Plenty of space in the shop for the huge lake boats, jet skis, or other necessary lake toys! Give us a call and we'll go take a look!
MlsNumber: --
ListingId: 11356483


Listing Provided By: Terry Real Estate, original listing
Phone: (575) 403-8522
Office Phone: (575) 403-8522
Agent Name: Viola Terry
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