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','tnhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'tnhud', 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','tnhud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'tnhud', 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','tnhud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'tnhud', 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;

2304 Rosedale Curve
Upland, CA 91784
Laura Dandoy with RE/MAX RESOURCES, original listing - (909) 575-4517

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,985,000
Beds: 4
Baths: Full: 2, ½: 1
Status: Active
SqFt: 3182 Square Feet
Agency: RE/MAX RESOURCES
Agency Phone: (909) 575-4517

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1932
Notes: Be prepared to be amazed by this storied stone estate. The field stone walls & wrought iron gates set the stage for a place where time slows, nature sings and everyday life unfolds like a chapter from a beloved novel. Situated on nearly two acres of flat land that boasts heritage trees, (including avocado, lemon, orange & grapefruit) native gardens and historic architecture, this one of a kind home offers both a rare connection to the past and an inspiring lifestyle for the present. Originally built in 1931 by local businessman, Jack Davis during the Great Depression, the home's construction was a labor of love. Over the decades, only four owners have stewarded this estate, each preserving the integrity while gently enhancing it with modern comforts. The heart of the home is a welcoming kitchen with handcrafted Pelletier cabinetry & granite counters, an inviting space where you can gather, not just to prepare meals, but to linger & enjoy views of the garden across the way. The family room updated and enhanced by Hartman Baldwin, Design Build, is adjacent to the kitchen offering an opportunity for shared space. The living & dining rooms exude charm. The hardwood floors gleam in the sunlight. There are beamed ceilings that offer height and substance to the space. Open the front door to enjoy the cool breezes and hear the birds singing. The primary suite was created in 1993 by Roy F. Kroll & Associates, a Design Build firm in Claremont. They were able to infuse the desire for a modern space, without disrupting the charm. There is also a loft, perfect for an office. The additional bedrooms are roomy and all have a view of the gorgeous grounds. There is a thoughtfully designed patio area with a waterfall that enhances the tranquility of the space. A perfect place to have a cup of coffee or glass of wine while viewing the wildlife buzz about the grounds. As you exit the home you will find an exciting addition of useable space in the laundry/wet room and the artist studio, as well as the workshop. So many options. Above all this property is a haven for nature lovers. Flowers & fruit tress invite birds and bees, while local wildlife can be seen on occasion. This estate is more than a home. It is a peaceful cohabitation of the land, a retreat, a piece of California history. Whether you are entertaining under the stars, painting in the studio, harvesting citrus or just enjoying the warm sun drenched days, life here is measured in moments, memories and meaning.
MlsNumber: --
ListingId: CV25095571


Listing Provided By: RE/MAX RESOURCES, original listing
Phone: (909) 398-1166
Office Phone: (909) 575-4517
Agent Name: Laura Dandoy
Disclaimer: Copyright © 2025 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','tnhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'tnhud', 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;
Sharon Suzanne Butler
ASCIIThe Butler Team
Call Today!: (714) 745-6348

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App