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;

35127 Condor Road
Newberry Springs, CA 92365

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $175,000
Beds: 2
Baths: 1
Status: Active
SqFt: 850
Agency: Trust Real Estate

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 93,218 sqft
Property Type: Residential
Year Built: 1975
Notes: This property is a Mechanic's dream. It has a HUGE machine shop/mechanics shop with 220 three phase power, 3 roll up high clearance garage doors, 4 overhead chain fall electric hoists in area with high ceilings & room to park at least 3 cars. The whole shop has been plumbed for air tools. Nice neighborhood, centrally located in Newberry Springs but more towards the west side so closer to Barstow than some of the properties. The lot is fully fenced and is on the NE Corner of & Coventry. There is an older single wide. 2 bdrm 1 bath mobile home on the property. It needs a lot of work but has a new service panel in the bedroom. A new well, 320' deep with was installed in December 2021 but never used. Pump, pressure tank, drop pipe & wire still need to be installed. There is also an older well that may be salvageable if new pump installed. Large pressure tank is for the old well is in the tall shed to the left of the driveway. There are security cameras & a caretaker, drive by only or make appointment to show. DIRECTIONS: From Barstow take 1-15 to East to Minneola Rd exit. Turn right, go 2.5 miles to Valley Center Rd, turn left. Go 2 miles to Condor Rd, turn left. Go 6 blocks to just past Coventry Street, the property will be on your right. Located on the NE corner of Condor & Coventry. Enter from Condor Rd.
MlsNumber: HD23217084


Listing Provided By: Trust Real Estate, original listing
Name: Trust Real Estate
Phone: (760) 256-1010
Office Name: Trust Real Estate
Office Phone: (760) 256-1010
Agent Name: Barbara Krommenhoek
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