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

38818 W Yermo Road
Yermo, CA 92398

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $699,999
Beds: 6
Baths: 10
Status: Active
SqFt: 3620
Agency: A-Z Realty and Investment LLC

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 25,236 sqft
Property Type: MultiFamily
Year Built: 1948
Notes: Former El Ranch Tel Motel turned MTM Apartments (9 Furnished Apartments and a 3 Bedroom House) located just off the 15 Freeway Between LA and LV. Master Metered; All utilities are paid for by the Landlord. Building I: 1 Bedroom Apt and 3 Furnished Studios. Building II: 2 Furnished Studios and a Furnished 1 Bedroom Apartment. Building III: 1 Single Family Dwelling. Building IV: Has Kitchen and 3/4 Bath / needs Remodel to make into 2 Bedroom Apartment w/ Single Car Garage. The property also has a New Laundry Facility w/ (2) Coin Op Washers and (2) Dryers, A Community Area w/ Trellis, Picnic Tables, Fire Pit, Palm Trees and BBQ Area. There are also and RV Hook Up, (3) Carports and outbuildings used for Dry Storage. Managers Laundry, Several Supply Closets, etc. There is a well onsite for Water Service. The Property is fully occupied and professionally managed. The Owner is also the Listing Agent. Rent Roll and Financials Available upon Request. Currently there are (4) vacant Studios. Property Management Service Available for Seamless Transition. Cash Sale Only. POF Required prior to showings. Seller seeking quick COE. Sold in AS IS Condition. Do your own Due Diligence on all aspects of the property.
MlsNumber: WS22254187


Listing Provided By: A-Z Realty and Investment LLC, original listing
Name: A-Z Realty and Investment LLC
Phone: (310) 897-1393
Office Name: A-Z REALTY & INVESTMENT CORP
Office Phone: (310) 897-1393
Agent Name: DUSTIN CLICK
Disclaimer: Copyright © 2024 California Regional Multiple Listing Service, Inc. 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