Title Page Background
DEBUG FN args: Array ( [0] => 3129 [1] => [2] => [3] => agent ) BEFORE: Site: 3129 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 3129 Igate: njhud LocID: 3129 Region: State: Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 3129 AND i.igate IN ('ohhud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'ohhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 3129 [1] => [2] => [3] => lender ) BEFORE: Site: 3129 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 3129 Igate: njhud LocID: 3129 Region: State: Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 3129 AND i.igate IN ('ohhud','ushud') AND m.expertType = 'lender' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'ohhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 3129 [1] => [2] => [3] => other ) BEFORE: Site: 3129 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 3129 Igate: njhud LocID: 3129 Region: State: Experttype: other Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 3129 AND i.igate IN ('ohhud','ushud') AND m.expertType = 'other' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'ohhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

1155 Poppy Court
Montebello, CA 90640
Xiao Yan Yao with RE/MAX GALAXY, original listing - (909) 861-9985

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $2,088,000
Beds: 5
Baths: Full: 5
Status: Active
SqFt: 2975 Square Feet
Agency: RE/MAX GALAXY
Agency Phone: (909) 861-9985

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Townhouse
Year Built: 2023
Notes: Discover the pinnacle of contemporary luxury in this Newer three-level masterpiece. Designed with sophistication and functionality in mind, this stunning residence boasts five spacious bedrooms and five elegantly appointed bathrooms, offering the ultimate in comfort and style.<br /> Step inside and be captivated by the open-concept living space, bathed in natural light from expansive floor-to-ceiling windows. The soaring ceilings and meticulously curated finishes create a sense of effortless elegance. At the heart of the home, the gourmet kitchen is a chef’s dream, featuring top-of-the-line appliances, custom cabinetry, and a sleek center island—perfect for both everyday living and entertaining.<br /> Each bedroom is thoughtfully designed as a private retreat, with ample closet space and serene ambiance. The primary suite is a sanctuary of its own, featuring a spa-inspired en-suite bath, dual vanities, and a soaking tub for ultimate relaxation. Additional bedrooms offer flexibility, ideal for family, guests, or a dedicated home office.Designed for modern living, this home boasts multiple lounge areas, a stylish loft, and inviting outdoor spaces perfect for relaxing or entertaining. The seller has done an excellent job with high-quality upgrades, including beautiful real wood flooring on the second and third floors and premium tile on the first floor, adding both elegance and durability. With clean architectural lines, smart-home technology, and premium materials throughout, this home truly embodies contemporary elegance.Nestled in a highly desirable neighborhood, this 2023-built residence is a rare opportunity to own a home that seamlessly blends innovation, comfort, and luxury.Don’t miss your chance to experience this exceptional home—schedule a private tour today!
MlsNumber: --
ListingId: AR25049746


Listing Provided By: RE/MAX GALAXY, original listing
Phone: (626) 678-5231
Office Phone: (909) 861-9985
Agent Name: Xiao Yan Yao
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