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 = 205 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 = 205 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 = 205 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;

533 E Sierra Madre Avenue
Glendora, CA 91741
Nicholas Abbadessa with RE/MAX MASTERS REALTY, original listing - (909) 445-8100

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $3,698,000
Beds: 7
Baths: Full: 6, ½: 1
Status: Active
SqFt: 8951 Square Feet
Agency: RE/MAX MASTERS REALTY
Agency Phone: (909) 445-8100

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1987
Notes: Welcome to this legacy Tudor estate, gracefully positioned on over an acre of private land. The front elevation captivates with its park-like, manicured grounds, surrounded by majestic oaks. A sweeping herringbone brick walkway leads you to a grand covered front porch, where double doors open into a breathtaking foyer featuring soaring vaulted ceilings with exposed beams and an impressive staircase. To your right, the formal living room, warmed by a fireplace, overlooks the front yard through beveled glass bay windows and connects to a deck via French doors, offering views of the expansive yard and the tennis court. Adjacent, the formal dining room provides both backyard views and easy access. The spacious kitchen offers rich wood cabinetry, tiled counters, an island featuring a prep sink and seating, recessed lighting, exposed beams, a walk-in pantry, and an eating area with views to the backyard. The family room, with its brick fireplace and hardwood floors, opens up to the outdoors through a wall of doors and windows. The main level also includes a great room perfect for entertaining, with a floor-to-ceiling fireplace, a wall of tall windows, French doors, exposed beam ceilings, a striking chandelier, and a built-in wet bar with countertop seating. Additional features on this level include an office with access to the front motor court, a cozy den with patio access, a powder room, two bedrooms each with ensuite bathrooms, and a third bedroom adjacent to another bathroom. A large laundry room and a secondary staircase leading upstairs complete this floor. Upstairs, a custom-milled office with a brick fireplace and a private balcony offers serene mountain views. The primary bedroom suite is a sanctuary with a retreat area, a fireplace, and double doors opening to a wide balcony. The primary bathroom indulges with a soaking tub, a custom walk-in shower, dual sinks, a dressing area, and two walk-in closets. A loft space, currently hosting a grand piano, overlooks the great room below. Further down the hall, two bedrooms share a Jack and Jill bathroom, while another room with an ensuite bathroom provides additional private space. An additional 2,415 ft.² contiguous basement is ready to be recreated totaling the size to 10,366 ft.². The backyard features a pebble-finished pool and spa, a newly refinished lighted tennis court, a covered patio, and grassy areas. The driveway leads through a porte-cochere to additional parking and a finished three-car garage.
MlsNumber: --
ListingId: CV24238909


Listing Provided By: RE/MAX MASTERS REALTY, original listing
Phone: (909) 292-7888
Office Phone: (909) 445-8100
Agent Name: Nicholas Abbadessa
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 = 205 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;
Linda Ojeda
ASCIILinda Ojeda and Associates, JohnHart Real Estate
Call Today!: (818) 442-7504

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App