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 = 202 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 = 202 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 = 202 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;

14760 Sunnydale Drive
Lake Hughes, CA 93532
Tanykea Ingram with Broadnax Properties, Inc., original listing - (661) 674-9635

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $499,990
Beds: 3
Baths: Full: 2
Status: Active
SqFt: 1512 Square Feet
Agency: Broadnax Properties, Inc.
Agency Phone: (661) 674-9635

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1989
Notes: This stunning renovated home sits on a very large 11,000+ sq. ft. lot, offering ample space for outdoor enjoyment and future possibilities. Inside, fresh full interior paint creates a bright and modern feel throughout. The completely new kitchen is a showstopper, boasting brand-new cabinets with elegant cultured quartz countertops, sleek stainless steel appliances, a new stainless steel sink, and a stylish new faucet. New plank flooring flows seamlessly through the common areas, bathrooms, and laundry room, while plush new carpet adds comfort to the bedrooms and hallways. The master suite offers a private retreat with an en-suite bath and access to a covered balcony, perfect for enjoying peaceful moments outdoors. The top level also includes a convenient laundry room and a half bath, while the lower level features two additional bedrooms and a full bath, providing a practical layout for families or guests. The spacious single living area is warmed by a charming wood fireplace, creating a cozy atmosphere, while the dining area, conveniently connected to the kitchen, leads to another covered balcony with scenic views. A large basement offers plenty of storage or potential for additional living space. The property also includes a two-car garage. Step outside to a beautifully fenced backyard, offering privacy and security, ideal for pets or outdoor gatherings. The landscaping is ready to be personalized to your taste, while the elevated front patio adds a touch of grandeur and a great space for relaxing. Located in an excellent area with easy access to amenities, this home provides both convenience and comfort. Don't miss out--come see this incredible property today!
MlsNumber: --
ListingId: 25001731


Listing Provided By: Broadnax Properties, Inc., original listing
Phone: (661) 674-9635
Office Phone: (661) 674-9635
Agent Name: Tanykea Ingram
Disclaimer: Copyright © 2025 Greater Antelope Valley Association of Realtors. 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