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

Foreclosure: 271 W Le Roy Avenue
Arcadia, CA 91007
Charles Karich with SOUTH HILLS PROPERTIES, INC., original listing - (626) 967-7902

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $5,200,000
Beds: 6
Baths: Full: 8, ½: 1
Status: Active
SqFt: 9381 Square Feet
Agency: SOUTH HILLS PROPERTIES, INC.
Agency Phone: (626) 967-7902

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2016
Notes: Beautiful Mediterranean Estate built by Franklin Development. This great property has alot to offer, from 6 bedrooms, 9 bathrooms, theatre room, wine room, formal study, gym room with sauna and dual staircase at the entry for that wow factor.<br /> <br /> Anticipation abounds as your circular driveway leads to wrought iron/wood front door. Grand entrance with 28” majestic ceilings and dual stair-cases with Elevator access, framed with an oval rotunda and massive chandelier is breathtaking. Formal living room with enticing separate formal dining is opulent. Private home office features exquisite wood library & custom ceilings. Home theater captivates your audience. Open floor plan family room, media center, wet-bar and kitchen and is an entertainers dream with encompassing patio views for dining alfresco. The master kitchen and prep room features Wolf & Sub Zero appliances. Enjoy your favorite reserve in your adjacent private wine room. Step seamlessly through inviting French doors leading to Loggia and majestic pool with spa and bbq area surrounded with perfect landscaping and Custom Sport court. Relaxation abounds in your massage/exercise room with dry sauna. Main level generous guest suite is amazing. All bedrooms are en suite and offer the finest finishes. Immaculate master suite is one of the largest I've seen and features a private sitting area, huge master bath with generous jet soaking tub and mountain views. The finest finishes available accent this private oasis for your relaxing & entertaining pleasure.
MlsNumber: --
ListingId: CV25080759


Listing Provided By: SOUTH HILLS PROPERTIES, INC., original listing
Phone: (626) 967-7902
Office Phone: (626) 967-7902
Agent Name: Charles Karich
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