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

62126 Starlight Street
Joshua Tree, CA 92252

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $950,000
Beds: 3
Baths: 3
Status: Active
SqFt: 1681
Agency: Elerock Realty

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 86,266 sqft
Property Type: Residential
Year Built: 2023
Notes: This custom newly built house is one of a kind and built on a 2 acre corner lot. A mid century modern style home with a smooth stucco exterior. 3 bedrooms and 3 full baths. 2 bedrooms have attached bathrooms with quartz countertops and modern cabinetry. Kitchen has modern Euro style cabinets in Como Ash with quartz counters with full backsplash and an island with room for sitting. Stainless steel Z-Line kitchen appliances include propane gas range, microwave, dishwasher, and refrigerator, along with a THOR wine cooler. 60 inches Dimplex electronic fireplace in the living room. Tiled floors throughout. High ceilings range from 9 to 12 ft. Dimmable recessed ceiling lighting throughout the house including the outdoor patio and carport. Daikin central air and heating with Bluetooth connectivity. Ceiling fans in every room. 16 ft. multislide door for a indoor outdoor experience from the open floor plan to the outside covered patio. Views all around including the San Gorgonio mountains. Prewired for data and cable inside. Prewired outside for 9 security camera locations around the outside walls so new owner can choose their preferred camera system. Septic tank is traffic rated along with the seepage pit for more longevity than standard leech lines. Paid for solar system. Fire sprinkler system throughout the house. 3 space carport with a Wall Box electric car charger. Just a mile from the main road (no 4 wheel drive is needed) and about 22 minutes drive to the Joshua Tree West Entrance.
MlsNumber: IG24082447


Listing Provided By: Elerock Realty, original listing
Name: Elerock Realty
Phone: (951) 444-1299
Office Name: Elerock Realty
Office Phone: (714) 403-6348
Agent Name: Amrit Bakshi
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