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;

125 Rose Court
Upland, CA 91784

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $4,220,000
Beds: 3
Baths: 4
Status: Active
SqFt: 5461
Agency: RE/MAX Resources

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 67,954 sqft
Property Type: Residential
Year Built: 2015
Notes: If you are looking for a one-of-a-kind architect-designed home, look no further! The vision for this Desert Modern home was brought to reality by notable architect, Marc Soloway of Tuscon, Arizona. This property is characterized by its curved roof slabs & walls of glass. The entrance of this home gracefully opens on to the great room boasting window heights of 21' to capture a full view of the snow-capped mountains. The cantilevered & angled roof line is set high above curved glass windows giving the impression of “flying roofs". The design of the roof covers the living space, so sun exposure does not become an issue, while the clerestory windows give the impression that you are standing in a house of glass. The interior boasts custom finishes in every space, including a host of original designed metal finishes throughout the home. The California Gold stacked stone graces both the interior & exterior of the property, providing for a fully integrated indoor/outdoor experience. The various wood accents create warmth & interest. The walls of horizontal sliding windows fold into each other so there is no obstruction of the views. You can see east to Mt. San Jacinto and, on a clear day, west to Los Angeles. The bar area also includes stacking windows that provide for seamless entertaining, both inside & outdoors. The infinity edge pool & cascading water feature are magnificent! It was designed to not only be a place to cool off in the summer, but to provide a visual work of art you can gaze upon every day. The kitchen is fantastic with its gorgeous granite counters, a Dune Spider Glass backsplash & elegant European-style cabinets. There is a full suite of Thermador professional-grade appliances & an oversized walk-in pantry. All of the finishes in the house were tastefully curated by designer Lori Carroll, who works to create high-end designs that integrate the landscape of the property & the lifestyle you are seeking. Every room & finish is stunning.There is a beautiful primary suite with all of the amenities, including a huge closet. Auto enthusiasts will love the enormous garage space with room for potentially 4 cars or more. Additionally, the house is gated for privacy & also includes approx. 38 fully paid solar panels. The expansive lot provides plenty of space to entertain. There are also permitted plans to create a second, first floor master suite, ideal for extended family. This home is enhanced by bespoke amenities tailored to fulfill every desire.
MlsNumber: CV24013097


Listing Provided By: RE/MAX Resources, original listing
Name: RE/MAX Resources
Phone: (909) 398-1166
Office Name: The Real Estate Resource Group
Office Phone: (909) 575-4517
Agent Name: Laura Dandoy
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