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

2357 W Fm 696
Lexington, TX 78947
Mark Mata with Texas Mobile Home Buyers, original listing - (512) 300-8079

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $37,000
Beds: --
Baths: --
Status: Active
SqFt: 1140 Square Feet
Agency: Texas Mobile Home Buyers
Agency Phone: (512) 300-8079

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 sqft
Garage: Garage
Property Type: Other-Mobile Home
Year Built: 2018
Notes: SÍ, ESTÁ DISPONIBLE Ubicación: Lexington, TX 78947 Debe ser trasladada Año: 2018 Fabricante: CMH Tipo: Casa móvil de una sola sección (Single Wide) Habitaciones/Baños: 3 / 2 Tamaño: 15x76 | 1,140 pies² Precio: $32,000 EFECTIVO o CHEQUE DE CAJA No ofrecemos financiamiento Condición: Como nueva, no necesita reparaciones Nunca ha sido trasladada Aire acondicionado, calefacción y calentador de agua funcionando Incluye refrigerador y estufa (no incluye lavadora/secadora) Envíame un mensaje para agendar una cita RBI: 38370 Horario: Lun-Jue: 9-8:30 Vie: 10-9 Dom: 10-6 YES, IT'S AVAILABLE Location: Lexington, TX 78947 Must Be Moved Year: 2018 Manufacturer: CMH Type: Single Wide Beds/Baths: 3 / 2 Size: 15x76 | 1,140 Sqft Price: $37,000 CASH or CASHIER'S CHECK No financing Condition: Like new, no repairs needed Never moved AC, heater, water heater all work Fridge and stove included (no washer/dryer) Message to schedule a showing RBI: 38370 Hours Mon-Thu: 9-8:30 Fri: 10-9 Sun: 10-6
MlsNumber: --
ListingId: 11486893


Listing Provided By: Texas Mobile Home Buyers, original listing
Phone: (737) 272-7450
Office Phone: (512) 300-8079
Agent Name: Mark Mata
Disclaimer: Copyright © 2025 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