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

2349 Westcott Avenue
Monterey Park, CA 91754
Jerry Sun with RE/MAX Premier Properties, original listing - (626) 316-6700

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $899,900
Beds: 3
Baths: Full: 2
Status: Active
SqFt: 1338 Square Feet
Agency: RE/MAX Premier Properties
Agency Phone: (626) 316-6700

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1967
Notes: This single-story home is located in the College Woods neighborhood, situated on a cul-de-sac that offers enhanced privacy. Near the border of the East LA and Montebello, it provides exceptional comfort and convenience. Just minutes from East LA College, elementary schools, public library, community parks, golf club, restaurants, banks, supermarkets, Atlantic Times Square Plaza, Costco Center, and Citadel Outlets. Easy access to freeways, public transportation to DTLA, Dodger Stadium, The Huntington Library, several museums.<br /> <br /> The home features central A/C, wall-unit A/C, brand-new laminate wood flooring, wood-like vinyl flooring, and new exterior lighting. Both the exterior and interior have been freshly painted. Upon entering, you’re greeted by a spacious living room with laminate wood flooring, while oversized sliding doors bring in abundant natural light and provide access to the backyard. <br /> <br /> The gourmet kitchen features ample cabinetry and a brand-new gas range. The adjacent dining area offers the perfect space for hosting intimate gatherings or enjoying family meals. The laundry closet provides convenient access to essentials. The home features three cozy bedrooms with laminate wood flooring. The master bedroom includes an ensuite bathroom with a framed shower. The second full bathroom offers a relaxing bathtub and updated flooring. Spend serene afternoons in your private backyard and patio, perfect for dining alfresco, unwinding, or exploring your passion for gardening.
MlsNumber: --
ListingId: AR24247191


Listing Provided By: RE/MAX Premier Properties, original listing
Phone: (626) 229-2200
Office Phone: (626) 316-6700
Agent Name: Jerry Sun
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