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;

19149 Elkhorn Road
Apple Valley, CA 92308

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $880,000
Beds: 4
Baths: 4
Status: Pending
SqFt: 3850
Agency: Realty ONE Group Empire

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 18,800 sqft
Property Type: Residential
Year Built: 2002
Notes: Discover the epitome of luxury at 19149 Elkhorn St, Apple Valley, CA—a home that redefines elegance and sophistication. Nestled in an exclusive gated community, this premium property boasts an array of high-end features designed for the discerning homeowner.<br /> Key Highlights:<br /> • Marble Flooring: Step into a world of refined beauty with pristine marble floors that exude timeless grace.<br /> • Panoramic Valley Views: Be captivated by the sweeping views of the valley, a daily spectacle from the comfort of your home.<br /> • State-of-the-Art Pool: Dive into luxury with a stunning pool & spa, perfect for relaxation or hosting lavish poolside gatherings.<br /> • Open Floor Plan: Experience the ultimate in modern living with a spacious open floor plan that offers flexibility and a seamless flow between living spaces.<br /> • Automotive Enthusiast’s Dream: A well-appointed garage equipped with two car lifts caters to the automotive aficionado. Large enough to park an RV inside as well as outdoor RV Parking and TONS of storage space.<br /> • Acoustic Excellence: Immerse yourself in the purest sound with integrated speakers and a home theater system that transforms every entertainment experience. In-wall speakers as well as integrated subwoofers in multiple rooms.<br /> <br /> This residence is not just a home; it’s a statement of prestige and unparalleled comfort. Welcome to your sanctuary of serenity and style at 19149 Elkhorn St.
MlsNumber: HD24054868


Listing Provided By: Realty ONE Group Empire, original listing
Name: Realty ONE Group Empire
Phone: (760) 407-6444
Office Name: Realty ONE Group Empire
Office Phone: (760) 932-4008
Agent Name: Mike Hale
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