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;

1245 Oliva Court
Duarte, CA 91010
Elizabeth Do with Keller Williams Realty, original listing - (714) 861-5500

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $825,000
Beds: 3
Baths: Full: 3, ½: 1
Status: Active
SqFt: 1730 Square Feet
Agency: Keller Williams Realty
Agency Phone: (714) 861-5500

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Property Type: Residential-Condominium
Year Built: 2020
Notes: Built in 2020, this stunning 3-bedroom, 3.5-bathroom tri-level townhouse is nestled in the desirable Oliva Community of Duarte. As you step inside, you are welcomed by expansive upgraded vinyl flooring that flows seamlessly throughout the living spaces, setting a tone of sophistication.<br /> The heart of the home is the exquisite kitchen, a culinary haven featuring gleaming granite countertops, chic white cabinets that offer abundant storage, and stylish floating shelves. Equipped with top-of-the-line stainless steel appliances, this kitchen is not only functional but also beautifully designed, highlighted by a large island that comfortably accommodates seating for four—perfect for casual gatherings or morning coffee.<br /> Each bedroom is thoughtfully designed with recessed lighting, creating a warm and inviting atmosphere. One bedroom is conveniently located on the entry level and provides easy access for guests or family members. Ascend to the master bedroom, an opulent retreat where luxury meets comfort. The master bathroom boasts a spacious walk-in shower, elegant double vanity sinks, a separate water closet, and a generously sized walk-in closet, ensuring ample space for all your personal belongings. Custom window treatments throughout the home enhance the elegant feel, allowing for both privacy and style. This townhouse also incorporates modern smart home features, including a Nest Learning thermostat and a Nest x Yale smart lock at the front door for added convenience and security. The efficiency upgrades, such as a tankless water heater, contribute to a sustainable lifestyle.<br /> With direct access to the garage from the entry floor, convenience is paramount. Ideally located just off the 210 Freeway at the Mountain and Foothill exits, this exquisite home is just a stone's throw from local eateries, the renowned City of Hope, Santa Anita Mall, and Old Pasadena shopping center making it the perfect blend of luxury and practicality. Experience a lifestyle of comfort and sophistication in this remarkable townhouse.
MlsNumber: --
ListingId: OC25071800


Listing Provided By: Keller Williams Realty, original listing
Phone: (714) 861-5557
Office Phone: (714) 861-5500
Agent Name: Elizabeth Do
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