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;

63434 E Broadway
Joshua Tree, CA 92252

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,137,000
Beds: 5
Baths: 4
Status: Active
SqFt: 2875
Agency: Blake Haddock, Broker

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 2007
Notes: Two Homes on one Lot makes a perfect property for an Airbnb investor who would like to enjoy it part-time and offer it as a short-term rental.<br /> This secluded mini-compound is adorned with rustic charm, warm artistic character with a fresh bright interior, while sitting on nearly 2 acres that are serenely embellished with scenic walking paths and a variety of interesting plants and trees, including many beautiful Canary Palms. There are wonderful amenities including a 360 degree panoramic mountain view.<br /> The spectacular covered outdoor bar seats ten, a beautiful outdoor patio swing-bed offer luxurious relaxation, a large string-lighted patio perfect for large parties sits poolside, a detached pool house for games offers more fun, a spiral staircase leads you up to a rooftop viewing deck, two darling vintage RVs provide extra sleeping quarters in addition to the five bedrooms inside. There are solar electric panels - owned, not leased. There is a one-year new House/ADU with a separate driveway, a great-room for added guest comfort or for a mother-in-law, with a full kitchen, a washer and dryer plus 2-bedroom en suites. It includes a separate solar electric system - owned, not leased. There's lots of onsite parking up to 20+ guest cars. It's located on a paved road appr 8 miles from Joshua Tree National Park entrance. It's offered furnished per written inventory - included. All of it is offered well below replacement cost.
MlsNumber: 219101418


Listing Provided By: Blake Haddock, Broker, original listing
Name: Blake Haddock, Broker
Phone: (760) 574-4446
Office Name: Elitist International Realty, Inc.
Office Phone: (760) 574-4446
Agent Name: Blake Haddock
Disclaimer: Copyright © 2024 California Desert Association of REALTORS ®, 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