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

5528 Morning Star Drive
Rancho Cucamonga, CA 91737

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $2,188,000
Beds: 4
Baths: 5
Status: Active
SqFt: 4233
Agency: Realty Masters & Associates

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 39,900 sqft
Property Type: Residential
Year Built: 1981
Notes: Welcome to your dream home nestled in the prestigious Deer Creek community, one of the most coveted neighborhoods in Alta Loma! This charming property offers an impressive 3,294 sq ft of living space, a massive workshop, an attached 3 car garage, and an oversized RV parking space. In addition, this property also features a guest house on nearly one acre of beautifully landscaped grounds. Situated on a peaceful cul-de-sac with magnificent curb appeal, this home offers spectacular views of both the city lights and the majestic mountains. <br /> <br /> Step inside to discover a meticulously maintained interior featuring a harmonious combination of tile and hardwood flooring, vaulted ceilings with exposed wood beams, and two exquisite fireplaces creating a warm and welcoming atmosphere. <br /> <br /> This home boasts a spacious layout, with an elegant formal dining room and bonus room. The heart of the home is the kitchen, equipped with top-of-the-line appliances, Dacor gas range with 6 burners, pot filler, built-in refrigerator, 2 wine refrigerators, silestone countertops, ample counter and cabinet space, solid cherry cabinetry, walk in pantry, and much more! <br /> <br /> One of the many highlights of this home is undoubtedly the ensuite bathrooms that accompany each bedroom. These remodeled bathrooms boast modern fixtures, high-end finishes, and a sophisticated design. The primary suite is a true masterpiece, featuring a spacious bedroom and a stunning ensuite bathroom. <br /> <br /> Step outside and discover your own private oasis. The nearly one-acre lot provides plenty of room for outdoor activities, gardening, or simply relaxing by the tranquil pool complete with a baja shelf and pebble-tec bottom. Also including a large patio deck, built-in BBQ, and wood burning fireplace.<br /> <br /> This residence not only boasts a stunning main house but also features a gorgeous detached Accessory Dwelling Unit or guest house (1,077 sqft) located at the rear, providing the possibility for multi generational living. This detached gem ensures privacy, offering a separate sanctuary with a large bedroom, bathroom, living area, laundry room, fireplace and patio. You will be captivated by the grandeur of the cathedral ceilings!<br /> <br /> Adjacent to the guest house, you will find a well-appointed workshop (850sqft) that awaits your creative endeavors, providing the ideal space for crafting or woodworking.<br /> <br /> Schedule a viewing today and discover the unparalleled beauty that awaits you in this meticulously crafted residence!
MlsNumber: CV24067124


Listing Provided By: Realty Masters & Associates, original listing
Name: Realty Masters & Associates
Phone: (714) 368-1300
Office Name: REALTY MASTERS & ASSOCIATES
Office Phone: (909) 303-4500
Agent Name: Erin Carman
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.


Local Real Estate Expert

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 = 3369 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;
Sandra Rosetti
ASCIIRE/MAX Proper
Call Today!: (909) 333-9962

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App