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

2367 Mountain Brook Dr.
Hacienda Heights, CA 91745
Karen Schmidt with Realty Masters & Associates, original listing - (909) 993-5710

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,429,888
Beds: 6
Baths: Full: 4
Status: Active
SqFt: 2497 Square Feet
Agency: Realty Masters & Associates
Agency Phone: (909) 993-5710

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1978
Notes: Tenant Occupied! Please don’t bother TENANTS! We will post the upcoming open house soon… Discover this stunning 6-bedroom, 4-bathroom pool home, ideally located in the highly sought-after community of Hacienda Heights. Renovated, the homeowner transformed the dining room into a spacious 6th bedroom, complete with a non-permitted ensuite featuring wide-plank laminate flooring, a ceramic tile shower surround, ceramic tile flooring, and a custom vanity with a granite countertop. Upon entering the house, you'll be welcomed by soaring vaulted ceilings. The expansive living room to the left boasts wide-plank laminate flooring and elegant wood shutters adorning the windows. The generous family room, featuring a cozy fireplace, seamlessly flows into the chef-inspired kitchen, which showcases two-tone white/light blue cabinetry, stainless steel appliances, ceramic tile flooring, and Corian countertops.<br /> All four bathrooms have been beautifully updated, with ceramic flooring, tile surround shower, granite countertops, and custom cabinetry. The main floor offers a thoughtfully designed layout with two bedrooms and two bathrooms, providing optimal convenience and flexibility. A wrought iron staircase leads to the second floor, where the primary suite awaits, complete with dual closets and an en-suite bathroom featuring a shower, double custom vanities, and elegant finishes. Two additional bedrooms, another bathroom, and a versatile bonus room—ideal as a 6th bedroom—complete the upper level.<br /> The backyard is an entertainer's paradise, with a spacious patio for outdoor dining and a large pool perfect for family gatherings. This home is located near Hsi Lai Temple, county parks, shopping centers, schools, medical facilities, supermarkets, restaurants, and banks. It is part of the esteemed Mesa Robles School and Glen A. Wilson High School districts.
MlsNumber: --
ListingId: TR25067424


Listing Provided By: Realty Masters & Associates, original listing
Phone: (909) 816-5367
Office Phone: (909) 993-5710
Agent Name: Karen Schmidt
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