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','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 = 204 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 = 204 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;

656 Gloria Road
Arcadia, CA 91006

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $3,350,000
Beds: 4
Baths: 5
Status: Active
SqFt: 3390
Agency: Keller Williams Downtown LA

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 18,774 sqft
Property Type: Residential
Year Built: 1951
Notes: Indulge in this exquisite single-story ranch-style residence nestled within the prestigious Santa Anita Oaks area of Arcadia. Offering four bedrooms, five bathrooms 3,390 square feet, and sprawling across an expansive almost 19,000 square foot lot, this residence epitomizes luxury living. Recently renovated in 2018, this home underwent a transformation from its very core, updated plumbing, electrical systems, flooring, and a modernized kitchen and bathrooms. Upon arrival, the grand circular driveway welcomes you, leading to a majestic two-door entrance adorned with a striking solid wood barn door. Inside, a world of elegance unfolds. To the left, the picturesque living room captures panoramic views of the majestic mountains, while to the right, an open-concept dining area seamlessly transitions into the gourmet chef’s kitchen with Wolf and Thermador appliances and an inviting family room. Discover four exquisite bedroom suites, each boasting its own luxurious en-suite bathroom. The primary suite is a sanctuary of relaxation, featuring a lavish wet room complete with his and hers showers and an oversized cast iron tub. A meticulously designed walk-in closet adds to the allure, alongside a private toilet enclosure. Convenience meets sophistication with a spacious laundry room equipped with side-by-side washer and dryer, as well as a dedicated doggy shower for your beloved pet. Step outside to an entertainer's paradise, where a sprawling backyard beckons with a magnificent large deck adorned with hand-painted black and white mosaic tiles, meticulously crafted by the owner. Surrounded by mature trees, lush greenery, and a sizable basketball court, this outdoor oasis offers privacy and tranquility. Perfectly positioned, this home is just moments away from the Shops at Santa Anita, Santa Anita Race Track, The Arboretum, and the charming downtown of Sierra Madre. Don't miss the opportunity to make this unparalleled residence your own.
MlsNumber: AR24103367


Listing Provided By: Keller Williams Downtown LA, original listing
Name: Keller Williams Downtown LA
Phone: (310) 467-1978
Office Name: Keller Williams DTLA
Office Phone: (213) 797-7000
Agent Name: Tina Wang
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.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App