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

1539 Rodeo Road
Arcadia, CA 91006
Maggie Ly with Re/Max Premier Prop SanMarino, original listing - (626) 660-1100

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $7,980,000
Beds: 7
Baths: Full: 9
Status: Active
SqFt: 10977 Square Feet
Agency: Re/Max Premier Prop SanMarino
Agency Phone: (626) 660-1100

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2009
Notes: Welcome to this French residence nestled in the most prestigious Arcadia neighborhood, where timeless elegance meets modern luxury. From the moment you Enter through the wrought-iron gates into a peaceful courtyard that showcases the extraordinary scale of the home. With almost ~11,000 sqft of luxury living area in an almost 30,000 sqft Lot, a voluminous atmosphere awaits, with a dramatic foyer and a double staircases plus a grand Living rooms of soaring ceiling of 28 feets. Highlights of this French Mansion include 7 generous bedrooms, 9 bathrooms, a stunning living room, a chef's kitchen adjacent to the beautiful family room, a gorgeous dining room and an inviting library/office plus a pool house. The primary suite features marble fireplace, sitting area, dual closets and bathrooms with custom marble finishes that lead to an expansive outdoor terrace with views of the pool, patio, and manicured gardens. Step outside to your own private oasis, where an exotic backyard invites you to relax and entertain. The pristine pool and spa are complemented by a top-of-the-line outdoor BBQ area, creating the perfect setting for unforgettable gatherings. With ample space for alfresco dining and entertaining, this backyard is a true retreat, offering an unparalleled Southern California lifestyle in the heart of most popular city in Southern California. This extraordinary property provides a peaceful and private sanctuary to experience ultimate luxury living in one of the most desirable neighborhoods, surrounded by the most coveted world-class dining, Santa Anita shopping Mall, the Race Track with the Arcadia awarded winning blue ribbon school district.
MlsNumber: --
ListingId: AR25031753


Listing Provided By: Re/Max Premier Prop SanMarino, original listing
Phone: (626) 203-9344
Office Phone: (626) 660-1100
Agent Name: Maggie Ly
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.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App